summaryrefslogtreecommitdiffstats
path: root/intentanalysis/src/main/resources/intent-analysis-init.sql
diff options
context:
space:
mode:
authorKeguang He <hekeguang@chinamobile.com>2022-08-31 07:03:21 +0000
committerGerrit Code Review <gerrit@onap.org>2022-08-31 07:03:21 +0000
commit7679786f7dd60e0ca5e2b1d0f93e235cf0df0011 (patch)
tree6e17ea37551d9e978d4c62bdcd75fff291374d90 /intentanalysis/src/main/resources/intent-analysis-init.sql
parentc2649cfda700cbcc2cb6e33d9ab6ed98d2e56989 (diff)
parent6331fc23cbe8321150fbcf0f176a1106e3982aa0 (diff)
Merge "Update intent module and CRUD APIs"
Diffstat (limited to 'intentanalysis/src/main/resources/intent-analysis-init.sql')
-rw-r--r--intentanalysis/src/main/resources/intent-analysis-init.sql15
1 files changed, 7 insertions, 8 deletions
diff --git a/intentanalysis/src/main/resources/intent-analysis-init.sql b/intentanalysis/src/main/resources/intent-analysis-init.sql
index d777077..d7c513c 100644
--- a/intentanalysis/src/main/resources/intent-analysis-init.sql
+++ b/intentanalysis/src/main/resources/intent-analysis-init.sql
@@ -23,14 +23,18 @@ 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_condition varchar(255),
+ parent_id varchar(255)
+);
+
+create table if not exists context_mapping(
+ context_id varchar(255) primary key,
+ parent_type varchar(255),
parent_id varchar(255)
);
@@ -53,12 +57,7 @@ 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),
+ condition_value varchar(255),
parent_id varchar(255)
);