summaryrefslogtreecommitdiffstats
path: root/intentanalysis/src/main/resources/intent-analysis-init.sql
diff options
context:
space:
mode:
authorzhuguanyu <zhuguanyu5@huawei.com>2022-08-16 16:14:56 +0800
committerzhuguanyu <zhuguanyu5@huawei.com>2022-08-26 16:34:02 +0800
commita6a29c67cbb22b9b120d08fe5310a45a16d987c6 (patch)
treeab4941a0309a835b111dadd9fc8d2f9056f21f9f /intentanalysis/src/main/resources/intent-analysis-init.sql
parent9643136574c0c06909ebe9af120c022fbb951b6d (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.sql21
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