--------------------------------------------------------
--  DDL for Table SRC_CMDB_NEXT_EXA_PDB_TB
--------------------------------------------------------

CREATE TABLE "OTHQ_OWN"."SRC_CMDB_NEXT_EXA_PDB_TB" (
    "ID"                        VARCHAR2(32 BYTE) NOT NULL,
    "NAME"                      VARCHAR2(32 BYTE),
    "THIN_NAME"                 VARCHAR2(128 BYTE),
    "DB_TYPE"                   VARCHAR2(32 BYTE),
    "VERSION"                   VARCHAR2(16 BYTE),
    "EXACS_SIZE_NUM"            NUMBER,
    "DATABASE_MODE"             VARCHAR2(32 BYTE),
    "N_KEY"                     VARCHAR2(16 BYTE),
    "ACCOUNT_TYPE"              VARCHAR2(32 BYTE),
    "ACCOUNT_COMP_ID"           VARCHAR2(16 BYTE),
    "ONLINE_SIGNUP"             VARCHAR2(8 BYTE),
    "RESOURCE_USER"             VARCHAR2(32 BYTE),
    "TIME_MAINTENANCE_REBOOT_DUE" DATE,
    "CREATED"                   DATE,
    "MODIFIED"                  DATE,
    "DESCRIPTION"               VARCHAR2(64 BYTE),
    "CLUSTER_NAME"              VARCHAR2(128 BYTE),
    "CLUSTER_ID"                VARCHAR2(256 BYTE),
    "DR_SOLUTION"               VARCHAR2(64 BYTE),
    "DB_NODE_HOSTNAME"          VARCHAR2(128 BYTE),
    "DB_NODE_ID"                VARCHAR2(256 BYTE),
    "CDB_SCAN_NAME"             VARCHAR2(128 BYTE),
    "CDB_INSTANCE"              VARCHAR2(32 BYTE),
    "CDB_VERSION"               VARCHAR2(16 BYTE),
    "CDB_ID"                    NUMBER,
    "CDB_PDB_CAPACITY_GIB"      VARCHAR2(8 BYTE),
    "CDB_OPERATING_STATUS"      VARCHAR2(16 BYTE),
    "DATA_GUARD_INFO"           VARCHAR2(128 BYTE)

    CONSTRAINT "SRC_CMDB_NEXT_EXA_PDB_TB_PK" PRIMARY KEY ("ID")
  );
  
--------------------------------------------------------
--  DDL for Index SRC_CMDB_NEXT_EXA_PDB_TB_PK
--------------------------------------------------------
  CREATE UNIQUE INDEX "OTHQ_OWN"."SRC_CMDB_NEXT_EXA_PDB_TB_PK" ON "OTHQ_OWN"."SRC_CMDB_NEXT_EXA_PDB_TB" ("ID") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 
  TABLESPACE "DATA" ;