DWADW.DIM_STATUSTYPE_SHIP_OTM

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo	Default
1	STATUSTYPE_OTM_ID	NUMBER	NO	“DWADW”.”ISEQ$$_251519”.nextval
2	STATUSTYPE_DESCRIPTION	VARCHAR2(960)	NO
3	ROW_ACTIVE	CHAR(1)	NO	‘A’
4	AUDIT_ID	NUMBER	NO

Restricciones

CHECK: DIM_STATUSTYPE_SHIP_OTM_AI_CK

Estado: ENABLED
Columnas: ROW_ACTIVE
Condición: row_active IN ('A','I')

CHECK: SYS_C0090537

Estado: ENABLED
Columnas: STATUSTYPE_OTM_ID
Condición: "STATUSTYPE_OTM_ID" IS NOT NULL

CHECK: SYS_C0090538

Estado: ENABLED
Columnas: STATUSTYPE_DESCRIPTION
Condición: "STATUSTYPE_DESCRIPTION" IS NOT NULL

CHECK: SYS_C0090539

Estado: ENABLED
Columnas: ROW_ACTIVE
Condición: "ROW_ACTIVE" IS NOT NULL

CHECK: SYS_C0090540

Estado: ENABLED
Columnas: AUDIT_ID
Condición: "AUDIT_ID" IS NOT NULL

PK: DIM_STATUSTYPE_SHIP_PK

Estado: ENABLED
Columnas: STATUSTYPE_OTM_ID

UK: DIM_STATUSTYPE_SHIP_UN

Estado: ENABLED
Columnas: STATUSTYPE_DESCRIPTION

DDL

CREATE TABLE "DWADW"."DIM_STATUSTYPE_SHIP_OTM" 
   (	"STATUSTYPE_OTM_ID" NUMBER GENERATED BY DEFAULT AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE, 
	"STATUSTYPE_DESCRIPTION" VARCHAR2(960) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	 CONSTRAINT "DIM_STATUSTYPE_SHIP_OTM_AI_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "DIM_STATUSTYPE_SHIP_PK" PRIMARY KEY ("STATUSTYPE_OTM_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_STATUSTYPE_SHIP_UN" UNIQUE ("STATUSTYPE_DESCRIPTION")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

CREATE UNIQUE INDEX "DWADW"."DIM_STATUSTYPE_SHIP_UN" ON "DWADW"."DIM_STATUSTYPE_SHIP_OTM" ("STATUSTYPE_DESCRIPTION") 
  ;
  CREATE UNIQUE INDEX "DWADW"."DIM_STATUSTYPE_SHIP_PK" ON "DWADW"."DIM_STATUSTYPE_SHIP_OTM" ("STATUSTYPE_OTM_ID") 
  ;

← Volver a tablas de DWADW

🏠 Volver al menú principal