From 6433005256513ec2943ee2ea52f2844711e4d62f Mon Sep 17 00:00:00 2001 From: hekeguang Date: Mon, 22 Aug 2022 21:16:25 +0800 Subject: Add database code. Issue-ID: USECASEUI-696 Change-Id: I1c8ce807ca1f2aaeebc8646d8a14df9f4b27a436 Signed-off-by: hekeguang --- .../src/main/resources/intent-analysis-init.sql | 26 ++++++++++++++++++---- 1 file changed, 22 insertions(+), 4 deletions(-) (limited to 'intentanalysis/src/main/resources/intent-analysis-init.sql') diff --git a/intentanalysis/src/main/resources/intent-analysis-init.sql b/intentanalysis/src/main/resources/intent-analysis-init.sql index 3e34576..727e0c6 100644 --- a/intentanalysis/src/main/resources/intent-analysis-init.sql +++ b/intentanalysis/src/main/resources/intent-analysis-init.sql @@ -19,15 +19,12 @@ create table if not exists expectation_object( create table if not exists expectation_target( target_id varchar(255) primary key, target_name varchar(255), - target_condition varchar(255), expectation_id varchar(255) ); create table if not exists context( context_id varchar(255) primary key, - context_name varchar(255), - context_type varchar(255), - context_condition varchar(255) + context_name varchar(255) ); create table if not exists context_mapping( @@ -50,3 +47,24 @@ create table if not exists state( condition varchar(255), expectation_id varchar(255) ); + +create table if not exists condition( + condition_id varchar(255) primary key, + condition_name varchar(255), + operator_type varchar(255), + condition_value varchar(255) +); + +create table if not exists condition_mapping( + condition_id varchar(255) primary key, + parent_type varchar(255), + parent_id varchar(255) + ); + +create table if not exists intent_management_function_reg_info{ + imfr_info_id varchar(255) primary key, + imfr_info_description varchar(255), + support_model varchar(255), + handle_name varchar(255), + intent_function_type varchar(255) + }; \ No newline at end of file -- cgit 1.2.3-korg