diff options
author | zhuguanyu <zhuguanyu5@huawei.com> | 2022-08-16 16:14:56 +0800 |
---|---|---|
committer | zhuguanyu <zhuguanyu5@huawei.com> | 2022-08-26 16:34:02 +0800 |
commit | a6a29c67cbb22b9b120d08fe5310a45a16d987c6 (patch) | |
tree | ab4941a0309a835b111dadd9fc8d2f9056f21f9f /intentanalysis/src/main/resources/intent-analysis-init.sql | |
parent | 9643136574c0c06909ebe9af120c022fbb951b6d (diff) |
Update intent module and intent API of retrieval
Issue-ID: USECASEUI-710
Signed-off-by: zhuguanyu <zhuguanyu5@huawei.com>
Change-Id: I1d6e19db2a4c78f07b907f51fa3c9cf904eff4aa
Diffstat (limited to 'intentanalysis/src/main/resources/intent-analysis-init.sql')
-rw-r--r-- | intentanalysis/src/main/resources/intent-analysis-init.sql | 21 |
1 files changed, 11 insertions, 10 deletions
diff --git a/intentanalysis/src/main/resources/intent-analysis-init.sql b/intentanalysis/src/main/resources/intent-analysis-init.sql index 727e0c6..d777077 100644 --- a/intentanalysis/src/main/resources/intent-analysis-init.sql +++ b/intentanalysis/src/main/resources/intent-analysis-init.sql @@ -1,3 +1,5 @@ +CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; + create table if not exists intent( intent_id varchar(255) primary key, intent_name varchar(255) @@ -11,25 +13,24 @@ create table if not exists expectation( ); create table if not exists expectation_object( - expectation_id varchar(255) primary key, + object_id varchar(255) DEFAULT uuid_generate_v4 (), + primary key(object_id), object_type varchar(255), - object_instance varchar(255) + object_instance varchar(255), + expectation_id varchar(255) ); 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) -); - -create table if not exists context_mapping( - context_id varchar(255) primary key, - parent_type varchar(255), + context_name varchar(255), + context_condition varchar(255), parent_id varchar(255) ); @@ -61,10 +62,10 @@ create table if not exists condition_mapping( parent_id varchar(255) ); -create table if not exists intent_management_function_reg_info{ +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 + );
\ No newline at end of file |