--------------------------------------------------------
--  DDL for Table SRC_CMDB_NEXT_ATP_LIST_TB
--------------------------------------------------------

CREATE TABLE "OTHQ_OWN"."SRC_CMDB_NEXT_ATP_LIST_TB" (
    "ID"                              VARCHAR2(256 BYTE) NOT NULL,
    "INSTANCE_TYPE"                   VARCHAR2(32 BYTE),
    "MOLECULE"                        VARCHAR2(36 BYTE),
    "PRODUCT"                         VARCHAR2(36 BYTE),
    "STATUS"                          VARCHAR2(36 BYTE),
    "LOGICAL_DATA_CENTER"             VARCHAR2(64 BYTE),
    "COMPARTMENT_ID"                  VARCHAR2(256 BYTE),
    "COMPARTMENT"                     VARCHAR2(128 BYTE),
    "REGION"                          VARCHAR2(36 BYTE),
    "TENANCY"                         VARCHAR2(64 BYTE),
    "AVAILABILITY_DOMAIN"             VARCHAR2(36 BYTE),
    "IP_ADDRESSES"                    VARCHAR2(256 BYTE),
    "OCPU_COUNT"                      NUMBER,
    "ECPU_COUNT"                      NUMBER,
    "NSX"                             NUMBER,
    "NSN"                             NUMBER,
    "ACCOUNT_COMP_ID"                 VARCHAR2(256 BYTE),
    "ACCOUNT_TYPE"                    VARCHAR2(128 BYTE),
    "COMP_ID"                         VARCHAR2(128 BYTE),
    "IP_ADDRESS"                      VARCHAR2(36 BYTE),
    "REGION_SHORT_NAME"               VARCHAR2(8 BYTE),
    "DELETED"                         DATE,
    "DELETED_BY_CASCADE"              NUMBER,
    "CREATED"                         DATE,
    "MODIFIED"                        DATE,
    "HOSTNAME"                        VARCHAR2(64 BYTE),
    "OCI_NAME"                        VARCHAR2(128 BYTE),
    "PROVISIONER"                     VARCHAR2(64 BYTE),
    "TIME_MAINTENANCE_REBOOT_DUE"     DATE,
    "IN_MONITORING"                   NUMBER,
    "BACKUP_BUCKET_NAME"              VARCHAR2(128 BYTE),
    "BACKUP_TYPE"                     VARCHAR2(36 BYTE),
    "PRIVATE_ENDPOINT"                VARCHAR2(256 BYTE),
    "CPU_CORE_COUNT"                  NUMBER,
    "DATA_STORAGE_SIZE"               NUMBER,
    "DATAGUARD_REGION_TYPE"           VARCHAR2(36 BYTE),
    "DB_NAME"                         VARCHAR2(64 BYTE),
    "DB_TYPE"                         VARCHAR2(32 BYTE),
    "VERSION"                         VARCHAR2(16 BYTE),
    "AUTO_SCALING_ENABLED"            NUMBER,
    "INSTANCE_NAME"                   VARCHAR2(128 BYTE),
    "EPOD"                            VARCHAR2(64 BYTE),
    "DATA_GUARD_ENABLED"              NUMBER,
    "DEDICATED"                       NUMBER,
    "TIME_MAINTENANCE_BEGIN"          DATE,
    "TIME_MAINTENANCE_END"            DATE,
    "ACTUAL_STORAGE"                  NUMBER,
    "ALLOCATED_STORAGE"               NUMBER,
    "COMPUTE_MODEL"                   VARCHAR2(32 BYTE),
    "IS_HIPAA"                        NUMBER,
    "DR_SOLUTION_NAME"                VARCHAR2(128 BYTE),
    "LOCAL_DR_TYPE"                   VARCHAR2(32 BYTE),
    "REMOTE_DR_TYPE"                  VARCHAR2(32 BYTE),
    "APP_LABEL"                       VARCHAR2(64 BYTE),
    "INSTANCE_SHAPE"                  VARCHAR2(32 BYTE),
    "INTERNAL_AVAILABILITY_DOMAIN"    VARCHAR2(32 BYTE),
    "CAPACITY_RESERVATION"            NUMBER

    CONSTRAINT "SRC_CMDB_NEXT_ATP_LIST_TB_PK" PRIMARY KEY ("ID")
  );

--------------------------------------------------------
--  DDL for Index SRC_CMDB_NEXT_ATP_LIST_TB_PK
--------------------------------------------------------
  CREATE UNIQUE INDEX "OTHQ_OWN"."SRC_CMDB_NEXT_ATP_LIST_TB_PK" ON "OTHQ_OWN"."SRC_CMDB_NEXT_ATP_LIST_TB" ("ID") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 
  TABLESPACE "DATA" ;