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
10 -- http://www.apache.org/licenses/LICENSE-2.0
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.
18 -- SPDX-License-Identifier: Apache-2.0
19 -- ============LICENSE_END=========================================================
24 CREATE EXTENSION IF NOT EXISTS postgis;
25 CREATE EXTENSION IF NOT EXISTS postgis_topology;
26 CREATE EXTENSION IF NOT EXISTS pg_trgm;
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;
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;
37 SET ROLE topology_exposure_user;
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
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;
50 $$ language 'plpgsql';
52 CREATE OR REPLACE FUNCTION teiv_data.create_enum_type(
53 schema_name TEXT, type_name TEXT, enum_values TEXT[]
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), ', '));
60 $$ language 'plpgsql';
62 SELECT teiv_data.create_enum_type('teiv_data', 'Reliability', ARRAY['OK', 'RESTORED', 'ADVISED']);
64 CREATE TABLE IF NOT EXISTS teiv_data."responsible_adapter" (
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");'
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" (
81 "aSide_NFDeployment" TEXT,
82 "bSide_NearRTRICFunction" TEXT,
84 "CD_classifiers" jsonb,
85 "CD_decorators" jsonb,
89 ALTER TABLE ONLY teiv_data."3C2E2CE7BDF8321BC824B6318B190690F58DBB82" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
91 ALTER TABLE ONLY teiv_data."3C2E2CE7BDF8321BC824B6318B190690F58DBB82" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
93 ALTER TABLE ONLY teiv_data."3C2E2CE7BDF8321BC824B6318B190690F58DBB82" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
95 CREATE TABLE IF NOT EXISTS teiv_data."5A1D611A68E4A8B2F007A89876701DB3FA88346E" (
97 "aSide_PhysicalAppliance" TEXT,
98 "bSide_ODUFunction" TEXT,
100 "CD_classifiers" jsonb,
101 "CD_decorators" jsonb,
105 ALTER TABLE ONLY teiv_data."5A1D611A68E4A8B2F007A89876701DB3FA88346E" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
107 ALTER TABLE ONLY teiv_data."5A1D611A68E4A8B2F007A89876701DB3FA88346E" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
109 ALTER TABLE ONLY teiv_data."5A1D611A68E4A8B2F007A89876701DB3FA88346E" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
111 CREATE TABLE IF NOT EXISTS teiv_data."AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA" (
113 "aSide_PhysicalAppliance" TEXT,
114 "bSide_OCUCPFunction" TEXT,
115 "CD_sourceIds" jsonb,
116 "CD_classifiers" jsonb,
117 "CD_decorators" jsonb,
121 ALTER TABLE ONLY teiv_data."AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
123 ALTER TABLE ONLY teiv_data."AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
125 ALTER TABLE ONLY teiv_data."AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
127 CREATE TABLE IF NOT EXISTS teiv_data."B83D20388E54C581319034D29C555DE6F8D938FF" (
129 "aSide_PhysicalAppliance" TEXT,
130 "bSide_OCUUPFunction" TEXT,
131 "CD_sourceIds" jsonb,
132 "CD_classifiers" jsonb,
133 "CD_decorators" jsonb,
137 ALTER TABLE ONLY teiv_data."B83D20388E54C581319034D29C555DE6F8D938FF" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
139 ALTER TABLE ONLY teiv_data."B83D20388E54C581319034D29C555DE6F8D938FF" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
141 ALTER TABLE ONLY teiv_data."B83D20388E54C581319034D29C555DE6F8D938FF" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
143 CREATE TABLE IF NOT EXISTS teiv_data."CFC235E0404703D1E4454647DF8AAE2C193DB402" (
145 "aSide_AntennaModule" TEXT,
146 "bSide_AntennaCapability" TEXT,
147 "CD_sourceIds" jsonb,
148 "CD_classifiers" jsonb,
149 "CD_decorators" jsonb,
153 ALTER TABLE ONLY teiv_data."CFC235E0404703D1E4454647DF8AAE2C193DB402" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
155 ALTER TABLE ONLY teiv_data."CFC235E0404703D1E4454647DF8AAE2C193DB402" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
157 ALTER TABLE ONLY teiv_data."CFC235E0404703D1E4454647DF8AAE2C193DB402" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
159 CREATE TABLE IF NOT EXISTS teiv_data."D4A45C271462B28FB655CFCF2F2D826236C78062" (
161 "aSide_PhysicalAppliance" TEXT,
162 "bSide_NearRTRICFunction" TEXT,
163 "CD_sourceIds" jsonb,
164 "CD_classifiers" jsonb,
165 "CD_decorators" jsonb,
169 ALTER TABLE ONLY teiv_data."D4A45C271462B28FB655CFCF2F2D826236C78062" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
171 ALTER TABLE ONLY teiv_data."D4A45C271462B28FB655CFCF2F2D826236C78062" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
173 ALTER TABLE ONLY teiv_data."D4A45C271462B28FB655CFCF2F2D826236C78062" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
175 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-cloud_CloudifiedNF" (
178 "CD_sourceIds" jsonb,
179 "CD_classifiers" jsonb,
180 "CD_decorators" jsonb,
184 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_CloudifiedNF" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
186 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_CloudifiedNF" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
188 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_CloudifiedNF" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
190 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-cloud_NFDEPLOYMENT_DEPLOYED_ON_OCLOUDNAMESPACE" (
192 "aSide_NFDeployment" TEXT,
193 "bSide_OCloudNamespace" TEXT,
194 "CD_sourceIds" jsonb,
195 "CD_classifiers" jsonb,
196 "CD_decorators" jsonb,
200 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDEPLOYMENT_DEPLOYED_ON_OCLOUDNAMESPACE" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
202 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDEPLOYMENT_DEPLOYED_ON_OCLOUDNAMESPACE" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
204 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDEPLOYMENT_DEPLOYED_ON_OCLOUDNAMESPACE" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
206 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-cloud_NFDeployment" (
209 "CD_sourceIds" jsonb,
210 "CD_classifiers" jsonb,
211 "CD_decorators" 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
227 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
229 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
231 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
233 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ALTER COLUMN "REL_CD_sourceIds_CLOUDIFIEDNF_COMPRISES_NFDEPLOYMENT" SET DEFAULT '[]';
235 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ALTER COLUMN "REL_CD_classifiers_CLOUDIFIEDNF_COMPRISES_NFDEPLOYMENT" SET DEFAULT '[]';
237 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ALTER COLUMN "REL_CD_decorators_CLOUDIFIEDNF_COMPRISES_NFDEPLOYMENT" SET DEFAULT '{}';
239 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ALTER COLUMN "REL_CD_sourceIds_NFDEPLOYMENT_SERVES_MANAGEDELEMENT" SET DEFAULT '[]';
241 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ALTER COLUMN "REL_CD_classifiers_NFDEPLOYMENT_SERVES_MANAGEDELEMENT" SET DEFAULT '[]';
243 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NFDeployment" ALTER COLUMN "REL_CD_decorators_NFDEPLOYMENT_SERVES_MANAGEDELEMENT" SET DEFAULT '{}';
245 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE" (
247 "aSide_NodeCluster" TEXT,
248 "bSide_OCloudSite" TEXT,
249 "CD_sourceIds" jsonb,
250 "CD_classifiers" jsonb,
251 "CD_decorators" jsonb,
255 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
257 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
259 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
261 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-cloud_NodeCluster" (
264 "CD_sourceIds" jsonb,
265 "CD_classifiers" jsonb,
266 "CD_decorators" jsonb,
270 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NodeCluster" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
272 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NodeCluster" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
274 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_NodeCluster" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
276 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" (
279 "CD_sourceIds" jsonb,
280 "CD_classifiers" jsonb,
281 "CD_decorators" 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
291 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
293 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
295 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
297 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" ALTER COLUMN "REL_CD_sourceIds_OCLOUDNAMESPACE_DEPLOYED_ON_NODECLUSTER" SET DEFAULT '[]';
299 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" ALTER COLUMN "REL_CD_classifiers_OCLOUDNAMESPACE_DEPLOYED_ON_NODECLUSTER" SET DEFAULT '[]';
301 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace" ALTER COLUMN "REL_CD_decorators_OCLOUDNAMESPACE_DEPLOYED_ON_NODECLUSTER" SET DEFAULT '{}';
303 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-cloud_OCloudSite" (
305 "geo-location" geography,
307 "CD_sourceIds" jsonb,
308 "CD_classifiers" jsonb,
309 "CD_decorators" jsonb,
313 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_OCloudSite" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
315 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_OCloudSite" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
317 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-cloud_OCloudSite" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
319 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-equipment_AntennaModule" (
321 "antennaBeamWidth" jsonb,
322 "antennaModelNumber" TEXT,
324 "electricalAntennaTilt" INTEGER,
325 "geo-location" geography,
326 "horizontalBeamWidth" DECIMAL,
327 "mechanicalAntennaBearing" INTEGER,
328 "mechanicalAntennaTilt" INTEGER,
329 "positionWithinSector" TEXT,
331 "verticalBeamWidth" DECIMAL,
332 "CD_sourceIds" jsonb,
333 "CD_classifiers" jsonb,
334 "CD_decorators" 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
350 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
352 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
354 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
356 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ALTER COLUMN "REL_CD_sourceIds_ANTENNAMODULE_INSTALLED_AT_SITE" SET DEFAULT '[]';
358 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ALTER COLUMN "REL_CD_classifiers_ANTENNAMODULE_INSTALLED_AT_SITE" SET DEFAULT '[]';
360 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ALTER COLUMN "REL_CD_decorators_ANTENNAMODULE_INSTALLED_AT_SITE" SET DEFAULT '{}';
362 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ALTER COLUMN "REL_CD_sourceIds_SECTOR_GROUPS_ANTENNAMODULE" SET DEFAULT '[]';
364 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ALTER COLUMN "REL_CD_classifiers_SECTOR_GROUPS_ANTENNAMODULE" SET DEFAULT '[]';
366 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_AntennaModule" ALTER COLUMN "REL_CD_decorators_SECTOR_GROUPS_ANTENNAMODULE" SET DEFAULT '{}';
368 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-equipment_Site" (
370 "geo-location" geography,
372 "CD_sourceIds" jsonb,
373 "CD_classifiers" jsonb,
374 "CD_decorators" jsonb,
378 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_Site" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
380 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_Site" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
382 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-equipment_Site" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
384 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-oam_ManagedElement" (
386 "CD_sourceIds" jsonb,
387 "CD_classifiers" jsonb,
388 "CD_decorators" 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
398 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-oam_ManagedElement" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
400 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-oam_ManagedElement" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
402 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-oam_ManagedElement" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
404 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-oam_ManagedElement" ALTER COLUMN "REL_CD_sourceIds_MANAGEDELEMENT_DEPLOYED_AS_CLOUDIFIEDNF" SET DEFAULT '[]';
406 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-oam_ManagedElement" ALTER COLUMN "REL_CD_classifiers_MANAGEDELEMENT_DEPLOYED_AS_CLOUDIFIEDNF" SET DEFAULT '[]';
408 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-oam_ManagedElement" ALTER COLUMN "REL_CD_decorators_MANAGEDELEMENT_DEPLOYED_AS_CLOUDIFIEDNF" SET DEFAULT '{}';
410 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-physical_PHYSICALAPPLIANCE_INSTALLEDAT_SITE" (
412 "aSide_PhysicalAppliance" TEXT,
414 "CD_sourceIds" jsonb,
415 "CD_classifiers" jsonb,
416 "CD_decorators" jsonb,
420 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-physical_PHYSICALAPPLIANCE_INSTALLEDAT_SITE" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
422 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-physical_PHYSICALAPPLIANCE_INSTALLEDAT_SITE" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
424 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-physical_PHYSICALAPPLIANCE_INSTALLEDAT_SITE" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
426 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-physical_PhysicalAppliance" (
430 "CD_sourceIds" jsonb,
431 "CD_classifiers" jsonb,
432 "CD_decorators" jsonb,
436 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-physical_PhysicalAppliance" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
438 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-physical_PhysicalAppliance" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
440 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-physical_PhysicalAppliance" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
442 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-physical_Site" (
444 "siteLocation" jsonb,
446 "CD_sourceIds" jsonb,
447 "CD_classifiers" jsonb,
448 "CD_decorators" jsonb,
452 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-physical_Site" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
454 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-physical_Site" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
456 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-physical_Site" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
458 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_AntennaCapability" (
460 "eUtranFqBands" jsonb,
461 "geranFqBands" jsonb,
463 "CD_sourceIds" jsonb,
464 "CD_classifiers" jsonb,
465 "CD_decorators" jsonb,
469 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_AntennaCapability" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
471 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_AntennaCapability" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
473 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_AntennaCapability" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
475 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_NRCellCU" (
477 "cellLocalId" INTEGER,
481 "CD_sourceIds" jsonb,
482 "CD_classifiers" jsonb,
483 "CD_decorators" 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
493 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellCU" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
495 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellCU" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
497 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellCU" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
499 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellCU" ALTER COLUMN "REL_CD_sourceIds_OCUCPFUNCTION_PROVIDES_NRCELLCU" SET DEFAULT '[]';
501 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellCU" ALTER COLUMN "REL_CD_classifiers_OCUCPFUNCTION_PROVIDES_NRCELLCU" SET DEFAULT '[]';
503 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellCU" ALTER COLUMN "REL_CD_decorators_OCUCPFUNCTION_PROVIDES_NRCELLCU" SET DEFAULT '{}';
505 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_NRCellDU" (
507 "cellLocalId" INTEGER,
511 "CD_sourceIds" jsonb,
512 "CD_classifiers" jsonb,
513 "CD_decorators" 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
529 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellDU" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
531 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellDU" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
533 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellDU" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
535 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellDU" ALTER COLUMN "REL_CD_sourceIds_ODUFUNCTION_PROVIDES_NRCELLDU" SET DEFAULT '[]';
537 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellDU" ALTER COLUMN "REL_CD_classifiers_ODUFUNCTION_PROVIDES_NRCELLDU" SET DEFAULT '[]';
539 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellDU" ALTER COLUMN "REL_CD_decorators_ODUFUNCTION_PROVIDES_NRCELLDU" SET DEFAULT '{}';
541 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellDU" ALTER COLUMN "REL_CD_sourceIds_SECTOR_GROUPS_NRCELLDU" SET DEFAULT '[]';
543 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellDU" ALTER COLUMN "REL_CD_classifiers_SECTOR_GROUPS_NRCELLDU" SET DEFAULT '[]';
545 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRCellDU" ALTER COLUMN "REL_CD_decorators_SECTOR_GROUPS_NRCELLDU" SET DEFAULT '{}';
547 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" (
551 "bSChannelBwDL" INTEGER,
552 "frequencyDL" INTEGER,
553 "frequencyUL" INTEGER,
554 "CD_sourceIds" jsonb,
555 "CD_classifiers" jsonb,
556 "CD_decorators" 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
578 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
580 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
582 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
584 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "REL_CD_sourceIds_NRCELLDU_USES_NRSECTORCARRIER" SET DEFAULT '[]';
586 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "REL_CD_classifiers_NRCELLDU_USES_NRSECTORCARRIER" SET DEFAULT '[]';
588 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "REL_CD_decorators_NRCELLDU_USES_NRSECTORCARRIER" SET DEFAULT '{}';
590 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "REL_CD_sourceIds_NRSECTORCARRIER_USES_ANTENNACAPABILITY" SET DEFAULT '[]';
592 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "REL_CD_classifiers_NRSECTORCARRIER_USES_ANTENNACAPABILITY" SET DEFAULT '[]';
594 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "REL_CD_decorators_NRSECTORCARRIER_USES_ANTENNACAPABILITY" SET DEFAULT '{}';
596 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "REL_CD_sourceIds_ODUFUNCTION_PROVIDES_NRSECTORCARRIER" SET DEFAULT '[]';
598 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "REL_CD_classifiers_ODUFUNCTION_PROVIDES_NRSECTORCARRIER" SET DEFAULT '[]';
600 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier" ALTER COLUMN "REL_CD_decorators_ODUFUNCTION_PROVIDES_NRSECTORCARRIER" SET DEFAULT '{}';
602 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" (
604 "nearRtRicId" BIGINT,
606 "CD_sourceIds" jsonb,
607 "CD_classifiers" jsonb,
608 "CD_decorators" 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
624 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
626 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
628 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
630 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ALTER COLUMN "REL_CD_sourceIds_MANAGEDELEMENT_MANAGES_NEARRTRICFUNCTION" SET DEFAULT '[]';
632 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ALTER COLUMN "REL_CD_classifiers_MANAGEDELEMENT_MANAGES_NEARRTRICFUNCTION" SET DEFAULT '[]';
634 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ALTER COLUMN "REL_CD_decorators_MANAGEDELEMENT_MANAGES_NEARRTRICFUNCTION" SET DEFAULT '{}';
636 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ALTER COLUMN "REL_CD_sourceIds_NEARRTRICFUNCTION_O1LINK_SMO" SET DEFAULT '[]';
638 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ALTER COLUMN "REL_CD_classifiers_NEARRTRICFUNCTION_O1LINK_SMO" SET DEFAULT '[]';
640 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction" ALTER COLUMN "REL_CD_decorators_NEARRTRICFUNCTION_O1LINK_SMO" SET DEFAULT '{}';
642 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" (
646 "gNBIdLength" INTEGER,
648 "CD_sourceIds" jsonb,
649 "CD_classifiers" jsonb,
650 "CD_decorators" 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
678 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
680 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
682 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
684 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_sourceIds_MANAGEDELEMENT_MANAGES_OCUCPFUNCTION" SET DEFAULT '[]';
686 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_classifiers_MANAGEDELEMENT_MANAGES_OCUCPFUNCTION" SET DEFAULT '[]';
688 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_decorators_MANAGEDELEMENT_MANAGES_OCUCPFUNCTION" SET DEFAULT '{}';
690 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_sourceIds_OCUCPFUNCTION_E1LINK_OCUUPFUNCTION" SET DEFAULT '[]';
692 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_classifiers_OCUCPFUNCTION_E1LINK_OCUUPFUNCTION" SET DEFAULT '[]';
694 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_decorators_OCUCPFUNCTION_E1LINK_OCUUPFUNCTION" SET DEFAULT '{}';
696 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_sourceIds_OCUCPFUNCTION_E2LINK_NEARRTRICFUNCTION" SET DEFAULT '[]';
698 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_classifiers_OCUCPFUNCTION_E2LINK_NEARRTRICFUNCTION" SET DEFAULT '[]';
700 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_decorators_OCUCPFUNCTION_E2LINK_NEARRTRICFUNCTION" SET DEFAULT '{}';
702 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_sourceIds_OCUCPFUNCTION_O1LINK_SMO" SET DEFAULT '[]';
704 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_classifiers_OCUCPFUNCTION_O1LINK_SMO" SET DEFAULT '[]';
706 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUCPFunction" ALTER COLUMN "REL_CD_decorators_OCUCPFUNCTION_O1LINK_SMO" SET DEFAULT '{}';
708 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" (
711 "gNBIdLength" INTEGER,
713 "CD_sourceIds" jsonb,
714 "CD_classifiers" jsonb,
715 "CD_decorators" 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
731 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
733 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
735 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
737 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ALTER COLUMN "REL_CD_sourceIds_MANAGEDELEMENT_MANAGES_OCUUPFUNCTION" SET DEFAULT '[]';
739 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ALTER COLUMN "REL_CD_classifiers_MANAGEDELEMENT_MANAGES_OCUUPFUNCTION" SET DEFAULT '[]';
741 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ALTER COLUMN "REL_CD_decorators_MANAGEDELEMENT_MANAGES_OCUUPFUNCTION" SET DEFAULT '{}';
743 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ALTER COLUMN "REL_CD_sourceIds_OCUUPFUNCTION_E2LINK_NEARRTRICFUNCTION" SET DEFAULT '[]';
745 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ALTER COLUMN "REL_CD_classifiers_OCUUPFUNCTION_E2LINK_NEARRTRICFUNCTION" SET DEFAULT '[]';
747 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" ALTER COLUMN "REL_CD_decorators_OCUUPFUNCTION_E2LINK_NEARRTRICFUNCTION" SET DEFAULT '{}';
749 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_ODUFunction" (
754 "gNBIdLength" INTEGER,
755 "CD_sourceIds" jsonb,
756 "CD_classifiers" jsonb,
757 "CD_decorators" 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
791 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
793 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
795 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
797 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_sourceIds_MANAGEDELEMENT_MANAGES_ODUFUNCTION" SET DEFAULT '[]';
799 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_classifiers_MANAGEDELEMENT_MANAGES_ODUFUNCTION" SET DEFAULT '[]';
801 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_decorators_MANAGEDELEMENT_MANAGES_ODUFUNCTION" SET DEFAULT '{}';
803 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_sourceIds_ODUFUNCTION_E2LINK_NEARRTRICFUNCTION" SET DEFAULT '[]';
805 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_classifiers_ODUFUNCTION_E2LINK_NEARRTRICFUNCTION" SET DEFAULT '[]';
807 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_decorators_ODUFUNCTION_E2LINK_NEARRTRICFUNCTION" SET DEFAULT '{}';
809 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_sourceIds_ODUFUNCTION_F1CLINK_OCUCPFUNCTION" SET DEFAULT '[]';
811 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_classifiers_ODUFUNCTION_F1CLINK_OCUCPFUNCTION" SET DEFAULT '[]';
813 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_decorators_ODUFUNCTION_F1CLINK_OCUCPFUNCTION" SET DEFAULT '{}';
815 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_sourceIds_ODUFUNCTION_F1ULINK_OCUUPFUNCTION" SET DEFAULT '[]';
817 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_classifiers_ODUFUNCTION_F1ULINK_OCUUPFUNCTION" SET DEFAULT '[]';
819 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_decorators_ODUFUNCTION_F1ULINK_OCUUPFUNCTION" SET DEFAULT '{}';
821 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_sourceIds_ODUFUNCTION_O1LINK_SMO" SET DEFAULT '[]';
823 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_classifiers_ODUFUNCTION_O1LINK_SMO" SET DEFAULT '[]';
825 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ODUFunction" ALTER COLUMN "REL_CD_decorators_ODUFUNCTION_O1LINK_SMO" SET DEFAULT '{}';
827 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_ORUFunction" (
830 "CD_sourceIds" jsonb,
831 "CD_classifiers" jsonb,
832 "CD_decorators" 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
878 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
880 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
882 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
884 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_sourceIds_MANAGEDELEMENT_MANAGES_ORUFUNCTION" SET DEFAULT '[]';
886 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_classifiers_MANAGEDELEMENT_MANAGES_ORUFUNCTION" SET DEFAULT '[]';
888 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_decorators_MANAGEDELEMENT_MANAGES_ORUFUNCTION" SET DEFAULT '{}';
890 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_sourceIds_ORUFUNCTION_O1LINK_SMO" SET DEFAULT '[]';
892 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_classifiers_ORUFUNCTION_O1LINK_SMO" SET DEFAULT '[]';
894 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_decorators_ORUFUNCTION_O1LINK_SMO" SET DEFAULT '{}';
896 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_sourceIds_ORUFUNCTION_OFHCLINK_ODUFUNCTION" SET DEFAULT '[]';
898 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_classifiers_ORUFUNCTION_OFHCLINK_ODUFUNCTION" SET DEFAULT '[]';
900 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_decorators_ORUFUNCTION_OFHCLINK_ODUFUNCTION" SET DEFAULT '{}';
902 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_sourceIds_ORUFUNCTION_OFHMLINK_ODUFUNCTION" SET DEFAULT '[]';
904 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_classifiers_ORUFUNCTION_OFHMLINK_ODUFUNCTION" SET DEFAULT '[]';
906 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_decorators_ORUFUNCTION_OFHMLINK_ODUFUNCTION" SET DEFAULT '{}';
908 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_sourceIds_ORUFUNCTION_OFHMLINK_SMO" SET DEFAULT '[]';
910 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_classifiers_ORUFUNCTION_OFHMLINK_SMO" SET DEFAULT '[]';
912 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_decorators_ORUFUNCTION_OFHMLINK_SMO" SET DEFAULT '{}';
914 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_sourceIds_ORUFUNCTION_OFHSLINK_ODUFUNCTION" SET DEFAULT '[]';
916 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_classifiers_ORUFUNCTION_OFHSLINK_ODUFUNCTION" SET DEFAULT '[]';
918 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_decorators_ORUFUNCTION_OFHSLINK_ODUFUNCTION" SET DEFAULT '{}';
920 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_sourceIds_ORUFUNCTION_OFHULINK_ODUFUNCTION" SET DEFAULT '[]';
922 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_classifiers_ORUFUNCTION_OFHULINK_ODUFUNCTION" SET DEFAULT '[]';
924 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_ORUFunction" ALTER COLUMN "REL_CD_decorators_ORUFUNCTION_OFHULINK_ODUFUNCTION" SET DEFAULT '{}';
926 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_SMO" (
929 "CD_sourceIds" jsonb,
930 "CD_classifiers" jsonb,
931 "CD_decorators" jsonb,
935 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_SMO" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
937 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_SMO" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
939 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_SMO" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
941 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-ran_Sector" (
944 "geo-location" geography,
946 "CD_sourceIds" jsonb,
947 "CD_classifiers" jsonb,
948 "CD_decorators" jsonb,
952 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_Sector" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
954 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_Sector" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
956 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-ran_Sector" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
958 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUCPFUNCTION" (
960 "aSide_NFDeployment" TEXT,
961 "bSide_OCUCPFunction" TEXT,
962 "CD_sourceIds" jsonb,
963 "CD_classifiers" jsonb,
964 "CD_decorators" jsonb,
968 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUCPFUNCTION" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
970 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUCPFUNCTION" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
972 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUCPFUNCTION" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
974 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUUPFUNCTION" (
976 "aSide_NFDeployment" TEXT,
977 "bSide_OCUUPFunction" TEXT,
978 "CD_sourceIds" jsonb,
979 "CD_classifiers" jsonb,
980 "CD_decorators" jsonb,
984 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUUPFUNCTION" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
986 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUUPFUNCTION" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
988 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUUPFUNCTION" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
990 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_ODUFUNCTION" (
992 "aSide_NFDeployment" TEXT,
993 "bSide_ODUFunction" TEXT,
994 "CD_sourceIds" jsonb,
995 "CD_classifiers" jsonb,
996 "CD_decorators" jsonb,
1000 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_ODUFUNCTION" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
1002 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_ODUFUNCTION" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
1004 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_ODUFUNCTION" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
1006 CREATE TABLE IF NOT EXISTS teiv_data."o-ran-smo-teiv-rel-equipment-ran_ANTENNAMODULE_SERVES_NRCELLDU" (
1008 "aSide_AntennaModule" TEXT,
1009 "bSide_NRCellDU" TEXT,
1010 "CD_sourceIds" jsonb,
1011 "CD_classifiers" jsonb,
1012 "CD_decorators" jsonb,
1016 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-equipment-ran_ANTENNAMODULE_SERVES_NRCELLDU" ALTER COLUMN "CD_sourceIds" SET DEFAULT '[]';
1018 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-equipment-ran_ANTENNAMODULE_SERVES_NRCELLDU" ALTER COLUMN "CD_classifiers" SET DEFAULT '[]';
1020 ALTER TABLE ONLY teiv_data."o-ran-smo-teiv-rel-equipment-ran_ANTENNAMODULE_SERVES_NRCELLDU" ALTER COLUMN "CD_decorators" SET DEFAULT '{}';
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
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");'
1766 CREATE INDEX IF NOT EXISTS "IDX_996D2C34C2458A6EFE8599C1A0E6942D3D288B7A" ON teiv_data."3C2E2CE7BDF8321BC824B6318B190690F58DBB82" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1768 CREATE INDEX IF NOT EXISTS "IDX_F52FEEDBAF1B04D2D22EBAE051BB5125DF6A6968" ON teiv_data."3C2E2CE7BDF8321BC824B6318B190690F58DBB82" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1770 CREATE INDEX IF NOT EXISTS "IDX_D333FA5882890B7CD3599712FFFB2641B9E04C80" ON teiv_data."3C2E2CE7BDF8321BC824B6318B190690F58DBB82" USING GIN ("CD_decorators");
1772 CREATE INDEX IF NOT EXISTS "IDX_24AACA66F5AFB5E40FE93C3638C789D4D2A8F063" ON teiv_data."5A1D611A68E4A8B2F007A89876701DB3FA88346E" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1774 CREATE INDEX IF NOT EXISTS "IDX_09295ADACB3D204E56C3917CB88E63FA186055A7" ON teiv_data."5A1D611A68E4A8B2F007A89876701DB3FA88346E" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1776 CREATE INDEX IF NOT EXISTS "IDX_CBF202818AE6FB3A69C44CC7572BD63D284B1AF6" ON teiv_data."5A1D611A68E4A8B2F007A89876701DB3FA88346E" USING GIN ("CD_decorators");
1778 CREATE INDEX IF NOT EXISTS "IDX_48546E24CFF2A489CA783C3D9E91AE5BF267F44E" ON teiv_data."AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1780 CREATE INDEX IF NOT EXISTS "IDX_99049D602D6E4A25F14898B4E7F97479C42D61C4" ON teiv_data."AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1782 CREATE INDEX IF NOT EXISTS "IDX_D11AD33EEC5B056675B950E3A1982AF2CD56EDEC" ON teiv_data."AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA" USING GIN ("CD_decorators");
1784 CREATE INDEX IF NOT EXISTS "IDX_A79F66153A0C78659F90CAF80147401312B1D3E6" ON teiv_data."B83D20388E54C581319034D29C555DE6F8D938FF" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1786 CREATE INDEX IF NOT EXISTS "IDX_BD4B6C32900972AA69A3E28241BE923C9A2C4C2B" ON teiv_data."B83D20388E54C581319034D29C555DE6F8D938FF" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1788 CREATE INDEX IF NOT EXISTS "IDX_392C4E8EFF5A261C6FC2EADBCD2566B1BDD9484D" ON teiv_data."B83D20388E54C581319034D29C555DE6F8D938FF" USING GIN ("CD_decorators");
1790 CREATE INDEX IF NOT EXISTS "IDX_E896A9EB22A3F9F96CE75A271475316A98B629C8" ON teiv_data."CFC235E0404703D1E4454647DF8AAE2C193DB402" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1792 CREATE INDEX IF NOT EXISTS "IDX_DD0D676834B12CA2F7E8219310998376A08D7F5F" ON teiv_data."CFC235E0404703D1E4454647DF8AAE2C193DB402" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1794 CREATE INDEX IF NOT EXISTS "IDX_7BF09D0227840279556AD27ACECB068705893D28" ON teiv_data."CFC235E0404703D1E4454647DF8AAE2C193DB402" USING GIN ("CD_decorators");
1796 CREATE INDEX IF NOT EXISTS "IDX_CF2AE01363E39CE4B5541047403F5354AA36E30E" ON teiv_data."D4A45C271462B28FB655CFCF2F2D826236C78062" USING GIN (("CD_sourceIds"::TEXT) gin_trgm_ops);
1798 CREATE INDEX IF NOT EXISTS "IDX_0D8159380FCF878593989891969AD9DCF3A75A28" ON teiv_data."D4A45C271462B28FB655CFCF2F2D826236C78062" USING GIN (("CD_classifiers"::TEXT) gin_trgm_ops);
1800 CREATE INDEX IF NOT EXISTS "IDX_1FAB22E8654FEFF5EAC13C58CEA0CCADEBECD4FF" ON teiv_data."D4A45C271462B28FB655CFCF2F2D826236C78062" USING GIN ("CD_decorators");
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);
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);
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");
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);
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);
1812 CREATE INDEX IF NOT EXISTS "IDX_4055A796F223DD01411AFFB5AD97EEEAB6B2320C" ON teiv_data."o-ran-smo-teiv-cloud_NFDEPLOYMENT_DEPLOYED_ON_OCLOUDNAMESPACE" USING GIN ("CD_decorators");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
1836 CREATE INDEX IF NOT EXISTS "IDX_98A32BE3A8C1FF8CDEC95561DE4A74852FE70322" ON teiv_data."o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE" USING GIN ("CD_decorators");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
1862 CREATE INDEX IF NOT EXISTS "IDX_21B0F1FE632B6CB185C49BA6F00224068F443215" ON teiv_data."o-ran-smo-teiv-equipment_AntennaModule" USING GIN (("antennaBeamWidth"::TEXT) gin_trgm_ops);
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
1904 CREATE INDEX IF NOT EXISTS "IDX_4CFE6D1BF80F10055EEF778827B1B769EB9FBFE7" ON teiv_data."o-ran-smo-teiv-physical_PHYSICALAPPLIANCE_INSTALLEDAT_SITE" USING GIN ("CD_decorators");
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);
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);
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");
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");
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);
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);
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");
1920 CREATE INDEX IF NOT EXISTS "IDX_5FB80647AE3E5C0443A792618D65B9090EE2A3FC" ON teiv_data."o-ran-smo-teiv-ran_AntennaCapability" USING GIN (("eUtranFqBands"::TEXT) gin_trgm_ops);
1922 CREATE INDEX IF NOT EXISTS "IDX_A94722FF7B95D8974B494793908B57B4E1A9743B" ON teiv_data."o-ran-smo-teiv-ran_AntennaCapability" USING GIN (("geranFqBands"::TEXT) gin_trgm_ops);
1924 CREATE INDEX IF NOT EXISTS "IDX_441B5C05448D63552C6414BD59C13641D8A4408D" ON teiv_data."o-ran-smo-teiv-ran_AntennaCapability" USING GIN (("nRFqBands"::TEXT) gin_trgm_ops);
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);
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);
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");
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
2040 CREATE INDEX IF NOT EXISTS "IDX_9122DAA7A60DB585BE5ECA68A2EDB9ABF1E7156A" ON teiv_data."o-ran-smo-teiv-ran_OCUUPFunction" USING GIN (("pLMNIdList"::TEXT) gin_trgm_ops);
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);
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);
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");
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);
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);
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");
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);
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);
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");
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
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);
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);
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");
2182 ANALYZE teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUUPFUNCTION";
2184 ANALYZE teiv_data."o-ran-smo-teiv-ran_ODUFunction";
2186 ANALYZE teiv_data."o-ran-smo-teiv-equipment_Site";
2188 ANALYZE teiv_data."o-ran-smo-teiv-cloud_NODECLUSTER_LOCATED_AT_OCLOUDSITE";
2190 ANALYZE teiv_data."o-ran-smo-teiv-physical_Site";
2192 ANALYZE teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_ODUFUNCTION";
2194 ANALYZE teiv_data."o-ran-smo-teiv-cloud_NodeCluster";
2196 ANALYZE teiv_data."o-ran-smo-teiv-physical_PHYSICALAPPLIANCE_INSTALLEDAT_SITE";
2198 ANALYZE teiv_data."AB1CE982C9BF5EE9B415206AD49C6A73584CA5BA";
2200 ANALYZE teiv_data."o-ran-smo-teiv-rel-cloud-ran_NFDEPLOYMENT_SERVES_OCUCPFUNCTION";
2202 ANALYZE teiv_data."o-ran-smo-teiv-ran_OCUCPFunction";
2204 ANALYZE teiv_data."o-ran-smo-teiv-oam_ManagedElement";
2206 ANALYZE teiv_data."o-ran-smo-teiv-ran_NRCellDU";
2208 ANALYZE teiv_data."o-ran-smo-teiv-rel-equipment-ran_ANTENNAMODULE_SERVES_NRCELLDU";
2210 ANALYZE teiv_data."o-ran-smo-teiv-ran_SMO";
2212 ANALYZE teiv_data."o-ran-smo-teiv-ran_NearRTRICFunction";
2214 ANALYZE teiv_data."o-ran-smo-teiv-cloud_CloudifiedNF";
2216 ANALYZE teiv_data."o-ran-smo-teiv-cloud_NFDeployment";
2218 ANALYZE teiv_data."o-ran-smo-teiv-physical_PhysicalAppliance";
2220 ANALYZE teiv_data."o-ran-smo-teiv-ran_AntennaCapability";
2222 ANALYZE teiv_data."3C2E2CE7BDF8321BC824B6318B190690F58DBB82";
2224 ANALYZE teiv_data."o-ran-smo-teiv-cloud_NFDEPLOYMENT_DEPLOYED_ON_OCLOUDNAMESPACE";
2226 ANALYZE teiv_data."5A1D611A68E4A8B2F007A89876701DB3FA88346E";
2228 ANALYZE teiv_data."B83D20388E54C581319034D29C555DE6F8D938FF";
2230 ANALYZE teiv_data."o-ran-smo-teiv-equipment_AntennaModule";
2232 ANALYZE teiv_data."D4A45C271462B28FB655CFCF2F2D826236C78062";
2234 ANALYZE teiv_data."o-ran-smo-teiv-ran_ORUFunction";
2236 ANALYZE teiv_data."o-ran-smo-teiv-ran_NRCellCU";
2238 ANALYZE teiv_data."CFC235E0404703D1E4454647DF8AAE2C193DB402";
2240 ANALYZE teiv_data."o-ran-smo-teiv-ran_OCUUPFunction";
2242 ANALYZE teiv_data."o-ran-smo-teiv-ran_NRSectorCarrier";
2244 ANALYZE teiv_data."o-ran-smo-teiv-ran_Sector";
2246 ANALYZE teiv_data."o-ran-smo-teiv-cloud_OCloudSite";
2248 ANALYZE teiv_data."o-ran-smo-teiv-cloud_OCloudNamespace";