Refactor CRUD to new table structure

Refactor operations on config tree to use new table structure
for service/network/vnf/vf-module data.

Change-Id: I2e673dfb7bd335e48a3bcf212399d021d37dd9ee
Issue-ID: SDNC-1481
Signed-off-by: Dan Timoney <dtimoney@att.com>

1 files changed, 0 insertions, 2755 deletions

diff --git a/ms/generic-resource-api/src/main/resources/schema-derby.sql b/ms/generic-resource-api/src/main/resources/schema-derby.sql
deleted file mode 100644
index 9fbf95f..0000000
--- a/ms/generic-resource-api/src/main/resources/schema-derby.sql
+++ /dev/null
@@ -1,2755 +0,0 @@
-
-CREATE SCHEMA gra;
-
-SET SCHEMA gra;
-
---
--- Table structure for table ACCESS_LOG
---
-
-CREATE TABLE ACCESS_LOG (
-  access_log_seq int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  method varchar(12) DEFAULT NULL,
-  version varchar(12) DEFAULT NULL,
-  status varchar(12) DEFAULT NULL,
-  url varchar(256) DEFAULT NULL,
-  remote_address varchar(128) DEFAULT NULL,
-  PRIMARY KEY (access_log_seq)
-) ;
-
---
--- Table structure for table CUSTOMER
---
-
-
-CREATE TABLE CUSTOMER (
-  cust_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  customer_name varchar(256) DEFAULT NULL,
-  grua varchar(4) NOT NULL,
-  create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  PRIMARY KEY (cust_id)
-) ;
-
-
---
--- Table structure for table ADDRESS_PLAN_POLICIES
---
-
-CREATE TABLE ADDRESS_PLAN_POLICIES (
-  key_name varchar(255) NOT NULL,
-  key_value_source_type varchar(255) NOT NULL,
-  key_value_source varchar(255) NOT NULL,
-  PRIMARY KEY (key_name)
-) ;
-
---
--- Table structure for table AGNOSTIC_NOTIFICATION_URL
---
-
-CREATE TABLE AGNOSTIC_NOTIFICATION_URL (
-  service_type varchar(128) NOT NULL,
-  service_instance_id varchar(128) NOT NULL,
-  request_id varchar(128) NOT NULL,
-  svc_notification_url varchar(256) NOT NULL,
-  PRIMARY KEY (service_type,service_instance_id,request_id)
-) ;
-
-
---
--- Table structure for table AGNOSTIC_TO_SVC_SPCFC_API
---
-CREATE TABLE AGNOSTIC_TO_SVC_SPCFC_API (
-  operation varchar(128) NOT NULL,
-  service varchar(128) NOT NULL,
-  service_specific_api varchar(128) NOT NULL,
-  async_process varchar(15) DEFAULT NULL,
-  PRIMARY KEY (operation,service)
-) ;
-
---
--- Table structure for table AIC_AVAIL_ZONE_POOL
---
-CREATE TABLE AIC_AVAIL_ZONE_POOL (
-  aic_site_id varchar(100) NOT NULL,
-  status varchar(40) NOT NULL,
-  availability_zone varchar(100) NOT NULL,
-  token varchar(5) NOT NULL,
-  vnf_id varchar(80) DEFAULT NULL,
-  service_type varchar(100) NOT NULL,
-  vnf_type varchar(20) DEFAULT NULL,
-  hypervisor varchar(10) DEFAULT NULL,
-  PRIMARY KEY (aic_site_id,availability_zone,token)
-) ;
-
---
--- Table structure for table AIC_HOSTNAME
---
-CREATE TABLE AIC_HOSTNAME (
-  hostname varchar(20) NOT NULL,
-  cust_id int NOT NULL,
-  vendor_code varchar(1) NOT NULL,
-  virtual_device_type varchar(2) DEFAULT NULL,
-  device_sequence varchar(3) NOT NULL,
-  create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  PRIMARY KEY (hostname)
-) ;
-
---
--- Table structure for table AIC_NETWORK
---
-
-CREATE TABLE AIC_NETWORK (
-  network_id varchar(100) NOT NULL,
-  network_name varchar(100) DEFAULT NULL,
-  status varchar(20) DEFAULT NULL,
-  tenant_id varchar(100) DEFAULT NULL,
-  switch_uuid varchar(100) DEFAULT NULL,
-  portgroup_name varchar(100) DEFAULT NULL,
-  portgroup_id varchar(100) DEFAULT NULL,
-  PRIMARY KEY (network_id)
-) ;
-
---
--- Table structure for table AIC_SITE
---
-
-CREATE TABLE AIC_SITE (
-  name varchar(100) DEFAULT NULL,
-  aic_site_id varchar(100) NOT NULL,
-  vcenter_url varchar(200) DEFAULT NULL,
-  vcenter_username varchar(40) DEFAULT NULL,
-  vcenter_passwd varchar(255) for bit data DEFAULT NULL,
-  city varchar(100) DEFAULT NULL,
-  state varchar(2) DEFAULT NULL,
-  operational_status varchar(20) DEFAULT NULL,
-  oam_gateway_addr varchar(20) DEFAULT '',
-  PRIMARY KEY (aic_site_id)
-) ;
-
---
--- Table structure for table AIC_SWITCH
---
-
-CREATE TABLE AIC_SWITCH (
-  switch_name varchar(100) DEFAULT NULL,
-  physical_network_name varchar(100) NOT NULL,
-  aic_site_id varchar(100) DEFAULT NULL,
-  uuid varchar(100) DEFAULT NULL,
-  availability_zone varchar(100) DEFAULT NULL,
-  PRIMARY KEY (physical_network_name)
-) ;
-
---
--- Table structure for table AIC_ZONE_CLOUD_REGION_ID
---
-
-CREATE TABLE AIC_ZONE_CLOUD_REGION_ID (
-  zone_region_id varchar(255) NOT NULL,
-  cilli_code varchar(255) NOT NULL,
-  location_id varchar(255) NOT NULL DEFAULT '',
-  city_state_country varchar(255) NOT NULL DEFAULT '',
-  PRIMARY KEY (zone_region_id,cilli_code,location_id,city_state_country)
-) ;
-
---
--- Table structure for table ALLOCATION_ITEM
---
-
-CREATE TABLE ALLOCATION_ITEM (
-  allocation_item_id bigint NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  resource_id bigint NOT NULL,
-  application_id varchar(50) NOT NULL,
-  resource_set_id varchar(200) NOT NULL,
-  resource_union_id varchar(200) NOT NULL,
-  resource_share_group_list varchar(200) DEFAULT NULL,
-  lt_used bigint DEFAULT NULL,
-  ll_label varchar(50) DEFAULT NULL,
-  rr_used varchar(200) DEFAULT NULL,
-  allocation_time timestamp NOT NULL,
-  PRIMARY KEY (allocation_item_id)
-) ;
-
---
--- Table structure for table ALLOTTED_RESOURCE_MODEL
---
-CREATE TABLE ALLOTTED_RESOURCE_MODEL (
-  customization_uuid varchar(255) NOT NULL,
-  model_yaml blob,
-  invariant_uuid varchar(255) DEFAULT NULL,
-  uuid varchar(255) DEFAULT NULL,
-  version varchar(255) DEFAULT NULL,
-  naming_policy varchar(255) DEFAULT NULL,
-  ecomp_generated_naming char(1) DEFAULT NULL,
-  depending_service varchar(255) DEFAULT NULL,
-  role varchar(255) DEFAULT NULL,
-  type varchar(255) DEFAULT NULL,
-  service_dependency varchar(255) DEFAULT NULL,
-  allotted_resource_type varchar(255) DEFAULT NULL,
-  PRIMARY KEY (customization_uuid)
-);
-
---
--- Table structure for table ALTS_CREDENTIALS
---
-
-CREATE TABLE ALTS_CREDENTIALS (
-  alts_username varchar(255) NOT NULL,
-  alts_password varchar(255) for bit data NOT NULL,
-  PRIMARY KEY (alts_username)
-) ;
-
---
--- Table structure for table ASDC_ARTIFACTS
---
-
-CREATE TABLE ASDC_ARTIFACTS (
-  asdc_artifacts_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  service_uuid varchar(50) DEFAULT NULL,
-  distribution_id varchar(50) DEFAULT NULL,
-  service_name varchar(255) DEFAULT NULL,
-  service_description varchar(255) DEFAULT NULL,
-  resource_uuid varchar(255) DEFAULT NULL,
-  resource_instance_name varchar(255) DEFAULT NULL,
-  resource_name varchar(255) DEFAULT NULL,
-  resource_version varchar(50) DEFAULT NULL,
-  resource_type varchar(50) DEFAULT NULL,
-  artifact_uuid varchar(50) DEFAULT NULL,
-  artifact_type varchar(50) DEFAULT NULL,
-  artifact_version varchar(25) DEFAULT NULL,
-  artifact_description varchar(255) DEFAULT NULL,
-  internal_version int DEFAULT NULL,
-  creation_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  artifact_name varchar(255) DEFAULT NULL,
-  artifact_content long varchar,
-  PRIMARY KEY (asdc_artifacts_id)
-) ;
-
---
--- Table structure for table ASDC_REFERENCE
---
-
-CREATE TABLE ASDC_REFERENCE (
-  asdc_reference_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  service_type varchar(50) DEFAULT NULL,
-  vnf_type varchar(50) DEFAULT NULL,
-  vnfc_type varchar(50) DEFAULT NULL,
-  file_category varchar(50) DEFAULT NULL,
-  action varchar(50) DEFAULT NULL,
-  artifact_type varchar(50) DEFAULT NULL,
-  artifact_name varchar(255) NOT NULL,
-  PRIMARY KEY (asdc_reference_id)
-) ;
-
-
---
--- Table structure for table BLOB_TEST
---
-
-CREATE TABLE BLOB_TEST (
-  seq int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  odl varchar(20) DEFAULT NULL,
-  communities blob,
-  status varchar(10) NOT NULL DEFAULT 'NEW' CONSTRAINT status_ck_1 CHECK(status IN ('NEW', 'COMPLETE', 'FAILED')),
-  retry_count int DEFAULT -1,
-  PRIMARY KEY (seq)
-) ;
-
---
--- Table structure for table CAPABILITY
---
-
-CREATE TABLE CAPABILITY (
-  capability_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  capability_name varchar(50) NOT NULL,
-  implementation_name varchar(100) NOT NULL,
-  operation_name varchar(50) NOT NULL,
-  operation_description varchar(100) NOT NULL,
-  input_definition long varchar,
-  output_definition long varchar,
-  dependency_definition long varchar,
-  tags varchar(100) DEFAULT NULL,
-  PRIMARY KEY (capability_id)
-) ;
-
---
--- Table structure for table CITY_CODE
---
-
-CREATE TABLE CITY_CODE (
-  city_code_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  city_code varchar(3) NOT NULL,
-  city varchar(150) NOT NULL,
-  state varchar(10) NOT NULL,
-  country_code varchar(10) NOT NULL,
-  PRIMARY KEY (city_code_id)
-) ;
-
---
--- Table structure for table CLI_UPDATES
---
-
-CREATE TABLE CLI_UPDATES (
-  seq int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  status varchar(10) NOT NULL DEFAULT 'NEW' CONSTRAINT status_ck_2 CHECK(status IN ('NEW', 'COMPLETE', 'FAILED')),
-  create_timestamp timestamp DEFAULT CURRENT_TIMESTAMP,
-  last_processed_timestamp timestamp DEFAULT CURRENT_TIMESTAMP,
-  target_address varchar(128) DEFAULT NULL,
-  cli_text varchar(128) DEFAULT NULL,
-  PRIMARY KEY (seq)
-) ;
-
---
--- Table structure for table CONFIGFILES
---
-
-CREATE TABLE CONFIGFILES (
-  config_file_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  external_version varchar(50) DEFAULT NULL,
-  data_source varchar(25) DEFAULT NULL,
-  creation_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  service_instance_id varchar(50) DEFAULT NULL,
-  vnf_type varchar(50) DEFAULT NULL,
-  vnfc_type varchar(50) DEFAULT NULL,
-  file_category varchar(50) DEFAULT NULL,
-  file_name varchar(255) DEFAULT NULL,
-  file_content long varchar,
-  action varchar(50) DEFAULT NULL,
-  vnf_id varchar(50) DEFAULT NULL,
-  vm_name varchar(50) DEFAULT NULL,
-  vnf_name varchar(50) DEFAULT NULL,
-  PRIMARY KEY (config_file_id)
-) ;
-
---
--- Table structure for table CONFIGURE_ACTION_DG
---
-
-
-CREATE TABLE CONFIGURE_ACTION_DG (
-  configure_action_dg_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  vnf_type varchar(50) DEFAULT NULL,
-  action varchar(50) DEFAULT NULL,
-  init_config_dg varchar(50) DEFAULT NULL,
-  generate_config_dg varchar(50) DEFAULT NULL,
-  download_config_dg varchar(50) DEFAULT NULL,
-  PRIMARY KEY (configure_action_dg_id)
-) ;
-
-
---
--- Table structure for table CONFIG_CONTENT
---
-
-CREATE TABLE CONFIG_CONTENT (
-  config_content_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  request_id varchar(50) NOT NULL,
-  content_type varchar(50) NOT NULL,
-  template_name varchar(50) DEFAULT NULL,
-  originator_id varchar(50) DEFAULT NULL,
-  service_description varchar(100) DEFAULT NULL,
-  action varchar(50) DEFAULT NULL,
-  creation_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  service_type varchar(50) DEFAULT NULL,
-  service_instance_id varchar(50) DEFAULT NULL,
-  vnf_id varchar(50) DEFAULT NULL,
-  vnf_name varchar(50) DEFAULT NULL,
-  vm_name varchar(50) DEFAULT NULL,
-  vnf_type varchar(50) DEFAULT NULL,
-  vnfc_type varchar(50) DEFAULT NULL,
-  host_ip_address varchar(50) DEFAULT NULL,
-  config_indicator varchar(25) DEFAULT NULL,
-  pending_delete varchar(1) DEFAULT NULL,
-  content long varchar,
-  PRIMARY KEY (config_content_id)
-) ;
-
-
---
--- Table structure for table CONFIG_FILE_REFERENCE
---
-
-CREATE TABLE CONFIG_FILE_REFERENCE (
-  config_file_reference_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  site_location varchar(50) DEFAULT NULL,
-  vnf_type varchar(50) DEFAULT NULL,
-  import_type varchar(50) DEFAULT NULL,
-  file_type varchar(50) DEFAULT NULL,
-  source_server_name varchar(255) DEFAULT NULL,
-  source_file_path varchar(255) DEFAULT NULL,
-  target_file_path varchar(255) DEFAULT NULL,
-  name varchar(50) DEFAULT NULL,
-  file_name varchar(255) DEFAULT NULL,
-  PRIMARY KEY (config_file_reference_id)
-) ;
-
---
--- Table structure for table CONFIG_TRANSACTION_LOG
---
-
-CREATE TABLE CONFIG_TRANSACTION_LOG (
-  config_transaction_log_id varchar(50) NOT NULL,
-  request_id varchar(50) DEFAULT NULL,
-  message_type varchar(100) DEFAULT NULL,
-  creation_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  message long varchar,
-  PRIMARY KEY (config_transaction_log_id)
-) ;
-
-
---
--- Table structure for table COUNTRY_ASN_MAPPING
---
-
-CREATE TABLE COUNTRY_ASN_MAPPING (
-  asn int NOT NULL,
-  iso_2char varchar(5) NOT NULL,
-  iso_3char varchar(5) NOT NULL
-) ;
-
-
-
-
---
--- Table structure for table CUSTOMER2CONNECTION_MAPPING
---
-
-CREATE TABLE CUSTOMER2CONNECTION_MAPPING (
-  customer2connection_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  service_instance_id varchar(80) NOT NULL,
-  instance_type varchar(20) NOT NULL,
-  originating_service_instance_id varchar(80) DEFAULT NULL,
-  originating_service_type varchar(20) DEFAULT NULL,
-  service_type varchar(30) DEFAULT NULL,
-  connection_id varchar(100) NOT NULL,
-  status varchar(20) DEFAULT NULL,
-  PRIMARY KEY (customer2connection_id)
-) ;
-
---
--- Table structure for table CUSTOMER2CONNECTION_MAPPING_NEW
---
-
-CREATE TABLE CUSTOMER2CONNECTION_MAPPING_NEW (
-  customer2connection_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  service_instance_id varchar(80) NOT NULL,
-  instance_type varchar(20) NOT NULL,
-  originating_service_instance_id varchar(80) DEFAULT NULL,
-  originating_service_type varchar(20) DEFAULT NULL,
-  service_type varchar(30) DEFAULT NULL,
-  connection_id varchar(100) NOT NULL,
-  status varchar(100) DEFAULT NULL,
-  PRIMARY KEY (customer2connection_id)
-) ;
-
---
--- Table structure for table DATA_OBJECT_MAPPING
---
-
-CREATE TABLE DATA_OBJECT_MAPPING (
-  serial_key int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  data_object_key varchar(100) NOT NULL,
-  data_object_type varchar(50) NOT NULL,
-  service_type varchar(50) NOT NULL,
-  data_object_key2 varchar(100) NOT NULL,
-  data_object_key2_type varchar(50) NOT NULL,
-  data_object_key3 varchar(100) DEFAULT NULL,
-  data_object_key3_type varchar(50) DEFAULT NULL,
-  service varchar(50) DEFAULT NULL,
-  PRIMARY KEY (serial_key)
-) ;
-
---
--- Table structure for table DEVICE2CONNECTION_MAPPING
---
-
-CREATE TABLE DEVICE2CONNECTION_MAPPING (
-  vnf_host_name varchar(100) NOT NULL,
-  e2e_vpn_key varchar(30) NOT NULL,
-  service_type varchar(30) NOT NULL,
-  connection_id varchar(100) NOT NULL,
-  PRIMARY KEY (vnf_host_name,e2e_vpn_key,service_type)
-) ;
-
---
--- Table structure for table DEVICE2IPADDRESS_CONSUMPTION
---
-
-CREATE TABLE DEVICE2IPADDRESS_CONSUMPTION (
-  serial_key int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  device_id varchar(100) NOT NULL,
-  device_type varchar(30) NOT NULL,
-  ip_version varchar(10) NOT NULL,
-  consumption_key varchar(100) NOT NULL,
-  logical_interface_service_id varchar(100) NOT NULL,
-  address_type varchar(30) NOT NULL,
-  ip_consumed varchar(50) NOT NULL,
-  vnf_type varchar(30) NOT NULL,
-  secondary_key varchar(100) DEFAULT NULL,
-  PRIMARY KEY (serial_key)
-) ;
-
---
--- Table structure for table DEVICE2IPADDRESS_MAPPING
---
-
-CREATE TABLE DEVICE2IPADDRESS_MAPPING (
-  serial_key int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  device_id varchar(100) NOT NULL,
-  device_type varchar(30) NOT NULL,
-  secondary_key varchar(100) NOT NULL,
-  secondary_key_type varchar(30) NOT NULL,
-  address varchar(50) NOT NULL,
-  address_type varchar(30) NOT NULL,
-  ip_version varchar(10) NOT NULL,
-  length int NOT NULL,
-  status varchar(30) NOT NULL,
-  PRIMARY KEY (serial_key)
-) ;
-
---
--- Table structure for table DEVICE_AUTHENTICATION
---
-
-CREATE TABLE DEVICE_AUTHENTICATION (
-  device_authentication_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  vnf_type varchar(50) DEFAULT NULL,
-  user_name varchar(50) DEFAULT NULL,
-  password varchar(100) DEFAULT NULL,
-  protocol varchar(100) DEFAULT NULL,
-  port_number int DEFAULT NULL,
-  PRIMARY KEY (device_authentication_id)
-) ;
-
---
--- Table structure for table DEVICE_INTERFACE_LOG
---
-
-CREATE TABLE DEVICE_INTERFACE_LOG (
-  device_interface_log_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  service_instance_id varchar(50) DEFAULT NULL,
-  request_id varchar(50) DEFAULT NULL,
-  creation_date timestamp NOT NULL,
-  log long varchar,
-  PRIMARY KEY (device_interface_log_id)
-) ;
-
---
--- Table structure for table DEVICE_INTERFACE_PROTOCOL
---
-
-CREATE TABLE DEVICE_INTERFACE_PROTOCOL (
-  device_interface_protocol_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  vnf_type varchar(50) DEFAULT NULL,
-  protocol varchar(50) DEFAULT NULL,
-  module varchar(50) DEFAULT NULL,
-  dg_rpc varchar(50) DEFAULT NULL,
-  PRIMARY KEY (device_interface_protocol_id)
-) ;
-
---
--- Table structure for table DOWNLOAD_CONFIG_TEMPLATE
---
-
-CREATE TABLE DOWNLOAD_CONFIG_TEMPLATE (
-  download_config_template_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  vnf_type varchar(50) NOT NULL,
-  protocol varchar(50) NOT NULL,
-  template long varchar,
-  PRIMARY KEY (download_config_template_id)
-) ;
-
---
--- Table structure for table DOWNLOAD_DG_REFERENCE
---
-
-CREATE TABLE DOWNLOAD_DG_REFERENCE (
-  download_dg_reference_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  protocol varchar(50) NOT NULL,
-  download_config_dg varchar(50) NOT NULL,
-  PRIMARY KEY (download_dg_reference_id)
-) ;
-
---
--- Table structure for table EIPAM_CLIENT_KEY_INDEX
---
-
-CREATE TABLE EIPAM_CLIENT_KEY_INDEX (
-  vnf_name_prefix varchar(100) NOT NULL,
-  index_number int NOT NULL,
-  PRIMARY KEY (vnf_name_prefix)
-) ;
-
---
--- Table structure for table EIPAM_IP_ASSIGNMENTS
---
-
-CREATE TABLE EIPAM_IP_ASSIGNMENTS (
-  plan_name varchar(40) NOT NULL,
-  client_key varchar(100) NOT NULL,
-  service_type varchar(40) NOT NULL,
-  ip_address varchar(40) DEFAULT NULL,
-  prefix_length int,
-  status varchar(255) DEFAULT NULL,
-  service_instance_id varchar(80) DEFAULT NULL,
-  last_modified_ts timestamp DEFAULT CURRENT_TIMESTAMP,
-  prev_status varchar(20) DEFAULT NULL,
-  info varchar(255) DEFAULT NULL,
-  PRIMARY KEY (plan_name,client_key)
-) ;
-
---
--- Table structure for table EIPAM_IP_POOLS
---
-
-CREATE TABLE EIPAM_IP_POOLS (
-  pool_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  key_name varchar(50) NOT NULL,
-  key_value varchar(255) NOT NULL,
-  level int NOT NULL,
-  plan_name varchar(50) NOT NULL,
-  address_family varchar(10) NOT NULL,
-  parent_pool varchar(255) NOT NULL,
-  service_instance_id varchar(255) DEFAULT NULL,
-  network_id varchar(255) DEFAULT NULL,
-  created_timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  delete_failure varchar(20) DEFAULT NULL,
-  delete_request_id varchar(255) DEFAULT NULL,
-  PRIMARY KEY (pool_id)
-) ;
-
---
--- Table structure for table EIPAM_IP_SUBNETS
---
-
-CREATE TABLE EIPAM_IP_SUBNETS (
-  entity_id int NOT NULL,
-  service_type varchar(40) NOT NULL,
-  plan_name varchar(50) NOT NULL,
-  address_family varchar(10) NOT NULL,
-  ip_address varchar(40) NOT NULL,
-  prefix_length int NOT NULL,
-  status varchar(20) NOT NULL,
-  last_modified_ts timestamp DEFAULT CURRENT_TIMESTAMP,
-  network_id varchar(255) DEFAULT NULL,
-  pool_id int DEFAULT NULL,
-  dealloc_failure varchar(20) DEFAULT NULL,
-  dealloc_request_id varchar(255) DEFAULT NULL,
-  PRIMARY KEY (entity_id)
-) ;
-
---
--- Table structure for table EIPAM_IP_SUBNET_KEYS
---
-
-CREATE TABLE EIPAM_IP_SUBNET_KEYS (
-  entity_id int NOT NULL,
-  key_name varchar(50) NOT NULL,
-  key_value varchar(255) NOT NULL,
-  level int NOT NULL,
-  PRIMARY KEY (entity_id,key_name,key_value,level)
-) ;
-
---
--- Table structure for table EIPAM_REQUEST_KEY
---
-
-CREATE TABLE EIPAM_REQUEST_KEY (
-  key_name_1 varchar(50) NOT NULL,
-  address_family varchar(4) NOT NULL,
-  serial_key int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  plan_name varchar(50) NOT NULL,
-  request_length int NOT NULL,
-  pools_length int NOT NULL,
-  plan_length int NOT NULL,
-  key_name_0 varchar(50) NOT NULL,
-  key_name_type_0 varchar(255) NOT NULL,
-  key_name_type_1 varchar(255) NOT NULL,
-  prefix_length int NOT NULL,
-  group_flag char(1) NOT NULL,
-  address_type varchar(20) DEFAULT NULL,
-  PRIMARY KEY (key_name_1,address_family)
-) ;
-
---
--- Table structure for table EXTERNAL_DATA
---
-
-CREATE TABLE EXTERNAL_DATA (
-  external_data_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  request_id int DEFAULT NULL,
-  param_name varchar(30) NOT NULL,
-  param_value varchar(50) NOT NULL,
-  PRIMARY KEY (external_data_id)
-) ;
-
---
--- Table structure for table FLOW_UPDATES
---
-
-CREATE TABLE FLOW_UPDATES (
-  seq int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  status varchar(10) NOT NULL DEFAULT 'NEW' CONSTRAINT status_ck_3 CHECK(status IN ('NEW', 'COMPLETE', 'FAILED')),
-  create_timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  last_processed_timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  odl varchar(128) DEFAULT NULL,
-  address_family varchar(4)  DEFAULT NULL CONSTRAINT fam_ck CHECK(address_family IN ('IPV4', 'IPV6')),
-  destination_prefix varchar(50) DEFAULT NULL,
-  communities varchar(6000) DEFAULT NULL,
-  route_key varchar(50) DEFAULT NULL,
-  PRIMARY KEY (seq)
-) ;
-
---
--- Table structure for table GENERIC_L3_NETWORK
---
-
-CREATE TABLE GENERIC_L3_NETWORK (
-  network_id varchar(80) NOT NULL,
-  network_name varchar(80) DEFAULT NULL,
-  network_type varchar(80) DEFAULT NULL,
-  network_role varchar(80) DEFAULT NULL,
-  network_technology varchar(80) DEFAULT NULL,
-  neutron_network_id varchar(80) DEFAULT NULL,
-  is_bound_to_vpn smallint DEFAULT NULL,
-  orchestration_status varchar(20) DEFAULT NULL,
-  heat_stack_id varchar(80) DEFAULT NULL,
-  mso_catalog_key varchar(80) DEFAULT NULL,
-  service_id varchar(80) NOT NULL,
-  tenant_id varchar(80) NOT NULL,
-  physical_location_id varchar(20) DEFAULT NULL,
-  network_role_instance varchar(80) NOT NULL,
-  PRIMARY KEY (network_id)
-) ;
-
---
--- Table structure for table GENERIC_L3_NETWORK_SUBNET
---
-
-CREATE TABLE GENERIC_L3_NETWORK_SUBNET (
-  network_id varchar(80) NOT NULL,
-  subnet_id varchar(80) NOT NULL,
-  neutron_subnet_id varchar(80) DEFAULT NULL,
-  gateway_address varchar(45) NOT NULL,
-  network_start_address varchar(45) NOT NULL,
-  cidr_mask varchar(20) NOT NULL,
-  ip_version char(1) NOT NULL,
-  orchestration_status varchar(64) NOT NULL,
-  dhcp_enabled smallint NOT NULL,
-  dhcp_start varchar(45) DEFAULT NULL,
-  dhcp_end varchar(45) DEFAULT NULL,
-  PRIMARY KEY (network_id,subnet_id)
-) ;
-
---
--- Table structure for table GENERIC_L3_NETWORK_VPN_BINDING
---
-
-CREATE TABLE GENERIC_L3_NETWORK_VPN_BINDING (
-  network_id varchar(80) NOT NULL,
-  vpn_id varchar(80) NOT NULL,
-  PRIMARY KEY (network_id,vpn_id)
-) ;
-
---
--- Table structure for table GENERIC_RESOURCE_NAME
---
-
-CREATE TABLE GENERIC_RESOURCE_NAME (
-  type varchar(50) NOT NULL,
-  name varchar(255) NOT NULL,
-  prefix varchar(255) ,
-  name_index int ,
-  context_id varchar(255) ,
-  PRIMARY KEY (type,name)
-) ;
-
---
--- Table structure for table GENERIC_VNF
---
-
-CREATE TABLE GENERIC_VNF (
-  vnf_id varchar(80) NOT NULL,
-  vnf_name varchar(80) NOT NULL,
-  vnf_type varchar(200) NOT NULL,
-  vnf_name2 varchar(80) DEFAULT NULL,
-  service_id varchar(80) NOT NULL,
-  equipment_role varchar(80) NOT NULL,
-  orchestration_status varchar(20) DEFAULT NULL,
-  prov_status varchar(20) DEFAULT NULL,
-  heat_stack_id varchar(80) DEFAULT NULL,
-  mso_catalog_key varchar(80) DEFAULT NULL,
-  regional_resource_zone varchar(80) DEFAULT NULL,
-  operational_state varchar(80) DEFAULT NULL,
-  license_key varchar(80) DEFAULT NULL,
-  ipv4_oam_address varchar(20) DEFAULT NULL,
-  ipv4_loopback0_address varchar(20) DEFAULT NULL,
-  nm_lan_v6_address varchar(40) DEFAULT NULL,
-  management_v6_address varchar(40) DEFAULT NULL,
-  management_option varchar(45) DEFAULT NULL,
-  vcpu varchar(45) DEFAULT NULL,
-  vmemory varchar(45) DEFAULT NULL,
-  vdisk varchar(45) DEFAULT NULL,
-  vcpu_units varchar(45) DEFAULT NULL,
-  vmemory_units varchar(45) DEFAULT NULL,
-  vdisk_units varchar(45) DEFAULT NULL,
-  PRIMARY KEY (vnf_id)
-) ;
-
---
--- Table structure for table GENERIC_VNF_L3_NETWORK
---
-
-CREATE TABLE GENERIC_VNF_L3_NETWORK (
-  vnf_id varchar(80) NOT NULL,
-  network_id varchar(80) NOT NULL,
-  PRIMARY KEY (vnf_id,network_id)
-) ;
-
---
--- Table structure for table GENERIC_VNF_LICENSE_MANAGEMENT
---
-
-CREATE TABLE GENERIC_VNF_LICENSE_MANAGEMENT (
-  vnf_id varchar(80) NOT NULL,
-  att_uuid varchar(80) NOT NULL,
-  PRIMARY KEY (vnf_id,att_uuid)
-) ;
-
---
--- Table structure for table GENERIC_VNF_LINTERFACE
---
-
-CREATE TABLE GENERIC_VNF_LINTERFACE (
-  vnf_id varchar(80) NOT NULL,
-  interface_name varchar(255) NOT NULL,
-  interface_role varchar(45) DEFAULT NULL,
-  v6_wan_link_ip varchar(45) DEFAULT NULL,
-  selflink varchar(128) DEFAULT NULL,
-  interface_id varchar(45) DEFAULT NULL,
-  macaddr varchar(64) DEFAULT NULL,
-  network_name varchar(255) DEFAULT NULL,
-  PRIMARY KEY (vnf_id,interface_name)
-) ;
-
---
--- Table structure for table GENERIC_VNF_PSERVER
---
-
-CREATE TABLE GENERIC_VNF_PSERVER (
-  vnf_id varchar(64) NOT NULL,
-  hostname varchar(255) NOT NULL,
-  PRIMARY KEY (vnf_id,hostname)
-) ;
-
---
--- Table structure for table GENERIC_VNF_SERVICE_INSTANCE
---
-
-CREATE TABLE GENERIC_VNF_SERVICE_INSTANCE (
-  vnf_id varchar(64) NOT NULL,
-  service_instance_id varchar(255) NOT NULL,
-  relationship_key varchar(64) NOT NULL,
-  relationship_value varchar(64) DEFAULT NULL,
-  global_customer_id varchar(255) DEFAULT NULL,
-  service_type varchar(255) DEFAULT NULL,
-  PRIMARY KEY (vnf_id,service_instance_id,relationship_key)
-) ;
-
---
--- Table structure for table GENERIC_VNF_VNF_IMAGE
---
-
-CREATE TABLE  GENERIC_VNF_VNF_IMAGE (
-  vnf_id varchar(64) NOT NULL,
-  att_uuid varchar(255) NOT NULL,
-  PRIMARY KEY (vnf_id,att_uuid)
-) ;
-
---
--- Table structure for table GENERIC_VNF_VSERVER
---
-
-CREATE TABLE  GENERIC_VNF_VSERVER (
-  vnf_id varchar(80) NOT NULL,
-  vserver_id varchar(128) NOT NULL,
-  tenant_id varchar(128) DEFAULT NULL,
-  PRIMARY KEY (vnf_id,vserver_id)
-) ;
-
---
--- Table structure for table GENERIC_VPN_BINDING
---
-
-CREATE TABLE  GENERIC_VPN_BINDING (
-  vpn_id varchar(80) NOT NULL,
-  vpn_name varchar(80) NOT NULL,
-  global_route_target varchar(80) NOT NULL,
-  PRIMARY KEY (vpn_id)
-) ;
-
---
--- Table structure for table GET_CONFIG_TEMPLATE
---
-
-CREATE TABLE  GET_CONFIG_TEMPLATE (
-  get_config_template_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  vnf_type varchar(50) NOT NULL,
-  device_interface_protocol_id int NOT NULL,
-  xml_processing varchar(1) DEFAULT NULL,
-  xml_protocol varchar(30) DEFAULT NULL,
-  template long varchar,
-  PRIMARY KEY (get_config_template_id)
-) ;
-
---
--- Table structure for table LOCATION
---
-
-CREATE TABLE  LOCATION (
-  loc_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  address varchar(150) NOT NULL,
-  city_code_id int NOT NULL,
-  create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  PRIMARY KEY (loc_id)
-) ;
-
---
--- Table structure for table HOSTNAME
---
-
-CREATE TABLE  HOSTNAME (
-  hostname varchar(21) NOT NULL,
-  parent_hostname varchar(21) DEFAULT NULL,
-  cust_id int NOT NULL,
-  loc_id int NOT NULL,
-  site_sequence varchar(2) NOT NULL,
-  server_sequence varchar(2) NOT NULL,
-  activation_code varchar(11) DEFAULT NULL,
-  vnf_sequence varchar(2) DEFAULT NULL,
-  vendor_code varchar(1) NOT NULL,
-  virtual_device_type varchar(2) DEFAULT NULL,
-  device_sequence varchar(3) DEFAULT NULL,
-  create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  PRIMARY KEY (hostname)
-) ;
-
---
--- Table structure for table IPV4_ADDRESS_POOL
---
-
-CREATE TABLE  IPV4_ADDRESS_POOL (
-  aic_site_id varchar(100) NOT NULL,
-  universe varchar(40) NOT NULL,
-  status varchar(40) NOT NULL,
-  ipv4_addr varchar(20) NOT NULL,
-  PRIMARY KEY (ipv4_addr,universe)
-) ;
-
---
--- Table structure for table LINK_MASTER
---
-
-CREATE TABLE  LINK_MASTER (
-  link_interface_ip varchar(20) NOT NULL,
-  source_crs_name varchar(20) NOT NULL,
-  destination_crs_name varchar(20) NOT NULL,
-  max_reserved_bw int DEFAULT NULL,
-  default_cost int DEFAULT NULL,
-  bundle_name varchar(20) DEFAULT NULL,
-  PRIMARY KEY (link_interface_ip)
-) ;
-
---
--- Table structure for table LINTERFACE_VLAN
---
-
-CREATE TABLE  LINTERFACE_VLAN (
-  vnf_id varchar(80) NOT NULL,
-  interface_name varchar(255) NOT NULL,
-  vlan_interface varchar(255) NOT NULL,
-  vlan_id_inner varchar(64) DEFAULT NULL,
-  vlan_id_outer varchar(64) DEFAULT NULL,
-  PRIMARY KEY (vnf_id,interface_name,vlan_interface)
-) ;
-
-
---
--- Table structure for table MAX_PORT_SPEED
---
-
-CREATE TABLE  MAX_PORT_SPEED (
-  max_port_speed_id bigint NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  image_file_name varchar(50) NOT NULL,
-  end_point_position varchar(50) NOT NULL,
-  interface_name varchar(100) NOT NULL,
-  max_speed bigint NOT NULL,
-  unit varchar(10) NOT NULL,
-  PRIMARY KEY (max_port_speed_id)
-) ;
-
---
--- Table structure for table MAX_SERVER_SPEED
---
-
-CREATE TABLE  MAX_SERVER_SPEED (
-  max_server_speed_id bigint NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  server_model varchar(50) NOT NULL,
-  evc_count smallint NOT NULL,
-  max_speed bigint NOT NULL,
-  unit varchar(10) NOT NULL,
-  description varchar(500) DEFAULT NULL,
-  PRIMARY KEY (max_server_speed_id)
-) ;
-
---
--- Table structure for table NAMING_POLICY_VM_NAME_INDEX
---
-
-CREATE TABLE  NAMING_POLICY_VM_NAME_INDEX (
-  vm_name_prefix varchar(255) NOT NULL,
-  index_number int NOT NULL,
-  PRIMARY KEY (vm_name_prefix)
-) ;
-
---
--- Table structure for table NAMING_POLICY_VNFC_NAME_INDEX
---
-
-CREATE TABLE  NAMING_POLICY_VNFC_NAME_INDEX (
-  vnfc_name_prefix varchar(255) NOT NULL,
-  index_number int NOT NULL,
-  PRIMARY KEY (vnfc_name_prefix)
-) ;
-
---
--- Table structure for table NBNC_ASSIGN_VPN_OVERRIDE
---
-
-CREATE TABLE  NBNC_ASSIGN_VPN_OVERRIDE (
-  vpn_id varchar(12) NOT NULL DEFAULT '',
-  vpn_rt varchar(16) NOT NULL DEFAULT '',
-  service_type varchar(16) NOT NULL DEFAULT '',
-  be_location varchar(16) NOT NULL DEFAULT '',
-  be_type varchar(32) NOT NULL DEFAULT '',
-  be_id varchar(32) DEFAULT NULL,
-  description varchar(128) DEFAULT NULL,
-  PRIMARY KEY (vpn_id,vpn_rt,service_type,be_location,be_type)
-) ;
-
---
--- Table structure for table NBNC_BORDER_ELEMENT
---
-
-CREATE TABLE  NBNC_BORDER_ELEMENT (
-  be_id varchar(32) NOT NULL,
-  be_type varchar(16) NOT NULL,
-  be_name varchar(32) DEFAULT NULL,
-  be_host_vnf_id varchar(32) DEFAULT NULL,
-  service_type varchar(16) DEFAULT NULL,
-  tangibility varchar(16) DEFAULT NULL,
-  usage_order smallint DEFAULT NULL,
-  vlan_start smallint DEFAULT NULL,
-  vlan_end smallint DEFAULT NULL,
-  ipv4_subnet varchar(18) DEFAULT NULL,
-  ipv6_subnet varchar(68) DEFAULT NULL,
-  network_ip varchar(48) DEFAULT NULL,
-  be_location varchar(16) DEFAULT NULL,
-  description varchar(128) DEFAULT NULL,
-  updated_timestamp timestamp DEFAULT NULL,
-  log_link_model_uuid varchar(64) DEFAULT NULL,
-  PRIMARY KEY (be_id,be_type)
-) ;
-
---
--- Table structure for table NBNC_IPE
---
-
-CREATE TABLE  NBNC_IPE (
-  ipe_name varchar(32) NOT NULL,
-  ipe_location varchar(16) DEFAULT NULL,
-  ipe_ip_address varchar(16) DEFAULT NULL,
-  ipe_id varchar(8) DEFAULT NULL,
-  service_type_array varchar(512) DEFAULT NULL,
-  ipe_status varchar(32) DEFAULT NULL,
-  updated_timestamp timestamp DEFAULT NULL,
-  PRIMARY KEY (ipe_name)
-) ;
-
---
--- Table structure for table NBNC_IPE_PORT
---
-
-CREATE TABLE  NBNC_IPE_PORT (
-  port_id varchar(16) NOT NULL,
-  ipe_name varchar(32) NOT NULL,
-  be_id varchar(32) NOT NULL,
-  be_type varchar(16) NOT NULL,
-  port_type varchar(16) DEFAULT NULL,
-  ae_name varchar(16) DEFAULT NULL,
-  description varchar(128) DEFAULT NULL,
-  updated_timestamp timestamp DEFAULT NULL,
-  PRIMARY KEY (port_id,ipe_name,be_id,be_type)
-) ;
-
---
--- Table structure for table NBNC_MAPPING_SBG_BGF
---
-
-CREATE TABLE  NBNC_MAPPING_SBG_BGF (
-  asbg_vlan smallint NOT NULL,
-  bgf_vlan smallint NOT NULL,
-  PRIMARY KEY (asbg_vlan)
-) ;
-
---
--- Table structure for table NBNC_SERVICE
---
-
-CREATE TABLE  NBNC_SERVICE (
-  service_type varchar(16) NOT NULL,
-  service_model_uuid varchar(64) NOT NULL,
-  description varchar(128) DEFAULT NULL,
-  created_timestamp timestamp DEFAULT NULL,
-  updated_timestamp timestamp DEFAULT NULL,
-  PRIMARY KEY (service_type)
-) ;
-
---
--- Table structure for table NBNC_SERVICE_VLAN
---
-
-CREATE TABLE  NBNC_SERVICE_VLAN (
-  be_id varchar(32) NOT NULL,
-  vlan smallint NOT NULL,
-  service_type varchar(16) DEFAULT NULL,
-  be_type varchar(16) DEFAULT NULL,
-  be_name varchar(32) DEFAULT NULL,
-  be_host_vnf_id varchar(32) DEFAULT NULL,
-  be_location varchar(16) DEFAULT NULL,
-  be_usage_order smallint DEFAULT NULL,
-  vlan_usage_order smallint DEFAULT NULL,
-  status varchar(16) DEFAULT 'AVAILABLE',
-  request_id varchar(64) DEFAULT NULL,
-  service_instance_id varchar(64) DEFAULT NULL,
-  vni_id varchar(16) DEFAULT NULL,
-  customer_id varchar(16) DEFAULT NULL,
-  ipe1_router_name varchar(32) DEFAULT NULL,
-  ipe1_port_id varchar(16) DEFAULT NULL,
-  ipe1_ae_name varchar(16) DEFAULT NULL,
-  ipe2_router_name varchar(32) DEFAULT NULL,
-  ipe2_port_id varchar(16) DEFAULT NULL,
-  ipe2_ae_name varchar(16) DEFAULT NULL,
-  available_timestamp timestamp DEFAULT NULL,
-  allocated_timestamp timestamp DEFAULT NULL,
-  disabled_timestamp timestamp DEFAULT NULL,
-  enabled_timestamp timestamp DEFAULT NULL,
-  vpn_id varchar(12) DEFAULT NULL,
-  vpn_rt varchar(16) DEFAULT NULL,
-  PRIMARY KEY (be_id,vlan)
-) ;
-
---
--- Table structure for table NCS_EXPECTED_ASYNC_REQUESTS
---
-
-CREATE TABLE  NCS_EXPECTED_ASYNC_REQUESTS (
-  ncs_request_id varchar(255) NOT NULL,
-  mso_gp_request_id varchar(255) NOT NULL,
-  service_instance_id varchar(255) NOT NULL,
-  sdn_module_name varchar(255) NOT NULL,
-  sdn_rpc_name varchar(255) NOT NULL,
-  sdn_service_action varchar(255) DEFAULT NULL,
-  ncs_rpc varchar(255) NOT NULL,
-  ncs_sub_action varchar(255) DEFAULT NULL,
-  status varchar(255) NOT NULL DEFAULT 'inProgress',
-  creation_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  PRIMARY KEY (ncs_request_id)
-) ;
-
---
--- Table structure for table NETWORK_INSTANCE_NAME_INDEX
---
-
-CREATE TABLE  NETWORK_INSTANCE_NAME_INDEX (
-  network_instance_name_prefix varchar(255) NOT NULL,
-  index_number int NOT NULL,
-  PRIMARY KEY (network_instance_name_prefix)
-) ;
-
-
---
--- Table structure for table SERVICE_MODEL
---
-
-CREATE TABLE SERVICE_MODEL (
-  service_uuid varchar(255) NOT NULL,
-  model_yaml blob,
-  invariant_uuid varchar(255) DEFAULT NULL,
-  version varchar(255) DEFAULT NULL,
-  name varchar(255) DEFAULT NULL,
-  description varchar(1024) DEFAULT NULL,
-  type varchar(255) DEFAULT NULL,
-  category varchar(255) DEFAULT NULL,
-  ecomp_naming char(1) DEFAULT NULL,
-  service_instance_name_prefix varchar(255) DEFAULT NULL,
-  filename varchar(100) DEFAULT NULL,
-  naming_policy varchar(255) DEFAULT NULL,
-  PRIMARY KEY (service_uuid)
-);
-
-
---
--- Table structure for table NETWORK_MODEL
---
-CREATE TABLE NETWORK_MODEL (
-  customization_uuid varchar(255) NOT NULL,
-  service_uuid varchar(255) NOT NULL,
-  model_yaml blob,
-  invariant_uuid varchar(255) DEFAULT NULL,
-  uuid varchar(255) DEFAULT NULL,
-  network_type varchar(255) DEFAULT NULL,
-  network_role varchar(255) DEFAULT NULL,
-  network_technology varchar(255) DEFAULT NULL,
-  trunk_network_indicator char(1) DEFAULT NULL,
-  network_scope varchar(255) DEFAULT NULL,
-  naming_policy varchar(255) DEFAULT NULL,
-  ecomp_generated_naming char(1) DEFAULT NULL,
-  is_shared_network char(1) DEFAULT NULL,
-  is_external_network char(1) DEFAULT NULL,
-  is_provider_network char(1) DEFAULT NULL,
-  physical_network_name varchar(255) DEFAULT NULL,
-  is_bound_to_vpn char(1) DEFAULT NULL,
-  vpn_binding varchar(255) DEFAULT NULL,
-  use_ipv4 char(1) DEFAULT NULL,
-  ipv4_dhcp_enabled char(1) DEFAULT NULL,
-  ipv4_ip_version char(1) DEFAULT NULL,
-  ipv4_cidr_mask varchar(255) DEFAULT NULL,
-  eipam_v4_address_plan varchar(255) DEFAULT NULL,
-  use_ipv6 char(1) DEFAULT NULL,
-  ipv6_dhcp_enabled char(1) DEFAULT NULL,
-  ipv6_ip_version char(1) DEFAULT NULL,
-  ipv6_cidr_mask varchar(255) DEFAULT NULL,
-  eipam_v6_address_plan varchar(255) DEFAULT NULL,
-  version varchar(255) DEFAULT NULL,
-  PRIMARY KEY (customization_uuid)
-);
-
---
--- Table structure for table NETWORK_PROFILE
---
-
-CREATE TABLE  NETWORK_PROFILE (
-  network_type varchar(100) NOT NULL,
-  technology varchar(100) NOT NULL,
-  PRIMARY KEY (network_type)
-) ;
-
---
--- Table structure for table NETWORK_ROLE_VPN_BINDING
---
-
-CREATE TABLE  NETWORK_ROLE_VPN_BINDING (
-  network_role varchar(80) NOT NULL,
-  vpn_id varchar(80) NOT NULL,
-  PRIMARY KEY (network_role,vpn_id)
-) ;
-
---
--- Table structure for table NODE_TYPES
---
-
-CREATE TABLE  NODE_TYPES (
-  nodetype varchar(80) NOT NULL,
-  PRIMARY KEY (nodetype)
-) ;
-
---
--- Table structure for table OBJECT_GROUPING
---
-
-CREATE TABLE  OBJECT_GROUPING (
-  group_id varchar(128) NOT NULL,
-  group_type varchar(128) NOT NULL,
-  PRIMARY KEY (group_id)
-) ;
-
---
--- Table structure for table OBJECT_GROUP_MEMBER_TRACKING
---
-
-CREATE TABLE  OBJECT_GROUP_MEMBER_TRACKING (
-  group_id varchar(128) NOT NULL,
-  key_id varchar(128) NOT NULL,
-  key_type varchar(128) NOT NULL,
-  PRIMARY KEY (group_id,key_id,key_type)
-) ;
-
---
--- Table structure for table PARAMETERS
---
-
-CREATE TABLE  PARAMETERS (
-  name varchar(100) NOT NULL,
-  value varchar(128) NOT NULL,
-  category varchar(24) DEFAULT NULL,
-  memo varchar(128) DEFAULT NULL,
-  PRIMARY KEY (name)
-) ;
-
---
--- Table structure for table PE_INV
---
-
-CREATE TABLE  PE_INV (
-  EQUIP_ID int DEFAULT NULL,
-  EQUIP_TYPE varchar(20) DEFAULT NULL,
-  PTNII_EQUIP_NAME varchar(20) DEFAULT NULL,
-  IP_ADDR varchar(15) DEFAULT NULL,
-  ROUTER_PROV_STATUS varchar(50) DEFAULT NULL,
-  REGION varchar(16) DEFAULT NULL,
-  COUNTRY_ABBR varchar(50) DEFAULT NULL,
-  EQUIP_NAME_CODE varchar(50) DEFAULT NULL,
-  AS_NUMBER varchar(5) DEFAULT NULL,
-  LOOPBACK1 varchar(15) DEFAULT NULL,
-  LOOPBACK2 varchar(15) DEFAULT NULL,
-  LOOPBACK3 varchar(15) DEFAULT NULL,
-  LOOPBACK40 varchar(15) DEFAULT NULL,
-  LOOPBACK65535 varchar(15) DEFAULT NULL,
-  INMS_LIST varchar(20) DEFAULT NULL,
-  ENCRYPTED_ACCESS_FLAG varchar(50) DEFAULT NULL,
-  SW_NAME varchar(100) DEFAULT NULL,
-  NMIPADDR varchar(15) DEFAULT NULL,
-  CREATE_DATE timestamp DEFAULT NULL,
-  MOD_DATE timestamp DEFAULT NULL,
-  FCN_CODE varchar(50) DEFAULT NULL
-) ;
-
---
--- Table structure for table PHYSICAL_LINK
---
-
-CREATE TABLE  PHYSICAL_LINK (
-  link_name varchar(255) NOT NULL,
-  speed_value varchar(64) DEFAULT NULL,
-  speed_units varchar(64) DEFAULT NULL,
-  circuit_id varchar(255) NOT NULL,
-  dual_mode varchar(64) NOT NULL,
-  PRIMARY KEY (link_name)
-) ;
-
---
--- Table structure for table PHYSICAL_LINK_PINTERFACE
---
-
-CREATE TABLE  PHYSICAL_LINK_PINTERFACE (
-  link_name varchar(255) NOT NULL,
-  hostname varchar(255) NOT NULL,
-  port_name_ft varchar(255) NOT NULL,
-  PRIMARY KEY (link_name,hostname,port_name_ft)
-) ;
-
---
--- Table structure for table PINTERFACE
---
-
-CREATE TABLE  PINTERFACE (
-  hostname varchar(255) NOT NULL,
-  port_name_ft varchar(255) NOT NULL,
-  interface_name varchar(255) DEFAULT '',
-  physical_speed varchar(255) DEFAULT '',
-  physical_units varchar(255) DEFAULT '',
-  port_description varchar(255) DEFAULT '',
-  PRIMARY KEY (hostname,port_name_ft)
-) ;
-
---
--- Table structure for table POLICY_UPDATE_NOTIFICATION
---
-
-CREATE TABLE  POLICY_UPDATE_NOTIFICATION (
-  policy_name varchar(255) NOT NULL,
-  version_id varchar(255) NOT NULL,
-  update_type varchar(255) NOT NULL,
-  timestamp timestamp DEFAULT CURRENT_TIMESTAMP,
-  PRIMARY KEY (policy_name,version_id)
-) ;
-
---
--- Table structure for table PORTAL_USERS
---
-
-CREATE TABLE  PORTAL_USERS (
-  email varchar(64) NOT NULL,
-  password varchar(255) for bit data NOT NULL,
-  privilege char(1) NOT NULL,
-  PRIMARY KEY (email)
-) ;
-
-
---
--- Table structure for table PREPARE_FILE_RELATIONSHIP
---
-
-CREATE TABLE  PREPARE_FILE_RELATIONSHIP (
-  prepare_file_relationship_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  service_instance_id varchar(50) DEFAULT NULL,
-  request_id varchar(255) DEFAULT NULL,
-  config_file_id int DEFAULT NULL,
-  asdc_artifacts_id int DEFAULT NULL,
-  PRIMARY KEY (prepare_file_relationship_id)
-) ;
-
---
--- Table structure for table PRE_LOAD_VNF_DATA
---
-
-CREATE TABLE  PRE_LOAD_VNF_DATA (
-  id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  svc_request_id varchar(100) DEFAULT '',
-  svc_action varchar(40) DEFAULT '',
-  status varchar(10) NOT NULL DEFAULT 'pending',
-  filename varchar(100) NOT NULL,
-  ts timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  preload_data blob,
-  PRIMARY KEY (id)
-) ;
-
---
--- Table structure for table PRE_LOAD_VNF_NETWORK_DATA
---
-
-CREATE TABLE  PRE_LOAD_VNF_NETWORK_DATA (
-  id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  svc_request_id varchar(100) DEFAULT '',
-  svc_action varchar(40) DEFAULT '',
-  status varchar(10) NOT NULL DEFAULT 'pending',
-  filename varchar(100) NOT NULL,
-  ts timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  preload_data blob,
-  PRIMARY KEY (id)
-) ;
-
---
--- Table structure for table PSERVER
---
-
-CREATE TABLE  PSERVER (
-  hostname varchar(255) NOT NULL,
-  ptnii_equip_name varchar(255) DEFAULT '',
-  number_of_cpus varchar(255) DEFAULT '',
-  disk_in_gigabytes varchar(255) DEFAULT '',
-  ram_in_megabytes varchar(255) DEFAULT '',
-  equip_type varchar(255) DEFAULT '',
-  equip_vendor varchar(255) DEFAULT '',
-  equip_model varchar(255) DEFAULT '',
-  fqdn varchar(255) DEFAULT '',
-  pserver_selflink varchar(255) DEFAULT '',
-  ipv4_oam_address varchar(40) DEFAULT NULL,
-  serial_number varchar(255) DEFAULT '',
-  pserver_id varchar(255) DEFAULT '',
-  internet_topology varchar(40) DEFAULT '',
-  aic_site_id varchar(100) DEFAULT '',
-  in_maint varchar(5) DEFAULT '',
-  pserver_name2 varchar(255) DEFAULT '',
-  purpose varchar(255) DEFAULT '',
-  PRIMARY KEY (hostname)
-) ;
-
---
--- Table structure for table RANGE_RULE
---
-
-CREATE TABLE  RANGE_RULE (
-  range_rule_id bigint NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  range_name varchar(50) NOT NULL,
-  service_model varchar(50) NOT NULL,
-  end_point_position varchar(50) NOT NULL,
-  equipment_level varchar(50) NOT NULL,
-  min_value int NOT NULL,
-  max_value int NOT NULL,
-  PRIMARY KEY (range_rule_id)
-) ;
-
---
--- Table structure for table REQUEST_DETAILS
---
-
-CREATE TABLE  REQUEST_DETAILS (
-  request_id varchar(255) NOT NULL,
-  controller_id varchar(255) DEFAULT NULL,
-  status varchar(255) DEFAULT NULL,
-  service_rate varchar(255) DEFAULT NULL,
-  service_instance_id varchar(255) DEFAULT NULL,
-  service_type varchar(255) DEFAULT NULL,
-  global_customer_id varchar(255) DEFAULT NULL,
-  notification_url varchar(255) DEFAULT NULL,
-  domain_requests varchar(255) DEFAULT NULL,
-  PRIMARY KEY (request_id)
-) ;
-
---
--- Table structure for table REQUEST_PROGRESS
---
-
-CREATE TABLE  REQUEST_PROGRESS (
-  request_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  request_type varchar(20) DEFAULT NULL,
-  service_instance_id varchar(80) NOT NULL,
-  request_instance_type varchar(20) NOT NULL,
-  originating_service_instance_id varchar(80) DEFAULT NULL,
-  originating_service_type varchar(20) DEFAULT NULL,
-  overall_status varchar(20) DEFAULT NULL,
-  status_date varchar(80) DEFAULT NULL,
-  message varchar(255) DEFAULT NULL,
-  PRIMARY KEY (request_id)
-) ;
-
---
--- Table structure for table REQUEST_PROGRESS_STATE
---
-
-CREATE TABLE  REQUEST_PROGRESS_STATE (
-  request_progress_state_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  request_id int DEFAULT NULL,
-  service_instance_id varchar(80) NOT NULL,
-  request_instance_type varchar(20) NOT NULL,
-  progress_state varchar(30) DEFAULT NULL,
-  transaction_status varchar(20) DEFAULT NULL,
-  status_date varchar(80) DEFAULT NULL,
-  response_code varchar(20) DEFAULT NULL,
-  message varchar(255) DEFAULT NULL,
-  PRIMARY KEY (request_progress_state_id)
-) ;
-
---
--- Table structure for table RESOURCE
---
-
-CREATE TABLE  RESOURCE (
-  resource_id bigint NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  asset_id varchar(100) NOT NULL,
-  resource_name varchar(50) NOT NULL,
-  resource_type varchar(5) NOT NULL CONSTRAINT res_ck CHECK(resource_type IN ('Limit','Label','Range')),
-  lt_used bigint DEFAULT NULL,
-  ll_label varchar(50) DEFAULT NULL,
-  ll_reference_count smallint DEFAULT NULL,
-  rr_used varchar(4000) DEFAULT NULL,
-  PRIMARY KEY (resource_id)
-) ;
-
---
--- Table structure for table RESOURCE_LOAD
---
-
-CREATE TABLE  RESOURCE_LOAD (
-  resource_load_id bigint NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  resource_id bigint NOT NULL,
-  application_id varchar(20) NOT NULL,
-  resource_load_time timestamp NOT NULL,
-  resource_expiration_time timestamp DEFAULT NULL,
-  PRIMARY KEY (resource_load_id)
-) ;
-
---
--- Table structure for table RESOURCE_LOCK
---
-
-CREATE TABLE  RESOURCE_LOCK (
-  resource_lock_id bigint NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  resource_name varchar(256) DEFAULT NULL,
-  lock_holder varchar(100) NOT NULL,
-  lock_count smallint NOT NULL,
-  lock_time timestamp NOT NULL,
-  expiration_time timestamp NOT NULL,
-  PRIMARY KEY (resource_lock_id)
-) ;
-
---
--- Table structure for table RESOURCE_RULE
---
-
-CREATE TABLE  RESOURCE_RULE (
-  resource_rule_id bigint NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  resource_name varchar(50) NOT NULL,
-  service_model varchar(50) NOT NULL,
-  end_point_position varchar(50) NOT NULL,
-  service_expression varchar(2000) NOT NULL,
-  equipment_level varchar(50) NOT NULL,
-  equipment_expression varchar(2000) NOT NULL,
-  allocation_expression varchar(2000) NOT NULL,
-  soft_limit_expression varchar(2000) NOT NULL,
-  hard_limit_expression varchar(2000) NOT NULL,
-  PRIMARY KEY (resource_rule_id)
-) ;
-
---
--- Table structure for table RESOURCE_THRESHOLD
---
-
-CREATE TABLE  RESOURCE_THRESHOLD (
-  resource_threshold_id bigint NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  resource_rule_id bigint NOT NULL,
-  threshold_expression varchar(2000) NOT NULL,
-  threshold_message varchar(2000) NOT NULL,
-  PRIMARY KEY (resource_threshold_id)
-) ;
-
---
--- Table structure for table ROUTER_MASTER
---
-
-CREATE TABLE  ROUTER_MASTER (
-  crs_name varchar(20) NOT NULL,
-  loopback_ip varchar(20) NOT NULL,
-  PRIMARY KEY (crs_name)
-) ;
-
---
--- Table structure for table ROUTING_CHARACTERISTIC_MAPPING
---
-
-CREATE TABLE  ROUTING_CHARACTERISTIC_MAPPING (
-  network_role varchar(255) NOT NULL,
-  vrf_name varchar(255) NOT NULL,
-  routing_characteristic varchar(255) NOT NULL,
-  PRIMARY KEY (network_role,vrf_name)
-) ;
-
---
--- Table structure for table SERVICE_HOMING
---
-
-CREATE TABLE  SERVICE_HOMING (
-  service_type varchar(100) NOT NULL,
-  lata int NOT NULL,
-  hubbing_city_type varchar(40) NOT NULL,
-  latitude float DEFAULT NULL,
-  longitude float DEFAULT NULL,
-  primary_aic_site_name varchar(100) NOT NULL,
-  secondary_aic_site_name varchar(100) DEFAULT NULL,
-  tertiary_aic_site_name varchar(100) DEFAULT NULL,
-  PRIMARY KEY (service_type,lata,hubbing_city_type)
-) ;
-
---
--- Table structure for table SERVICE_HOMING_BACKUP
---
-
-CREATE TABLE  SERVICE_HOMING_BACKUP (
-  service_type varchar(100) NOT NULL,
-  lata int NOT NULL,
-  hubbing_city_type varchar(40) NOT NULL,
-  latitude float DEFAULT NULL,
-  longitude float DEFAULT NULL,
-  primary_aic_site_name varchar(100) NOT NULL,
-  secondary_aic_site_name varchar(100) DEFAULT NULL,
-  tertiary_aic_site_name varchar(100) DEFAULT NULL,
-  PRIMARY KEY (service_type,lata,hubbing_city_type)
-) ;
-
---
--- Table structure for table SERVICE_INSTANCE_NAME_INDEX
---
-
-CREATE TABLE  SERVICE_INSTANCE_NAME_INDEX (
-  service_instance_name_prefix varchar(255) NOT NULL,
-  index_number int NOT NULL,
-  PRIMARY KEY (service_instance_name_prefix)
-) ;
-
---
--- Table structure for table SERVICE_MANAGER_CREDENTIALS
---
-
-CREATE TABLE  SERVICE_MANAGER_CREDENTIALS (
-  service_manager_username varchar(255) NOT NULL,
-  service_manager_password varchar(255) for bit data NOT NULL,
-  PRIMARY KEY (service_manager_username)
-) ;
-
---
--- Table structure for table SERVICE_PROXY
---
-
-CREATE TABLE  SERVICE_PROXY (
-  port_mirror_service_uuid varchar(255) NOT NULL,
-  service_proxy_name varchar(255) NOT NULL,
-  source_service_uuid varchar(255) NOT NULL,
-  resources_vendor varchar(255) DEFAULT NULL,
-  resource_vendor_release varchar(255) DEFAULT NULL,
-  description varchar(255) DEFAULT NULL,
-  category varchar(255) DEFAULT NULL,
-  subcategory varchar(255) DEFAULT NULL,
-  version varchar(255) DEFAULT NULL,
-  role varchar(255) NOT NULL,
-  uuid varchar(255) DEFAULT NULL,
-  customization_uuid varchar(255) DEFAULT NULL,
-  invariant_uuid varchar(255) DEFAULT NULL,
-  PRIMARY KEY (port_mirror_service_uuid,service_proxy_name)
-) ;
-
---
--- Table structure for table SERVICE_RESOURCE
---
-
-CREATE TABLE  SERVICE_RESOURCE (
-  service_resource_id bigint NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  service_instance_id varchar(80) NOT NULL,
-  service_status varchar(7) NOT NULL CONSTRAINT svc_stat_ck CHECK (service_status IN ('Active','Pending')),
-  service_change_number smallint NOT NULL,
-  resource_set_id varchar(100) NOT NULL,
-  resource_union_id varchar(100) NOT NULL,
-  PRIMARY KEY (service_instance_id,service_change_number)
-) ;
-
---
--- Table structure for table SERVICE_TYPE_MAPPING
---
-
-CREATE TABLE  SERVICE_TYPE_MAPPING (
-  sdnc_service_type varchar(128) NOT NULL,
-  ncs_service_type varchar(128) NOT NULL,
-  PRIMARY KEY (sdnc_service_type,ncs_service_type)
-) ;
-
---
--- Table structure for table SUBNETPOOL_MAPPING
---
-
-CREATE TABLE  SUBNETPOOL_MAPPING (
-  aic_cloud_region varchar(16) NOT NULL,
-  ntc varchar(32) NOT NULL,
-  lcp varchar(32) NOT NULL,
-  aic_region_id varchar(255) NOT NULL,
-  PRIMARY KEY (aic_cloud_region)
-) ;
-
---
--- Table structure for table SUPPORTED_SEQUENCE_NUMBER
---
-
-CREATE TABLE  SUPPORTED_SEQUENCE_NUMBER (
-  resource_sequence_number varchar(10) NOT NULL,
-  resource_type varchar(10) NOT NULL,
-  PRIMARY KEY (resource_sequence_number,resource_type)
-) ;
-
---
--- Table structure for table SVC_LOGIC
---
-
-CREATE TABLE  SVC_LOGIC (
-  module varchar(80) NOT NULL,
-  rpc varchar(80) NOT NULL,
-  version varchar(40) NOT NULL,
-  mode varchar(5) NOT NULL,
-  active varchar(1) NOT NULL,
-  graph blob,
-  modified_timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  md5sum varchar(128) DEFAULT NULL,
-  PRIMARY KEY (module,rpc,version,mode)
-) ;
-
---
--- Table structure for table TABLE_CLEANUP_CONFIGURATION
---
-
-CREATE TABLE  TABLE_CLEANUP_CONFIGURATION (
-  table_name varchar(255) NOT NULL,
-  days_old int NOT NULL ,
-  date_column varchar(255) NOT NULL ,
-  commit_interval int NOT NULL DEFAULT 2500 ,
-  query_clause varchar(1000) DEFAULT NULL ,
-  child_table_name varchar(255) DEFAULT NULL,
-  child_table_pk varchar(255) DEFAULT NULL,
-  PRIMARY KEY (table_name)
-) ;
-
---
--- Table structure for table TASK_TEMPLATE
---
-
-CREATE TABLE  TASK_TEMPLATE (
-  task_template_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  request_type varchar(20) DEFAULT NULL,
-  task_name varchar(30) NOT NULL,
-  task_category varchar(50) NOT NULL,
-  ecomp_task varchar(50) NOT NULL,
-  initial_load varchar(1) NOT NULL,
-  service varchar(20) DEFAULT NULL,
-  PRIMARY KEY (task_template_id)
-) ;
-
---
--- Table structure for table TENANT
---
-
-CREATE TABLE  TENANT (
-  tenant_id varchar(255) NOT NULL,
-  tenant_name varchar(255) NOT NULL,
-  service_instance_id varchar(255) NOT NULL,
-  PRIMARY KEY (tenant_id,tenant_name)
-) ;
-
---
--- Table structure for table TESTTBL
---
-
-CREATE TABLE  TESTTBL (
-  pk varchar(25) NOT NULL,
-  col1 varchar(25) DEFAULT NULL
-) ;
-
---
--- Table structure for table THRESHOLD_NOTIFICATION
---
-
-CREATE TABLE  THRESHOLD_NOTIFICATION (
-  resource_id bigint NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  threshold_expression varchar(2000) DEFAULT NULL,
-  threshold_message varchar(500) DEFAULT NULL,
-  PRIMARY KEY (resource_id)
-) ;
-
---
--- Table structure for table TMP_AIC_AVAIL_ZONE_POOL
---
-
-CREATE TABLE  TMP_AIC_AVAIL_ZONE_POOL (
-  aic_site_id varchar(100) NOT NULL,
-  status varchar(40) NOT NULL,
-  availability_zone varchar(100) NOT NULL,
-  token int NOT NULL,
-  vnf_id varchar(80) DEFAULT NULL,
-  service_type varchar(100) NOT NULL,
-  vnf_type varchar(20) DEFAULT NULL,
-  hypervisor varchar(10) DEFAULT NULL,
-  PRIMARY KEY (aic_site_id,availability_zone,token)
-) ;
-
---
--- Table structure for table TOPOLOGY_PARAMETER
---
-
-CREATE TABLE  TOPOLOGY_PARAMETER (
-  parameter_id int NOT NULL,
-  parameter_name varchar(20) NOT NULL,
-  parameter_set int NOT NULL,
-  create_update_time timestamp NOT NULL,
-  create_update_user varchar(40) NOT NULL,
-  PRIMARY KEY (parameter_id)
-) ;
-
---
--- Table structure for table TOPOLOGY_PARAMETER_ENTRIES
---
-
-CREATE TABLE  TOPOLOGY_PARAMETER_ENTRIES (
-  parameter_entry_id int NOT NULL,
-  parameter_name varchar(255) NOT NULL,
-  parameter_value varchar(64) NOT NULL,
-  create_update_time timestamp NOT NULL,
-  create_update_user varchar(40) NOT NULL,
-  PRIMARY KEY (parameter_entry_id)
-) ;
-
---
--- Table structure for table TOPOLOGY_PARAMETER_TO_ENTRIES
---
-
-CREATE TABLE  TOPOLOGY_PARAMETER_TO_ENTRIES (
-  parameter_id int DEFAULT NULL,
-  parameter_entry_id int DEFAULT NULL,
-  entry_order int DEFAULT NULL,
-  create_update_time timestamp DEFAULT NULL,
-  create_update_user varchar(40) NOT NULL
-) ;
-
---
--- Table structure for table TOPOLOGY_LOGICAL_RELATION_TO_PINTERFACE
---
-
-CREATE TABLE  TOPOLOGY_LOGICAL_RELATION_TO_PINTERFACE (
-  interface_name varchar(255) NOT NULL,
-  interface_id varchar(255) NOT NULL,
-  pnf_name varchar(255) NOT NULL,
-  pnf_id varchar(255) NOT NULL,
-  controller_id varchar(255) DEFAULT NULL,
-  rate varchar(255) DEFAULT NULL,
-  clli varchar(255) DEFAULT NULL,
-  connection_point varchar(255) DEFAULT NULL,
-  PRIMARY KEY (interface_name)
-) ;
-
---
--- Table structure for table TRANSACTION_LOG
---
-
-CREATE TABLE  TRANSACTION_LOG (
-  serial_key int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  log_time varchar(40) NOT NULL,
-  request_id varchar(80) DEFAULT NULL,
-  svc_request_id varchar(80) DEFAULT NULL,
-  x_ecomp_request_id varchar(80) DEFAULT NULL,
-  graph_name varchar(255) DEFAULT NULL,
-  PRIMARY KEY (serial_key)
-) ;
-
-
---
--- Table structure for table UPLOAD_CONFIG
---
-
-CREATE TABLE  UPLOAD_CONFIG (
-  upload_config_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  request_id varchar(50) DEFAULT NULL,
-  originator_id varchar(50) DEFAULT NULL,
-  service_description varchar(100) DEFAULT NULL,
-  action varchar(50) DEFAULT NULL,
-  upload_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  vnf_id varchar(50) DEFAULT NULL,
-  vnf_name varchar(50) DEFAULT NULL,
-  vm_name varchar(50) DEFAULT NULL,
-  vnf_type varchar(50) DEFAULT NULL,
-  vnfc_type varchar(50) DEFAULT NULL,
-  host_ip_address varchar(50) DEFAULT NULL,
-  config_indicator varchar(25) DEFAULT NULL,
-  pending_delete varchar(1) DEFAULT NULL,
-  content long varchar,
-  PRIMARY KEY (upload_config_id)
-) ;
-
---
--- Table structure for table USED_SEQUENCE_NUMBER
---
-
-CREATE TABLE  USED_SEQUENCE_NUMBER (
-  resource_sequence_number varchar(10) NOT NULL,
-  resource_type varchar(10) NOT NULL,
-  zone_region_id varchar(50) NOT NULL,
-  PRIMARY KEY (resource_sequence_number,resource_type,zone_region_id)
-) ;
-
-
---
--- Table structure for table VENDOR_CODE
---
-
-CREATE TABLE  VENDOR_CODE (
-  vendor_code varchar(1) NOT NULL,
-  vendor varchar(45) NOT NULL DEFAULT '',
-  PRIMARY KEY (vendor_code,vendor)
-) ;
-
---
--- Table structure for table VFC_MODEL
---
-
-CREATE TABLE VFC_MODEL (
-  customization_uuid varchar(255) NOT NULL,
-  model_yaml blob,
-  invariant_uuid varchar(255) DEFAULT NULL,
-  uuid varchar(255) DEFAULT NULL,
-  version varchar(255) DEFAULT NULL,
-  naming_policy varchar(255) DEFAULT NULL,
-  ecomp_generated_naming char(1) DEFAULT NULL,
-  nfc_function varchar(255) DEFAULT NULL,
-  nfc_naming_code varchar(255) DEFAULT NULL,
-  vm_type varchar(255) DEFAULT NULL,
-  vm_type_tag varchar(255) DEFAULT NULL,
-  vm_image_name varchar(255) DEFAULT NULL,
-  vm_flavor_name varchar(255) DEFAULT NULL,
-  high_availability varchar(255) DEFAULT NULL,
-  nfc_naming varchar(255) DEFAULT NULL,
-  min_instances int(11) DEFAULT NULL,
-  max_instances int(11) DEFAULT NULL,
-  PRIMARY KEY (customization_uuid)
-) ;
-
---
--- Table structure for table VFC_TO_NETWORK_ROLE_MAPPING
---
-
-CREATE TABLE VFC_TO_NETWORK_ROLE_MAPPING (
-  seq int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  vfc_customization_uuid varchar(255) NOT NULL,
-  network_role varchar(255) NOT NULL,
-  vm_type varchar(255) DEFAULT NULL,
-  network_role_tag varchar(255) DEFAULT NULL,
-  ipv4_count int(11) NOT NULL,
-  ipv6_count int(11) NOT NULL,
-  ipv4_use_dhcp char(1) DEFAULT NULL,
-  ipv6_use_dhcp char(1) DEFAULT NULL,
-  ipv4_ip_version char(1) DEFAULT NULL,
-  ipv6_ip_version char(1) DEFAULT NULL,
-  extcp_subnetpool_id varchar(512) DEFAULT NULL,
-  ipv4_floating_count int(11) DEFAULT NULL,
-  ipv6_floating_count int(11) DEFAULT NULL,
-  ipv4_address_plan_name varchar(512) DEFAULT NULL,
-  ipv6_address_plan_name varchar(512) DEFAULT NULL,
-  ipv4_vrf_name varchar(512) DEFAULT NULL,
-  ipv6_vrf_name varchar(512) DEFAULT NULL,
-  subnet_role varchar(255) DEFAULT NULL,
-  subinterface_indicator char(1) DEFAULT NULL,
-  PRIMARY KEY (seq)
-) ;
-
---
--- Table structure for table VF_MODEL
---
-
-CREATE TABLE VF_MODEL (
-  customization_uuid varchar(255) NOT NULL,
-  model_yaml blob,
-  invariant_uuid varchar(255) DEFAULT NULL,
-  uuid varchar(255) DEFAULT NULL,
-  version varchar(255) DEFAULT NULL,
-  name varchar(255) DEFAULT NULL,
-  naming_policy varchar(255) DEFAULT NULL,
-  ecomp_generated_naming char(1) DEFAULT NULL,
-  avail_zone_max_count int(11) DEFAULT NULL,
-  nf_function varchar(255) DEFAULT NULL,
-  nf_code varchar(255) DEFAULT NULL,
-  nf_type varchar(255) DEFAULT NULL,
-  nf_role varchar(255) DEFAULT NULL,
-  vendor varchar(255) DEFAULT NULL,
-  vendor_version varchar(255) DEFAULT NULL,
-  sdnc_model_name varchar(255) DEFAULT NULL,
-  sdnc_model_version varchar(255) DEFAULT NULL,
-  sdnc_artifact_name varchar(255) DEFAULT NULL,
-  PRIMARY KEY (customization_uuid)
-);
-
---
--- Table structure for table VF_MODULE_MODEL
---
-
-CREATE TABLE VF_MODULE_MODEL (
-  customization_uuid varchar(255) NOT NULL,
-  model_yaml longblob,
-  invariant_uuid varchar(255) DEFAULT NULL,
-  uuid varchar(255) DEFAULT NULL,
-  version varchar(255) DEFAULT NULL,
-  vf_module_type varchar(255) DEFAULT NULL,
-  availability_zone_count int(11) DEFAULT NULL,
-  ecomp_generated_vm_assignments char(1) DEFAULT NULL,
-  vf_customization_uuid varchar(255) DEFAULT NULL,
-  vf_module_label varchar(255) DEFAULT NULL,
-  PRIMARY KEY (customization_uuid)
-) ;
-
---
--- Table structure for table VF_MODULE_TO_VFC_MAPPING
---
-
-CREATE TABLE VF_MODULE_TO_VFC_MAPPING (
-  seq int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  vf_module_customization_uuid varchar(255) NOT NULL,
-  vfc_customization_uuid varchar(255) NOT NULL,
-  vm_type varchar(255) NOT NULL,
-  vm_count int(11) NOT NULL,
-  PRIMARY KEY (seq),
-);
-
---
--- Table structure for table VF_TO_NETWORK_ROLE_MAPPING
---
-
-CREATE TABLE  VF_TO_NETWORK_ROLE_MAPPING (
-  seq int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  vf_customization_uuid varchar(255) NOT NULL,
-  network_role varchar(255) NOT NULL,
-  PRIMARY KEY (seq)
-) ;
-
---
--- Table structure for table VIPR_CONFIGURATION
---
-
-CREATE TABLE  VIPR_CONFIGURATION (
-  seq int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  serial_number varchar(255) DEFAULT NULL,
-  vnf_id varchar(255) DEFAULT NULL,
-  vnf_name varchar(255) DEFAULT NULL,
-  ecomp_service_instance_id varchar(255) DEFAULT NULL,
-  vm_name varchar(255) DEFAULT NULL,
-  cloud_region_id varchar(255) DEFAULT NULL,
-  cloud_owner varchar(255) DEFAULT NULL,
-  PRIMARY KEY (seq)
-) ;
-
---
--- Table structure for table VIPR_SZ_MANAGER_KEY
---
-
-CREATE TABLE  VIPR_SZ_MANAGER_KEY (
-  vipr_sz_manager_ip_addr varchar(40) NOT NULL,
-  vipr_sz_manager_state varchar(10) DEFAULT NULL,
-  vipr_sz_manager_api_key varchar(255) DEFAULT NULL,
-  PRIMARY KEY (vipr_sz_manager_ip_addr)
-) ;
-
---
--- Table structure for table VLAN_ID_POOL
---
-
-CREATE TABLE  VLAN_ID_POOL (
-  aic_site_id varchar(100) NOT NULL,
-  purpose varchar(40) NOT NULL,
-  status varchar(40) NOT NULL,
-  vlan_id int NOT NULL,
-  svc_instance_id varchar(80) DEFAULT NULL,
-  availability_zone varchar(100) DEFAULT NULL,
-  vplspe_name varchar(80) DEFAULT NULL,
-  PRIMARY KEY (vlan_id,aic_site_id,purpose)
-) ;
-
---
--- Table structure for table VLAN_L3INTERFACE_IPV4_ADDRESS
---
-
-CREATE TABLE  VLAN_L3INTERFACE_IPV4_ADDRESS (
-  vnf_id varchar(80) NOT NULL,
-  interface_name varchar(255) NOT NULL,
-  vlan_interface varchar(255) NOT NULL,
-  l3_interface_ipv4_address varchar(64) NOT NULL,
-  l3_interface_ipv4_prefix_length varchar(45) DEFAULT NULL,
-  vlan_id_inner varchar(45) DEFAULT NULL,
-  vlan_id_outer varchar(45) DEFAULT NULL,
-  is_floating varchar(1) DEFAULT NULL,
-  PRIMARY KEY (vnf_id,interface_name,vlan_interface,l3_interface_ipv4_address)
-) ;
-
---
--- Table structure for table VLAN_L3INTERFACE_IPV6_ADDRESS
---
-
-CREATE TABLE  VLAN_L3INTERFACE_IPV6_ADDRESS (
-  vnf_id varchar(80) NOT NULL,
-  interface_name varchar(255) NOT NULL,
-  vlan_interface varchar(255) NOT NULL,
-  l3_interface_ipv6_address varchar(64) NOT NULL,
-  l3_interface_ipv6_prefix_length varchar(45) DEFAULT NULL,
-  vlan_id_inner varchar(45) DEFAULT NULL,
-  vlan_id_outer varchar(45) DEFAULT NULL,
-  is_floating varchar(1) DEFAULT NULL,
-  PRIMARY KEY (vnf_id,interface_name,vlan_interface,l3_interface_ipv6_address)
-) ;
-
---
--- Table structure for table VLAN_PLAN_ID
---
-
-CREATE TABLE  VLAN_PLAN_ID (
-  plan_type varchar(40) NOT NULL,
-  purpose varchar(40) NOT NULL,
-  vlan_plan_id_count int NOT NULL,
-  PRIMARY KEY (vlan_plan_id_count,plan_type,purpose)
-) ;
-
---
--- Table structure for table VLAN_POOL
---
-
-CREATE TABLE  VLAN_POOL (
-  aic_site_id varchar(100) NOT NULL,
-  availability_zone varchar(100) NOT NULL,
-  vlan_plan_id varchar(100) NOT NULL,
-  plan_type varchar(40) NOT NULL,
-  purpose varchar(40) NOT NULL,
-  vlan_id int NOT NULL,
-  status varchar(40) NOT NULL,
-  reserved_id varchar(80) DEFAULT NULL,
-  PRIMARY KEY (aic_site_id,availability_zone,vlan_plan_id,plan_type,purpose,vlan_id)
-) ;
-
---
--- Table structure for table VLAN_RANGES
---
-
-CREATE TABLE  VLAN_RANGES (
-  vlan_plan_id varchar(100) NOT NULL,
-  plan_type varchar(40) NOT NULL,
-  purpose varchar(40) NOT NULL,
-  range_start int NOT NULL,
-  range_end int NOT NULL,
-  generated char(1) DEFAULT NULL,
-  PRIMARY KEY (vlan_plan_id,plan_type,purpose,range_start,range_end)
-) ;
-
---
--- Table structure for table VM_NAME_INDEX
---
-
-CREATE TABLE  VM_NAME_INDEX (
-  vm_name_prefix varchar(255) NOT NULL,
-  index_number int NOT NULL,
-  PRIMARY KEY (vm_name_prefix)
-) ;
-
---
--- Table structure for table VM_NETWORKS
---
-
-CREATE TABLE  VM_NETWORKS (
-  vnf_type varchar(200) NOT NULL,
-  vm_type varchar(45) NOT NULL,
-  network_role varchar(45) NOT NULL,
-  assign_ips smallint NOT NULL,
-  assign_macs smallint NOT NULL,
-  assign_floating_ip smallint NOT NULL,
-  ip_count int DEFAULT NULL,
-  PRIMARY KEY (vnf_type,vm_type,network_role)
-) ;
-
---
--- Table structure for table VM_PROFILE
---
-
-CREATE TABLE  VM_PROFILE (
-  vnf_type varchar(200) NOT NULL,
-  vm_type varchar(45) NOT NULL,
-  vm_count int NOT NULL,
-  PRIMARY KEY (vnf_type,vm_type)
-) ;
-
---
--- Table structure for table VNF
---
-
-CREATE TABLE  VNF (
-  vnf_id varchar(80) NOT NULL,
-  vnf_name varchar(80) NOT NULL,
-  vnf_type varchar(10) NOT NULL,
-  orchestration_status varchar(20) DEFAULT NULL,
-  heat_stack_id varchar(80) DEFAULT NULL,
-  mso_catalog_key varchar(80) DEFAULT NULL,
-  availability_zone varchar(80) DEFAULT NULL,
-  aic_site_id varchar(80) DEFAULT NULL,
-  oam_ipv4_address varchar(20) DEFAULT NULL,
-  vnf_name2 varchar(80) DEFAULT NULL,
-  vpe_id varchar(80) NOT NULL,
-  ipv4_loopback0_address varchar(80) DEFAULT NULL,
-  license_key varchar(256) DEFAULT NULL,
-  entitlement_resource_uuid varchar(256) DEFAULT NULL,
-  PRIMARY KEY (vnf_id)
-) ;
-
---
--- Table structure for table VNFC_DG_MAPPING
---
-
-CREATE TABLE  VNFC_DG_MAPPING (
-  vnfc_dg_mapping_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  action varchar(50) DEFAULT NULL,
-  api_version varchar(10) DEFAULT NULL,
-  vnf_type varchar(50) DEFAULT NULL,
-  vnfc_type varchar(50) DEFAULT NULL,
-  dg_name varchar(50) NOT NULL,
-  dg_version varchar(50) DEFAULT NULL,
-  dg_module varchar(50) NOT NULL,
-  PRIMARY KEY (vnfc_dg_mapping_id)
-) ;
-
---
--- Table structure for table VNFC_REFERENCE
---
-
-CREATE TABLE  VNFC_REFERENCE (
-  vnfc_reference_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  action varchar(50) NOT NULL,
-  vnf_type varchar(50) NOT NULL,
-  vm_instance int NOT NULL,
-  vnfc_instance int NOT NULL,
-  vnfc_type varchar(50) NOT NULL,
-  vnfc_function_code varchar(50) NOT NULL,
-  ipaddress_v4_oam_vip varchar(50) DEFAULT NULL,
-  group_notation_type varchar(50) DEFAULT NULL,
-  group_notation_value varchar(50) DEFAULT NULL,
-  PRIMARY KEY (vnfc_reference_id)
-) ;
-
---
--- Table structure for table VNF_IMAGE
---
-
-CREATE TABLE  VNF_IMAGE (
-  application_vendor varchar(255) NOT NULL,
-  application_version varchar(255) NOT NULL,
-  att_uuid varchar(255) NOT NULL,
-  application varchar(255) DEFAULT NULL,
-  selflink varchar(255) DEFAULT NULL,
-  PRIMARY KEY (application_vendor,application_version,att_uuid)
-) ;
-
---
--- Table structure for table VNF_MODEL_LICENSES
---
-
-CREATE TABLE  VNF_MODEL_LICENSES (
-  att_part_number varchar(255) NOT NULL,
-  license_assignment_group varchar(255) NOT NULL,
-  license_required smallint DEFAULT NULL,
-  entitlement_assignment_group varchar(255) DEFAULT NULL,
-  entitlement_required smallint DEFAULT 0,
-  feature_group_uuid varchar(255) DEFAULT NULL,
-  PRIMARY KEY (att_part_number,license_assignment_group)
-) ;
-
---
--- Table structure for table VNF_MODEL_LICENSE_FEATURES
---
-
-CREATE TABLE  VNF_MODEL_LICENSE_FEATURES (
-  att_part_number varchar(255) NOT NULL,
-  license_assignment_group varchar(255) NOT NULL,
-  feature varchar(255) NOT NULL,
-  PRIMARY KEY (att_part_number,license_assignment_group,feature)
-) ;
-
---
--- Table structure for table VNF_NAME_INDEX
---
-
-CREATE TABLE  VNF_NAME_INDEX (
-  vnf_name_prefix varchar(255) NOT NULL,
-  index_number int NOT NULL,
-  PRIMARY KEY (vnf_name_prefix)
-) ;
-
---
--- Table structure for table VNF_NETWORKS
---
-
-CREATE TABLE  VNF_NETWORKS (
-  vnf_type varchar(200) NOT NULL,
-  network_role varchar(45) NOT NULL,
-  PRIMARY KEY (vnf_type,network_role)
-) ;
-
---
--- Table structure for table VNF_NETWORK_CONNECTION
---
-
-CREATE TABLE  VNF_NETWORK_CONNECTION (
-  connection_uuid varchar(80) NOT NULL,
-  vnf_id varchar(80) NOT NULL,
-  connection_id varchar(80) DEFAULT NULL,
-  connection_type varchar(20) DEFAULT NULL,
-  neutron_network_id varchar(80) DEFAULT NULL,
-  neutron_network_name varchar(80) DEFAULT NULL,
-  orchestration_status varchar(20) DEFAULT NULL,
-  switch_id varchar(40) DEFAULT NULL,
-  heat_stack_id varchar(80) DEFAULT NULL,
-  mso_catalog_key varchar(80) DEFAULT NULL,
-  provider_network varchar(80) DEFAULT NULL,
-  port_group_id varchar(80) DEFAULT NULL,
-  port_group_name varchar(80) DEFAULT NULL,
-  PRIMARY KEY (connection_uuid)
-) ;
-
---
--- Table structure for table VNF_NETWORK_CONNECTION_VLAN
---
-
-CREATE TABLE  VNF_NETWORK_CONNECTION_VLAN (
-  vlan_uuid varchar(80) NOT NULL,
-  vlan_id int NOT NULL,
-  vlan_type varchar(5) NOT NULL,
-  connection_uuid varchar(80) DEFAULT NULL,
-  PRIMARY KEY (vlan_uuid)
-) ;
-
---
--- Table structure for table VNF_PROFILE
---
-
-CREATE TABLE  VNF_PROFILE (
-  vnf_type varchar(200) NOT NULL,
-  availability_zone_count int NOT NULL,
-  equipment_role varchar(80) NOT NULL,
-  PRIMARY KEY (vnf_type)
-) ;
-
---
--- Table structure for table VNF_SERVICE_TO_NETWORK_ROLE_FILTER
---
-
-CREATE TABLE  VNF_SERVICE_TO_NETWORK_ROLE_FILTER (
-  vnf_service_type varchar(60) NOT NULL,
-  network_role_filter varchar(60) NOT NULL,
-  PRIMARY KEY (vnf_service_type,network_role_filter)
-) ;
-
---
--- Table structure for table VPE_LOCK
---
-
-CREATE TABLE  VPE_LOCK (
-  vpe_name varchar(20) NOT NULL,
-  vpn_lock varchar(20) NOT NULL,
-  PRIMARY KEY (vpe_name)
-) ;
-
---
--- Table structure for table VPE_MAC_ADDRESS_POOL
---
-
-CREATE TABLE  VPE_MAC_ADDRESS_POOL (
-  id int NOT NULL,
-  mac_address varchar(50) NOT NULL,
-  sw_name varchar(30) NOT NULL,
-  PRIMARY KEY (id)
-) ;
-
---
--- Table structure for table VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING
---
-
-CREATE TABLE  VPE_MAC_ADDRESS_TO_HOSTNAME_MAPPING (
-  id int NOT NULL,
-  hostname varchar(50) NOT NULL,
-  assigned_user varchar(25) NOT NULL,
-  assigned_date date DEFAULT NULL,
-  PRIMARY KEY (id)
-) ;
-
---
--- Table structure for table VPE_POOL
---
-
-CREATE TABLE  VPE_POOL (
-  vpe_name varchar(20) NOT NULL,
-  ipv4_oam_address varchar(20) NOT NULL,
-  loopback0_ipv4_address varchar(20) NOT NULL,
-  provisioning_status varchar(10) NOT NULL,
-  aic_site_id varchar(100) NOT NULL,
-  availability_zone varchar(100) NOT NULL,
-  vlan_id_outer varchar(20) NOT NULL,
-  vendor varchar(20) NOT NULL,
-  physical_intf_name varchar(40) NOT NULL,
-  physical_intf_speed varchar(20) NOT NULL,
-  physical_intf_units varchar(20) NOT NULL,
-  vpe_uuid varchar(80) DEFAULT NULL,
-  vpe_id varchar(80) NOT NULL,
-  image_filename varchar(100) DEFAULT NULL,
-  as_number varchar(20) NOT NULL,
-  loopback5000 varchar(16) DEFAULT NULL,
-  loopback10 varchar(16) DEFAULT NULL,
-  aic_version varchar(50) DEFAULT NULL,
-  vpe_capacity int NOT NULL,
-  PRIMARY KEY (aic_site_id,vpe_name,availability_zone)
-) ;
-
---
--- Table structure for table VPLSPE_POOL
---
-
-CREATE TABLE  VPLSPE_POOL (
-  vplspe_name varchar(20) NOT NULL,
-  aic_site_id varchar(100) NOT NULL,
-  availability_zone varchar(100) NOT NULL,
-  physical_intf_name varchar(40) NOT NULL,
-  physical_intf_speed varchar(20) NOT NULL,
-  physical_intf_units varchar(20) NOT NULL,
-  loopback0_ipv4_address varchar(20) NOT NULL,
-  vlan_id_outer varchar(20) NOT NULL,
-  vplspe_uuid varchar(80) DEFAULT NULL,
-  image_filename varchar(100) DEFAULT NULL,
-  provisioning_status varchar(10) DEFAULT NULL,
-  vendor varchar(20) DEFAULT NULL,
-  PRIMARY KEY (vplspe_name,aic_site_id,availability_zone,physical_intf_name)
-) ;
-
---
--- Table structure for table VPN_BINDINGS
---
-
-CREATE TABLE  VPN_BINDINGS (
-  network_customization_uuid varchar(255) NOT NULL,
-  binding_uuid varchar(255) NOT NULL,
-  PRIMARY KEY (network_customization_uuid,binding_uuid)
-) ;
-
---
--- Table structure for table VRR_FUNCTION_CODE_VMTYPE_MAPPING
---
-
-CREATE TABLE  VRR_FUNCTION_CODE_VMTYPE_MAPPING (
-  ptnii_function_code varchar(128) NOT NULL,
-  vm_type varchar(128) NOT NULL,
-  PRIMARY KEY (ptnii_function_code,vm_type)
-) ;
-
---
--- Table structure for table VSERVER
---
-
-CREATE TABLE  VSERVER (
-  tenant_id varchar(40) NOT NULL,
-  vserver_id varchar(40) NOT NULL,
-  aic_site_id varchar(100) NOT NULL,
-  vendor varchar(20) NOT NULL,
-  image_name varchar(100) NOT NULL,
-  vnf_type varchar(10) NOT NULL,
-  vnf_id varchar(80) NOT NULL,
-  PRIMARY KEY (tenant_id,vserver_id)
-) ;
-
---
--- Table structure for table VSERVER2
---
-
-CREATE TABLE  VSERVER2 (
-  tenant_id varchar(255) NOT NULL,
-  vserver_id varchar(128) NOT NULL,
-  vserver_name varchar(255) NOT NULL,
-  vserver_name2 varchar(255) DEFAULT NULL,
-  prov_status varchar(20) DEFAULT NULL,
-  selflink varchar(255) DEFAULT NULL,
-  PRIMARY KEY (tenant_id,vserver_id)
-) ;
-
---
--- Table structure for table VSERVER_PSERVER
---
-
-CREATE TABLE  VSERVER_PSERVER (
-  vserver_id varchar(128) NOT NULL,
-  pserver_hostname varchar(255) DEFAULT NULL,
-  PRIMARY KEY (vserver_id)
-) ;
-
---
--- Table structure for table VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING
---
-
-CREATE TABLE  VVIG_VM_INSTANCE_TO_CLOUD_REGION_MAPPING (
-  key_id varchar(128) NOT NULL,
-  cloud_region varchar(128) NOT NULL,
-  key_type varchar(128) NOT NULL,
-  PRIMARY KEY (key_id,cloud_region,key_type)
-) ;
-
---
--- Table structure for table WAN_COMBO_ALLOWABLE
---
-
-CREATE TABLE  WAN_COMBO_ALLOWABLE (
-  combo_sequence int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  topology varchar(16) DEFAULT 'unknown',
-  internet_topology varchar(20) DEFAULT NULL,
-  wan1 varchar(40) DEFAULT NULL,
-  wan2 varchar(40) DEFAULT NULL,
-  new_start_release_flexware varchar(16) DEFAULT 'unknown',
-  is_active_flexware varchar(1) DEFAULT 'N',
-  new_start_release_dhv varchar(16) DEFAULT 'unknown',
-  is_active_dhv varchar(1) DEFAULT 'N',
-  ucpe_type varchar(32) DEFAULT 'stand-alone',
-  description varchar(128) NOT NULL,
-  PRIMARY KEY (combo_sequence)
-) ;
-
-CREATE TABLE  DHCP_MAP (
-  mac_addr varchar(128) NOT NULL,
-  ip_addr varchar(128) DEFAULT NULL,
-  PRIMARY KEY (mac_addr)
-) ;
-
-CREATE TABLE  RESOURCE_GROUP_TO_TARGET_NODE_MAPPING (
-  group_uuid varchar(255) NOT NULL,
-  parent_uuid varchar(255) NOT NULL,
-  target_node_uuid varchar(255) NOT NULL,
-  target_type varchar(255) ,
-  table_name varchar(255) ,
-  PRIMARY KEY (group_uuid, parent_uuid, target_node_uuid)
-) ;
-
-
-
-CREATE TABLE  ATTRIBUTE_VALUE_PAIR (
-  resource_uuid varchar(255) NOT NULL,
-  attribute_name varchar(255) NOT NULL,
-  resource_type varchar(255) NOT NULL,
-  attribute_value varchar(255) DEFAULT NULL,
-  resource_customization_uuid varchar(255) DEFAULT NULL,
-  PRIMARY KEY (resource_uuid,attribute_name,resource_type)
-) ;
-
-CREATE TABLE  COMPLEX_RESOURCE (
-  uuid varchar(255) NOT NULL,
-  model_yaml blob,
-  invariant_uuid varchar(255) NOT NULL,
-  customization_uuid varchar(255) NOT NULL,
-  version varchar(255) DEFAULT NULL,
-  name varchar(255) DEFAULT NULL,
-  description varchar(255) DEFAULT NULL,
-  type varchar(255) NOT NULL,
-  PRIMARY KEY (uuid,customization_uuid)
-) ;
-
-CREATE TABLE  NODE_CAPABILITY (
-  capability_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  capability_provider_uuid varchar(255) NOT NULL,
-  capability_provider_customization_uuid varchar(255) NOT NULL,
-  capability_name varchar(255) DEFAULT NULL,
-  capability_type varchar(255) DEFAULT NULL,
-  PRIMARY KEY (capability_id)
-) ;
-
-CREATE TABLE  NODE_REQUIREMENT (
-  requirement_id int NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT BY 1),
-  capability_id int DEFAULT NULL,
-  capability_provider_uuid varchar(255) DEFAULT NULL,
-  capability_provider_customization_uuid varchar(255) DEFAULT NULL,
-  capability_consumer_uuid varchar(255) NOT NULL,
-  capability_consumer_customization_uuid varchar(255) NOT NULL,
-  requirement_name varchar(255) NOT NULL,
-  PRIMARY KEY (requirement_id)
-) ;
-
-CREATE TABLE  RELATED_NETWORK_ROLE (
-  network_model_customization_uuid varchar(255) NOT NULL,
-  related_network_role varchar(255) NOT NULL,
-  PRIMARY KEY (network_model_customization_uuid,related_network_role)
-) ;
-
-CREATE TABLE  RESOURCE_GROUP (
-  resource_uuid varchar(255) NOT NULL,
-  group_uuid varchar(255) NOT NULL,
-  group_customization_uuid varchar(255) DEFAULT NULL,
-  group_invariant_uuid varchar(255) NOT NULL,
-  group_name varchar(255) DEFAULT NULL,
-  version varchar(255) DEFAULT NULL,
-  group_type varchar(255) DEFAULT NULL,
-  PRIMARY KEY (resource_uuid,group_uuid)
-) ;
-
-CREATE TABLE  RESOURCE_POLICY (
-  resource_uuid varchar(255) NOT NULL,
-  policy_uuid varchar(255) NOT NULL,
-  policy_customization_uuid varchar(255) DEFAULT NULL,
-  policy_invariant_uuid varchar(255) NOT NULL,
-  policy_name varchar(255) DEFAULT NULL,
-  version varchar(255) DEFAULT NULL,
-  policy_type varchar(255) DEFAULT NULL,
-  property_type varchar(255) DEFAULT NULL,
-  property_source varchar(255) DEFAULT NULL,
-  property_name varchar(255) DEFAULT NULL,
-  PRIMARY KEY (resource_uuid,policy_uuid)
-) ;
-
-CREATE TABLE  RESOURCE_POLICY_TO_TARGET_NODE_MAPPING (
-  policy_uuid varchar(255) NOT NULL,
-  parent_uuid varchar(255) NOT NULL,
-  target_node_uuid varchar(255) NOT NULL,
-  target_type varchar(255) DEFAULT NULL,
-  target_node_customization_uuid varchar(255) DEFAULT NULL,
-  policy_customization_uuid varchar(255) DEFAULT NULL,
-  PRIMARY KEY (policy_uuid,parent_uuid,target_node_uuid)
-) ;
-
-
-CREATE TABLE  SERVICE_MODEL_TO_COMPLEX_RESOURCE_MAPPING (
-  service_uuid varchar(255) NOT NULL,
-  complex_resource_uuid varchar(255) NOT NULL,
-  complex_resource_customization_uuid varchar(255) NOT NULL,
-  PRIMARY KEY (service_uuid,complex_resource_uuid,complex_resource_customization_uuid)
-) ;
-
-CREATE TABLE  VFC_RELATED_NETWORK_ROLE (
-  vfc_customization_uuid varchar(255) NOT NULL,
-  vm_type varchar(255) NOT NULL,
-  network_role varchar(255) NOT NULL,
-  related_network_role varchar(255) NOT NULL,
-  PRIMARY KEY (vfc_customization_uuid,vm_type,network_role,related_network_role)
-) ;
-
-CREATE TABLE  VNF_RELATED_NETWORK_ROLE (
-  vnf_customization_uuid varchar(255) NOT NULL,
-  network_role varchar(255) NOT NULL,
-  related_network_role varchar(255) NOT NULL,
-  PRIMARY KEY (vnf_customization_uuid,network_role,related_network_role)
-) ;
-
-CREATE TABLE CONFIG_GRA_SERVICES (
-  svcInstanceId varchar(255) not null,
-  serviceStatusAction varchar(255),
-  serviceStatusFinalIndicator varchar(255),
-  serviceStatusRequestStatus varchar(255),
-  serviceStatusResponseCode varchar(255),
-  serviceStatusResponseMessage varchar(255),
-  serviceStatusResponseTimestamp varchar(255),
-  serviceStatusRpcAction varchar(255),
-  serviceStatusRpcName varchar(255),
-  svcData clob, primary key (svcInstanceId)
-) ;
-
-CREATE TABLE OPERATIONAL_GRA_SERVICES (
-  svcInstanceId varchar(255) not null,
-  serviceStatusAction varchar(255),
-  serviceStatusFinalIndicator varchar(255),
-  serviceStatusRequestStatus varchar(255),
-  serviceStatusResponseCode varchar(255),
-  serviceStatusResponseMessage varchar(255),
-  serviceStatusResponseTimestamp varchar(255),
-  serviceStatusRpcAction varchar(255),
-  serviceStatusRpcName varchar(255),
-  svcData clob,
-  primary key (svcInstanceId)
-) ;
-
-CREATE TABLE CONFIG_GRA_PORT_MIRROR_CONFIGURATIONS (
-  configurationId varchar(255) not null,
-  portMirrorConfigurationStatusAction varchar(255),
-  portMirrorConfigurationStatusFinalIndicator varchar(255),
-  portMirrorConfigurationStatusRequestStatus varchar(255),
-  portMirrorConfigurationStatusResponseCode varchar(255),
-  portMirrorConfigurationStatusResponseMessage varchar(255),
-  portMirrorConfigurationStatusResponseTimestamp varchar(255),
-  portMirrorConfigurationStatusRpcAction varchar(255),
-  portMirrorConfigurationStatusRpcName varchar(255),
-  pmcData clob, primary key (configurationId)
-) ;
-
-CREATE TABLE OPERATIONAL_GRA_PORT_MIRROR_CONFIGURATIONS (
-  configurationId varchar(255) not null,
-  portMirrorConfigurationStatusAction varchar(255),
-  portMirrorConfigurationStatusFinalIndicator varchar(255),
-  portMirrorConfigurationStatusRequestStatus varchar(255),
-  portMirrorConfigurationStatusResponseCode varchar(255),
-  portMirrorConfigurationStatusResponseMessage varchar(255),
-  portMirrorConfigurationStatusResponseTimestamp varchar(255),
-  portMirrorConfigurationStatusRpcAction varchar(255),
-  portMirrorConfigurationStatusRpcName varchar(255),
-  pmcData clob,
-  primary key (configurationId)
-) ;
-
-CREATE TABLE CONFIG_GRA_CONTRAIL_ROUTE_ALLOTTED_RESOURCES (
-  allottedResourceId varchar(255) not null,
-  allottedResourceStatusAction varchar(255),
-  allottedResourceStatusFinalIndicator varchar(255),
-  allottedResourceStatusRequestStatus varchar(255),
-  allottedResourceStatusResponseCode varchar(255),
-  allottedResourceStatusResponseMessage varchar(255),
-  allottedResourceStatusResponseTimestamp varchar(255),
-  allottedResourceStatusRpcAction varchar(255),
-  allottedResourceStatusRpcName varchar(255),
-  arData clob, primary key (allottedResourceId)
-) ;
-
-CREATE TABLE OPERATIONAL_GRA_CONTRAIL_ROUTE_ALLOTTED_RESOURCES (
-  allottedResourceId varchar(255) not null,
-  allottedResourceStatusAction varchar(255),
-  allottedResourceStatusFinalIndicator varchar(255),
-  allottedResourceStatusRequestStatus varchar(255),
-  allottedResourceStatusResponseCode varchar(255),
-  allottedResourceStatusResponseMessage varchar(255),
-  allottedResourceStatusResponseTimestamp varchar(255),
-  allottedResourceStatusRpcAction varchar(255),
-  allottedResourceStatusRpcName varchar(255),
-  arData clob,
-  primary key (allottedResourceId)
-) ;