2 create table dictionary (
3 name varchar(255) not null,
4 created_by varchar(255),
5 created_timestamp datetime(6) not null,
6 updated_by varchar(255),
7 updated_timestamp datetime(6) not null,
8 dictionary_second_level integer,
9 dictionary_type varchar(255),
13 create table dictionary_elements (
14 name varchar(255) not null,
15 created_by varchar(255),
16 created_timestamp datetime(6) not null,
17 updated_by varchar(255),
18 updated_timestamp datetime(6) not null,
19 description varchar(255),
20 short_name varchar(255) not null,
21 subdictionary_id varchar(255) not null,
22 type varchar(255) not null,
23 dictionary_id varchar(255),
27 create table hibernate_sequence (
31 insert into hibernate_sequence values ( 1 );
33 create table loop_logs (
35 log_component varchar(255) not null,
36 log_instant datetime(6) not null,
37 log_type varchar(255) not null,
38 message MEDIUMTEXT not null,
39 loop_id varchar(255) not null,
43 create table loop_templates (
44 name varchar(255) not null,
45 created_by varchar(255),
46 created_timestamp datetime(6) not null,
47 updated_by varchar(255),
48 updated_timestamp datetime(6) not null,
49 blueprint_yaml MEDIUMTEXT not null,
50 maximum_instances_allowed integer,
51 svg_representation MEDIUMTEXT,
52 service_uuid varchar(255),
57 name varchar(255) not null,
58 created_by varchar(255),
59 created_timestamp datetime(6) not null,
60 updated_by varchar(255),
61 updated_timestamp datetime(6) not null,
62 blueprint_yaml MEDIUMTEXT not null,
63 dcae_blueprint_id varchar(255),
64 dcae_deployment_id varchar(255),
65 dcae_deployment_status_url varchar(255),
66 global_properties_json json,
67 last_computed_state varchar(255) not null,
68 svg_representation MEDIUMTEXT,
69 loop_template_name varchar(255),
70 service_uuid varchar(255),
74 create table loops_microservicepolicies (
75 loop_id varchar(255) not null,
76 microservicepolicy_id varchar(255) not null,
77 primary key (loop_id, microservicepolicy_id)
80 create table micro_service_models (
81 name varchar(255) not null,
82 created_by varchar(255),
83 created_timestamp datetime(6) not null,
84 updated_by varchar(255),
85 updated_timestamp datetime(6) not null,
86 blueprint_yaml varchar(255) not null,
87 policy_type varchar(255) not null,
88 policy_model_type varchar(255),
89 policy_model_version varchar(255),
93 create table micro_service_policies (
94 name varchar(255) not null,
95 created_by varchar(255),
96 created_timestamp datetime(6) not null,
97 updated_by varchar(255),
98 updated_timestamp datetime(6) not null,
100 dcae_deployment_id varchar(255),
101 dcae_deployment_status_url varchar(255),
102 device_type_scope varchar(255),
103 json_representation json not null,
104 policy_model_type varchar(255) not null,
105 policy_tosca MEDIUMTEXT not null,
108 micro_service_model_id varchar(255),
112 create table operational_policies (
113 name varchar(255) not null,
114 configurations_json json,
115 json_representation json not null,
116 loop_id varchar(255) not null,
117 policy_model_type varchar(255),
118 policy_model_version varchar(255),
122 create table policy_models (
123 policy_model_type varchar(255) not null,
124 version varchar(255) not null,
125 created_by varchar(255),
126 created_timestamp datetime(6) not null,
127 updated_by varchar(255),
128 updated_timestamp datetime(6) not null,
129 policy_acronym varchar(255),
130 policy_tosca MEDIUMTEXT,
131 policy_variant varchar(255),
132 primary key (policy_model_type, version)
135 create table services (
136 service_uuid varchar(255) not null,
137 name varchar(255) not null,
138 resource_details json,
139 service_details json,
140 version varchar(255),
141 primary key (service_uuid)
144 create table templates_microservicemodels (
145 loop_template_name varchar(255) not null,
146 micro_service_model_name varchar(255) not null,
147 flow_order integer not null,
148 primary key (loop_template_name, micro_service_model_name)
151 alter table dictionary_elements
152 add constraint UK_qxkrvsrhp26m60apfvxphpl3d unique (short_name);
154 alter table dictionary_elements
155 add constraint FKn87bpgpm9i56w7uko585rbkgn
156 foreign key (dictionary_id)
157 references dictionary (name);
159 alter table loop_logs
160 add constraint FK1j0cda46aickcaoxqoo34khg2
161 foreign key (loop_id)
162 references loops (name);
164 alter table loop_templates
165 add constraint FKn692dk6281wvp1o95074uacn6
166 foreign key (service_uuid)
167 references services (service_uuid);
170 add constraint FK844uwy82wt0l66jljkjqembpj
171 foreign key (loop_template_name)
172 references loop_templates (name);
175 add constraint FK4b9wnqopxogwek014i1shqw7w
176 foreign key (service_uuid)
177 references services (service_uuid);
179 alter table loops_microservicepolicies
180 add constraint FKem7tp1cdlpwe28av7ef91j1yl
181 foreign key (microservicepolicy_id)
182 references micro_service_policies (name);
184 alter table loops_microservicepolicies
185 add constraint FKsvx91jekgdkfh34iaxtjfgebt
186 foreign key (loop_id)
187 references loops (name);
189 alter table micro_service_models
190 add constraint FKlkcffpnuavcg65u5o4tr66902
191 foreign key (policy_model_type, policy_model_version)
192 references policy_models (policy_model_type, version);
194 alter table micro_service_policies
195 add constraint FK5p7lipy9m2v7d4n3fvlclwse
196 foreign key (micro_service_model_id)
197 references micro_service_models (name);
199 alter table operational_policies
200 add constraint FK1ddoggk9ni2bnqighv6ecmuwu
201 foreign key (loop_id)
202 references loops (name);
204 alter table operational_policies
205 add constraint FKlsyhfkoqvkwj78ofepxhoctip
206 foreign key (policy_model_type, policy_model_version)
207 references policy_models (policy_model_type, version);
209 alter table templates_microservicemodels
210 add constraint FKq2gqg5q9jrkx8voosn7x5plqo
211 foreign key (loop_template_name)
212 references loop_templates (name);
214 alter table templates_microservicemodels
215 add constraint FKphn3m81suxavmj9c4u06cchju
216 foreign key (micro_service_model_name)
217 references micro_service_models (name);