From 6433005256513ec2943ee2ea52f2844711e4d62f Mon Sep 17 00:00:00 2001
From: hekeguang <hekeguang@chinamobile.com>
Date: Mon, 22 Aug 2022 21:16:25 +0800
Subject: Add database code.

Issue-ID: USECASEUI-696
Change-Id: I1c8ce807ca1f2aaeebc8646d8a14df9f4b27a436
Signed-off-by: hekeguang <hekeguang@chinamobile.com>
---
 .../src/main/resources/intent-analysis-init.sql    | 26 ++++++++++++++++++----
 1 file changed, 22 insertions(+), 4 deletions(-)

(limited to 'intentanalysis/src/main/resources/intent-analysis-init.sql')

diff --git a/intentanalysis/src/main/resources/intent-analysis-init.sql b/intentanalysis/src/main/resources/intent-analysis-init.sql
index 3e34576..727e0c6 100644
--- a/intentanalysis/src/main/resources/intent-analysis-init.sql
+++ b/intentanalysis/src/main/resources/intent-analysis-init.sql
@@ -19,15 +19,12 @@ 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_type varchar(255),
-    context_condition varchar(255)
+    context_name varchar(255)
 );
 
 create table if not exists context_mapping(
@@ -50,3 +47,24 @@ create table if not exists state(
     condition varchar(255),
     expectation_id varchar(255)
 );
+
+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),
+    parent_id varchar(255)
+    );
+
+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
-- 
cgit 1.2.3-korg

