aboutsummaryrefslogtreecommitdiffstats
path: root/intentanalysis/src/main/resources/intent-analysis-init.sql
diff options
context:
space:
mode:
Diffstat (limited to 'intentanalysis/src/main/resources/intent-analysis-init.sql')
-rw-r--r--intentanalysis/src/main/resources/intent-analysis-init.sql23
1 files changed, 22 insertions, 1 deletions
diff --git a/intentanalysis/src/main/resources/intent-analysis-init.sql b/intentanalysis/src/main/resources/intent-analysis-init.sql
index ee7f8af..61ea45b 100644
--- a/intentanalysis/src/main/resources/intent-analysis-init.sql
+++ b/intentanalysis/src/main/resources/intent-analysis-init.sql
@@ -43,7 +43,8 @@ create table if not exists fulfillment_info(
fulfillment_info_id varchar(255) primary key,
fulfillment_info_status varchar(255),
not_fulfilled_state varchar(255),
- not_fulfilled_reason varchar(255)
+ not_fulfilled_reason varchar(255),
+ achieve_value varchar(255)
);
create table if not exists state(
@@ -80,3 +81,23 @@ create table if not exists intent_event_record(
operate_type varchar (225),
parent_id varchar(255)
);
+
+create table if not exists intent_report(
+ intent_report_id varchar(255) primary key,
+ intent_reference varchar(255),
+ report_time timestamptz
+ );
+
+create table if not exists intent_report_fulfillment_info(
+ parent_id varchar(255),
+ fulfillment_info_id varchar(255),
+ fulfillment_info_status varchar(255),
+ not_fulfilled_state varchar(255),
+ not_fulfilled_reason varchar(255),
+ achieve_value varchar(255)
+ );
+
+create table if not exists object_instance(
+ parent_id varchar(255),
+ object_instance varchar(255)
+ );