blob: b84f8e31ae4434cd0fd84a000bd97ed793ad26b6 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
/*
Navicat Premium Data Transfer
Source Server : 1
Source Server Type : PostgreSQL
Source Server Version : 100011
Source Host : localhost:5432
Source Catalog : exampledb
Source Schema : mec
Target Server Type : PostgreSQL
Target Server Version : 100011
File Encoding : 65001
Date: 30/12/2019 14:40:23
*/
DROP TABLE IF EXISTS intent;
DROP TABLE IF EXISTS expectation;
DROP TABLE IF EXISTS state;
CREATE TABLE if NOT EXISTS intent(
intent_id varchar(255),
intent_name varchar(255),
CONSTRAINT intent_test_task_pkey PRIMARY KEY (intent_id)
);
create table if not exists expectation(
expectation_id varchar(255),
expectation_name varchar(255),
target_moi varchar(255),
intent_id varchar(255),
CONSTRAINT expectation_test_task_pkey PRIMARY KEY (expectation_id)
);
create table if not exists state(
state_id varchar(255),
state_name varchar(255),
is_satisfied boolean,
condition varchar(255),
expectation_id varchar(255),
CONSTRAINT state_test_task_pkey PRIMARY KEY (state_id)
);
|
