Modify the intent report model and create a table

Issue-ID: USECASEUI-812
Signed-off-by: kaixiliu <liukaixi@chinamobile.com>
Change-Id: I33221660b76dd54306fb447d29d60fc5faeb0617

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)
+    );