4fb1fd8f12d842190554f940d551573ad2abc56c
[it/dep.git] /
1 --
2 -- ============LICENSE_START=======================================================
3 -- Copyright (C) 2024 Ericsson
4 -- Modifications Copyright (C) 2024 OpenInfra Foundation Europe
5 -- ================================================================================
6 -- Licensed under the Apache License, Version 2.0 (the "License");
7 -- you may not use this file except in compliance with the License.
8 -- You may obtain a copy of the License at
9 --
10 --       http://www.apache.org/licenses/LICENSE-2.0
11 --
12 -- Unless required by applicable law or agreed to in writing, software
13 -- distributed under the License is distributed on an "AS IS" BASIS,
14 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
15 -- See the License for the specific language governing permissions and
16 -- limitations under the License.
17 --
18 -- SPDX-License-Identifier: Apache-2.0
19 -- ============LICENSE_END=========================================================
20 --
21
22 BEGIN;
23
24 CREATE EXTENSION IF NOT EXISTS postgis;
25 CREATE EXTENSION IF NOT EXISTS postgis_topology;
26 CREATE EXTENSION IF NOT EXISTS pg_trgm;
27
28 GRANT USAGE ON SCHEMA topology to topology_exposure_user;
29 GRANT SELECT ON ALL SEQUENCES IN SCHEMA topology TO topology_exposure_user;
30 GRANT SELECT ON ALL TABLES IN SCHEMA topology TO topology_exposure_user;
31
32 CREATE SCHEMA IF NOT EXISTS teiv_data;
33 ALTER SCHEMA teiv_data OWNER TO topology_exposure_user;
34 SET default_tablespace = '';
35 SET default_table_access_method = heap;
36
37 SET ROLE topology_exposure_user;
38
39 -- Function to create CONSTRAINT only if it does not exists
40 CREATE OR REPLACE FUNCTION teiv_data.create_constraint_if_not_exists (
41         t_name TEXT, c_name TEXT, constraint_sql TEXT
42 )
43 RETURNS void AS
44 $$
45 BEGIN
46         IF NOT EXISTS (SELECT constraint_name FROM information_schema.table_constraints WHERE table_schema = 'teiv_data' AND table_name = t_name AND constraint_name = c_name) THEN
47                 EXECUTE constraint_sql;
48         END IF;
49 END;
50 $$ language 'plpgsql';
51
52 CREATE OR REPLACE FUNCTION teiv_data.create_enum_type(
53     schema_name TEXT, type_name TEXT, enum_values TEXT[]
54 ) RETURNS VOID AS $$
55 BEGIN
56     IF NOT EXISTS (SELECT 1 FROM pg_type t JOIN pg_namespace n ON n.oid = t.typnamespace WHERE t.typname = type_name AND n.nspname = schema_name) THEN
57         EXECUTE format('CREATE TYPE %I.%I AS ENUM (%s)',schema_name, type_name, array_to_string(ARRAY(SELECT quote_literal(value) FROM unnest(enum_values) AS value), ', '));
58     END IF;
59 END;
60 $$ language 'plpgsql';
61
62 SELECT teiv_data.create_enum_type('teiv_data', 'Reliability', ARRAY['OK', 'RESTORED', 'ADVISED']);
63
64 CREATE TABLE IF NOT EXISTS teiv_data."responsible_adapter" (
65         "id"                    TEXT,
66         "hashed_id"                     BYTEA
67 );
68
69 SELECT teiv_data.create_constraint_if_not_exists(
70         'responsible_adapter',
71  'PK_responsible_adapter_id',
72  'ALTER TABLE teiv_data."responsible_adapter" ADD CONSTRAINT "PK_responsible_adapter_id" PRIMARY KEY ("id");'
73 );
74
75 SELECT teiv_data.create_constraint_if_not_exists(
76         'responsible_adapter',
77  'UNIQUE_responsible_adapter_hashed_id',
78  'ALTER TABLE teiv_data."responsible_adapter" ADD CONSTRAINT "UNIQUE_responsible_adapter_hashed_id" UNIQUE ("hashed_id");'
79 );CREATE TABLE IF NOT EXISTS teiv_data."3C2E2CE7BDF8321BC824B6318B190690F58DBB82" (
80         "id"                    TEXT,
81         "aSide_NFDeployment"                    TEXT,
82         "bSide_NearRTRICFunction"                       TEXT,
83         "CD_sourceIds"                  jsonb,
84         "CD_classifiers"                        jsonb,
85         "CD_decorators"                 jsonb,
86         "metadata"                      jsonb
87 );
88
89 ALTER TABLE ONLY teiv_data."3C2E2CE7BDF8321BC824B6318B190690F58DBB82" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
90
91 ALTER TABLE ONLY teiv_data."3C2E2CE7BDF8321BC824B6318B190690F58DBB82" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
92
93 ALTER TABLE ONLY teiv_data."3C2E2CE7BDF8321BC824B6318B190690F58DBB82" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
94
95 CREATE TABLE IF NOT EXISTS teiv_data."5A1D611A68E4A8B2F007A89876701DB3FA88346E" (
96         "id"                    TEXT,
97         "aSide_PhysicalAppliance"                       TEXT,
98         "bSide_ODUFunction"                     TEXT,
99         "CD_sourceIds"                  jsonb,
100         "CD_classifiers"                        jsonb,
101         "CD_decorators"                 jsonb,
102         "metadata"                      jsonb
103 );
104
105 ALTER TABLE ONLY teiv_data."5A1D611A68E4A8B2F007A89876701DB3FA88346E" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
106
107 ALTER TABLE ONLY teiv_data."5A1D611A68E4A8B2F007A89876701DB3FA88346E" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
108
109 ALTER TABLE ONLY teiv_data."5A1D611A68E4A8B2F007A89876701DB3FA88346E" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
110
111 CREATE TABLE IF NOT EXISTS teiv_data."AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA" (
112         "id"                    TEXT,
113         "aSide_PhysicalAppliance"                       TEXT,
114         "bSide_OCUCPFunction"                   TEXT,
115         "CD_sourceIds"                  jsonb,
116         "CD_classifiers"                        jsonb,
117         "CD_decorators"                 jsonb,
118         "metadata"                      jsonb
119 );
120
121 ALTER TABLE ONLY teiv_data."AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
122
123 ALTER TABLE ONLY teiv_data."AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
124
125 ALTER TABLE ONLY teiv_data."AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
126
127 CREATE TABLE IF NOT EXISTS teiv_data."B83D20388E54C581319034D29C555DE6F8D938FF" (
128         "id"                    TEXT,
129         "aSide_PhysicalAppliance"                       TEXT,
130         "bSide_OCUUPFunction"                   TEXT,
131         "CD_sourceIds"                  jsonb,
132         "CD_classifiers"                        jsonb,
133         "CD_decorators"                 jsonb,
134         "metadata"                      jsonb
135 );
136
137 ALTER TABLE ONLY teiv_data."B83D20388E54C581319034D29C555DE6F8D938FF" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
138
139 ALTER TABLE ONLY teiv_data."B83D20388E54C581319034D29C555DE6F8D938FF" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
140
141 ALTER TABLE ONLY teiv_data."B83D20388E54C581319034D29C555DE6F8D938FF" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
142
143 CREATE TABLE IF NOT EXISTS teiv_data."CFC235E0404703D1E4454647DF8AAE2C193DB402" (
144         "id"                    TEXT,
145         "aSide_AntennaModule"                   TEXT,
146         "bSide_AntennaCapability"                       TEXT,
147         "CD_sourceIds"                  jsonb,
148         "CD_classifiers"                        jsonb,
149         "CD_decorators"                 jsonb,
150         "metadata"                      jsonb
151 );
152
153 ALTER TABLE ONLY teiv_data."CFC235E0404703D1E4454647DF8AAE2C193DB402" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
154
155 ALTER TABLE ONLY teiv_data."CFC235E0404703D1E4454647DF8AAE2C193DB402" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
156
157 ALTER TABLE ONLY teiv_data."CFC235E0404703D1E4454647DF8AAE2C193DB402" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
158
159 CREATE TABLE IF NOT EXISTS teiv_data."D4A45C271462B28FB655CFCF2F2D826236C78062" (
160         "id"                    TEXT,
161         "aSide_PhysicalAppliance"                       TEXT,
162         "bSide_NearRTRICFunction"                       TEXT,
163         "CD_sourceIds"                  jsonb,
164         "CD_classifiers"                        jsonb,
165         "CD_decorators"                 jsonb,
166         "metadata"                      jsonb
167 );
168
169 ALTER TABLE ONLY teiv_data."D4A45C271462B28FB655CFCF2F2D826236C78062" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
170
171 ALTER TABLE ONLY teiv_data."D4A45C271462B28FB655CFCF2F2D826236C78062" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
172
173 ALTER TABLE ONLY teiv_data."D4A45C271462B28FB655CFCF2F2D826236C78062" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
174
175 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-cloud_CloudifiedNF" (
176         "id"                    TEXT,
177         "name"                  TEXT,
178         "CD_sourceIds"                  jsonb,
179         "CD_classifiers"                        jsonb,
180         "CD_decorators"                 jsonb,
181         "metadata"                      jsonb
182 );
183
184 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_CloudifiedNF" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
185
186 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_CloudifiedNF" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
187
188 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_CloudifiedNF" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
189
190 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-cloud_NFDEPLOYMENT_DEPLOYED_ON_OCLOUDNAMESPACE" (
191         "id"                    TEXT,
192         "aSide_NFDeployment"                    TEXT,
193         "bSide_OCloudNamespace"                 TEXT,
194         "CD_sourceIds"                  jsonb,
195         "CD_classifiers"                        jsonb,
196         "CD_decorators"                 jsonb,
197         "metadata"                      jsonb
198 );
199
200 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDEPLOYMENT_DEPLOYED_ON_OCLOUDNAMESPACE" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
201
202 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDEPLOYMENT_DEPLOYED_ON_OCLOUDNAMESPACE" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
203
204 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDEPLOYMENT_DEPLOYED_ON_OCLOUDNAMESPACE" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
205
206 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-cloud_NFDeployment" (
207         "id"                    TEXT,
208         "name"                  TEXT,
209         "CD_sourceIds"                  jsonb,
210         "CD_classifiers"                        jsonb,
211         "CD_decorators"                 jsonb,
212         "metadata"                      jsonb,
213         "REL_FK_comprised-by-cloudifiedNF"                      TEXT,
214         "REL_ID_CLOUDIFIEDNF_COMPRISES_NFDEPLOYMENT"                    TEXT,
215         "REL_CD_sourceIds_CLOUDIFIEDNF_COMPRISES_NFDEPLOYMENT"                  jsonb,
216         "REL_CD_classifiers_CLOUDIFIEDNF_COMPRISES_NFDEPLOYMENT"                        jsonb,
217         "REL_CD_decorators_CLOUDIFIEDNF_COMPRISES_NFDEPLOYMENT"                 jsonb,
218         "REL_metadata_CLOUDIFIEDNF_COMPRISES_NFDEPLOYMENT"                      jsonb,
219         "REL_FK_serviced-managedElement"                        TEXT,
220         "REL_ID_NFDEPLOYMENT_SERVES_MANAGEDELEMENT"                     TEXT,
221         "REL_CD_sourceIds_NFDEPLOYMENT_SERVES_MANAGEDELEMENT"                   jsonb,
222         "REL_CD_classifiers_NFDEPLOYMENT_SERVES_MANAGEDELEMENT"                 jsonb,
223         "REL_CD_decorators_NFDEPLOYMENT_SERVES_MANAGEDELEMENT"                  jsonb,
224         "REL_metadata_NFDEPLOYMENT_SERVES_MANAGEDELEMENT"                       jsonb
225 );
226
227 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
228
229 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
230
231 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
232
233 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ALTER COLUMN "REL_CD_sourceIds_CLOUDIFIEDNF_COMPRISES_NFDEPLOYMENT" SET DEFAULT '[]';
234
235 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ALTER COLUMN "REL_CD_classifiers_CLOUDIFIEDNF_COMPRISES_NFDEPLOYMENT" SET DEFAULT '[]';
236
237 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ALTER COLUMN "REL_CD_decorators_CLOUDIFIEDNF_COMPRISES_NFDEPLOYMENT" SET DEFAULT '{}';
238
239 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ALTER COLUMN "REL_CD_sourceIds_NFDEPLOYMENT_SERVES_MANAGEDELEMENT" SET DEFAULT '[]';
240
241 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ALTER COLUMN "REL_CD_classifiers_NFDEPLOYMENT_SERVES_MANAGEDELEMENT" SET DEFAULT '[]';
242
243 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ALTER COLUMN "REL_CD_decorators_NFDEPLOYMENT_SERVES_MANAGEDELEMENT" SET DEFAULT '{}';
244
245 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE" (
246         "id"                    TEXT,
247         "aSide_NodeCluster"                     TEXT,
248         "bSide_OCloudSite"                      TEXT,
249         "CD_sourceIds"                  jsonb,
250         "CD_classifiers"                        jsonb,
251         "CD_decorators"                 jsonb,
252         "metadata"                      jsonb
253 );
254
255 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
256
257 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
258
259 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
260
261 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-cloud_NodeCluster" (
262         "id"                    TEXT,
263         "name"                  TEXT,
264         "CD_sourceIds"                  jsonb,
265         "CD_classifiers"                        jsonb,
266         "CD_decorators"                 jsonb,
267         "metadata"                      jsonb
268 );
269
270 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NodeCluster" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
271
272 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NodeCluster" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
273
274 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NodeCluster" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
275
276 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" (
277         "id"                    TEXT,
278         "name"                  TEXT,
279         "CD_sourceIds"                  jsonb,
280         "CD_classifiers"                        jsonb,
281         "CD_decorators"                 jsonb,
282         "metadata"                      jsonb,
283         "REL_FK_deployed-on-nodeCluster"                        TEXT,
284         "REL_ID_OCLOUDNAMESPACE_DEPLOYED_ON_NODECLUSTER"                        TEXT,
285         "REL_CD_sourceIds_OCLOUDNAMESPACE_DEPLOYED_ON_NODECLUSTER"                      jsonb,
286         "REL_CD_classifiers_OCLOUDNAMESPACE_DEPLOYED_ON_NODECLUSTER"                    jsonb,
287         "REL_CD_decorators_OCLOUDNAMESPACE_DEPLOYED_ON_NODECLUSTER"                     jsonb,
288         "REL_metadata_OCLOUDNAMESPACE_DEPLOYED_ON_NODECLUSTER"                  jsonb
289 );
290
291 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
292
293 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
294
295 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
296
297 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" ALTER COLUMN "REL_CD_sourceIds_OCLOUDNAMESPACE_DEPLOYED_ON_NODECLUSTER" SET DEFAULT '[]';
298
299 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" ALTER COLUMN "REL_CD_classifiers_OCLOUDNAMESPACE_DEPLOYED_ON_NODECLUSTER" SET DEFAULT '[]';
300
301 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" ALTER COLUMN "REL_CD_decorators_OCLOUDNAMESPACE_DEPLOYED_ON_NODECLUSTER" SET DEFAULT '{}';
302
303 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-cloud_OCloudSite" (
304         "id"                    TEXT,
305         "geo-location"                  geography,
306         "name"                  TEXT,
307         "CD_sourceIds"                  jsonb,
308         "CD_classifiers"                        jsonb,
309         "CD_decorators"                 jsonb,
310         "metadata"                      jsonb
311 );
312
313 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_OCloudSite" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
314
315 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_OCloudSite" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
316
317 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_OCloudSite" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
318
319 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-equipment_AntennaModule" (
320         "id"                    TEXT,
321         "antennaBeamWidth"                      jsonb,
322         "antennaModelNumber"                    TEXT,
323         "azimuth"                       DECIMAL,
324         "electricalAntennaTilt"                 INTEGER,
325         "geo-location"                  geography,
326         "horizontalBeamWidth"                   DECIMAL,
327         "mechanicalAntennaBearing"                      INTEGER,
328         "mechanicalAntennaTilt"                 INTEGER,
329         "positionWithinSector"                  TEXT,
330         "totalTilt"                     INTEGER,
331         "verticalBeamWidth"                     DECIMAL,
332         "CD_sourceIds"                  jsonb,
333         "CD_classifiers"                        jsonb,
334         "CD_decorators"                 jsonb,
335         "metadata"                      jsonb,
336         "REL_FK_installed-at-site"                      TEXT,
337         "REL_ID_ANTENNAMODULE_INSTALLED_AT_SITE"                        TEXT,
338         "REL_CD_sourceIds_ANTENNAMODULE_INSTALLED_AT_SITE"                      jsonb,
339         "REL_CD_classifiers_ANTENNAMODULE_INSTALLED_AT_SITE"                    jsonb,
340         "REL_CD_decorators_ANTENNAMODULE_INSTALLED_AT_SITE"                     jsonb,
341         "REL_metadata_ANTENNAMODULE_INSTALLED_AT_SITE"                  jsonb,
342         "REL_FK_grouped-by-sector"                      TEXT,
343         "REL_ID_SECTOR_GROUPS_ANTENNAMODULE"                    TEXT,
344         "REL_CD_sourceIds_SECTOR_GROUPS_ANTENNAMODULE"                  jsonb,
345         "REL_CD_classifiers_SECTOR_GROUPS_ANTENNAMODULE"                        jsonb,
346         "REL_CD_decorators_SECTOR_GROUPS_ANTENNAMODULE"                 jsonb,
347         "REL_metadata_SECTOR_GROUPS_ANTENNAMODULE"                      jsonb
348 );
349
350 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
351
352 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
353
354 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
355
356 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ALTER COLUMN "REL_CD_sourceIds_ANTENNAMODULE_INSTALLED_AT_SITE" SET DEFAULT '[]';
357
358 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ALTER COLUMN "REL_CD_classifiers_ANTENNAMODULE_INSTALLED_AT_SITE" SET DEFAULT '[]';
359
360 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ALTER COLUMN "REL_CD_decorators_ANTENNAMODULE_INSTALLED_AT_SITE" SET DEFAULT '{}';
361
362 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ALTER COLUMN "REL_CD_sourceIds_SECTOR_GROUPS_ANTENNAMODULE" SET DEFAULT '[]';
363
364 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ALTER COLUMN "REL_CD_classifiers_SECTOR_GROUPS_ANTENNAMODULE" SET DEFAULT '[]';
365
366 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ALTER COLUMN "REL_CD_decorators_SECTOR_GROUPS_ANTENNAMODULE" SET DEFAULT '{}';
367
368 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-equipment_Site" (
369         "id"                    TEXT,
370         "geo-location"                  geography,
371         "name"                  TEXT,
372         "CD_sourceIds"                  jsonb,
373         "CD_classifiers"                        jsonb,
374         "CD_decorators"                 jsonb,
375         "metadata"                      jsonb
376 );
377
378 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_Site" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
379
380 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_Site" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
381
382 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_Site" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
383
384 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-oam_ManagedElement" (
385         "id"                    TEXT,
386         "CD_sourceIds"                  jsonb,
387         "CD_classifiers"                        jsonb,
388         "CD_decorators"                 jsonb,
389         "metadata"                      jsonb,
390         "REL_FK_deployed-as-cloudifiedNF"                       TEXT,
391         "REL_ID_MANAGEDELEMENT_DEPLOYED_AS_CLOUDIFIEDNF"                        TEXT,
392         "REL_CD_sourceIds_MANAGEDELEMENT_DEPLOYED_AS_CLOUDIFIEDNF"                      jsonb,
393         "REL_CD_classifiers_MANAGEDELEMENT_DEPLOYED_AS_CLOUDIFIEDNF"                    jsonb,
394         "REL_CD_decorators_MANAGEDELEMENT_DEPLOYED_AS_CLOUDIFIEDNF"                     jsonb,
395         "REL_metadata_MANAGEDELEMENT_DEPLOYED_AS_CLOUDIFIEDNF"                  jsonb
396 );
397
398 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-oam_ManagedElement" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
399
400 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-oam_ManagedElement" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
401
402 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-oam_ManagedElement" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
403
404 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-oam_ManagedElement" ALTER COLUMN "REL_CD_sourceIds_MANAGEDELEMENT_DEPLOYED_AS_CLOUDIFIEDNF" SET DEFAULT '[]';
405
406 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-oam_ManagedElement" ALTER COLUMN "REL_CD_classifiers_MANAGEDELEMENT_DEPLOYED_AS_CLOUDIFIEDNF" SET DEFAULT '[]';
407
408 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-oam_ManagedElement" ALTER COLUMN "REL_CD_decorators_MANAGEDELEMENT_DEPLOYED_AS_CLOUDIFIEDNF" SET DEFAULT '{}';
409
410 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-physical_PHYSICALAPPLIANCE_INSTALLEDAT_SITE" (
411         "id"                    TEXT,
412         "aSide_PhysicalAppliance"                       TEXT,
413         "bSide_Site"                    TEXT,
414         "CD_sourceIds"                  jsonb,
415         "CD_classifiers"                        jsonb,
416         "CD_decorators"                 jsonb,
417         "metadata"                      jsonb
418 );
419
420 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-physical_PHYSICALAPPLIANCE_INSTALLEDAT_SITE" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
421
422 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-physical_PHYSICALAPPLIANCE_INSTALLEDAT_SITE" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
423
424 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-physical_PHYSICALAPPLIANCE_INSTALLEDAT_SITE" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
425
426 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-physical_PhysicalAppliance" (
427         "id"                    TEXT,
428         "modelName"                     TEXT,
429         "vendorName"                    TEXT,
430         "CD_sourceIds"                  jsonb,
431         "CD_classifiers"                        jsonb,
432         "CD_decorators"                 jsonb,
433         "metadata"                      jsonb
434 );
435
436 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-physical_PhysicalAppliance" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
437
438 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-physical_PhysicalAppliance" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
439
440 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-physical_PhysicalAppliance" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
441
442 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-physical_Site" (
443         "id"                    TEXT,
444         "siteLocation"                  jsonb,
445         "siteName"                      TEXT,
446         "CD_sourceIds"                  jsonb,
447         "CD_classifiers"                        jsonb,
448         "CD_decorators"                 jsonb,
449         "metadata"                      jsonb
450 );
451
452 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-physical_Site" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
453
454 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-physical_Site" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
455
456 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-physical_Site" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
457
458 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_AntennaCapability" (
459         "id"                    TEXT,
460         "eUtranFqBands"                 jsonb,
461         "geranFqBands"                  jsonb,
462         "nRFqBands"                     jsonb,
463         "CD_sourceIds"                  jsonb,
464         "CD_classifiers"                        jsonb,
465         "CD_decorators"                 jsonb,
466         "metadata"                      jsonb
467 );
468
469 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_AntennaCapability" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
470
471 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_AntennaCapability" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
472
473 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_AntennaCapability" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
474
475 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_NRCellCU" (
476         "id"                    TEXT,
477         "cellLocalId"                   INTEGER,
478         "nCI"                   BIGINT,
479         "nRTAC"                 INTEGER,
480         "plmnId"                        jsonb,
481         "CD_sourceIds"                  jsonb,
482         "CD_classifiers"                        jsonb,
483         "CD_decorators"                 jsonb,
484         "metadata"                      jsonb,
485         "REL_FK_provided-by-ocucpFunction"                      TEXT,
486         "REL_ID_OCUCPFUNCTION_PROVIDES_NRCELLCU"                        TEXT,
487         "REL_CD_sourceIds_OCUCPFUNCTION_PROVIDES_NRCELLCU"                      jsonb,
488         "REL_CD_classifiers_OCUCPFUNCTION_PROVIDES_NRCELLCU"                    jsonb,
489         "REL_CD_decorators_OCUCPFUNCTION_PROVIDES_NRCELLCU"                     jsonb,
490         "REL_metadata_OCUCPFUNCTION_PROVIDES_NRCELLCU"                  jsonb
491 );
492
493 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellCU" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
494
495 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellCU" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
496
497 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellCU" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
498
499 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellCU" ALTER COLUMN "REL_CD_sourceIds_OCUCPFUNCTION_PROVIDES_NRCELLCU" SET DEFAULT '[]';
500
501 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellCU" ALTER COLUMN "REL_CD_classifiers_OCUCPFUNCTION_PROVIDES_NRCELLCU" SET DEFAULT '[]';
502
503 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellCU" ALTER COLUMN "REL_CD_decorators_OCUCPFUNCTION_PROVIDES_NRCELLCU" SET DEFAULT '{}';
504
505 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_NRCellDU" (
506         "id"                    TEXT,
507         "cellLocalId"                   INTEGER,
508         "nCI"                   BIGINT,
509         "nRPCI"                 INTEGER,
510         "nRTAC"                 INTEGER,
511         "CD_sourceIds"                  jsonb,
512         "CD_classifiers"                        jsonb,
513         "CD_decorators"                 jsonb,
514         "metadata"                      jsonb,
515         "REL_FK_provided-by-oduFunction"                        TEXT,
516         "REL_ID_ODUFUNCTION_PROVIDES_NRCELLDU"                  TEXT,
517         "REL_CD_sourceIds_ODUFUNCTION_PROVIDES_NRCELLDU"                        jsonb,
518         "REL_CD_classifiers_ODUFUNCTION_PROVIDES_NRCELLDU"                      jsonb,
519         "REL_CD_decorators_ODUFUNCTION_PROVIDES_NRCELLDU"                       jsonb,
520         "REL_metadata_ODUFUNCTION_PROVIDES_NRCELLDU"                    jsonb,
521         "REL_FK_grouped-by-sector"                      TEXT,
522         "REL_ID_SECTOR_GROUPS_NRCELLDU"                 TEXT,
523         "REL_CD_sourceIds_SECTOR_GROUPS_NRCELLDU"                       jsonb,
524         "REL_CD_classifiers_SECTOR_GROUPS_NRCELLDU"                     jsonb,
525         "REL_CD_decorators_SECTOR_GROUPS_NRCELLDU"                      jsonb,
526         "REL_metadata_SECTOR_GROUPS_NRCELLDU"                   jsonb
527 );
528
529 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellDU" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
530
531 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellDU" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
532
533 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellDU" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
534
535 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellDU" ALTER COLUMN "REL_CD_sourceIds_ODUFUNCTION_PROVIDES_NRCELLDU" SET DEFAULT '[]';
536
537 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellDU" ALTER COLUMN "REL_CD_classifiers_ODUFUNCTION_PROVIDES_NRCELLDU" SET DEFAULT '[]';
538
539 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellDU" ALTER COLUMN "REL_CD_decorators_ODUFUNCTION_PROVIDES_NRCELLDU" SET DEFAULT '{}';
540
541 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellDU" ALTER COLUMN "REL_CD_sourceIds_SECTOR_GROUPS_NRCELLDU" SET DEFAULT '[]';
542
543 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellDU" ALTER COLUMN "REL_CD_classifiers_SECTOR_GROUPS_NRCELLDU" SET DEFAULT '[]';
544
545 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellDU" ALTER COLUMN "REL_CD_decorators_SECTOR_GROUPS_NRCELLDU" SET DEFAULT '{}';
546
547 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" (
548         "id"                    TEXT,
549         "arfcnDL"                       INTEGER,
550         "arfcnUL"                       INTEGER,
551         "bSChannelBwDL"                 INTEGER,
552         "frequencyDL"                   INTEGER,
553         "frequencyUL"                   INTEGER,
554         "CD_sourceIds"                  jsonb,
555         "CD_classifiers"                        jsonb,
556         "CD_decorators"                 jsonb,
557         "metadata"                      jsonb,
558         "REL_FK_used-by-nrCellDu"                       TEXT,
559         "REL_ID_NRCELLDU_USES_NRSECTORCARRIER"                  TEXT,
560         "REL_CD_sourceIds_NRCELLDU_USES_NRSECTORCARRIER"                        jsonb,
561         "REL_CD_classifiers_NRCELLDU_USES_NRSECTORCARRIER"                      jsonb,
562         "REL_CD_decorators_NRCELLDU_USES_NRSECTORCARRIER"                       jsonb,
563         "REL_metadata_NRCELLDU_USES_NRSECTORCARRIER"                    jsonb,
564         "REL_FK_used-antennaCapability"                 TEXT,
565         "REL_ID_NRSECTORCARRIER_USES_ANTENNACAPABILITY"                 TEXT,
566         "REL_CD_sourceIds_NRSECTORCARRIER_USES_ANTENNACAPABILITY"                       jsonb,
567         "REL_CD_classifiers_NRSECTORCARRIER_USES_ANTENNACAPABILITY"                     jsonb,
568         "REL_CD_decorators_NRSECTORCARRIER_USES_ANTENNACAPABILITY"                      jsonb,
569         "REL_metadata_NRSECTORCARRIER_USES_ANTENNACAPABILITY"                   jsonb,
570         "REL_FK_provided-by-oduFunction"                        TEXT,
571         "REL_ID_ODUFUNCTION_PROVIDES_NRSECTORCARRIER"                   TEXT,
572         "REL_CD_sourceIds_ODUFUNCTION_PROVIDES_NRSECTORCARRIER"                 jsonb,
573         "REL_CD_classifiers_ODUFUNCTION_PROVIDES_NRSECTORCARRIER"                       jsonb,
574         "REL_CD_decorators_ODUFUNCTION_PROVIDES_NRSECTORCARRIER"                        jsonb,
575         "REL_metadata_ODUFUNCTION_PROVIDES_NRSECTORCARRIER"                     jsonb
576 );
577
578 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
579
580 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
581
582 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
583
584 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "REL_CD_sourceIds_NRCELLDU_USES_NRSECTORCARRIER" SET DEFAULT '[]';
585
586 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "REL_CD_classifiers_NRCELLDU_USES_NRSECTORCARRIER" SET DEFAULT '[]';
587
588 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "REL_CD_decorators_NRCELLDU_USES_NRSECTORCARRIER" SET DEFAULT '{}';
589
590 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "REL_CD_sourceIds_NRSECTORCARRIER_USES_ANTENNACAPABILITY" SET DEFAULT '[]';
591
592 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "REL_CD_classifiers_NRSECTORCARRIER_USES_ANTENNACAPABILITY" SET DEFAULT '[]';
593
594 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "REL_CD_decorators_NRSECTORCARRIER_USES_ANTENNACAPABILITY" SET DEFAULT '{}';
595
596 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "REL_CD_sourceIds_ODUFUNCTION_PROVIDES_NRSECTORCARRIER" SET DEFAULT '[]';
597
598 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "REL_CD_classifiers_ODUFUNCTION_PROVIDES_NRSECTORCARRIER" SET DEFAULT '[]';
599
600 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "REL_CD_decorators_ODUFUNCTION_PROVIDES_NRSECTORCARRIER" SET DEFAULT '{}';
601
602 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" (
603         "id"                    TEXT,
604         "nearRtRicId"                   BIGINT,
605         "pLMNId"                        jsonb,
606         "CD_sourceIds"                  jsonb,
607         "CD_classifiers"                        jsonb,
608         "CD_decorators"                 jsonb,
609         "metadata"                      jsonb,
610         "REL_FK_managed-by-managedElement"                      TEXT,
611         "REL_ID_MANAGEDELEMENT_MANAGES_NEARRTRICFUNCTION"                       TEXT,
612         "REL_CD_sourceIds_MANAGEDELEMENT_MANAGES_NEARRTRICFUNCTION"                     jsonb,
613         "REL_CD_classifiers_MANAGEDELEMENT_MANAGES_NEARRTRICFUNCTION"                   jsonb,
614         "REL_CD_decorators_MANAGEDELEMENT_MANAGES_NEARRTRICFUNCTION"                    jsonb,
615         "REL_metadata_MANAGEDELEMENT_MANAGES_NEARRTRICFUNCTION"                 jsonb,
616         "REL_FK_nearRTRICFunction-o1-linked-smo"                        TEXT,
617         "REL_ID_NEARRTRICFUNCTION_O1LINK_SMO"                   TEXT,
618         "REL_CD_sourceIds_NEARRTRICFUNCTION_O1LINK_SMO"                 jsonb,
619         "REL_CD_classifiers_NEARRTRICFUNCTION_O1LINK_SMO"                       jsonb,
620         "REL_CD_decorators_NEARRTRICFUNCTION_O1LINK_SMO"                        jsonb,
621         "REL_metadata_NEARRTRICFUNCTION_O1LINK_SMO"                     jsonb
622 );
623
624 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
625
626 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
627
628 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
629
630 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ALTER COLUMN "REL_CD_sourceIds_MANAGEDELEMENT_MANAGES_NEARRTRICFUNCTION" SET DEFAULT '[]';
631
632 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ALTER COLUMN "REL_CD_classifiers_MANAGEDELEMENT_MANAGES_NEARRTRICFUNCTION" SET DEFAULT '[]';
633
634 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ALTER COLUMN "REL_CD_decorators_MANAGEDELEMENT_MANAGES_NEARRTRICFUNCTION" SET DEFAULT '{}';
635
636 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ALTER COLUMN "REL_CD_sourceIds_NEARRTRICFUNCTION_O1LINK_SMO" SET DEFAULT '[]';
637
638 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ALTER COLUMN "REL_CD_classifiers_NEARRTRICFUNCTION_O1LINK_SMO" SET DEFAULT '[]';
639
640 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ALTER COLUMN "REL_CD_decorators_NEARRTRICFUNCTION_O1LINK_SMO" SET DEFAULT '{}';
641
642 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" (
643         "id"                    TEXT,
644         "gNBCUName"                     TEXT,
645         "gNBId"                 BIGINT,
646         "gNBIdLength"                   INTEGER,
647         "pLMNId"                        jsonb,
648         "CD_sourceIds"                  jsonb,
649         "CD_classifiers"                        jsonb,
650         "CD_decorators"                 jsonb,
651         "metadata"                      jsonb,
652         "REL_FK_managed-by-managedElement"                      TEXT,
653         "REL_ID_MANAGEDELEMENT_MANAGES_OCUCPFUNCTION"                   TEXT,
654         "REL_CD_sourceIds_MANAGEDELEMENT_MANAGES_OCUCPFUNCTION"                 jsonb,
655         "REL_CD_classifiers_MANAGEDELEMENT_MANAGES_OCUCPFUNCTION"                       jsonb,
656         "REL_CD_decorators_MANAGEDELEMENT_MANAGES_OCUCPFUNCTION"                        jsonb,
657         "REL_metadata_MANAGEDELEMENT_MANAGES_OCUCPFUNCTION"                     jsonb,
658         "REL_FK_ocucpFunction-e2-linked-ocuupFunction"                  TEXT,
659         "REL_ID_OCUCPFUNCTION_E1LINK_OCUUPFUNCTION"                     TEXT,
660         "REL_CD_sourceIds_OCUCPFUNCTION_E1LINK_OCUUPFUNCTION"                   jsonb,
661         "REL_CD_classifiers_OCUCPFUNCTION_E1LINK_OCUUPFUNCTION"                 jsonb,
662         "REL_CD_decorators_OCUCPFUNCTION_E1LINK_OCUUPFUNCTION"                  jsonb,
663         "REL_metadata_OCUCPFUNCTION_E1LINK_OCUUPFUNCTION"                       jsonb,
664         "REL_FK_ocucpFunction-e2-linked-nearRTRICFunction"                      TEXT,
665         "REL_ID_OCUCPFUNCTION_E2LINK_NEARRTRICFUNCTION"                 TEXT,
666         "REL_CD_sourceIds_OCUCPFUNCTION_E2LINK_NEARRTRICFUNCTION"                       jsonb,
667         "REL_CD_classifiers_OCUCPFUNCTION_E2LINK_NEARRTRICFUNCTION"                     jsonb,
668         "REL_CD_decorators_OCUCPFUNCTION_E2LINK_NEARRTRICFUNCTION"                      jsonb,
669         "REL_metadata_OCUCPFUNCTION_E2LINK_NEARRTRICFUNCTION"                   jsonb,
670         "REL_FK_ocucpFunction-o1-linked-smo"                    TEXT,
671         "REL_ID_OCUCPFUNCTION_O1LINK_SMO"                       TEXT,
672         "REL_CD_sourceIds_OCUCPFUNCTION_O1LINK_SMO"                     jsonb,
673         "REL_CD_classifiers_OCUCPFUNCTION_O1LINK_SMO"                   jsonb,
674         "REL_CD_decorators_OCUCPFUNCTION_O1LINK_SMO"                    jsonb,
675         "REL_metadata_OCUCPFUNCTION_O1LINK_SMO"                 jsonb
676 );
677
678 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
679
680 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
681
682 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
683
684 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_sourceIds_MANAGEDELEMENT_MANAGES_OCUCPFUNCTION" SET DEFAULT '[]';
685
686 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_classifiers_MANAGEDELEMENT_MANAGES_OCUCPFUNCTION" SET DEFAULT '[]';
687
688 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_decorators_MANAGEDELEMENT_MANAGES_OCUCPFUNCTION" SET DEFAULT '{}';
689
690 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_sourceIds_OCUCPFUNCTION_E1LINK_OCUUPFUNCTION" SET DEFAULT '[]';
691
692 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_classifiers_OCUCPFUNCTION_E1LINK_OCUUPFUNCTION" SET DEFAULT '[]';
693
694 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_decorators_OCUCPFUNCTION_E1LINK_OCUUPFUNCTION" SET DEFAULT '{}';
695
696 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_sourceIds_OCUCPFUNCTION_E2LINK_NEARRTRICFUNCTION" SET DEFAULT '[]';
697
698 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_classifiers_OCUCPFUNCTION_E2LINK_NEARRTRICFUNCTION" SET DEFAULT '[]';
699
700 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_decorators_OCUCPFUNCTION_E2LINK_NEARRTRICFUNCTION" SET DEFAULT '{}';
701
702 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_sourceIds_OCUCPFUNCTION_O1LINK_SMO" SET DEFAULT '[]';
703
704 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_classifiers_OCUCPFUNCTION_O1LINK_SMO" SET DEFAULT '[]';
705
706 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_decorators_OCUCPFUNCTION_O1LINK_SMO" SET DEFAULT '{}';
707
708 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" (
709         "id"                    TEXT,
710         "gNBId"                 BIGINT,
711         "gNBIdLength"                   INTEGER,
712         "pLMNIdList"                    jsonb,
713         "CD_sourceIds"                  jsonb,
714         "CD_classifiers"                        jsonb,
715         "CD_decorators"                 jsonb,
716         "metadata"                      jsonb,
717         "REL_FK_managed-by-managedElement"                      TEXT,
718         "REL_ID_MANAGEDELEMENT_MANAGES_OCUUPFUNCTION"                   TEXT,
719         "REL_CD_sourceIds_MANAGEDELEMENT_MANAGES_OCUUPFUNCTION"                 jsonb,
720         "REL_CD_classifiers_MANAGEDELEMENT_MANAGES_OCUUPFUNCTION"                       jsonb,
721         "REL_CD_decorators_MANAGEDELEMENT_MANAGES_OCUUPFUNCTION"                        jsonb,
722         "REL_metadata_MANAGEDELEMENT_MANAGES_OCUUPFUNCTION"                     jsonb,
723         "REL_FK_ocuupFunction-e2-linked-nearRTRICFunction"                      TEXT,
724         "REL_ID_OCUUPFUNCTION_E2LINK_NEARRTRICFUNCTION"                 TEXT,
725         "REL_CD_sourceIds_OCUUPFUNCTION_E2LINK_NEARRTRICFUNCTION"                       jsonb,
726         "REL_CD_classifiers_OCUUPFUNCTION_E2LINK_NEARRTRICFUNCTION"                     jsonb,
727         "REL_CD_decorators_OCUUPFUNCTION_E2LINK_NEARRTRICFUNCTION"                      jsonb,
728         "REL_metadata_OCUUPFUNCTION_E2LINK_NEARRTRICFUNCTION"                   jsonb
729 );
730
731 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
732
733 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
734
735 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
736
737 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ALTER COLUMN "REL_CD_sourceIds_MANAGEDELEMENT_MANAGES_OCUUPFUNCTION" SET DEFAULT '[]';
738
739 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ALTER COLUMN "REL_CD_classifiers_MANAGEDELEMENT_MANAGES_OCUUPFUNCTION" SET DEFAULT '[]';
740
741 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ALTER COLUMN "REL_CD_decorators_MANAGEDELEMENT_MANAGES_OCUUPFUNCTION" SET DEFAULT '{}';
742
743 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ALTER COLUMN "REL_CD_sourceIds_OCUUPFUNCTION_E2LINK_NEARRTRICFUNCTION" SET DEFAULT '[]';
744
745 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ALTER COLUMN "REL_CD_classifiers_OCUUPFUNCTION_E2LINK_NEARRTRICFUNCTION" SET DEFAULT '[]';
746
747 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ALTER COLUMN "REL_CD_decorators_OCUUPFUNCTION_E2LINK_NEARRTRICFUNCTION" SET DEFAULT '{}';
748
749 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_ODUFunction" (
750         "id"                    TEXT,
751         "dUpLMNId"                      jsonb,
752         "gNBDUId"                       BIGINT,
753         "gNBId"                 BIGINT,
754         "gNBIdLength"                   INTEGER,
755         "CD_sourceIds"                  jsonb,
756         "CD_classifiers"                        jsonb,
757         "CD_decorators"                 jsonb,
758         "metadata"                      jsonb,
759         "REL_FK_managed-by-managedElement"                      TEXT,
760         "REL_ID_MANAGEDELEMENT_MANAGES_ODUFUNCTION"                     TEXT,
761         "REL_CD_sourceIds_MANAGEDELEMENT_MANAGES_ODUFUNCTION"                   jsonb,
762         "REL_CD_classifiers_MANAGEDELEMENT_MANAGES_ODUFUNCTION"                 jsonb,
763         "REL_CD_decorators_MANAGEDELEMENT_MANAGES_ODUFUNCTION"                  jsonb,
764         "REL_metadata_MANAGEDELEMENT_MANAGES_ODUFUNCTION"                       jsonb,
765         "REL_FK_oduFunction-e2-linked-nearRTRICFunction"                        TEXT,
766         "REL_ID_ODUFUNCTION_E2LINK_NEARRTRICFUNCTION"                   TEXT,
767         "REL_CD_sourceIds_ODUFUNCTION_E2LINK_NEARRTRICFUNCTION"                 jsonb,
768         "REL_CD_classifiers_ODUFUNCTION_E2LINK_NEARRTRICFUNCTION"                       jsonb,
769         "REL_CD_decorators_ODUFUNCTION_E2LINK_NEARRTRICFUNCTION"                        jsonb,
770         "REL_metadata_ODUFUNCTION_E2LINK_NEARRTRICFUNCTION"                     jsonb,
771         "REL_FK_oduFunction-f1-c-linked-ocucpFunction"                  TEXT,
772         "REL_ID_ODUFUNCTION_F1CLINK_OCUCPFUNCTION"                      TEXT,
773         "REL_CD_sourceIds_ODUFUNCTION_F1CLINK_OCUCPFUNCTION"                    jsonb,
774         "REL_CD_classifiers_ODUFUNCTION_F1CLINK_OCUCPFUNCTION"                  jsonb,
775         "REL_CD_decorators_ODUFUNCTION_F1CLINK_OCUCPFUNCTION"                   jsonb,
776         "REL_metadata_ODUFUNCTION_F1CLINK_OCUCPFUNCTION"                        jsonb,
777         "REL_FK_oduFunction-f1-u-linked-ocuupFunction"                  TEXT,
778         "REL_ID_ODUFUNCTION_F1ULINK_OCUUPFUNCTION"                      TEXT,
779         "REL_CD_sourceIds_ODUFUNCTION_F1ULINK_OCUUPFUNCTION"                    jsonb,
780         "REL_CD_classifiers_ODUFUNCTION_F1ULINK_OCUUPFUNCTION"                  jsonb,
781         "REL_CD_decorators_ODUFUNCTION_F1ULINK_OCUUPFUNCTION"                   jsonb,
782         "REL_metadata_ODUFUNCTION_F1ULINK_OCUUPFUNCTION"                        jsonb,
783         "REL_FK_oduFunction-o1-linked-smo"                      TEXT,
784         "REL_ID_ODUFUNCTION_O1LINK_SMO"                 TEXT,
785         "REL_CD_sourceIds_ODUFUNCTION_O1LINK_SMO"                       jsonb,
786         "REL_CD_classifiers_ODUFUNCTION_O1LINK_SMO"                     jsonb,
787         "REL_CD_decorators_ODUFUNCTION_O1LINK_SMO"                      jsonb,
788         "REL_metadata_ODUFUNCTION_O1LINK_SMO"                   jsonb
789 );
790
791 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
792
793 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
794
795 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
796
797 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_sourceIds_MANAGEDELEMENT_MANAGES_ODUFUNCTION" SET DEFAULT '[]';
798
799 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_classifiers_MANAGEDELEMENT_MANAGES_ODUFUNCTION" SET DEFAULT '[]';
800
801 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_decorators_MANAGEDELEMENT_MANAGES_ODUFUNCTION" SET DEFAULT '{}';
802
803 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_sourceIds_ODUFUNCTION_E2LINK_NEARRTRICFUNCTION" SET DEFAULT '[]';
804
805 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_classifiers_ODUFUNCTION_E2LINK_NEARRTRICFUNCTION" SET DEFAULT '[]';
806
807 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_decorators_ODUFUNCTION_E2LINK_NEARRTRICFUNCTION" SET DEFAULT '{}';
808
809 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_sourceIds_ODUFUNCTION_F1CLINK_OCUCPFUNCTION" SET DEFAULT '[]';
810
811 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_classifiers_ODUFUNCTION_F1CLINK_OCUCPFUNCTION" SET DEFAULT '[]';
812
813 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_decorators_ODUFUNCTION_F1CLINK_OCUCPFUNCTION" SET DEFAULT '{}';
814
815 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_sourceIds_ODUFUNCTION_F1ULINK_OCUUPFUNCTION" SET DEFAULT '[]';
816
817 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_classifiers_ODUFUNCTION_F1ULINK_OCUUPFUNCTION" SET DEFAULT '[]';
818
819 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_decorators_ODUFUNCTION_F1ULINK_OCUUPFUNCTION" SET DEFAULT '{}';
820
821 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_sourceIds_ODUFUNCTION_O1LINK_SMO" SET DEFAULT '[]';
822
823 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_classifiers_ODUFUNCTION_O1LINK_SMO" SET DEFAULT '[]';
824
825 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_decorators_ODUFUNCTION_O1LINK_SMO" SET DEFAULT '{}';
826
827 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_ORUFunction" (
828         "id"                    TEXT,
829         "oruId"                 BIGINT,
830         "CD_sourceIds"                  jsonb,
831         "CD_classifiers"                        jsonb,
832         "CD_decorators"                 jsonb,
833         "metadata"                      jsonb,
834         "REL_FK_managed-by-managedElement"                      TEXT,
835         "REL_ID_MANAGEDELEMENT_MANAGES_ORUFUNCTION"                     TEXT,
836         "REL_CD_sourceIds_MANAGEDELEMENT_MANAGES_ORUFUNCTION"                   jsonb,
837         "REL_CD_classifiers_MANAGEDELEMENT_MANAGES_ORUFUNCTION"                 jsonb,
838         "REL_CD_decorators_MANAGEDELEMENT_MANAGES_ORUFUNCTION"                  jsonb,
839         "REL_metadata_MANAGEDELEMENT_MANAGES_ORUFUNCTION"                       jsonb,
840         "REL_FK_oruFunction-o1-linked-smo"                      TEXT,
841         "REL_ID_ORUFUNCTION_O1LINK_SMO"                 TEXT,
842         "REL_CD_sourceIds_ORUFUNCTION_O1LINK_SMO"                       jsonb,
843         "REL_CD_classifiers_ORUFUNCTION_O1LINK_SMO"                     jsonb,
844         "REL_CD_decorators_ORUFUNCTION_O1LINK_SMO"                      jsonb,
845         "REL_metadata_ORUFUNCTION_O1LINK_SMO"                   jsonb,
846         "REL_FK_oruFunction-ofhc-linked-oduFunction"                    TEXT,
847         "REL_ID_ORUFUNCTION_OFHCLINK_ODUFUNCTION"                       TEXT,
848         "REL_CD_sourceIds_ORUFUNCTION_OFHCLINK_ODUFUNCTION"                     jsonb,
849         "REL_CD_classifiers_ORUFUNCTION_OFHCLINK_ODUFUNCTION"                   jsonb,
850         "REL_CD_decorators_ORUFUNCTION_OFHCLINK_ODUFUNCTION"                    jsonb,
851         "REL_metadata_ORUFUNCTION_OFHCLINK_ODUFUNCTION"                 jsonb,
852         "REL_FK_oruFunction-ofhm-linked-oduFunction"                    TEXT,
853         "REL_ID_ORUFUNCTION_OFHMLINK_ODUFUNCTION"                       TEXT,
854         "REL_CD_sourceIds_ORUFUNCTION_OFHMLINK_ODUFUNCTION"                     jsonb,
855         "REL_CD_classifiers_ORUFUNCTION_OFHMLINK_ODUFUNCTION"                   jsonb,
856         "REL_CD_decorators_ORUFUNCTION_OFHMLINK_ODUFUNCTION"                    jsonb,
857         "REL_metadata_ORUFUNCTION_OFHMLINK_ODUFUNCTION"                 jsonb,
858         "REL_FK_oruFunction-ofhm-linked-smo"                    TEXT,
859         "REL_ID_ORUFUNCTION_OFHMLINK_SMO"                       TEXT,
860         "REL_CD_sourceIds_ORUFUNCTION_OFHMLINK_SMO"                     jsonb,
861         "REL_CD_classifiers_ORUFUNCTION_OFHMLINK_SMO"                   jsonb,
862         "REL_CD_decorators_ORUFUNCTION_OFHMLINK_SMO"                    jsonb,
863         "REL_metadata_ORUFUNCTION_OFHMLINK_SMO"                 jsonb,
864         "REL_FK_oruFunction-ofhs-linked-oduFunction"                    TEXT,
865         "REL_ID_ORUFUNCTION_OFHSLINK_ODUFUNCTION"                       TEXT,
866         "REL_CD_sourceIds_ORUFUNCTION_OFHSLINK_ODUFUNCTION"                     jsonb,
867         "REL_CD_classifiers_ORUFUNCTION_OFHSLINK_ODUFUNCTION"                   jsonb,
868         "REL_CD_decorators_ORUFUNCTION_OFHSLINK_ODUFUNCTION"                    jsonb,
869         "REL_metadata_ORUFUNCTION_OFHSLINK_ODUFUNCTION"                 jsonb,
870         "REL_FK_oruFunction-ofhu-linked-oduFunction"                    TEXT,
871         "REL_ID_ORUFUNCTION_OFHULINK_ODUFUNCTION"                       TEXT,
872         "REL_CD_sourceIds_ORUFUNCTION_OFHULINK_ODUFUNCTION"                     jsonb,
873         "REL_CD_classifiers_ORUFUNCTION_OFHULINK_ODUFUNCTION"                   jsonb,
874         "REL_CD_decorators_ORUFUNCTION_OFHULINK_ODUFUNCTION"                    jsonb,
875         "REL_metadata_ORUFUNCTION_OFHULINK_ODUFUNCTION"                 jsonb
876 );
877
878 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
879
880 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
881
882 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
883
884 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_sourceIds_MANAGEDELEMENT_MANAGES_ORUFUNCTION" SET DEFAULT '[]';
885
886 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_classifiers_MANAGEDELEMENT_MANAGES_ORUFUNCTION" SET DEFAULT '[]';
887
888 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_decorators_MANAGEDELEMENT_MANAGES_ORUFUNCTION" SET DEFAULT '{}';
889
890 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_sourceIds_ORUFUNCTION_O1LINK_SMO" SET DEFAULT '[]';
891
892 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_classifiers_ORUFUNCTION_O1LINK_SMO" SET DEFAULT '[]';
893
894 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_decorators_ORUFUNCTION_O1LINK_SMO" SET DEFAULT '{}';
895
896 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_sourceIds_ORUFUNCTION_OFHCLINK_ODUFUNCTION" SET DEFAULT '[]';
897
898 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_classifiers_ORUFUNCTION_OFHCLINK_ODUFUNCTION" SET DEFAULT '[]';
899
900 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_decorators_ORUFUNCTION_OFHCLINK_ODUFUNCTION" SET DEFAULT '{}';
901
902 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_sourceIds_ORUFUNCTION_OFHMLINK_ODUFUNCTION" SET DEFAULT '[]';
903
904 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_classifiers_ORUFUNCTION_OFHMLINK_ODUFUNCTION" SET DEFAULT '[]';
905
906 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_decorators_ORUFUNCTION_OFHMLINK_ODUFUNCTION" SET DEFAULT '{}';
907
908 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_sourceIds_ORUFUNCTION_OFHMLINK_SMO" SET DEFAULT '[]';
909
910 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_classifiers_ORUFUNCTION_OFHMLINK_SMO" SET DEFAULT '[]';
911
912 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_decorators_ORUFUNCTION_OFHMLINK_SMO" SET DEFAULT '{}';
913
914 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_sourceIds_ORUFUNCTION_OFHSLINK_ODUFUNCTION" SET DEFAULT '[]';
915
916 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_classifiers_ORUFUNCTION_OFHSLINK_ODUFUNCTION" SET DEFAULT '[]';
917
918 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_decorators_ORUFUNCTION_OFHSLINK_ODUFUNCTION" SET DEFAULT '{}';
919
920 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_sourceIds_ORUFUNCTION_OFHULINK_ODUFUNCTION" SET DEFAULT '[]';
921
922 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_classifiers_ORUFUNCTION_OFHULINK_ODUFUNCTION" SET DEFAULT '[]';
923
924 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_decorators_ORUFUNCTION_OFHULINK_ODUFUNCTION" SET DEFAULT '{}';
925
926 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_SMO" (
927         "id"                    TEXT,
928         "smoName"                       TEXT,
929         "CD_sourceIds"                  jsonb,
930         "CD_classifiers"                        jsonb,
931         "CD_decorators"                 jsonb,
932         "metadata"                      jsonb
933 );
934
935 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_SMO" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
936
937 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_SMO" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
938
939 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_SMO" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
940
941 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_Sector" (
942         "id"                    TEXT,
943         "azimuth"                       DECIMAL,
944         "geo-location"                  geography,
945         "sectorId"                      BIGINT,
946         "CD_sourceIds"                  jsonb,
947         "CD_classifiers"                        jsonb,
948         "CD_decorators"                 jsonb,
949         "metadata"                      jsonb
950 );
951
952 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_Sector" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
953
954 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_Sector" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
955
956 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_Sector" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
957
958 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUCPFUNCTION" (
959         "id"                    TEXT,
960         "aSide_NFDeployment"                    TEXT,
961         "bSide_OCUCPFunction"                   TEXT,
962         "CD_sourceIds"                  jsonb,
963         "CD_classifiers"                        jsonb,
964         "CD_decorators"                 jsonb,
965         "metadata"                      jsonb
966 );
967
968 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUCPFUNCTION" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
969
970 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUCPFUNCTION" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
971
972 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUCPFUNCTION" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
973
974 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUUPFUNCTION" (
975         "id"                    TEXT,
976         "aSide_NFDeployment"                    TEXT,
977         "bSide_OCUUPFunction"                   TEXT,
978         "CD_sourceIds"                  jsonb,
979         "CD_classifiers"                        jsonb,
980         "CD_decorators"                 jsonb,
981         "metadata"                      jsonb
982 );
983
984 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUUPFUNCTION" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
985
986 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUUPFUNCTION" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
987
988 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUUPFUNCTION" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
989
990 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_ODUFUNCTION" (
991         "id"                    TEXT,
992         "aSide_NFDeployment"                    TEXT,
993         "bSide_ODUFunction"                     TEXT,
994         "CD_sourceIds"                  jsonb,
995         "CD_classifiers"                        jsonb,
996         "CD_decorators"                 jsonb,
997         "metadata"                      jsonb
998 );
999
1000 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_ODUFUNCTION" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
1001
1002 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_ODUFUNCTION" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
1003
1004 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_ODUFUNCTION" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
1005
1006 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-rel-equipment-ran_ANTENNAMODULE_SERVES_NRCELLDU" (
1007         "id"                    TEXT,
1008         "aSide_AntennaModule"                   TEXT,
1009         "bSide_NRCellDU"                        TEXT,
1010         "CD_sourceIds"                  jsonb,
1011         "CD_classifiers"                        jsonb,
1012         "CD_decorators"                 jsonb,
1013         "metadata"                      jsonb
1014 );
1015
1016 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-equipment-ran_ANTENNAMODULE_SERVES_NRCELLDU" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
1017
1018 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-equipment-ran_ANTENNAMODULE_SERVES_NRCELLDU" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
1019
1020 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-equipment-ran_ANTENNAMODULE_SERVES_NRCELLDU" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
1021
1022 SELECT teiv_data.create_constraint_if_not_exists(
1023         '3C2E2CE7BDF8321BC824B6318B190690F58DBB82',
1024  'PK_82A1C5618438FF6DF7CDD48FD71E0A584E6D052A',
1025  'ALTER TABLE teiv_data."3C2E2CE7BDF8321BC824B6318B190690F58DBB82" ADD CONSTRAINT "PK_82A1C5618438FF6DF7CDD48FD71E0A584E6D052A" PRIMARY KEY ("id");'
1026 );
1027
1028 SELECT teiv_data.create_constraint_if_not_exists(
1029         '5A1D611A68E4A8B2F007A89876701DB3FA88346E',
1030  'PK_6C410FD0F9E98168BA2B4F63C967F3C10E8F8AC9',
1031  'ALTER TABLE teiv_data."5A1D611A68E4A8B2F007A89876701DB3FA88346E" ADD CONSTRAINT "PK_6C410FD0F9E98168BA2B4F63C967F3C10E8F8AC9" PRIMARY KEY ("id");'
1032 );
1033
1034 SELECT teiv_data.create_constraint_if_not_exists(
1035         'AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA',
1036  'PK_84398955EE4737F32AB94B09BB68E6F48ECE707E',
1037  'ALTER TABLE teiv_data."AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA" ADD CONSTRAINT "PK_84398955EE4737F32AB94B09BB68E6F48ECE707E" PRIMARY KEY ("id");'
1038 );
1039
1040 SELECT teiv_data.create_constraint_if_not_exists(
1041         'B83D20388E54C581319034D29C555DE6F8D938FF',
1042  'PK_0D7B04E5B3AD0DB04FBD8FC00598BEEE04BD3E75',
1043  'ALTER TABLE teiv_data."B83D20388E54C581319034D29C555DE6F8D938FF" ADD CONSTRAINT "PK_0D7B04E5B3AD0DB04FBD8FC00598BEEE04BD3E75" PRIMARY KEY ("id");'
1044 );
1045
1046 SELECT teiv_data.create_constraint_if_not_exists(
1047         'CFC235E0404703D1E4454647DF8AAE2C193DB402',
1048  'PK_63E61CB6802F21FE7A04A80A095F6AF8ABF067CE',
1049  'ALTER TABLE teiv_data."CFC235E0404703D1E4454647DF8AAE2C193DB402" ADD CONSTRAINT "PK_63E61CB6802F21FE7A04A80A095F6AF8ABF067CE" PRIMARY KEY ("id");'
1050 );
1051
1052 SELECT teiv_data.create_constraint_if_not_exists(
1053         'D4A45C271462B28FB655CFCF2F2D826236C78062',
1054  'PK_6E80C7AFF8B1C6C89ECCA6A855DC3B31066318AD',
1055  'ALTER TABLE teiv_data."D4A45C271462B28FB655CFCF2F2D826236C78062" ADD CONSTRAINT "PK_6E80C7AFF8B1C6C89ECCA6A855DC3B31066318AD" PRIMARY KEY ("id");'
1056 );
1057
1058 SELECT teiv_data.create_constraint_if_not_exists(
1059         'o-ran-smo-teiv-cloud_CloudifiedNF',
1060  'PK_o-ran-smo-teiv-cloud_CloudifiedNF_id',
1061  'ALTER TABLE teiv_data."o-ran-smo-teiv-cloud_CloudifiedNF" ADD CONSTRAINT "PK_o-ran-smo-teiv-cloud_CloudifiedNF_id" PRIMARY KEY ("id");'
1062 );
1063
1064 SELECT teiv_data.create_constraint_if_not_exists(
1065         'o-ran-smo-teiv-cloud_NFDEPLOYMENT_DEPLOYED_ON_OCLOUDNAMESPACE',
1066  'PK_E4FDDE2DC433209F933C7F53C9F72C1D2EB04BC6',
1067  'ALTER TABLE teiv_data."o-ran-smo-teiv-cloud_NFDEPLOYMENT_DEPLOYED_ON_OCLOUDNAMESPACE" ADD CONSTRAINT "PK_E4FDDE2DC433209F933C7F53C9F72C1D2EB04BC6" PRIMARY KEY ("id");'
1068 );
1069
1070 SELECT teiv_data.create_constraint_if_not_exists(
1071         'o-ran-smo-teiv-cloud_NFDeployment',
1072  'PK_o-ran-smo-teiv-cloud_NFDeployment_id',
1073  'ALTER TABLE teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ADD CONSTRAINT "PK_o-ran-smo-teiv-cloud_NFDeployment_id" PRIMARY KEY ("id");'
1074 );
1075
1076 SELECT teiv_data.create_constraint_if_not_exists(
1077         'o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE',
1078  'PK_o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE_id',
1079  'ALTER TABLE teiv_data."o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE" ADD CONSTRAINT "PK_o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE_id" PRIMARY KEY ("id");'
1080 );
1081
1082 SELECT teiv_data.create_constraint_if_not_exists(
1083         'o-ran-smo-teiv-cloud_NodeCluster',
1084  'PK_o-ran-smo-teiv-cloud_NodeCluster_id',
1085  'ALTER TABLE teiv_data."o-ran-smo-teiv-cloud_NodeCluster" ADD CONSTRAINT "PK_o-ran-smo-teiv-cloud_NodeCluster_id" PRIMARY KEY ("id");'
1086 );
1087
1088 SELECT teiv_data.create_constraint_if_not_exists(
1089         'o-ran-smo-teiv-cloud_OCloudNamespace',
1090  'PK_o-ran-smo-teiv-cloud_OCloudNamespace_id',
1091  'ALTER TABLE teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" ADD CONSTRAINT "PK_o-ran-smo-teiv-cloud_OCloudNamespace_id" PRIMARY KEY ("id");'
1092 );
1093
1094 SELECT teiv_data.create_constraint_if_not_exists(
1095         'o-ran-smo-teiv-cloud_OCloudSite',
1096  'PK_o-ran-smo-teiv-cloud_OCloudSite_id',
1097  'ALTER TABLE teiv_data."o-ran-smo-teiv-cloud_OCloudSite" ADD CONSTRAINT "PK_o-ran-smo-teiv-cloud_OCloudSite_id" PRIMARY KEY ("id");'
1098 );
1099
1100 SELECT teiv_data.create_constraint_if_not_exists(
1101         'o-ran-smo-teiv-equipment_AntennaModule',
1102  'PK_o-ran-smo-teiv-equipment_AntennaModule_id',
1103  'ALTER TABLE teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ADD CONSTRAINT "PK_o-ran-smo-teiv-equipment_AntennaModule_id" PRIMARY KEY ("id");'
1104 );
1105
1106 SELECT teiv_data.create_constraint_if_not_exists(
1107         'o-ran-smo-teiv-equipment_Site',
1108  'PK_o-ran-smo-teiv-equipment_Site_id',
1109  'ALTER TABLE teiv_data."o-ran-smo-teiv-equipment_Site" ADD CONSTRAINT "PK_o-ran-smo-teiv-equipment_Site_id" PRIMARY KEY ("id");'
1110 );
1111
1112 SELECT teiv_data.create_constraint_if_not_exists(
1113         'o-ran-smo-teiv-oam_ManagedElement',
1114  'PK_o-ran-smo-teiv-oam_ManagedElement_id',
1115  'ALTER TABLE teiv_data."o-ran-smo-teiv-oam_ManagedElement" ADD CONSTRAINT "PK_o-ran-smo-teiv-oam_ManagedElement_id" PRIMARY KEY ("id");'
1116 );
1117
1118 SELECT teiv_data.create_constraint_if_not_exists(
1119         'o-ran-smo-teiv-physical_PHYSICALAPPLIANCE_INSTALLEDAT_SITE',
1120  'PK_38CC59EE4BB930940AA47257E64BA5E4BBFEF260',
1121  'ALTER TABLE teiv_data."o-ran-smo-teiv-physical_PHYSICALAPPLIANCE_INSTALLEDAT_SITE" ADD CONSTRAINT "PK_38CC59EE4BB930940AA47257E64BA5E4BBFEF260" PRIMARY KEY ("id");'
1122 );
1123
1124 SELECT teiv_data.create_constraint_if_not_exists(
1125         'o-ran-smo-teiv-physical_PhysicalAppliance',
1126  'PK_o-ran-smo-teiv-physical_PhysicalAppliance_id',
1127  'ALTER TABLE teiv_data."o-ran-smo-teiv-physical_PhysicalAppliance" ADD CONSTRAINT "PK_o-ran-smo-teiv-physical_PhysicalAppliance_id" PRIMARY KEY ("id");'
1128 );
1129
1130 SELECT teiv_data.create_constraint_if_not_exists(
1131         'o-ran-smo-teiv-physical_Site',
1132  'PK_o-ran-smo-teiv-physical_Site_id',
1133  'ALTER TABLE teiv_data."o-ran-smo-teiv-physical_Site" ADD CONSTRAINT "PK_o-ran-smo-teiv-physical_Site_id" PRIMARY KEY ("id");'
1134 );
1135
1136 SELECT teiv_data.create_constraint_if_not_exists(
1137         'o-ran-smo-teiv-ran_AntennaCapability',
1138  'PK_o-ran-smo-teiv-ran_AntennaCapability_id',
1139  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_AntennaCapability" ADD CONSTRAINT "PK_o-ran-smo-teiv-ran_AntennaCapability_id" PRIMARY KEY ("id");'
1140 );
1141
1142 SELECT teiv_data.create_constraint_if_not_exists(
1143         'o-ran-smo-teiv-ran_NRCellCU',
1144  'PK_o-ran-smo-teiv-ran_NRCellCU_id',
1145  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_NRCellCU" ADD CONSTRAINT "PK_o-ran-smo-teiv-ran_NRCellCU_id" PRIMARY KEY ("id");'
1146 );
1147
1148 SELECT teiv_data.create_constraint_if_not_exists(
1149         'o-ran-smo-teiv-ran_NRCellDU',
1150  'PK_o-ran-smo-teiv-ran_NRCellDU_id',
1151  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_NRCellDU" ADD CONSTRAINT "PK_o-ran-smo-teiv-ran_NRCellDU_id" PRIMARY KEY ("id");'
1152 );
1153
1154 SELECT teiv_data.create_constraint_if_not_exists(
1155         'o-ran-smo-teiv-ran_NRSectorCarrier',
1156  'PK_o-ran-smo-teiv-ran_NRSectorCarrier_id',
1157  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ADD CONSTRAINT "PK_o-ran-smo-teiv-ran_NRSectorCarrier_id" PRIMARY KEY ("id");'
1158 );
1159
1160 SELECT teiv_data.create_constraint_if_not_exists(
1161         'o-ran-smo-teiv-ran_NearRTRICFunction',
1162  'PK_o-ran-smo-teiv-ran_NearRTRICFunction_id',
1163  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ADD CONSTRAINT "PK_o-ran-smo-teiv-ran_NearRTRICFunction_id" PRIMARY KEY ("id");'
1164 );
1165
1166 SELECT teiv_data.create_constraint_if_not_exists(
1167         'o-ran-smo-teiv-ran_OCUCPFunction',
1168  'PK_o-ran-smo-teiv-ran_OCUCPFunction_id',
1169  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ADD CONSTRAINT "PK_o-ran-smo-teiv-ran_OCUCPFunction_id" PRIMARY KEY ("id");'
1170 );
1171
1172 SELECT teiv_data.create_constraint_if_not_exists(
1173         'o-ran-smo-teiv-ran_OCUUPFunction',
1174  'PK_o-ran-smo-teiv-ran_OCUUPFunction_id',
1175  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ADD CONSTRAINT "PK_o-ran-smo-teiv-ran_OCUUPFunction_id" PRIMARY KEY ("id");'
1176 );
1177
1178 SELECT teiv_data.create_constraint_if_not_exists(
1179         'o-ran-smo-teiv-ran_ODUFunction',
1180  'PK_o-ran-smo-teiv-ran_ODUFunction_id',
1181  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ODUFunction" ADD CONSTRAINT "PK_o-ran-smo-teiv-ran_ODUFunction_id" PRIMARY KEY ("id");'
1182 );
1183
1184 SELECT teiv_data.create_constraint_if_not_exists(
1185         'o-ran-smo-teiv-ran_ORUFunction',
1186  'PK_o-ran-smo-teiv-ran_ORUFunction_id',
1187  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ORUFunction" ADD CONSTRAINT "PK_o-ran-smo-teiv-ran_ORUFunction_id" PRIMARY KEY ("id");'
1188 );
1189
1190 SELECT teiv_data.create_constraint_if_not_exists(
1191         'o-ran-smo-teiv-ran_SMO',
1192  'PK_o-ran-smo-teiv-ran_SMO_id',
1193  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_SMO" ADD CONSTRAINT "PK_o-ran-smo-teiv-ran_SMO_id" PRIMARY KEY ("id");'
1194 );
1195
1196 SELECT teiv_data.create_constraint_if_not_exists(
1197         'o-ran-smo-teiv-ran_Sector',
1198  'PK_o-ran-smo-teiv-ran_Sector_id',
1199  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_Sector" ADD CONSTRAINT "PK_o-ran-smo-teiv-ran_Sector_id" PRIMARY KEY ("id");'
1200 );
1201
1202 SELECT teiv_data.create_constraint_if_not_exists(
1203         'o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUCPFUNCTION',
1204  'PK_2D854968CB74C42C534D8E7C2A53E93F6B7F001F',
1205  'ALTER TABLE teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUCPFUNCTION" ADD CONSTRAINT "PK_2D854968CB74C42C534D8E7C2A53E93F6B7F001F" PRIMARY KEY ("id");'
1206 );
1207
1208 SELECT teiv_data.create_constraint_if_not_exists(
1209         'o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUUPFUNCTION',
1210  'PK_E551D02D14B3C04A565DC73A386BEB29627D3C08',
1211  'ALTER TABLE teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUUPFUNCTION" ADD CONSTRAINT "PK_E551D02D14B3C04A565DC73A386BEB29627D3C08" PRIMARY KEY ("id");'
1212 );
1213
1214 SELECT teiv_data.create_constraint_if_not_exists(
1215         'o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_ODUFUNCTION',
1216  'PK_A10CB552A0F126991DD325EC84DBFAC6F2BBE1A3',
1217  'ALTER TABLE teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_ODUFUNCTION" ADD CONSTRAINT "PK_A10CB552A0F126991DD325EC84DBFAC6F2BBE1A3" PRIMARY KEY ("id");'
1218 );
1219
1220 SELECT teiv_data.create_constraint_if_not_exists(
1221         'o-ran-smo-teiv-rel-equipment-ran_ANTENNAMODULE_SERVES_NRCELLDU',
1222  'PK_F41873285F3BD831F63C6041B4356A063403406D',
1223  'ALTER TABLE teiv_data."o-ran-smo-teiv-rel-equipment-ran_ANTENNAMODULE_SERVES_NRCELLDU" ADD CONSTRAINT "PK_F41873285F3BD831F63C6041B4356A063403406D" PRIMARY KEY ("id");'
1224 );
1225
1226 SELECT teiv_data.create_constraint_if_not_exists(
1227         '3C2E2CE7BDF8321BC824B6318B190690F58DBB82',
1228  'FK_BE847E738902EA979AC709D5A3D0CCD3FD8911CA',
1229  'ALTER TABLE teiv_data."3C2E2CE7BDF8321BC824B6318B190690F58DBB82" ADD CONSTRAINT "FK_BE847E738902EA979AC709D5A3D0CCD3FD8911CA" FOREIGN KEY ("aSide_NFDeployment") REFERENCES teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ("id");'
1230 );
1231
1232 SELECT teiv_data.create_constraint_if_not_exists(
1233         '3C2E2CE7BDF8321BC824B6318B190690F58DBB82',
1234  'FK_CCC0DEA6E4ABAB8614332070E83D953254D5A3A5',
1235  'ALTER TABLE teiv_data."3C2E2CE7BDF8321BC824B6318B190690F58DBB82" ADD CONSTRAINT "FK_CCC0DEA6E4ABAB8614332070E83D953254D5A3A5" FOREIGN KEY ("bSide_NearRTRICFunction") REFERENCES teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ("id");'
1236 );
1237
1238 SELECT teiv_data.create_constraint_if_not_exists(
1239         '5A1D611A68E4A8B2F007A89876701DB3FA88346E',
1240  'FK_77018C1186D1BDFFA579BB0AFF4616B44E5D2869',
1241  'ALTER TABLE teiv_data."5A1D611A68E4A8B2F007A89876701DB3FA88346E" ADD CONSTRAINT "FK_77018C1186D1BDFFA579BB0AFF4616B44E5D2869" FOREIGN KEY ("aSide_PhysicalAppliance") REFERENCES teiv_data."o-ran-smo-teiv-physical_PhysicalAppliance" ("id");'
1242 );
1243
1244 SELECT teiv_data.create_constraint_if_not_exists(
1245         '5A1D611A68E4A8B2F007A89876701DB3FA88346E',
1246  'FK_8D4427BBC6A11AB138377367A3854C0B3F8617BA',
1247  'ALTER TABLE teiv_data."5A1D611A68E4A8B2F007A89876701DB3FA88346E" ADD CONSTRAINT "FK_8D4427BBC6A11AB138377367A3854C0B3F8617BA" FOREIGN KEY ("bSide_ODUFunction") REFERENCES teiv_data."o-ran-smo-teiv-ran_ODUFunction" ("id");'
1248 );
1249
1250 SELECT teiv_data.create_constraint_if_not_exists(
1251         'AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA',
1252  'FK_24136D3737CD1512DCEF8A40E1755B72EC0A2CD4',
1253  'ALTER TABLE teiv_data."AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA" ADD CONSTRAINT "FK_24136D3737CD1512DCEF8A40E1755B72EC0A2CD4" FOREIGN KEY ("aSide_PhysicalAppliance") REFERENCES teiv_data."o-ran-smo-teiv-physical_PhysicalAppliance" ("id");'
1254 );
1255
1256 SELECT teiv_data.create_constraint_if_not_exists(
1257         'AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA',
1258  'FK_7026E52E2D490BEB55AECB31A1E8EFE10A492AA3',
1259  'ALTER TABLE teiv_data."AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA" ADD CONSTRAINT "FK_7026E52E2D490BEB55AECB31A1E8EFE10A492AA3" FOREIGN KEY ("bSide_OCUCPFunction") REFERENCES teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ("id");'
1260 );
1261
1262 SELECT teiv_data.create_constraint_if_not_exists(
1263         'B83D20388E54C581319034D29C555DE6F8D938FF',
1264  'FK_E1B88CD983257BA0928134B10E59DD3CC819849A',
1265  'ALTER TABLE teiv_data."B83D20388E54C581319034D29C555DE6F8D938FF" ADD CONSTRAINT "FK_E1B88CD983257BA0928134B10E59DD3CC819849A" FOREIGN KEY ("aSide_PhysicalAppliance") REFERENCES teiv_data."o-ran-smo-teiv-physical_PhysicalAppliance" ("id");'
1266 );
1267
1268 SELECT teiv_data.create_constraint_if_not_exists(
1269         'B83D20388E54C581319034D29C555DE6F8D938FF',
1270  'FK_609F0EE7138FEC84D27F37B2C9E0C428DD2BFF54',
1271  'ALTER TABLE teiv_data."B83D20388E54C581319034D29C555DE6F8D938FF" ADD CONSTRAINT "FK_609F0EE7138FEC84D27F37B2C9E0C428DD2BFF54" FOREIGN KEY ("bSide_OCUUPFunction") REFERENCES teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ("id");'
1272 );
1273
1274 SELECT teiv_data.create_constraint_if_not_exists(
1275         'CFC235E0404703D1E4454647DF8AAE2C193DB402',
1276  'FK_D80D1E6B26DF620B4DE659C600A3B7F709A41960',
1277  'ALTER TABLE teiv_data."CFC235E0404703D1E4454647DF8AAE2C193DB402" ADD CONSTRAINT "FK_D80D1E6B26DF620B4DE659C600A3B7F709A41960" FOREIGN KEY ("aSide_AntennaModule") REFERENCES teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ("id");'
1278 );
1279
1280 SELECT teiv_data.create_constraint_if_not_exists(
1281         'CFC235E0404703D1E4454647DF8AAE2C193DB402',
1282  'FK_7148BEED02C0617DE1DEEB6639F34A9FA9251B06',
1283  'ALTER TABLE teiv_data."CFC235E0404703D1E4454647DF8AAE2C193DB402" ADD CONSTRAINT "FK_7148BEED02C0617DE1DEEB6639F34A9FA9251B06" FOREIGN KEY ("bSide_AntennaCapability") REFERENCES teiv_data."o-ran-smo-teiv-ran_AntennaCapability" ("id");'
1284 );
1285
1286 SELECT teiv_data.create_constraint_if_not_exists(
1287         'D4A45C271462B28FB655CFCF2F2D826236C78062',
1288  'FK_377503D2B43273E3FC49BB0247CD3AB487BDDDD4',
1289  'ALTER TABLE teiv_data."D4A45C271462B28FB655CFCF2F2D826236C78062" ADD CONSTRAINT "FK_377503D2B43273E3FC49BB0247CD3AB487BDDDD4" FOREIGN KEY ("aSide_PhysicalAppliance") REFERENCES teiv_data."o-ran-smo-teiv-physical_PhysicalAppliance" ("id");'
1290 );
1291
1292 SELECT teiv_data.create_constraint_if_not_exists(
1293         'D4A45C271462B28FB655CFCF2F2D826236C78062',
1294  'FK_D65A8BCA9956E1F8D3F395B69A28E023863656B8',
1295  'ALTER TABLE teiv_data."D4A45C271462B28FB655CFCF2F2D826236C78062" ADD CONSTRAINT "FK_D65A8BCA9956E1F8D3F395B69A28E023863656B8" FOREIGN KEY ("bSide_NearRTRICFunction") REFERENCES teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ("id");'
1296 );
1297
1298 SELECT teiv_data.create_constraint_if_not_exists(
1299         'o-ran-smo-teiv-cloud_NFDEPLOYMENT_DEPLOYED_ON_OCLOUDNAMESPACE',
1300  'FK_A08D274894ECB6799E56C2089A494AF0345B9B16',
1301  'ALTER TABLE teiv_data."o-ran-smo-teiv-cloud_NFDEPLOYMENT_DEPLOYED_ON_OCLOUDNAMESPACE" ADD CONSTRAINT "FK_A08D274894ECB6799E56C2089A494AF0345B9B16" FOREIGN KEY ("aSide_NFDeployment") REFERENCES teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ("id");'
1302 );
1303
1304 SELECT teiv_data.create_constraint_if_not_exists(
1305         'o-ran-smo-teiv-cloud_NFDEPLOYMENT_DEPLOYED_ON_OCLOUDNAMESPACE',
1306  'FK_D39953B79C8D39296B892FCF2C00B9C99AC7023F',
1307  'ALTER TABLE teiv_data."o-ran-smo-teiv-cloud_NFDEPLOYMENT_DEPLOYED_ON_OCLOUDNAMESPACE" ADD CONSTRAINT "FK_D39953B79C8D39296B892FCF2C00B9C99AC7023F" FOREIGN KEY ("bSide_OCloudNamespace") REFERENCES teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" ("id");'
1308 );
1309
1310 SELECT teiv_data.create_constraint_if_not_exists(
1311         'o-ran-smo-teiv-cloud_NFDeployment',
1312  'FK_127C21CB9B8871C3BCACA05A5400BE6B8E7FCAC0',
1313  'ALTER TABLE teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ADD CONSTRAINT "FK_127C21CB9B8871C3BCACA05A5400BE6B8E7FCAC0" FOREIGN KEY ("REL_FK_comprised-by-cloudifiedNF") REFERENCES teiv_data."o-ran-smo-teiv-cloud_CloudifiedNF" ("id");'
1314 );
1315
1316 SELECT teiv_data.create_constraint_if_not_exists(
1317         'o-ran-smo-teiv-cloud_NFDeployment',
1318  'UNIQUE_A5A8418B6BE911F281E6E2AA640D7D9F777471DC',
1319  'ALTER TABLE teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ADD CONSTRAINT "UNIQUE_A5A8418B6BE911F281E6E2AA640D7D9F777471DC" UNIQUE ("REL_ID_CLOUDIFIEDNF_COMPRISES_NFDEPLOYMENT");'
1320 );
1321
1322 SELECT teiv_data.create_constraint_if_not_exists(
1323         'o-ran-smo-teiv-cloud_NFDeployment',
1324  'FK_AC1348E208C2E64F2EB1DECE2CCA5DB10B89CBD9',
1325  'ALTER TABLE teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ADD CONSTRAINT "FK_AC1348E208C2E64F2EB1DECE2CCA5DB10B89CBD9" FOREIGN KEY ("REL_FK_serviced-managedElement") REFERENCES teiv_data."o-ran-smo-teiv-oam_ManagedElement" ("id");'
1326 );
1327
1328 SELECT teiv_data.create_constraint_if_not_exists(
1329         'o-ran-smo-teiv-cloud_NFDeployment',
1330  'UNIQUE_8AD46969905BEEB89F63D3F37FD82B14F34FDCBC',
1331  'ALTER TABLE teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ADD CONSTRAINT "UNIQUE_8AD46969905BEEB89F63D3F37FD82B14F34FDCBC" UNIQUE ("REL_ID_NFDEPLOYMENT_SERVES_MANAGEDELEMENT");'
1332 );
1333
1334 SELECT teiv_data.create_constraint_if_not_exists(
1335         'o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE',
1336  'FK_AE882D77CE8D21B8032B124E1822E0EEE5DAAD92',
1337  'ALTER TABLE teiv_data."o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE" ADD CONSTRAINT "FK_AE882D77CE8D21B8032B124E1822E0EEE5DAAD92" FOREIGN KEY ("aSide_NodeCluster") REFERENCES teiv_data."o-ran-smo-teiv-cloud_NodeCluster" ("id");'
1338 );
1339
1340 SELECT teiv_data.create_constraint_if_not_exists(
1341         'o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE',
1342  'FK_888BF6FF782916E61B3FE80643A549A1CFDB6117',
1343  'ALTER TABLE teiv_data."o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE" ADD CONSTRAINT "FK_888BF6FF782916E61B3FE80643A549A1CFDB6117" FOREIGN KEY ("bSide_OCloudSite") REFERENCES teiv_data."o-ran-smo-teiv-cloud_OCloudSite" ("id");'
1344 );
1345
1346 SELECT teiv_data.create_constraint_if_not_exists(
1347         'o-ran-smo-teiv-cloud_OCloudNamespace',
1348  'FK_143EFC1953E68469572446EFB56BDEBBC83B8EBF',
1349  'ALTER TABLE teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" ADD CONSTRAINT "FK_143EFC1953E68469572446EFB56BDEBBC83B8EBF" FOREIGN KEY ("REL_FK_deployed-on-nodeCluster") REFERENCES teiv_data."o-ran-smo-teiv-cloud_NodeCluster" ("id");'
1350 );
1351
1352 SELECT teiv_data.create_constraint_if_not_exists(
1353         'o-ran-smo-teiv-cloud_OCloudNamespace',
1354  'UNIQUE_C4DE73BD7AA3DBFA2D32E577D4E0A534A7184AB0',
1355  'ALTER TABLE teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" ADD CONSTRAINT "UNIQUE_C4DE73BD7AA3DBFA2D32E577D4E0A534A7184AB0" UNIQUE ("REL_ID_OCLOUDNAMESPACE_DEPLOYED_ON_NODECLUSTER");'
1356 );
1357
1358 SELECT teiv_data.create_constraint_if_not_exists(
1359         'o-ran-smo-teiv-equipment_AntennaModule',
1360  'FK_E3BAEF04443354C0FC1837CF7964E05BEF9FD6CC',
1361  'ALTER TABLE teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ADD CONSTRAINT "FK_E3BAEF04443354C0FC1837CF7964E05BEF9FD6CC" FOREIGN KEY ("REL_FK_installed-at-site") REFERENCES teiv_data."o-ran-smo-teiv-equipment_Site" ("id");'
1362 );
1363
1364 SELECT teiv_data.create_constraint_if_not_exists(
1365         'o-ran-smo-teiv-equipment_AntennaModule',
1366  'UNIQUE_9DF414C2F0CD7FA8BFCB3E9BF851784AC4BC49B1',
1367  'ALTER TABLE teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ADD CONSTRAINT "UNIQUE_9DF414C2F0CD7FA8BFCB3E9BF851784AC4BC49B1" UNIQUE ("REL_ID_ANTENNAMODULE_INSTALLED_AT_SITE");'
1368 );
1369
1370 SELECT teiv_data.create_constraint_if_not_exists(
1371         'o-ran-smo-teiv-equipment_AntennaModule',
1372  'FK_078764B2F3D613D44CC6E3586F564C83164D2481',
1373  'ALTER TABLE teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ADD CONSTRAINT "FK_078764B2F3D613D44CC6E3586F564C83164D2481" FOREIGN KEY ("REL_FK_grouped-by-sector") REFERENCES teiv_data."o-ran-smo-teiv-ran_Sector" ("id");'
1374 );
1375
1376 SELECT teiv_data.create_constraint_if_not_exists(
1377         'o-ran-smo-teiv-equipment_AntennaModule',
1378  'UNIQUE_78B1D3DCD903AFFB1965D440D87B2D194CA028A0',
1379  'ALTER TABLE teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ADD CONSTRAINT "UNIQUE_78B1D3DCD903AFFB1965D440D87B2D194CA028A0" UNIQUE ("REL_ID_SECTOR_GROUPS_ANTENNAMODULE");'
1380 );
1381
1382 SELECT teiv_data.create_constraint_if_not_exists(
1383         'o-ran-smo-teiv-oam_ManagedElement',
1384  'FK_899B8130A861D1450FC49D3159D8B29C0628A717',
1385  'ALTER TABLE teiv_data."o-ran-smo-teiv-oam_ManagedElement" ADD CONSTRAINT "FK_899B8130A861D1450FC49D3159D8B29C0628A717" FOREIGN KEY ("REL_FK_deployed-as-cloudifiedNF") REFERENCES teiv_data."o-ran-smo-teiv-cloud_CloudifiedNF" ("id");'
1386 );
1387
1388 SELECT teiv_data.create_constraint_if_not_exists(
1389         'o-ran-smo-teiv-oam_ManagedElement',
1390  'UNIQUE_EC9B35192A31C6491E6566602720D1C26E3CB708',
1391  'ALTER TABLE teiv_data."o-ran-smo-teiv-oam_ManagedElement" ADD CONSTRAINT "UNIQUE_EC9B35192A31C6491E6566602720D1C26E3CB708" UNIQUE ("REL_ID_MANAGEDELEMENT_DEPLOYED_AS_CLOUDIFIEDNF");'
1392 );
1393
1394 SELECT teiv_data.create_constraint_if_not_exists(
1395         'o-ran-smo-teiv-physical_PHYSICALAPPLIANCE_INSTALLEDAT_SITE',
1396  'FK_0C307FF7FE1210B6696BF0BD533D43BCF20D5CEB',
1397  'ALTER TABLE teiv_data."o-ran-smo-teiv-physical_PHYSICALAPPLIANCE_INSTALLEDAT_SITE" ADD CONSTRAINT "FK_0C307FF7FE1210B6696BF0BD533D43BCF20D5CEB" FOREIGN KEY ("aSide_PhysicalAppliance") REFERENCES teiv_data."o-ran-smo-teiv-physical_PhysicalAppliance" ("id");'
1398 );
1399
1400 SELECT teiv_data.create_constraint_if_not_exists(
1401         'o-ran-smo-teiv-physical_PHYSICALAPPLIANCE_INSTALLEDAT_SITE',
1402  'FK_724766DCE4C384828DFFDA92F96D3CF41A10AC60',
1403  'ALTER TABLE teiv_data."o-ran-smo-teiv-physical_PHYSICALAPPLIANCE_INSTALLEDAT_SITE" ADD CONSTRAINT "FK_724766DCE4C384828DFFDA92F96D3CF41A10AC60" FOREIGN KEY ("bSide_Site") REFERENCES teiv_data."o-ran-smo-teiv-physical_Site" ("id");'
1404 );
1405
1406 SELECT teiv_data.create_constraint_if_not_exists(
1407         'o-ran-smo-teiv-ran_NRCellCU',
1408  'FK_o-ran-smo-teiv-ran_NRCellCU_REL_FK_provided-by-ocucpFunction',
1409  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_NRCellCU" ADD CONSTRAINT "FK_o-ran-smo-teiv-ran_NRCellCU_REL_FK_provided-by-ocucpFunction" FOREIGN KEY ("REL_FK_provided-by-ocucpFunction") REFERENCES teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ("id");'
1410 );
1411
1412 SELECT teiv_data.create_constraint_if_not_exists(
1413         'o-ran-smo-teiv-ran_NRCellCU',
1414  'UNIQUE_928074AEE57C9CB151F93FDC81BC59200D5F7497',
1415  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_NRCellCU" ADD CONSTRAINT "UNIQUE_928074AEE57C9CB151F93FDC81BC59200D5F7497" UNIQUE ("REL_ID_OCUCPFUNCTION_PROVIDES_NRCELLCU");'
1416 );
1417
1418 SELECT teiv_data.create_constraint_if_not_exists(
1419         'o-ran-smo-teiv-ran_NRCellDU',
1420  'FK_o-ran-smo-teiv-ran_NRCellDU_REL_FK_provided-by-oduFunction',
1421  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_NRCellDU" ADD CONSTRAINT "FK_o-ran-smo-teiv-ran_NRCellDU_REL_FK_provided-by-oduFunction" FOREIGN KEY ("REL_FK_provided-by-oduFunction") REFERENCES teiv_data."o-ran-smo-teiv-ran_ODUFunction" ("id");'
1422 );
1423
1424 SELECT teiv_data.create_constraint_if_not_exists(
1425         'o-ran-smo-teiv-ran_NRCellDU',
1426  'UNIQUE_B70F668E0E45FFFC5B7014489F6FD528EB15F192',
1427  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_NRCellDU" ADD CONSTRAINT "UNIQUE_B70F668E0E45FFFC5B7014489F6FD528EB15F192" UNIQUE ("REL_ID_ODUFUNCTION_PROVIDES_NRCELLDU");'
1428 );
1429
1430 SELECT teiv_data.create_constraint_if_not_exists(
1431         'o-ran-smo-teiv-ran_NRCellDU',
1432  'FK_o-ran-smo-teiv-ran_NRCellDU_REL_FK_grouped-by-sector',
1433  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_NRCellDU" ADD CONSTRAINT "FK_o-ran-smo-teiv-ran_NRCellDU_REL_FK_grouped-by-sector" FOREIGN KEY ("REL_FK_grouped-by-sector") REFERENCES teiv_data."o-ran-smo-teiv-ran_Sector" ("id");'
1434 );
1435
1436 SELECT teiv_data.create_constraint_if_not_exists(
1437         'o-ran-smo-teiv-ran_NRCellDU',
1438  'UNIQUE_AC1C114ABED77D6DEC3F3AE3F9EBE8231924AEF4',
1439  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_NRCellDU" ADD CONSTRAINT "UNIQUE_AC1C114ABED77D6DEC3F3AE3F9EBE8231924AEF4" UNIQUE ("REL_ID_SECTOR_GROUPS_NRCELLDU");'
1440 );
1441
1442 SELECT teiv_data.create_constraint_if_not_exists(
1443         'o-ran-smo-teiv-ran_NRSectorCarrier',
1444  'FK_o-ran-smo-teiv-ran_NRSectorCarrier_REL_FK_used-by-nrCellDu',
1445  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ADD CONSTRAINT "FK_o-ran-smo-teiv-ran_NRSectorCarrier_REL_FK_used-by-nrCellDu" FOREIGN KEY ("REL_FK_used-by-nrCellDu") REFERENCES teiv_data."o-ran-smo-teiv-ran_NRCellDU" ("id");'
1446 );
1447
1448 SELECT teiv_data.create_constraint_if_not_exists(
1449         'o-ran-smo-teiv-ran_NRSectorCarrier',
1450  'UNIQUE_1AB577E5AC207ED4C99A9A96BA1C9C35544AFD25',
1451  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ADD CONSTRAINT "UNIQUE_1AB577E5AC207ED4C99A9A96BA1C9C35544AFD25" UNIQUE ("REL_ID_NRCELLDU_USES_NRSECTORCARRIER");'
1452 );
1453
1454 SELECT teiv_data.create_constraint_if_not_exists(
1455         'o-ran-smo-teiv-ran_NRSectorCarrier',
1456  'FK_65D538D54EB33081C808540235FEB28823428E64',
1457  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ADD CONSTRAINT "FK_65D538D54EB33081C808540235FEB28823428E64" FOREIGN KEY ("REL_FK_used-antennaCapability") REFERENCES teiv_data."o-ran-smo-teiv-ran_AntennaCapability" ("id");'
1458 );
1459
1460 SELECT teiv_data.create_constraint_if_not_exists(
1461         'o-ran-smo-teiv-ran_NRSectorCarrier',
1462  'UNIQUE_A799EC9DA6624651081E1DA21B5F0C2D38F6A192',
1463  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ADD CONSTRAINT "UNIQUE_A799EC9DA6624651081E1DA21B5F0C2D38F6A192" UNIQUE ("REL_ID_NRSECTORCARRIER_USES_ANTENNACAPABILITY");'
1464 );
1465
1466 SELECT teiv_data.create_constraint_if_not_exists(
1467         'o-ran-smo-teiv-ran_NRSectorCarrier',
1468  'FK_9B73B9E2DBA36736FB76606005C823A6D565A5CD',
1469  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ADD CONSTRAINT "FK_9B73B9E2DBA36736FB76606005C823A6D565A5CD" FOREIGN KEY ("REL_FK_provided-by-oduFunction") REFERENCES teiv_data."o-ran-smo-teiv-ran_ODUFunction" ("id");'
1470 );
1471
1472 SELECT teiv_data.create_constraint_if_not_exists(
1473         'o-ran-smo-teiv-ran_NRSectorCarrier',
1474  'UNIQUE_D5D35955594A6EB48640425529F7DE44BED00B62',
1475  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ADD CONSTRAINT "UNIQUE_D5D35955594A6EB48640425529F7DE44BED00B62" UNIQUE ("REL_ID_ODUFUNCTION_PROVIDES_NRSECTORCARRIER");'
1476 );
1477
1478 SELECT teiv_data.create_constraint_if_not_exists(
1479         'o-ran-smo-teiv-ran_NearRTRICFunction',
1480  'FK_32BDE0334EA6AD74ABB3958A2B163F63A3F05203',
1481  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ADD CONSTRAINT "FK_32BDE0334EA6AD74ABB3958A2B163F63A3F05203" FOREIGN KEY ("REL_FK_managed-by-managedElement") REFERENCES teiv_data."o-ran-smo-teiv-oam_ManagedElement" ("id");'
1482 );
1483
1484 SELECT teiv_data.create_constraint_if_not_exists(
1485         'o-ran-smo-teiv-ran_NearRTRICFunction',
1486  'UNIQUE_E020461673334EB824643649B6B31670FB064EC8',
1487  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ADD CONSTRAINT "UNIQUE_E020461673334EB824643649B6B31670FB064EC8" UNIQUE ("REL_ID_MANAGEDELEMENT_MANAGES_NEARRTRICFUNCTION");'
1488 );
1489
1490 SELECT teiv_data.create_constraint_if_not_exists(
1491         'o-ran-smo-teiv-ran_NearRTRICFunction',
1492  'FK_38EF935E0C374C18F1865F231A3EA230FD743A91',
1493  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ADD CONSTRAINT "FK_38EF935E0C374C18F1865F231A3EA230FD743A91" FOREIGN KEY ("REL_FK_nearRTRICFunction-o1-linked-smo") REFERENCES teiv_data."o-ran-smo-teiv-ran_SMO" ("id");'
1494 );
1495
1496 SELECT teiv_data.create_constraint_if_not_exists(
1497         'o-ran-smo-teiv-ran_NearRTRICFunction',
1498  'UNIQUE_7F0B99D35476B0D3DB489400BA4456E1A31D24E0',
1499  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ADD CONSTRAINT "UNIQUE_7F0B99D35476B0D3DB489400BA4456E1A31D24E0" UNIQUE ("REL_ID_NEARRTRICFUNCTION_O1LINK_SMO");'
1500 );
1501
1502 SELECT teiv_data.create_constraint_if_not_exists(
1503         'o-ran-smo-teiv-ran_OCUCPFunction',
1504  'FK_122DD9709032528D161177B3624AD7AAF6589005',
1505  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ADD CONSTRAINT "FK_122DD9709032528D161177B3624AD7AAF6589005" FOREIGN KEY ("REL_FK_managed-by-managedElement") REFERENCES teiv_data."o-ran-smo-teiv-oam_ManagedElement" ("id");'
1506 );
1507
1508 SELECT teiv_data.create_constraint_if_not_exists(
1509         'o-ran-smo-teiv-ran_OCUCPFunction',
1510  'UNIQUE_2B7D3D49C1072E660047DE56843413CE628BF94A',
1511  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ADD CONSTRAINT "UNIQUE_2B7D3D49C1072E660047DE56843413CE628BF94A" UNIQUE ("REL_ID_MANAGEDELEMENT_MANAGES_OCUCPFUNCTION");'
1512 );
1513
1514 SELECT teiv_data.create_constraint_if_not_exists(
1515         'o-ran-smo-teiv-ran_OCUCPFunction',
1516  'FK_03B281BB0D7DB0CBC38DA02B76F4C5E8664040F0',
1517  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ADD CONSTRAINT "FK_03B281BB0D7DB0CBC38DA02B76F4C5E8664040F0" FOREIGN KEY ("REL_FK_ocucpFunction-e2-linked-ocuupFunction") REFERENCES teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ("id");'
1518 );
1519
1520 SELECT teiv_data.create_constraint_if_not_exists(
1521         'o-ran-smo-teiv-ran_OCUCPFunction',
1522  'UNIQUE_FB6281E267F316F3D288BFEF96319FFD5FF2E9CF',
1523  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ADD CONSTRAINT "UNIQUE_FB6281E267F316F3D288BFEF96319FFD5FF2E9CF" UNIQUE ("REL_ID_OCUCPFUNCTION_E1LINK_OCUUPFUNCTION");'
1524 );
1525
1526 SELECT teiv_data.create_constraint_if_not_exists(
1527         'o-ran-smo-teiv-ran_OCUCPFunction',
1528  'FK_92C27CC7666DB694835211BBAB9639C4FECAA639',
1529  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ADD CONSTRAINT "FK_92C27CC7666DB694835211BBAB9639C4FECAA639" FOREIGN KEY ("REL_FK_ocucpFunction-e2-linked-nearRTRICFunction") REFERENCES teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ("id");'
1530 );
1531
1532 SELECT teiv_data.create_constraint_if_not_exists(
1533         'o-ran-smo-teiv-ran_OCUCPFunction',
1534  'UNIQUE_636E8949BC041514E4F592F7B65FC701773C6067',
1535  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ADD CONSTRAINT "UNIQUE_636E8949BC041514E4F592F7B65FC701773C6067" UNIQUE ("REL_ID_OCUCPFUNCTION_E2LINK_NEARRTRICFUNCTION");'
1536 );
1537
1538 SELECT teiv_data.create_constraint_if_not_exists(
1539         'o-ran-smo-teiv-ran_OCUCPFunction',
1540  'FK_E31B73DB925367F14AEC0DA6EBD7C9BAD8C7A275',
1541  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ADD CONSTRAINT "FK_E31B73DB925367F14AEC0DA6EBD7C9BAD8C7A275" FOREIGN KEY ("REL_FK_ocucpFunction-o1-linked-smo") REFERENCES teiv_data."o-ran-smo-teiv-ran_SMO" ("id");'
1542 );
1543
1544 SELECT teiv_data.create_constraint_if_not_exists(
1545         'o-ran-smo-teiv-ran_OCUCPFunction',
1546  'UNIQUE_368AE553B3A5941070CAB09A7864BA7E9E08087B',
1547  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ADD CONSTRAINT "UNIQUE_368AE553B3A5941070CAB09A7864BA7E9E08087B" UNIQUE ("REL_ID_OCUCPFUNCTION_O1LINK_SMO");'
1548 );
1549
1550 SELECT teiv_data.create_constraint_if_not_exists(
1551         'o-ran-smo-teiv-ran_OCUUPFunction',
1552  'FK_8062AF50E5EE5543FBCC68D66FDFF673E31E081D',
1553  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ADD CONSTRAINT "FK_8062AF50E5EE5543FBCC68D66FDFF673E31E081D" FOREIGN KEY ("REL_FK_managed-by-managedElement") REFERENCES teiv_data."o-ran-smo-teiv-oam_ManagedElement" ("id");'
1554 );
1555
1556 SELECT teiv_data.create_constraint_if_not_exists(
1557         'o-ran-smo-teiv-ran_OCUUPFunction',
1558  'UNIQUE_DF85FE7809B5527CB4A6028DD1A599DBBD5AF214',
1559  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ADD CONSTRAINT "UNIQUE_DF85FE7809B5527CB4A6028DD1A599DBBD5AF214" UNIQUE ("REL_ID_MANAGEDELEMENT_MANAGES_OCUUPFUNCTION");'
1560 );
1561
1562 SELECT teiv_data.create_constraint_if_not_exists(
1563         'o-ran-smo-teiv-ran_OCUUPFunction',
1564  'FK_E8131DF616156B9C91CA7C5A68AE261FA00A89BA',
1565  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ADD CONSTRAINT "FK_E8131DF616156B9C91CA7C5A68AE261FA00A89BA" FOREIGN KEY ("REL_FK_ocuupFunction-e2-linked-nearRTRICFunction") REFERENCES teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ("id");'
1566 );
1567
1568 SELECT teiv_data.create_constraint_if_not_exists(
1569         'o-ran-smo-teiv-ran_OCUUPFunction',
1570  'UNIQUE_90EB740B5632402F115555B7387BC0A218B9A19F',
1571  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ADD CONSTRAINT "UNIQUE_90EB740B5632402F115555B7387BC0A218B9A19F" UNIQUE ("REL_ID_OCUUPFUNCTION_E2LINK_NEARRTRICFUNCTION");'
1572 );
1573
1574 SELECT teiv_data.create_constraint_if_not_exists(
1575         'o-ran-smo-teiv-ran_ODUFunction',
1576  'FK_B6F0A4F9024FB47DA39C9A4F1DFFF78330222A80',
1577  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ODUFunction" ADD CONSTRAINT "FK_B6F0A4F9024FB47DA39C9A4F1DFFF78330222A80" FOREIGN KEY ("REL_FK_managed-by-managedElement") REFERENCES teiv_data."o-ran-smo-teiv-oam_ManagedElement" ("id");'
1578 );
1579
1580 SELECT teiv_data.create_constraint_if_not_exists(
1581         'o-ran-smo-teiv-ran_ODUFunction',
1582  'UNIQUE_D570291C9E28A2AF73387B7A8B0F4C70130EEDB4',
1583  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ODUFunction" ADD CONSTRAINT "UNIQUE_D570291C9E28A2AF73387B7A8B0F4C70130EEDB4" UNIQUE ("REL_ID_MANAGEDELEMENT_MANAGES_ODUFUNCTION");'
1584 );
1585
1586 SELECT teiv_data.create_constraint_if_not_exists(
1587         'o-ran-smo-teiv-ran_ODUFunction',
1588  'FK_24F4D92B40E989ED842E75CBCDA1CFC16424FE87',
1589  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ODUFunction" ADD CONSTRAINT "FK_24F4D92B40E989ED842E75CBCDA1CFC16424FE87" FOREIGN KEY ("REL_FK_oduFunction-e2-linked-nearRTRICFunction") REFERENCES teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ("id");'
1590 );
1591
1592 SELECT teiv_data.create_constraint_if_not_exists(
1593         'o-ran-smo-teiv-ran_ODUFunction',
1594  'UNIQUE_F504808C587D183EA569C353BDCB7923AB1DDFE9',
1595  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ODUFunction" ADD CONSTRAINT "UNIQUE_F504808C587D183EA569C353BDCB7923AB1DDFE9" UNIQUE ("REL_ID_ODUFUNCTION_E2LINK_NEARRTRICFUNCTION");'
1596 );
1597
1598 SELECT teiv_data.create_constraint_if_not_exists(
1599         'o-ran-smo-teiv-ran_ODUFunction',
1600  'FK_8BC456F756C1DA4C4D8571A9A39030157AECD1DE',
1601  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ODUFunction" ADD CONSTRAINT "FK_8BC456F756C1DA4C4D8571A9A39030157AECD1DE" FOREIGN KEY ("REL_FK_oduFunction-f1-c-linked-ocucpFunction") REFERENCES teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ("id");'
1602 );
1603
1604 SELECT teiv_data.create_constraint_if_not_exists(
1605         'o-ran-smo-teiv-ran_ODUFunction',
1606  'UNIQUE_B3D6249002011DDAB474A440BEA6BDF00E1391CB',
1607  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ODUFunction" ADD CONSTRAINT "UNIQUE_B3D6249002011DDAB474A440BEA6BDF00E1391CB" UNIQUE ("REL_ID_ODUFUNCTION_F1CLINK_OCUCPFUNCTION");'
1608 );
1609
1610 SELECT teiv_data.create_constraint_if_not_exists(
1611         'o-ran-smo-teiv-ran_ODUFunction',
1612  'FK_C3185BEF15112E48700CBF1DB10FF50140F98DE7',
1613  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ODUFunction" ADD CONSTRAINT "FK_C3185BEF15112E48700CBF1DB10FF50140F98DE7" FOREIGN KEY ("REL_FK_oduFunction-f1-u-linked-ocuupFunction") REFERENCES teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ("id");'
1614 );
1615
1616 SELECT teiv_data.create_constraint_if_not_exists(
1617         'o-ran-smo-teiv-ran_ODUFunction',
1618  'UNIQUE_6CEC3CBD56C1EBB3972859FCF3847DBA01D943A5',
1619  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ODUFunction" ADD CONSTRAINT "UNIQUE_6CEC3CBD56C1EBB3972859FCF3847DBA01D943A5" UNIQUE ("REL_ID_ODUFUNCTION_F1ULINK_OCUUPFUNCTION");'
1620 );
1621
1622 SELECT teiv_data.create_constraint_if_not_exists(
1623         'o-ran-smo-teiv-ran_ODUFunction',
1624  'FK_629FF74123AF5F3D71FA78130DB028D84FC5B48F',
1625  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ODUFunction" ADD CONSTRAINT "FK_629FF74123AF5F3D71FA78130DB028D84FC5B48F" FOREIGN KEY ("REL_FK_oduFunction-o1-linked-smo") REFERENCES teiv_data."o-ran-smo-teiv-ran_SMO" ("id");'
1626 );
1627
1628 SELECT teiv_data.create_constraint_if_not_exists(
1629         'o-ran-smo-teiv-ran_ODUFunction',
1630  'UNIQUE_C95D4C8AC64C4CAF8BC4E10E54B5660E3B2EB82E',
1631  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ODUFunction" ADD CONSTRAINT "UNIQUE_C95D4C8AC64C4CAF8BC4E10E54B5660E3B2EB82E" UNIQUE ("REL_ID_ODUFUNCTION_O1LINK_SMO");'
1632 );
1633
1634 SELECT teiv_data.create_constraint_if_not_exists(
1635         'o-ran-smo-teiv-ran_ORUFunction',
1636  'FK_B497A8C3DC2D647938E6DB4C7E691509DD8C90DE',
1637  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ORUFunction" ADD CONSTRAINT "FK_B497A8C3DC2D647938E6DB4C7E691509DD8C90DE" FOREIGN KEY ("REL_FK_managed-by-managedElement") REFERENCES teiv_data."o-ran-smo-teiv-oam_ManagedElement" ("id");'
1638 );
1639
1640 SELECT teiv_data.create_constraint_if_not_exists(
1641         'o-ran-smo-teiv-ran_ORUFunction',
1642  'UNIQUE_4E6F008B82605A806EED04B2315A1FEE095A9241',
1643  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ORUFunction" ADD CONSTRAINT "UNIQUE_4E6F008B82605A806EED04B2315A1FEE095A9241" UNIQUE ("REL_ID_MANAGEDELEMENT_MANAGES_ORUFUNCTION");'
1644 );
1645
1646 SELECT teiv_data.create_constraint_if_not_exists(
1647         'o-ran-smo-teiv-ran_ORUFunction',
1648  'FK_DBE4275001B5740ED355F64F62F181489A4E398A',
1649  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ORUFunction" ADD CONSTRAINT "FK_DBE4275001B5740ED355F64F62F181489A4E398A" FOREIGN KEY ("REL_FK_oruFunction-o1-linked-smo") REFERENCES teiv_data."o-ran-smo-teiv-ran_SMO" ("id");'
1650 );
1651
1652 SELECT teiv_data.create_constraint_if_not_exists(
1653         'o-ran-smo-teiv-ran_ORUFunction',
1654  'UNIQUE_0FA79727AA200AB090C512DD295B96D44660D5DA',
1655  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ORUFunction" ADD CONSTRAINT "UNIQUE_0FA79727AA200AB090C512DD295B96D44660D5DA" UNIQUE ("REL_ID_ORUFUNCTION_O1LINK_SMO");'
1656 );
1657
1658 SELECT teiv_data.create_constraint_if_not_exists(
1659         'o-ran-smo-teiv-ran_ORUFunction',
1660  'FK_09032C749AEA4F56C53BB96DDB5B0FC46F586333',
1661  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ORUFunction" ADD CONSTRAINT "FK_09032C749AEA4F56C53BB96DDB5B0FC46F586333" FOREIGN KEY ("REL_FK_oruFunction-ofhc-linked-oduFunction") REFERENCES teiv_data."o-ran-smo-teiv-ran_ODUFunction" ("id");'
1662 );
1663
1664 SELECT teiv_data.create_constraint_if_not_exists(
1665         'o-ran-smo-teiv-ran_ORUFunction',
1666  'UNIQUE_AEAE9E71A4B9E40CABD1B03DE399873A593C232F',
1667  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ORUFunction" ADD CONSTRAINT "UNIQUE_AEAE9E71A4B9E40CABD1B03DE399873A593C232F" UNIQUE ("REL_ID_ORUFUNCTION_OFHCLINK_ODUFUNCTION");'
1668 );
1669
1670 SELECT teiv_data.create_constraint_if_not_exists(
1671         'o-ran-smo-teiv-ran_ORUFunction',
1672  'FK_7AF8E8A967D49CB387EE6804300D70FE35111A3B',
1673  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ORUFunction" ADD CONSTRAINT "FK_7AF8E8A967D49CB387EE6804300D70FE35111A3B" FOREIGN KEY ("REL_FK_oruFunction-ofhm-linked-oduFunction") REFERENCES teiv_data."o-ran-smo-teiv-ran_ODUFunction" ("id");'
1674 );
1675
1676 SELECT teiv_data.create_constraint_if_not_exists(
1677         'o-ran-smo-teiv-ran_ORUFunction',
1678  'UNIQUE_D08B266B3B0AF66E6EA629340B0D46C31E88B73F',
1679  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ORUFunction" ADD CONSTRAINT "UNIQUE_D08B266B3B0AF66E6EA629340B0D46C31E88B73F" UNIQUE ("REL_ID_ORUFUNCTION_OFHMLINK_ODUFUNCTION");'
1680 );
1681
1682 SELECT teiv_data.create_constraint_if_not_exists(
1683         'o-ran-smo-teiv-ran_ORUFunction',
1684  'FK_ACF604FA62A9B913BC1320824BF6D2E9766634DA',
1685  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ORUFunction" ADD CONSTRAINT "FK_ACF604FA62A9B913BC1320824BF6D2E9766634DA" FOREIGN KEY ("REL_FK_oruFunction-ofhm-linked-smo") REFERENCES teiv_data."o-ran-smo-teiv-ran_SMO" ("id");'
1686 );
1687
1688 SELECT teiv_data.create_constraint_if_not_exists(
1689         'o-ran-smo-teiv-ran_ORUFunction',
1690  'UNIQUE_9967840981340189977B88AA138C3773F21122C7',
1691  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ORUFunction" ADD CONSTRAINT "UNIQUE_9967840981340189977B88AA138C3773F21122C7" UNIQUE ("REL_ID_ORUFUNCTION_OFHMLINK_SMO");'
1692 );
1693
1694 SELECT teiv_data.create_constraint_if_not_exists(
1695         'o-ran-smo-teiv-ran_ORUFunction',
1696  'FK_2C3BB8ACA6BF4139102F14195012F211A1AB96CB',
1697  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ORUFunction" ADD CONSTRAINT "FK_2C3BB8ACA6BF4139102F14195012F211A1AB96CB" FOREIGN KEY ("REL_FK_oruFunction-ofhs-linked-oduFunction") REFERENCES teiv_data."o-ran-smo-teiv-ran_ODUFunction" ("id");'
1698 );
1699
1700 SELECT teiv_data.create_constraint_if_not_exists(
1701         'o-ran-smo-teiv-ran_ORUFunction',
1702  'UNIQUE_5CE3164003E7D1563EDF49E03067A4BEF651739A',
1703  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ORUFunction" ADD CONSTRAINT "UNIQUE_5CE3164003E7D1563EDF49E03067A4BEF651739A" UNIQUE ("REL_ID_ORUFUNCTION_OFHSLINK_ODUFUNCTION");'
1704 );
1705
1706 SELECT teiv_data.create_constraint_if_not_exists(
1707         'o-ran-smo-teiv-ran_ORUFunction',
1708  'FK_A07203CE9F3A264F2C5A8A293745D8C6F715D266',
1709  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ORUFunction" ADD CONSTRAINT "FK_A07203CE9F3A264F2C5A8A293745D8C6F715D266" FOREIGN KEY ("REL_FK_oruFunction-ofhu-linked-oduFunction") REFERENCES teiv_data."o-ran-smo-teiv-ran_ODUFunction" ("id");'
1710 );
1711
1712 SELECT teiv_data.create_constraint_if_not_exists(
1713         'o-ran-smo-teiv-ran_ORUFunction',
1714  'UNIQUE_AD5917CB1185E13CA09C58CC4E0D1974218C9E4D',
1715  'ALTER TABLE teiv_data."o-ran-smo-teiv-ran_ORUFunction" ADD CONSTRAINT "UNIQUE_AD5917CB1185E13CA09C58CC4E0D1974218C9E4D" UNIQUE ("REL_ID_ORUFUNCTION_OFHULINK_ODUFUNCTION");'
1716 );
1717
1718 SELECT teiv_data.create_constraint_if_not_exists(
1719         'o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUCPFUNCTION',
1720  'FK_2B4B09AF7CC9C877B1140BB127B4CB4DA438195D',
1721  'ALTER TABLE teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUCPFUNCTION" ADD CONSTRAINT "FK_2B4B09AF7CC9C877B1140BB127B4CB4DA438195D" FOREIGN KEY ("aSide_NFDeployment") REFERENCES teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ("id");'
1722 );
1723
1724 SELECT teiv_data.create_constraint_if_not_exists(
1725         'o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUCPFUNCTION',
1726  'FK_BCF2F9776761ABC19AE0BBD0244D7CD5785E7AC6',
1727  'ALTER TABLE teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUCPFUNCTION" ADD CONSTRAINT "FK_BCF2F9776761ABC19AE0BBD0244D7CD5785E7AC6" FOREIGN KEY ("bSide_OCUCPFunction") REFERENCES teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ("id");'
1728 );
1729
1730 SELECT teiv_data.create_constraint_if_not_exists(
1731         'o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUUPFUNCTION',
1732  'FK_AC1393DCBA845EDA13DADCB5BD87DF4163CD1669',
1733  'ALTER TABLE teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUUPFUNCTION" ADD CONSTRAINT "FK_AC1393DCBA845EDA13DADCB5BD87DF4163CD1669" FOREIGN KEY ("aSide_NFDeployment") REFERENCES teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ("id");'
1734 );
1735
1736 SELECT teiv_data.create_constraint_if_not_exists(
1737         'o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUUPFUNCTION',
1738  'FK_8585D545BC37A473A298E0F5F5942F897A7105B1',
1739  'ALTER TABLE teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUUPFUNCTION" ADD CONSTRAINT "FK_8585D545BC37A473A298E0F5F5942F897A7105B1" FOREIGN KEY ("bSide_OCUUPFunction") REFERENCES teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ("id");'
1740 );
1741
1742 SELECT teiv_data.create_constraint_if_not_exists(
1743         'o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_ODUFUNCTION',
1744  'FK_ABA5D0BEEB45E6A5B14DB24E880029CA38DF3F79',
1745  'ALTER TABLE teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_ODUFUNCTION" ADD CONSTRAINT "FK_ABA5D0BEEB45E6A5B14DB24E880029CA38DF3F79" FOREIGN KEY ("aSide_NFDeployment") REFERENCES teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ("id");'
1746 );
1747
1748 SELECT teiv_data.create_constraint_if_not_exists(
1749         'o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_ODUFUNCTION',
1750  'FK_C7C12DB840FBCF4EA729B8C2BBCD8BFDE06F0F08',
1751  'ALTER TABLE teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_ODUFUNCTION" ADD CONSTRAINT "FK_C7C12DB840FBCF4EA729B8C2BBCD8BFDE06F0F08" FOREIGN KEY ("bSide_ODUFunction") REFERENCES teiv_data."o-ran-smo-teiv-ran_ODUFunction" ("id");'
1752 );
1753
1754 SELECT teiv_data.create_constraint_if_not_exists(
1755         'o-ran-smo-teiv-rel-equipment-ran_ANTENNAMODULE_SERVES_NRCELLDU',
1756  'FK_1AB1E0CC29DA2E122D43A6616EC60A3F73E68649',
1757  'ALTER TABLE teiv_data."o-ran-smo-teiv-rel-equipment-ran_ANTENNAMODULE_SERVES_NRCELLDU" ADD CONSTRAINT "FK_1AB1E0CC29DA2E122D43A6616EC60A3F73E68649" FOREIGN KEY ("aSide_AntennaModule") REFERENCES teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ("id");'
1758 );
1759
1760 SELECT teiv_data.create_constraint_if_not_exists(
1761         'o-ran-smo-teiv-rel-equipment-ran_ANTENNAMODULE_SERVES_NRCELLDU',
1762  'FK_8605800A4923C52258A8CE3989E18A7C93D22E8C',
1763  'ALTER TABLE teiv_data."o-ran-smo-teiv-rel-equipment-ran_ANTENNAMODULE_SERVES_NRCELLDU" ADD CONSTRAINT "FK_8605800A4923C52258A8CE3989E18A7C93D22E8C" FOREIGN KEY ("bSide_NRCellDU") REFERENCES teiv_data."o-ran-smo-teiv-ran_NRCellDU" ("id");'
1764 );
1765
1766 CREATE INDEX IF NOT EXISTS "IDX_996D2C34C2458A6EFE8599C1A0E6942D3D288B7A" ON teiv_data."3C2E2CE7BDF8321BC824B6318B190690F58DBB82" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1767
1768 CREATE INDEX IF NOT EXISTS "IDX_F52FEEDBAF1B04D2D22EBAE051BB5125DF6A6968" ON teiv_data."3C2E2CE7BDF8321BC824B6318B190690F58DBB82" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1769
1770 CREATE INDEX IF NOT EXISTS "IDX_D333FA5882890B7CD3599712FFFB2641B9E04C80" ON teiv_data."3C2E2CE7BDF8321BC824B6318B190690F58DBB82" USING GIN ("CD_decorators");
1771
1772 CREATE INDEX IF NOT EXISTS "IDX_24AACA66F5AFB5E40FE93C3638C789D4D2A8F063" ON teiv_data."5A1D611A68E4A8B2F007A89876701DB3FA88346E" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1773
1774 CREATE INDEX IF NOT EXISTS "IDX_09295ADACB3D204E56C3917CB88E63FA186055A7" ON teiv_data."5A1D611A68E4A8B2F007A89876701DB3FA88346E" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1775
1776 CREATE INDEX IF NOT EXISTS "IDX_CBF202818AE6FB3A69C44CC7572BD63D284B1AF6" ON teiv_data."5A1D611A68E4A8B2F007A89876701DB3FA88346E" USING GIN ("CD_decorators");
1777
1778 CREATE INDEX IF NOT EXISTS "IDX_48546E24CFF2A489CA783C3D9E91AE5BF267F44E" ON teiv_data."AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1779
1780 CREATE INDEX IF NOT EXISTS "IDX_99049D602D6E4A25F14898B4E7F97479C42D61C4" ON teiv_data."AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1781
1782 CREATE INDEX IF NOT EXISTS "IDX_D11AD33EEC5B056675B950E3A1982AF2CD56EDEC" ON teiv_data."AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA" USING GIN ("CD_decorators");
1783
1784 CREATE INDEX IF NOT EXISTS "IDX_A79F66153A0C78659F90CAF80147401312B1D3E6" ON teiv_data."B83D20388E54C581319034D29C555DE6F8D938FF" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1785
1786 CREATE INDEX IF NOT EXISTS "IDX_BD4B6C32900972AA69A3E28241BE923C9A2C4C2B" ON teiv_data."B83D20388E54C581319034D29C555DE6F8D938FF" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1787
1788 CREATE INDEX IF NOT EXISTS "IDX_392C4E8EFF5A261C6FC2EADBCD2566B1BDD9484D" ON teiv_data."B83D20388E54C581319034D29C555DE6F8D938FF" USING GIN ("CD_decorators");
1789
1790 CREATE INDEX IF NOT EXISTS "IDX_E896A9EB22A3F9F96CE75A271475316A98B629C8" ON teiv_data."CFC235E0404703D1E4454647DF8AAE2C193DB402" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1791
1792 CREATE INDEX IF NOT EXISTS "IDX_DD0D676834B12CA2F7E8219310998376A08D7F5F" ON teiv_data."CFC235E0404703D1E4454647DF8AAE2C193DB402" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1793
1794 CREATE INDEX IF NOT EXISTS "IDX_7BF09D0227840279556AD27ACECB068705893D28" ON teiv_data."CFC235E0404703D1E4454647DF8AAE2C193DB402" USING GIN ("CD_decorators");
1795
1796 CREATE INDEX IF NOT EXISTS "IDX_CF2AE01363E39CE4B5541047403F5354AA36E30E" ON teiv_data."D4A45C271462B28FB655CFCF2F2D826236C78062" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1797
1798 CREATE INDEX IF NOT EXISTS "IDX_0D8159380FCF878593989891969AD9DCF3A75A28" ON teiv_data."D4A45C271462B28FB655CFCF2F2D826236C78062" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1799
1800 CREATE INDEX IF NOT EXISTS "IDX_1FAB22E8654FEFF5EAC13C58CEA0CCADEBECD4FF" ON teiv_data."D4A45C271462B28FB655CFCF2F2D826236C78062" USING GIN ("CD_decorators");
1801
1802 CREATE INDEX IF NOT EXISTS "IDX_9EDB5C47201FC82A4565BFED9EF369D6C6529B19" ON teiv_data."o-ran-smo-teiv-cloud_CloudifiedNF" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1803
1804 CREATE INDEX IF NOT EXISTS "IDX_BD96130868B69147B2F87B0D15F5829690DEF454" ON teiv_data."o-ran-smo-teiv-cloud_CloudifiedNF" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1805
1806 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-cloud_CloudifiedNF_CD_decorators" ON teiv_data."o-ran-smo-teiv-cloud_CloudifiedNF" USING GIN ("CD_decorators");
1807
1808 CREATE INDEX IF NOT EXISTS "IDX_F97E398B17532BCD9923CE0CF98E73227D890037" ON teiv_data."o-ran-smo-teiv-cloud_NFDEPLOYMENT_DEPLOYED_ON_OCLOUDNAMESPACE" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1809
1810 CREATE INDEX IF NOT EXISTS "IDX_1BCFD9635C4FA089EDC2E18FFEF56DBF3C5E7A52" ON teiv_data."o-ran-smo-teiv-cloud_NFDEPLOYMENT_DEPLOYED_ON_OCLOUDNAMESPACE" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1811
1812 CREATE INDEX IF NOT EXISTS "IDX_4055A796F223DD01411AFFB5AD97EEEAB6B2320C" ON teiv_data."o-ran-smo-teiv-cloud_NFDEPLOYMENT_DEPLOYED_ON_OCLOUDNAMESPACE" USING GIN ("CD_decorators");
1813
1814 CREATE INDEX IF NOT EXISTS "IDX_6433B9B7D69E51E828BDCFCAF59729EDCD10DA60" ON teiv_data."o-ran-smo-teiv-cloud_NFDeployment" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1815
1816 CREATE INDEX IF NOT EXISTS "IDX_BED5B5FAA75FEE133E27581EAA611B89D20F24E1" ON teiv_data."o-ran-smo-teiv-cloud_NFDeployment" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1817
1818 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-cloud_NFDeployment_CD_decorators" ON teiv_data."o-ran-smo-teiv-cloud_NFDeployment" USING GIN ("CD_decorators");
1819
1820 CREATE INDEX IF NOT EXISTS "IDX_072EB0C094138AB2D90F9CFBDA765B3B464EE86F" ON teiv_data."o-ran-smo-teiv-cloud_NFDeployment" USING GIN (("REL_CD_sourceIds_CLOUDIFIEDNF_COMPRISES_NFDEPLOYMENT"::TEXT) gin_trgm_ops);
1821
1822 CREATE INDEX IF NOT EXISTS "IDX_31F185F0F700C0AE11C5A9B8D28DBF6E37538635" ON teiv_data."o-ran-smo-teiv-cloud_NFDeployment" USING GIN (("REL_CD_classifiers_CLOUDIFIEDNF_COMPRISES_NFDEPLOYMENT"::TEXT) gin_trgm_ops);
1823
1824 CREATE INDEX IF NOT EXISTS "IDX_46CDB369134F042EC021F7496DF721B49A9D43C0" ON teiv_data."o-ran-smo-teiv-cloud_NFDeployment" USING GIN ("REL_CD_decorators_CLOUDIFIEDNF_COMPRISES_NFDEPLOYMENT");
1825
1826 CREATE INDEX IF NOT EXISTS "IDX_4DD95BAED8503502101FEB9ECA25DDA8F371816C" ON teiv_data."o-ran-smo-teiv-cloud_NFDeployment" USING GIN (("REL_CD_sourceIds_NFDEPLOYMENT_SERVES_MANAGEDELEMENT"::TEXT) gin_trgm_ops);
1827
1828 CREATE INDEX IF NOT EXISTS "IDX_1EE98ACCAE5537752BD51A3D5F6429585CC543F6" ON teiv_data."o-ran-smo-teiv-cloud_NFDeployment" USING GIN (("REL_CD_classifiers_NFDEPLOYMENT_SERVES_MANAGEDELEMENT"::TEXT) gin_trgm_ops);
1829
1830 CREATE INDEX IF NOT EXISTS "IDX_39A292C3C42B34C2AD7C2A0FD087739C253B06FC" ON teiv_data."o-ran-smo-teiv-cloud_NFDeployment" USING GIN ("REL_CD_decorators_NFDEPLOYMENT_SERVES_MANAGEDELEMENT");
1831
1832 CREATE INDEX IF NOT EXISTS "IDX_1D7F9BD4B5BBF73CC3D06D949731DC169DDED26D" ON teiv_data."o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1833
1834 CREATE INDEX IF NOT EXISTS "IDX_29702D5C8D0B9B20BFB534FA233B9D9FADC2E3A1" ON teiv_data."o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1835
1836 CREATE INDEX IF NOT EXISTS "IDX_98A32BE3A8C1FF8CDEC95561DE4A74852FE70322" ON teiv_data."o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE" USING GIN ("CD_decorators");
1837
1838 CREATE INDEX IF NOT EXISTS "IDX_DC1829E4241BA7C9B3E5281AC0DF00A766F9452E" ON teiv_data."o-ran-smo-teiv-cloud_NodeCluster" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1839
1840 CREATE INDEX IF NOT EXISTS "IDX_CB29E8DDA990051B2A3DF193D8E4912F25D5FA0D" ON teiv_data."o-ran-smo-teiv-cloud_NodeCluster" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1841
1842 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-cloud_NodeCluster_CD_decorators" ON teiv_data."o-ran-smo-teiv-cloud_NodeCluster" USING GIN ("CD_decorators");
1843
1844 CREATE INDEX IF NOT EXISTS "IDX_1B8DF6B061E229E5B6AC796911E6C8C23ECAD585" ON teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1845
1846 CREATE INDEX IF NOT EXISTS "IDX_57EB74DEF745DE4BA9AAD8E735BACB71F2E8C417" ON teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1847
1848 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-cloud_OCloudNamespace_CD_decorators" ON teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" USING GIN ("CD_decorators");
1849
1850 CREATE INDEX IF NOT EXISTS "IDX_A7A50200F582AB86EF483F9BA74F999F17B7F653" ON teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" USING GIN (("REL_CD_sourceIds_OCLOUDNAMESPACE_DEPLOYED_ON_NODECLUSTER"::TEXT) gin_trgm_ops);
1851
1852 CREATE INDEX IF NOT EXISTS "IDX_6EE081E80342904B676496DA42DFAEC3EDA2CE27" ON teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" USING GIN (("REL_CD_classifiers_OCLOUDNAMESPACE_DEPLOYED_ON_NODECLUSTER"::TEXT) gin_trgm_ops);
1853
1854 CREATE INDEX IF NOT EXISTS "IDX_9AB8994DE0826F790D70614D4C52DD270AEF946B" ON teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" USING GIN ("REL_CD_decorators_OCLOUDNAMESPACE_DEPLOYED_ON_NODECLUSTER");
1855
1856 CREATE INDEX IF NOT EXISTS "IDX_30C83E5F8447D28D8E2A73048DF751C886AF318B" ON teiv_data."o-ran-smo-teiv-cloud_OCloudSite" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1857
1858 CREATE INDEX IF NOT EXISTS "IDX_281A2DE604D25D6CFECB9B26D1FF70429FDB0FD0" ON teiv_data."o-ran-smo-teiv-cloud_OCloudSite" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1859
1860 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-cloud_OCloudSite_CD_decorators" ON teiv_data."o-ran-smo-teiv-cloud_OCloudSite" USING GIN ("CD_decorators");
1861
1862 CREATE INDEX IF NOT EXISTS "IDX_21B0F1FE632B6CB185C49BA6F00224068F443215" ON teiv_data."o-ran-smo-teiv-equipment_AntennaModule" USING GIN (("antennaBeamWidth"::TEXT) gin_trgm_ops);
1863
1864 CREATE INDEX IF NOT EXISTS "IDX_905011128A2C218B5352C19ED1FE9851F43EB911" ON teiv_data."o-ran-smo-teiv-equipment_AntennaModule" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1865
1866 CREATE INDEX IF NOT EXISTS "IDX_1C0CAFD80FDD6444044E3F76C7C0A7BDC35F9BC8" ON teiv_data."o-ran-smo-teiv-equipment_AntennaModule" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1867
1868 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-equipment_AntennaModule_CD_decorators" ON teiv_data."o-ran-smo-teiv-equipment_AntennaModule" USING GIN ("CD_decorators");
1869
1870 CREATE INDEX IF NOT EXISTS "IDX_F497DEC01DA066CB09DA2AA7EDE3F4410078491B" ON teiv_data."o-ran-smo-teiv-equipment_AntennaModule" USING GIN (("REL_CD_sourceIds_ANTENNAMODULE_INSTALLED_AT_SITE"::TEXT) gin_trgm_ops);
1871
1872 CREATE INDEX IF NOT EXISTS "IDX_17E417F7EF56809674BE1D5F5154DCCE01E00A96" ON teiv_data."o-ran-smo-teiv-equipment_AntennaModule" USING GIN (("REL_CD_classifiers_ANTENNAMODULE_INSTALLED_AT_SITE"::TEXT) gin_trgm_ops);
1873
1874 CREATE INDEX IF NOT EXISTS "IDX_2321BFA482AD2700F41E2BA359F6EB00F47601B9" ON teiv_data."o-ran-smo-teiv-equipment_AntennaModule" USING GIN ("REL_CD_decorators_ANTENNAMODULE_INSTALLED_AT_SITE");
1875
1876 CREATE INDEX IF NOT EXISTS "IDX_5ABDB19E55A6BDEF33855F14CB1B3B8CF457912C" ON teiv_data."o-ran-smo-teiv-equipment_AntennaModule" USING GIN (("REL_CD_sourceIds_SECTOR_GROUPS_ANTENNAMODULE"::TEXT) gin_trgm_ops);
1877
1878 CREATE INDEX IF NOT EXISTS "IDX_83B6347C0C0A005D5E3D856D973D3322DFEDEA35" ON teiv_data."o-ran-smo-teiv-equipment_AntennaModule" USING GIN (("REL_CD_classifiers_SECTOR_GROUPS_ANTENNAMODULE"::TEXT) gin_trgm_ops);
1879
1880 CREATE INDEX IF NOT EXISTS "IDX_6C6FBD69F47F41970595A8775DC99CA0F5E894A1" ON teiv_data."o-ran-smo-teiv-equipment_AntennaModule" USING GIN ("REL_CD_decorators_SECTOR_GROUPS_ANTENNAMODULE");
1881
1882 CREATE INDEX IF NOT EXISTS "IDX_102A50584376DE25B6BBD7157594C607A5C957F2" ON teiv_data."o-ran-smo-teiv-equipment_Site" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1883
1884 CREATE INDEX IF NOT EXISTS "IDX_EEBF1BC3344E97988232825777AB13FAB6C4F3F0" ON teiv_data."o-ran-smo-teiv-equipment_Site" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1885
1886 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-equipment_Site_CD_decorators" ON teiv_data."o-ran-smo-teiv-equipment_Site" USING GIN ("CD_decorators");
1887
1888 CREATE INDEX IF NOT EXISTS "IDX_DDD73D6F4004BF3A96AA118281EE3E565A922B47" ON teiv_data."o-ran-smo-teiv-oam_ManagedElement" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1889
1890 CREATE INDEX IF NOT EXISTS "IDX_98AC4232BC02323E03416954215889CEE874A1E9" ON teiv_data."o-ran-smo-teiv-oam_ManagedElement" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1891
1892 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-oam_ManagedElement_CD_decorators" ON teiv_data."o-ran-smo-teiv-oam_ManagedElement" USING GIN ("CD_decorators");
1893
1894 CREATE INDEX IF NOT EXISTS "IDX_8065626F3F48D4E5A4285654739D3B26499E4C4E" ON teiv_data."o-ran-smo-teiv-oam_ManagedElement" USING GIN (("REL_CD_sourceIds_MANAGEDELEMENT_DEPLOYED_AS_CLOUDIFIEDNF"::TEXT) gin_trgm_ops);
1895
1896 CREATE INDEX IF NOT EXISTS "IDX_634619CF7333EBC0AFDE990900B79220FC626EBA" ON teiv_data."o-ran-smo-teiv-oam_ManagedElement" USING GIN (("REL_CD_classifiers_MANAGEDELEMENT_DEPLOYED_AS_CLOUDIFIEDNF"::TEXT) gin_trgm_ops);
1897
1898 CREATE INDEX IF NOT EXISTS "IDX_F15A070FC83B2E49223B4232E0BEB8931C2B7A4C" ON teiv_data."o-ran-smo-teiv-oam_ManagedElement" USING GIN ("REL_CD_decorators_MANAGEDELEMENT_DEPLOYED_AS_CLOUDIFIEDNF");
1899
1900 CREATE INDEX IF NOT EXISTS "IDX_9159E48882E10BD6AD511721D591EABE231A0C16" ON teiv_data."o-ran-smo-teiv-physical_PHYSICALAPPLIANCE_INSTALLEDAT_SITE" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1901
1902 CREATE INDEX IF NOT EXISTS "IDX_4A8DA56C1989C762E2026427F92B787B11632C30" ON teiv_data."o-ran-smo-teiv-physical_PHYSICALAPPLIANCE_INSTALLEDAT_SITE" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1903
1904 CREATE INDEX IF NOT EXISTS "IDX_4CFE6D1BF80F10055EEF778827B1B769EB9FBFE7" ON teiv_data."o-ran-smo-teiv-physical_PHYSICALAPPLIANCE_INSTALLEDAT_SITE" USING GIN ("CD_decorators");
1905
1906 CREATE INDEX IF NOT EXISTS "IDX_CD60BBA5629EE3D5882EE9907BAB87E9E18BF2A4" ON teiv_data."o-ran-smo-teiv-physical_PhysicalAppliance" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1907
1908 CREATE INDEX IF NOT EXISTS "IDX_1D52205C41F3233591749A18B5ED604A4A6B5144" ON teiv_data."o-ran-smo-teiv-physical_PhysicalAppliance" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1909
1910 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-physical_PhysicalAppliance_CD_decorators" ON teiv_data."o-ran-smo-teiv-physical_PhysicalAppliance" USING GIN ("CD_decorators");
1911
1912 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-physical_Site_siteLocation" ON teiv_data."o-ran-smo-teiv-physical_Site" USING GIN ("siteLocation");
1913
1914 CREATE INDEX IF NOT EXISTS "IDX_555DE28C10DDDB6CB6AB619D5C71E93068D432FB" ON teiv_data."o-ran-smo-teiv-physical_Site" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1915
1916 CREATE INDEX IF NOT EXISTS "IDX_DCA080CB1439BEFA5461FD03A76033285B9A8EA2" ON teiv_data."o-ran-smo-teiv-physical_Site" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1917
1918 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-physical_Site_CD_decorators" ON teiv_data."o-ran-smo-teiv-physical_Site" USING GIN ("CD_decorators");
1919
1920 CREATE INDEX IF NOT EXISTS "IDX_5FB80647AE3E5C0443A792618D65B9090EE2A3FC" ON teiv_data."o-ran-smo-teiv-ran_AntennaCapability" USING GIN (("eUtranFqBands"::TEXT) gin_trgm_ops);
1921
1922 CREATE INDEX IF NOT EXISTS "IDX_A94722FF7B95D8974B494793908B57B4E1A9743B" ON teiv_data."o-ran-smo-teiv-ran_AntennaCapability" USING GIN (("geranFqBands"::TEXT) gin_trgm_ops);
1923
1924 CREATE INDEX IF NOT EXISTS "IDX_441B5C05448D63552C6414BD59C13641D8A4408D" ON teiv_data."o-ran-smo-teiv-ran_AntennaCapability" USING GIN (("nRFqBands"::TEXT) gin_trgm_ops);
1925
1926 CREATE INDEX IF NOT EXISTS "IDX_CC3E208A4EE51D3B505416A599F36F3C99F466C8" ON teiv_data."o-ran-smo-teiv-ran_AntennaCapability" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1927
1928 CREATE INDEX IF NOT EXISTS "IDX_E7FFE8F4A166AA9A382A0659762FFEC313A9EB5C" ON teiv_data."o-ran-smo-teiv-ran_AntennaCapability" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1929
1930 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-ran_AntennaCapability_CD_decorators" ON teiv_data."o-ran-smo-teiv-ran_AntennaCapability" USING GIN ("CD_decorators");
1931
1932 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-ran_NRCellCU_plmnId" ON teiv_data."o-ran-smo-teiv-ran_NRCellCU" USING GIN ("plmnId");
1933
1934 CREATE INDEX IF NOT EXISTS "IDX_0C443A16285D233F16966C2F0314CDC9D0F6D0B8" ON teiv_data."o-ran-smo-teiv-ran_NRCellCU" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1935
1936 CREATE INDEX IF NOT EXISTS "IDX_E5930226819982DC0CFC1FA64FB3600647222435" ON teiv_data."o-ran-smo-teiv-ran_NRCellCU" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1937
1938 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-ran_NRCellCU_CD_decorators" ON teiv_data."o-ran-smo-teiv-ran_NRCellCU" USING GIN ("CD_decorators");
1939
1940 CREATE INDEX IF NOT EXISTS "IDX_6891C1BB8EE214340A362906C08955E8ACC1C597" ON teiv_data."o-ran-smo-teiv-ran_NRCellCU" USING GIN (("REL_CD_sourceIds_OCUCPFUNCTION_PROVIDES_NRCELLCU"::TEXT) gin_trgm_ops);
1941
1942 CREATE INDEX IF NOT EXISTS "IDX_D366F952FD4A52645C45A19CBFD02B8897FC1F18" ON teiv_data."o-ran-smo-teiv-ran_NRCellCU" USING GIN (("REL_CD_classifiers_OCUCPFUNCTION_PROVIDES_NRCELLCU"::TEXT) gin_trgm_ops);
1943
1944 CREATE INDEX IF NOT EXISTS "IDX_5D761303176D3B9338784DFBEE0CEC51046ADC30" ON teiv_data."o-ran-smo-teiv-ran_NRCellCU" USING GIN ("REL_CD_decorators_OCUCPFUNCTION_PROVIDES_NRCELLCU");
1945
1946 CREATE INDEX IF NOT EXISTS "IDX_FFD60DD99D80C276F402E66546F5DACB2D81EE26" ON teiv_data."o-ran-smo-teiv-ran_NRCellDU" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1947
1948 CREATE INDEX IF NOT EXISTS "IDX_C437D39632DC79BAB6AC4F0880826A05425F9C32" ON teiv_data."o-ran-smo-teiv-ran_NRCellDU" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1949
1950 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-ran_NRCellDU_CD_decorators" ON teiv_data."o-ran-smo-teiv-ran_NRCellDU" USING GIN ("CD_decorators");
1951
1952 CREATE INDEX IF NOT EXISTS "IDX_B48D188E92ACBE9A2CAF8CD730A5DDFD7E086705" ON teiv_data."o-ran-smo-teiv-ran_NRCellDU" USING GIN (("REL_CD_sourceIds_ODUFUNCTION_PROVIDES_NRCELLDU"::TEXT) gin_trgm_ops);
1953
1954 CREATE INDEX IF NOT EXISTS "IDX_A950BF337D5D820E5B39AC3F1B1AC09C062F30C9" ON teiv_data."o-ran-smo-teiv-ran_NRCellDU" USING GIN (("REL_CD_classifiers_ODUFUNCTION_PROVIDES_NRCELLDU"::TEXT) gin_trgm_ops);
1955
1956 CREATE INDEX IF NOT EXISTS "IDX_F494CB3BA4C726D4C45D53B1EF62E1E26811CCEF" ON teiv_data."o-ran-smo-teiv-ran_NRCellDU" USING GIN ("REL_CD_decorators_ODUFUNCTION_PROVIDES_NRCELLDU");
1957
1958 CREATE INDEX IF NOT EXISTS "IDX_6325926B4D2FDD1FBBB34250DABEA5E7229FF9F5" ON teiv_data."o-ran-smo-teiv-ran_NRCellDU" USING GIN (("REL_CD_sourceIds_SECTOR_GROUPS_NRCELLDU"::TEXT) gin_trgm_ops);
1959
1960 CREATE INDEX IF NOT EXISTS "IDX_7CB4A7724F68D1CB2D12E8DE779BA9103F7DBE0A" ON teiv_data."o-ran-smo-teiv-ran_NRCellDU" USING GIN (("REL_CD_classifiers_SECTOR_GROUPS_NRCELLDU"::TEXT) gin_trgm_ops);
1961
1962 CREATE INDEX IF NOT EXISTS "IDX_0A03C47C13AD3B5C84D3D8081493D670E9CBDCD1" ON teiv_data."o-ran-smo-teiv-ran_NRCellDU" USING GIN ("REL_CD_decorators_SECTOR_GROUPS_NRCELLDU");
1963
1964 CREATE INDEX IF NOT EXISTS "IDX_8E34EC0B1DE7DDCE3B32ADD85B11E15F95C5644E" ON teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1965
1966 CREATE INDEX IF NOT EXISTS "IDX_050A80BEEF775E4D3CE216F282F23DB99DA2D798" ON teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1967
1968 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-ran_NRSectorCarrier_CD_decorators" ON teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" USING GIN ("CD_decorators");
1969
1970 CREATE INDEX IF NOT EXISTS "IDX_7BFD17A71AB1B7765FE6431DA4E66C2EDE88AC3B" ON teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" USING GIN (("REL_CD_sourceIds_NRCELLDU_USES_NRSECTORCARRIER"::TEXT) gin_trgm_ops);
1971
1972 CREATE INDEX IF NOT EXISTS "IDX_ED50A5139F1449DBAD8DA10D45F5A5BF819EACBA" ON teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" USING GIN (("REL_CD_classifiers_NRCELLDU_USES_NRSECTORCARRIER"::TEXT) gin_trgm_ops);
1973
1974 CREATE INDEX IF NOT EXISTS "IDX_2ADB5C6DCAEE8811FB1CA8FD9EB53381F35FCB70" ON teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" USING GIN ("REL_CD_decorators_NRCELLDU_USES_NRSECTORCARRIER");
1975
1976 CREATE INDEX IF NOT EXISTS "IDX_1F27C515A028616FAC422A02ABBEC402D5DBB2E5" ON teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" USING GIN (("REL_CD_sourceIds_NRSECTORCARRIER_USES_ANTENNACAPABILITY"::TEXT) gin_trgm_ops);
1977
1978 CREATE INDEX IF NOT EXISTS "IDX_B975D24291849007D4AA6686C5D3983885D5C884" ON teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" USING GIN (("REL_CD_classifiers_NRSECTORCARRIER_USES_ANTENNACAPABILITY"::TEXT) gin_trgm_ops);
1979
1980 CREATE INDEX IF NOT EXISTS "IDX_902B73F741160B9D4FBF62406D3D9ABBECAD8BE7" ON teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" USING GIN ("REL_CD_decorators_NRSECTORCARRIER_USES_ANTENNACAPABILITY");
1981
1982 CREATE INDEX IF NOT EXISTS "IDX_986B2223E72FF79237337329F4C3BB9DA9025A34" ON teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" USING GIN (("REL_CD_sourceIds_ODUFUNCTION_PROVIDES_NRSECTORCARRIER"::TEXT) gin_trgm_ops);
1983
1984 CREATE INDEX IF NOT EXISTS "IDX_FC70CCFDC1359B698BBBE5CA7AA158F0AF693461" ON teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" USING GIN (("REL_CD_classifiers_ODUFUNCTION_PROVIDES_NRSECTORCARRIER"::TEXT) gin_trgm_ops);
1985
1986 CREATE INDEX IF NOT EXISTS "IDX_5AB1D780E57D940C42BAD29772E9E2B6C63498A0" ON teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" USING GIN ("REL_CD_decorators_ODUFUNCTION_PROVIDES_NRSECTORCARRIER");
1987
1988 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-ran_NearRTRICFunction_pLMNId" ON teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" USING GIN ("pLMNId");
1989
1990 CREATE INDEX IF NOT EXISTS "IDX_E4E40B26C322AF63A662706AF8B0B36E1043B793" ON teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1991
1992 CREATE INDEX IF NOT EXISTS "IDX_8BCCF388DFC8652AD5CD0675C64F49D2D2EDC7A1" ON teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1993
1994 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-ran_NearRTRICFunction_CD_decorators" ON teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" USING GIN ("CD_decorators");
1995
1996 CREATE INDEX IF NOT EXISTS "IDX_B608D8F6B8A79097EA61A1B4777A96CD3D2D1E98" ON teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" USING GIN (("REL_CD_sourceIds_MANAGEDELEMENT_MANAGES_NEARRTRICFUNCTION"::TEXT) gin_trgm_ops);
1997
1998 CREATE INDEX IF NOT EXISTS "IDX_0ECC814A408874C9F8E73EEE3968984A6345A606" ON teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" USING GIN (("REL_CD_classifiers_MANAGEDELEMENT_MANAGES_NEARRTRICFUNCTION"::TEXT) gin_trgm_ops);
1999
2000 CREATE INDEX IF NOT EXISTS "IDX_B10FD045A6C3E169953CCC38CC2D801FCE15A75F" ON teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" USING GIN ("REL_CD_decorators_MANAGEDELEMENT_MANAGES_NEARRTRICFUNCTION");
2001
2002 CREATE INDEX IF NOT EXISTS "IDX_6B3AF742DAE59FE0E798E67C7E2417783464FD8D" ON teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" USING GIN (("REL_CD_sourceIds_NEARRTRICFUNCTION_O1LINK_SMO"::TEXT) gin_trgm_ops);
2003
2004 CREATE INDEX IF NOT EXISTS "IDX_F2F838B3DBDF4E0EFC3FC2096F7549740976B346" ON teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" USING GIN (("REL_CD_classifiers_NEARRTRICFUNCTION_O1LINK_SMO"::TEXT) gin_trgm_ops);
2005
2006 CREATE INDEX IF NOT EXISTS "IDX_218EB3FA277F4E7F72EC345841246A5BB3402E28" ON teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" USING GIN ("REL_CD_decorators_NEARRTRICFUNCTION_O1LINK_SMO");
2007
2008 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-ran_OCUCPFunction_pLMNId" ON teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" USING GIN ("pLMNId");
2009
2010 CREATE INDEX IF NOT EXISTS "IDX_84A29F8571860AC5A7BD1A99923485ECB6A3939D" ON teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
2011
2012 CREATE INDEX IF NOT EXISTS "IDX_8D9862DBF6A721FABAEA4204E04B374692C1C5B8" ON teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
2013
2014 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-ran_OCUCPFunction_CD_decorators" ON teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" USING GIN ("CD_decorators");
2015
2016 CREATE INDEX IF NOT EXISTS "IDX_4C6B5CB5CF018656DC8191CE6FE3B9DA2CD0C819" ON teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" USING GIN (("REL_CD_sourceIds_MANAGEDELEMENT_MANAGES_OCUCPFUNCTION"::TEXT) gin_trgm_ops);
2017
2018 CREATE INDEX IF NOT EXISTS "IDX_21F2560C8330A795E8AFB54C6D31CDCF6CCD3070" ON teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" USING GIN (("REL_CD_classifiers_MANAGEDELEMENT_MANAGES_OCUCPFUNCTION"::TEXT) gin_trgm_ops);
2019
2020 CREATE INDEX IF NOT EXISTS "IDX_D856E84F300B6711E81931AE1CBC8AD905FA384F" ON teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" USING GIN ("REL_CD_decorators_MANAGEDELEMENT_MANAGES_OCUCPFUNCTION");
2021
2022 CREATE INDEX IF NOT EXISTS "IDX_13597F9B767DD22A86305D13FF5B050BFE06B14D" ON teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" USING GIN (("REL_CD_sourceIds_OCUCPFUNCTION_E1LINK_OCUUPFUNCTION"::TEXT) gin_trgm_ops);
2023
2024 CREATE INDEX IF NOT EXISTS "IDX_4D7E42AC9DF388919712322B7C0169A370E56ADF" ON teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" USING GIN (("REL_CD_classifiers_OCUCPFUNCTION_E1LINK_OCUUPFUNCTION"::TEXT) gin_trgm_ops);
2025
2026 CREATE INDEX IF NOT EXISTS "IDX_7F7A8AE3E6B3F57A5D1273A1243A79CABA4753C0" ON teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" USING GIN ("REL_CD_decorators_OCUCPFUNCTION_E1LINK_OCUUPFUNCTION");
2027
2028 CREATE INDEX IF NOT EXISTS "IDX_48341F480087D5BD4C2A19DCA0083184B7178A43" ON teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" USING GIN (("REL_CD_sourceIds_OCUCPFUNCTION_E2LINK_NEARRTRICFUNCTION"::TEXT) gin_trgm_ops);
2029
2030 CREATE INDEX IF NOT EXISTS "IDX_090E0962B4064F2ECF7C3256325BF2A30BCE85B8" ON teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" USING GIN (("REL_CD_classifiers_OCUCPFUNCTION_E2LINK_NEARRTRICFUNCTION"::TEXT) gin_trgm_ops);
2031
2032 CREATE INDEX IF NOT EXISTS "IDX_C470E73FA66AEA37FBC2C25AEFB2B959BEA0FBB2" ON teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" USING GIN ("REL_CD_decorators_OCUCPFUNCTION_E2LINK_NEARRTRICFUNCTION");
2033
2034 CREATE INDEX IF NOT EXISTS "IDX_2F4FCB18A717B38224F5BAA484D2EFE26A458CC7" ON teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" USING GIN (("REL_CD_sourceIds_OCUCPFUNCTION_O1LINK_SMO"::TEXT) gin_trgm_ops);
2035
2036 CREATE INDEX IF NOT EXISTS "IDX_D9ADFBBC5360F5D511E0E67A0D13622A4BBD78E1" ON teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" USING GIN (("REL_CD_classifiers_OCUCPFUNCTION_O1LINK_SMO"::TEXT) gin_trgm_ops);
2037
2038 CREATE INDEX IF NOT EXISTS "IDX_FC018070572BA39A4683CBDDCAAA16D3A9129DB8" ON teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" USING GIN ("REL_CD_decorators_OCUCPFUNCTION_O1LINK_SMO");
2039
2040 CREATE INDEX IF NOT EXISTS "IDX_9122DAA7A60DB585BE5ECA68A2EDB9ABF1E7156A" ON teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" USING GIN (("pLMNIdList"::TEXT) gin_trgm_ops);
2041
2042 CREATE INDEX IF NOT EXISTS "IDX_6C81B2BBFCFE94C87598869A2099E04571202BA7" ON teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
2043
2044 CREATE INDEX IF NOT EXISTS "IDX_25E4BCFBF8F5344DFC60BCB159FA873FFC8109E9" ON teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
2045
2046 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-ran_OCUUPFunction_CD_decorators" ON teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" USING GIN ("CD_decorators");
2047
2048 CREATE INDEX IF NOT EXISTS "IDX_50209F1FF59B49F79FF194887B631994F2B5148A" ON teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" USING GIN (("REL_CD_sourceIds_MANAGEDELEMENT_MANAGES_OCUUPFUNCTION"::TEXT) gin_trgm_ops);
2049
2050 CREATE INDEX IF NOT EXISTS "IDX_3346DFB8C2B7D6EEA12B7C1DE4A84B058C24A657" ON teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" USING GIN (("REL_CD_classifiers_MANAGEDELEMENT_MANAGES_OCUUPFUNCTION"::TEXT) gin_trgm_ops);
2051
2052 CREATE INDEX IF NOT EXISTS "IDX_ADD3393C27589066C4993A3491436C6FB57A539F" ON teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" USING GIN ("REL_CD_decorators_MANAGEDELEMENT_MANAGES_OCUUPFUNCTION");
2053
2054 CREATE INDEX IF NOT EXISTS "IDX_7B8C47A1FD2FCA75DED85825317147EE0831A1C7" ON teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" USING GIN (("REL_CD_sourceIds_OCUUPFUNCTION_E2LINK_NEARRTRICFUNCTION"::TEXT) gin_trgm_ops);
2055
2056 CREATE INDEX IF NOT EXISTS "IDX_5E92F3864ACD360810BD006484337B25B5C64004" ON teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" USING GIN (("REL_CD_classifiers_OCUUPFUNCTION_E2LINK_NEARRTRICFUNCTION"::TEXT) gin_trgm_ops);
2057
2058 CREATE INDEX IF NOT EXISTS "IDX_CEFE5F65D4553C67E4494FCDE9E0E44549171577" ON teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" USING GIN ("REL_CD_decorators_OCUUPFUNCTION_E2LINK_NEARRTRICFUNCTION");
2059
2060 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-ran_ODUFunction_dUpLMNId" ON teiv_data."o-ran-smo-teiv-ran_ODUFunction" USING GIN ("dUpLMNId");
2061
2062 CREATE INDEX IF NOT EXISTS "IDX_73790DA8FF6365B752DC8B399893AC6DE8CF26C4" ON teiv_data."o-ran-smo-teiv-ran_ODUFunction" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
2063
2064 CREATE INDEX IF NOT EXISTS "IDX_5CE9EDE1F25AB2D880A41BC5D297FDBE668182E8" ON teiv_data."o-ran-smo-teiv-ran_ODUFunction" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
2065
2066 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-ran_ODUFunction_CD_decorators" ON teiv_data."o-ran-smo-teiv-ran_ODUFunction" USING GIN ("CD_decorators");
2067
2068 CREATE INDEX IF NOT EXISTS "IDX_0E5C91A3252FBAFA72DB644D4E949A379F0CB910" ON teiv_data."o-ran-smo-teiv-ran_ODUFunction" USING GIN (("REL_CD_sourceIds_MANAGEDELEMENT_MANAGES_ODUFUNCTION"::TEXT) gin_trgm_ops);
2069
2070 CREATE INDEX IF NOT EXISTS "IDX_5DD192861541E0EB2776C6BFE34B327FF27F93C3" ON teiv_data."o-ran-smo-teiv-ran_ODUFunction" USING GIN (("REL_CD_classifiers_MANAGEDELEMENT_MANAGES_ODUFUNCTION"::TEXT) gin_trgm_ops);
2071
2072 CREATE INDEX IF NOT EXISTS "IDX_0B9AC962B1E07740CE43D912B5FBC54E0B39DD24" ON teiv_data."o-ran-smo-teiv-ran_ODUFunction" USING GIN ("REL_CD_decorators_MANAGEDELEMENT_MANAGES_ODUFUNCTION");
2073
2074 CREATE INDEX IF NOT EXISTS "IDX_5F2DC68F0CE9A176F79C9DEF6752556C38C7A8DF" ON teiv_data."o-ran-smo-teiv-ran_ODUFunction" USING GIN (("REL_CD_sourceIds_ODUFUNCTION_E2LINK_NEARRTRICFUNCTION"::TEXT) gin_trgm_ops);
2075
2076 CREATE INDEX IF NOT EXISTS "IDX_AFD9E48ECC8E81DCD5F3A10199B7936A894D75F1" ON teiv_data."o-ran-smo-teiv-ran_ODUFunction" USING GIN (("REL_CD_classifiers_ODUFUNCTION_E2LINK_NEARRTRICFUNCTION"::TEXT) gin_trgm_ops);
2077
2078 CREATE INDEX IF NOT EXISTS "IDX_714284D19884BC9E2A594B6B5010D429E12F5AE7" ON teiv_data."o-ran-smo-teiv-ran_ODUFunction" USING GIN ("REL_CD_decorators_ODUFUNCTION_E2LINK_NEARRTRICFUNCTION");
2079
2080 CREATE INDEX IF NOT EXISTS "IDX_4C7915C1CD9395FE91ED0474B1235393063920BA" ON teiv_data."o-ran-smo-teiv-ran_ODUFunction" USING GIN (("REL_CD_sourceIds_ODUFUNCTION_F1CLINK_OCUCPFUNCTION"::TEXT) gin_trgm_ops);
2081
2082 CREATE INDEX IF NOT EXISTS "IDX_F784968DE38F941EB1D9E2845576B5F93ED1E18B" ON teiv_data."o-ran-smo-teiv-ran_ODUFunction" USING GIN (("REL_CD_classifiers_ODUFUNCTION_F1CLINK_OCUCPFUNCTION"::TEXT) gin_trgm_ops);
2083
2084 CREATE INDEX IF NOT EXISTS "IDX_9A1D505BA4542318211ECF2569A0CEA390AAB52D" ON teiv_data."o-ran-smo-teiv-ran_ODUFunction" USING GIN ("REL_CD_decorators_ODUFUNCTION_F1CLINK_OCUCPFUNCTION");
2085
2086 CREATE INDEX IF NOT EXISTS "IDX_0C48537C4C2C125C6B188375EC62CBA0984B3D8B" ON teiv_data."o-ran-smo-teiv-ran_ODUFunction" USING GIN (("REL_CD_sourceIds_ODUFUNCTION_F1ULINK_OCUUPFUNCTION"::TEXT) gin_trgm_ops);
2087
2088 CREATE INDEX IF NOT EXISTS "IDX_91CC0F89EAA44A400D822FCFDC9AB8AE0285499C" ON teiv_data."o-ran-smo-teiv-ran_ODUFunction" USING GIN (("REL_CD_classifiers_ODUFUNCTION_F1ULINK_OCUUPFUNCTION"::TEXT) gin_trgm_ops);
2089
2090 CREATE INDEX IF NOT EXISTS "IDX_090DF573B5D8AFDA2478C3B4BA551FEC2CD48585" ON teiv_data."o-ran-smo-teiv-ran_ODUFunction" USING GIN ("REL_CD_decorators_ODUFUNCTION_F1ULINK_OCUUPFUNCTION");
2091
2092 CREATE INDEX IF NOT EXISTS "IDX_F8F72994228550E6DA79A2E336AFF745CF5B13A8" ON teiv_data."o-ran-smo-teiv-ran_ODUFunction" USING GIN (("REL_CD_sourceIds_ODUFUNCTION_O1LINK_SMO"::TEXT) gin_trgm_ops);
2093
2094 CREATE INDEX IF NOT EXISTS "IDX_166E643CA7B58B57DC9CA292E233C033DA771649" ON teiv_data."o-ran-smo-teiv-ran_ODUFunction" USING GIN (("REL_CD_classifiers_ODUFUNCTION_O1LINK_SMO"::TEXT) gin_trgm_ops);
2095
2096 CREATE INDEX IF NOT EXISTS "IDX_0A7B8671FF4C6943209D81A0351DE1CAEFB55629" ON teiv_data."o-ran-smo-teiv-ran_ODUFunction" USING GIN ("REL_CD_decorators_ODUFUNCTION_O1LINK_SMO");
2097
2098 CREATE INDEX IF NOT EXISTS "IDX_D0D11CFAA917F4FA12748A041A34D2B39A3AD707" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
2099
2100 CREATE INDEX IF NOT EXISTS "IDX_2A5AAAD13FDCFF7F2958005C22937366F6604A0D" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
2101
2102 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-ran_ORUFunction_CD_decorators" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN ("CD_decorators");
2103
2104 CREATE INDEX IF NOT EXISTS "IDX_AF235FB2C9CCA99D94CC4038669EDD1BB6C7B2DF" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN (("REL_CD_sourceIds_MANAGEDELEMENT_MANAGES_ORUFUNCTION"::TEXT) gin_trgm_ops);
2105
2106 CREATE INDEX IF NOT EXISTS "IDX_DA79A3F946C1F4E8D05B4D6ADEF5E4C65E47635E" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN (("REL_CD_classifiers_MANAGEDELEMENT_MANAGES_ORUFUNCTION"::TEXT) gin_trgm_ops);
2107
2108 CREATE INDEX IF NOT EXISTS "IDX_7B916E1753D2860DF434831CF1E9697ED9973C8F" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN ("REL_CD_decorators_MANAGEDELEMENT_MANAGES_ORUFUNCTION");
2109
2110 CREATE INDEX IF NOT EXISTS "IDX_C650BB0BAF5EF02FB2A7CBF9D89379DB446443F3" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN (("REL_CD_sourceIds_ORUFUNCTION_O1LINK_SMO"::TEXT) gin_trgm_ops);
2111
2112 CREATE INDEX IF NOT EXISTS "IDX_583EAFCC8FB5174AB69184076C2EC75E85F44402" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN (("REL_CD_classifiers_ORUFUNCTION_O1LINK_SMO"::TEXT) gin_trgm_ops);
2113
2114 CREATE INDEX IF NOT EXISTS "IDX_DE327F0FC00996B5856EE87C424E2E70C39475CA" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN ("REL_CD_decorators_ORUFUNCTION_O1LINK_SMO");
2115
2116 CREATE INDEX IF NOT EXISTS "IDX_DEC190D478DCFE7B4974DFE067136180DC4F98D2" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN (("REL_CD_sourceIds_ORUFUNCTION_OFHCLINK_ODUFUNCTION"::TEXT) gin_trgm_ops);
2117
2118 CREATE INDEX IF NOT EXISTS "IDX_913D348FC7569F1B3054A7F11583A8E826C44C4D" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN (("REL_CD_classifiers_ORUFUNCTION_OFHCLINK_ODUFUNCTION"::TEXT) gin_trgm_ops);
2119
2120 CREATE INDEX IF NOT EXISTS "IDX_2C350ECD1561367CFE3C6ECE240110B0CFBE691E" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN ("REL_CD_decorators_ORUFUNCTION_OFHCLINK_ODUFUNCTION");
2121
2122 CREATE INDEX IF NOT EXISTS "IDX_70B09AD99FFFEC82C50E21709F65D759CD306CC2" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN (("REL_CD_sourceIds_ORUFUNCTION_OFHMLINK_ODUFUNCTION"::TEXT) gin_trgm_ops);
2123
2124 CREATE INDEX IF NOT EXISTS "IDX_10F981F841A1BEAC998725703500D2AAFF92C615" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN (("REL_CD_classifiers_ORUFUNCTION_OFHMLINK_ODUFUNCTION"::TEXT) gin_trgm_ops);
2125
2126 CREATE INDEX IF NOT EXISTS "IDX_091099E01E22A69CF5FBD13F6BE31A590A12DFEB" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN ("REL_CD_decorators_ORUFUNCTION_OFHMLINK_ODUFUNCTION");
2127
2128 CREATE INDEX IF NOT EXISTS "IDX_8D607F7CBEE96E7D2F0D0E2399E1DF2D4A4D2DE1" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN (("REL_CD_sourceIds_ORUFUNCTION_OFHMLINK_SMO"::TEXT) gin_trgm_ops);
2129
2130 CREATE INDEX IF NOT EXISTS "IDX_C5EF805B2EF19761349A03D3CD3CF6C12818C98B" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN (("REL_CD_classifiers_ORUFUNCTION_OFHMLINK_SMO"::TEXT) gin_trgm_ops);
2131
2132 CREATE INDEX IF NOT EXISTS "IDX_0F1592A3DE78629D65D3FED257905832BF2C42EA" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN ("REL_CD_decorators_ORUFUNCTION_OFHMLINK_SMO");
2133
2134 CREATE INDEX IF NOT EXISTS "IDX_1EF8E086BAB9488EA6AD191B6082977A76CD2BD9" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN (("REL_CD_sourceIds_ORUFUNCTION_OFHSLINK_ODUFUNCTION"::TEXT) gin_trgm_ops);
2135
2136 CREATE INDEX IF NOT EXISTS "IDX_2E9527C8D166D7A31FE2F2B26EEED8202FC33B14" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN (("REL_CD_classifiers_ORUFUNCTION_OFHSLINK_ODUFUNCTION"::TEXT) gin_trgm_ops);
2137
2138 CREATE INDEX IF NOT EXISTS "IDX_21586E874FC18901720393534E189FB50B0825AC" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN ("REL_CD_decorators_ORUFUNCTION_OFHSLINK_ODUFUNCTION");
2139
2140 CREATE INDEX IF NOT EXISTS "IDX_544CBFFD146034E3AA9C2EAF6B8770C8CF8740DF" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN (("REL_CD_sourceIds_ORUFUNCTION_OFHULINK_ODUFUNCTION"::TEXT) gin_trgm_ops);
2141
2142 CREATE INDEX IF NOT EXISTS "IDX_7B224280C4E1CD6248628CAF23CB06FE50AA838D" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN (("REL_CD_classifiers_ORUFUNCTION_OFHULINK_ODUFUNCTION"::TEXT) gin_trgm_ops);
2143
2144 CREATE INDEX IF NOT EXISTS "IDX_F3DE945424D3435D889B06D0080CFC8C26F76CF2" ON teiv_data."o-ran-smo-teiv-ran_ORUFunction" USING GIN ("REL_CD_decorators_ORUFUNCTION_OFHULINK_ODUFUNCTION");
2145
2146 CREATE INDEX IF NOT EXISTS "IDX_F34E4B2CD5D3DEC7271D5FA89AFC34BCF424D636" ON teiv_data."o-ran-smo-teiv-ran_SMO" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
2147
2148 CREATE INDEX IF NOT EXISTS "IDX_E528335C63DF74D690BADBF0ED2134E2BE5EC147" ON teiv_data."o-ran-smo-teiv-ran_SMO" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
2149
2150 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-ran_SMO_CD_decorators" ON teiv_data."o-ran-smo-teiv-ran_SMO" USING GIN ("CD_decorators");
2151
2152 CREATE INDEX IF NOT EXISTS "IDX_E234B43A7CD7843672F08F2197AB46A2A50BECB0" ON teiv_data."o-ran-smo-teiv-ran_Sector" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
2153
2154 CREATE INDEX IF NOT EXISTS "IDX_19C19556F9714850389595E0A16218FA229205FE" ON teiv_data."o-ran-smo-teiv-ran_Sector" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
2155
2156 CREATE INDEX IF NOT EXISTS "IDX_GIN_o-ran-smo-teiv-ran_Sector_CD_decorators" ON teiv_data."o-ran-smo-teiv-ran_Sector" USING GIN ("CD_decorators");
2157
2158 CREATE INDEX IF NOT EXISTS "IDX_10BCC6B44663A8D5431668BEE5DF80423420C616" ON teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUCPFUNCTION" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
2159
2160 CREATE INDEX IF NOT EXISTS "IDX_03F9C6A2FA82614A788443AC6044BCED2401C465" ON teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUCPFUNCTION" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
2161
2162 CREATE INDEX IF NOT EXISTS "IDX_0867A1E865A904F4BB513948DAEB60412BE67DF3" ON teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUCPFUNCTION" USING GIN ("CD_decorators");
2163
2164 CREATE INDEX IF NOT EXISTS "IDX_64B7C127C01069009A3FB13592DAE249B0029283" ON teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUUPFUNCTION" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
2165
2166 CREATE INDEX IF NOT EXISTS "IDX_69152691D777DDB084C053915D4A4B15F7F8B3EB" ON teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUUPFUNCTION" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
2167
2168 CREATE INDEX IF NOT EXISTS "IDX_3AB53A0DB6DC4B4C8BB6194D6D487EBDC3D0E88F" ON teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUUPFUNCTION" USING GIN ("CD_decorators");
2169
2170 CREATE INDEX IF NOT EXISTS "IDX_5996D077978D38D0C1A951A262F1F7E1E339F052" ON teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_ODUFUNCTION" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
2171
2172 CREATE INDEX IF NOT EXISTS "IDX_F4A1999634924C7E4D1CBD05E83996A5B1262A8A" ON teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_ODUFUNCTION" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
2173
2174 CREATE INDEX IF NOT EXISTS "IDX_5BAC6D2F05A63FDE27F082E8C8F4D766C145E835" ON teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_ODUFUNCTION" USING GIN ("CD_decorators");
2175
2176 CREATE INDEX IF NOT EXISTS "IDX_0E1BE8724BEBB21C5AE3986BE150BEC8F8CD903E" ON teiv_data."o-ran-smo-teiv-rel-equipment-ran_ANTENNAMODULE_SERVES_NRCELLDU" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
2177
2178 CREATE INDEX IF NOT EXISTS "IDX_F93AD0AE5C6940EE73D0B661A2E2E5BB10B3772C" ON teiv_data."o-ran-smo-teiv-rel-equipment-ran_ANTENNAMODULE_SERVES_NRCELLDU" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
2179
2180 CREATE INDEX IF NOT EXISTS "IDX_319FDFF6C9E6BC1D922F0A2AFEAAC294E520F753" ON teiv_data."o-ran-smo-teiv-rel-equipment-ran_ANTENNAMODULE_SERVES_NRCELLDU" USING GIN ("CD_decorators");
2181
2182 ANALYZE teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUUPFUNCTION";
2183
2184 ANALYZE teiv_data."o-ran-smo-teiv-ran_ODUFunction";
2185
2186 ANALYZE teiv_data."o-ran-smo-teiv-equipment_Site";
2187
2188 ANALYZE teiv_data."o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE";
2189
2190 ANALYZE teiv_data."o-ran-smo-teiv-physical_Site";
2191
2192 ANALYZE teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_ODUFUNCTION";
2193
2194 ANALYZE teiv_data."o-ran-smo-teiv-cloud_NodeCluster";
2195
2196 ANALYZE teiv_data."o-ran-smo-teiv-physical_PHYSICALAPPLIANCE_INSTALLEDAT_SITE";
2197
2198 ANALYZE teiv_data."AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA";
2199
2200 ANALYZE teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUCPFUNCTION";
2201
2202 ANALYZE teiv_data."o-ran-smo-teiv-ran_OCUCPFunction";
2203
2204 ANALYZE teiv_data."o-ran-smo-teiv-oam_ManagedElement";
2205
2206 ANALYZE teiv_data."o-ran-smo-teiv-ran_NRCellDU";
2207
2208 ANALYZE teiv_data."o-ran-smo-teiv-rel-equipment-ran_ANTENNAMODULE_SERVES_NRCELLDU";
2209
2210 ANALYZE teiv_data."o-ran-smo-teiv-ran_SMO";
2211
2212 ANALYZE teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction";
2213
2214 ANALYZE teiv_data."o-ran-smo-teiv-cloud_CloudifiedNF";
2215
2216 ANALYZE teiv_data."o-ran-smo-teiv-cloud_NFDeployment";
2217
2218 ANALYZE teiv_data."o-ran-smo-teiv-physical_PhysicalAppliance";
2219
2220 ANALYZE teiv_data."o-ran-smo-teiv-ran_AntennaCapability";
2221
2222 ANALYZE teiv_data."3C2E2CE7BDF8321BC824B6318B190690F58DBB82";
2223
2224 ANALYZE teiv_data."o-ran-smo-teiv-cloud_NFDEPLOYMENT_DEPLOYED_ON_OCLOUDNAMESPACE";
2225
2226 ANALYZE teiv_data."5A1D611A68E4A8B2F007A89876701DB3FA88346E";
2227
2228 ANALYZE teiv_data."B83D20388E54C581319034D29C555DE6F8D938FF";
2229
2230 ANALYZE teiv_data."o-ran-smo-teiv-equipment_AntennaModule";
2231
2232 ANALYZE teiv_data."D4A45C271462B28FB655CFCF2F2D826236C78062";
2233
2234 ANALYZE teiv_data."o-ran-smo-teiv-ran_ORUFunction";
2235
2236 ANALYZE teiv_data."o-ran-smo-teiv-ran_NRCellCU";
2237
2238 ANALYZE teiv_data."CFC235E0404703D1E4454647DF8AAE2C193DB402";
2239
2240 ANALYZE teiv_data."o-ran-smo-teiv-ran_OCUUPFunction";
2241
2242 ANALYZE teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier";
2243
2244 ANALYZE teiv_data."o-ran-smo-teiv-ran_Sector";
2245
2246 ANALYZE teiv_data."o-ran-smo-teiv-cloud_OCloudSite";
2247
2248 ANALYZE teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace";
2249
2250 COMMIT;