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 short_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) not null,
20 name varchar(255) not null,
21 subdictionary_name varchar(255),
22 type varchar(255) not null,
23 primary key (short_name)
26 create table dictionary_to_dictionaryelements (
27 dictionary_name varchar(255) not null,
28 dictionary_element_short_name varchar(255) not null,
29 primary key (dictionary_name, dictionary_element_short_name)
32 create table hibernate_sequence (
36 insert into hibernate_sequence values ( 1 );
38 create table loop_element_models (
39 name varchar(255) not null,
40 created_by varchar(255),
41 created_timestamp datetime(6) not null,
42 updated_by varchar(255),
43 updated_timestamp datetime(6) not null,
44 blueprint_yaml MEDIUMTEXT,
45 dcae_blueprint_id varchar(255),
46 loop_element_type varchar(255) not null,
47 short_name varchar(255),
51 create table loop_logs (
53 log_component varchar(255) not null,
54 log_instant datetime(6) not null,
55 log_type varchar(255) not null,
56 message MEDIUMTEXT not null,
57 loop_id varchar(255) not null,
61 create table loop_templates (
62 name varchar(255) not null,
63 created_by varchar(255),
64 created_timestamp datetime(6) not null,
65 updated_by varchar(255),
66 updated_timestamp datetime(6) not null,
67 allowed_loop_type varchar(255),
68 blueprint_yaml MEDIUMTEXT,
69 dcae_blueprint_id varchar(255),
70 maximum_instances_allowed integer,
71 unique_blueprint boolean default false,
72 service_uuid varchar(255),
76 create table loopelementmodels_to_policymodels (
77 loop_element_name varchar(255) not null,
78 policy_model_type varchar(255) not null,
79 policy_model_version varchar(255) not null,
80 primary key (loop_element_name, policy_model_type, policy_model_version)
84 name varchar(255) not null,
85 created_by varchar(255),
86 created_timestamp datetime(6) not null,
87 updated_by varchar(255),
88 updated_timestamp datetime(6) not null,
89 dcae_deployment_id varchar(255),
90 dcae_deployment_status_url varchar(255),
91 global_properties_json json,
92 last_computed_state varchar(255) not null,
93 loop_template_name varchar(255) not null,
94 service_uuid varchar(255),
98 create table loops_to_microservicepolicies (
99 loop_name varchar(255) not null,
100 microservicepolicy_name varchar(255) not null,
101 primary key (loop_name, microservicepolicy_name)
104 create table looptemplates_to_loopelementmodels (
105 loop_element_model_name varchar(255) not null,
106 loop_template_name varchar(255) not null,
107 flow_order integer not null,
108 primary key (loop_element_model_name, loop_template_name)
111 create table micro_service_policies (
112 name varchar(255) not null,
113 created_by varchar(255),
114 created_timestamp datetime(6) not null,
115 updated_by varchar(255),
116 updated_timestamp datetime(6) not null,
117 configurations_json json,
118 json_representation json not null,
119 pdp_group varchar(255),
120 pdp_sub_group varchar(255),
121 context varchar(255),
122 dcae_blueprint_id varchar(255),
123 dcae_deployment_id varchar(255),
124 dcae_deployment_status_url varchar(255),
125 device_type_scope varchar(255),
127 loop_element_model_id varchar(255),
128 policy_model_type varchar(255),
129 policy_model_version varchar(255),
133 create table operational_policies (
134 name varchar(255) not null,
135 created_by varchar(255),
136 created_timestamp datetime(6) not null,
137 updated_by varchar(255),
138 updated_timestamp datetime(6) not null,
139 configurations_json json,
140 json_representation json not null,
141 pdp_group varchar(255),
142 pdp_sub_group varchar(255),
143 loop_element_model_id varchar(255),
144 policy_model_type varchar(255),
145 policy_model_version varchar(255),
146 loop_id varchar(255) not null,
150 create table policy_models (
151 policy_model_type varchar(255) not null,
152 version varchar(255) not null,
153 created_by varchar(255),
154 created_timestamp datetime(6) not null,
155 updated_by varchar(255),
156 updated_timestamp datetime(6) not null,
157 policy_acronym varchar(255),
158 policy_tosca MEDIUMTEXT,
159 policy_pdp_group json,
160 primary key (policy_model_type, version)
163 create table services (
164 service_uuid varchar(255) not null,
165 name varchar(255) not null,
166 resource_details json,
167 service_details json,
168 version varchar(255),
169 primary key (service_uuid)
172 alter table dictionary_to_dictionaryelements
173 add constraint FK68hjjinnm8nte2owstd0xwp23
174 foreign key (dictionary_element_short_name)
175 references dictionary_elements (short_name);
177 alter table dictionary_to_dictionaryelements
178 add constraint FKtqfxg46gsxwlm2gkl6ne3cxfe
179 foreign key (dictionary_name)
180 references dictionary (name);
182 alter table loop_logs
183 add constraint FK1j0cda46aickcaoxqoo34khg2
184 foreign key (loop_id)
185 references loops (name);
187 alter table loop_templates
188 add constraint FKn692dk6281wvp1o95074uacn6
189 foreign key (service_uuid)
190 references services (service_uuid);
192 alter table loopelementmodels_to_policymodels
193 add constraint FK23j2q74v6kaexefy0tdabsnda
194 foreign key (policy_model_type, policy_model_version)
195 references policy_models (policy_model_type, version);
197 alter table loopelementmodels_to_policymodels
198 add constraint FKjag1iu0olojfwryfkvb5o0rk5
199 foreign key (loop_element_name)
200 references loop_element_models (name);
203 add constraint FK844uwy82wt0l66jljkjqembpj
204 foreign key (loop_template_name)
205 references loop_templates (name);
208 add constraint FK4b9wnqopxogwek014i1shqw7w
209 foreign key (service_uuid)
210 references services (service_uuid);
212 alter table loops_to_microservicepolicies
213 add constraint FKle255jmi7b065fwbvmwbiehtb
214 foreign key (microservicepolicy_name)
215 references micro_service_policies (name);
217 alter table loops_to_microservicepolicies
218 add constraint FK8avfqaf7xl71l7sn7a5eri68d
219 foreign key (loop_name)
220 references loops (name);
222 alter table looptemplates_to_loopelementmodels
223 add constraint FK1k7nbrbugvqa0xfxkq3cj1yn9
224 foreign key (loop_element_model_name)
225 references loop_element_models (name);
227 alter table looptemplates_to_loopelementmodels
228 add constraint FKj29yxyw0x7ue6mwgi6d3qg748
229 foreign key (loop_template_name)
230 references loop_templates (name);
232 alter table micro_service_policies
233 add constraint FKqvvdypacbww07fuv8xvlvdjgl
234 foreign key (loop_element_model_id)
235 references loop_element_models (name);
237 alter table micro_service_policies
238 add constraint FKn17j9ufmyhqicb6cvr1dbjvkt
239 foreign key (policy_model_type, policy_model_version)
240 references policy_models (policy_model_type, version);
242 alter table operational_policies
243 add constraint FKi9kh7my40737xeuaye9xwbnko
244 foreign key (loop_element_model_id)
245 references loop_element_models (name);
247 alter table operational_policies
248 add constraint FKlsyhfkoqvkwj78ofepxhoctip
249 foreign key (policy_model_type, policy_model_version)
250 references policy_models (policy_model_type, version);
252 alter table operational_policies
253 add constraint FK1ddoggk9ni2bnqighv6ecmuwu
254 foreign key (loop_id)
255 references loops (name);