CREATE SCHEMA sdnctl; SET SCHEMA sdnctl; -- -- 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 clob, 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 clob, 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 DEFAULT NULL, max_instances int 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 NOT NULL, ipv6_count int 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 DEFAULT NULL, ipv6_floating_count int 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 clob, 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 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, PRIMARY KEY (customization_uuid) ) ; -- -- Table structure for table VF_MODULE_MODEL -- CREATE TABLE VF_MODULE_MODEL ( customization_uuid varchar(255) NOT NULL, model_yaml clob, 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 DEFAULT NULL, ecomp_generated_vm_assignments char(1) 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 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) ) ;