path: root/ms/generic-resource-api/src/main/resources/schema-derby.sql

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)
) ;