Add Intent Report Interface

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

1 files changed, 22 insertions, 1 deletions

diff --git a/intentanalysis/src/test/resources/intentdb-test-init.sql b/intentanalysis/src/test/resources/intentdb-test-init.sql
index 1741585..25dc9ba 100644
--- a/intentanalysis/src/test/resources/intentdb-test-init.sql
+++ b/intentanalysis/src/test/resources/intentdb-test-init.sql
@@ -67,7 +67,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 condition
@@ -97,3 +98,23 @@ create table if not exists intent_Event_Record(
     operateType 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 varchar(255)
+    );
+
+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)
+    );
\ No newline at end of file