🏠 Menú principal

← Volver a tablas

---

DWADW.DIM_STATUSVALUE_OR_OTM

Base de datos origen: ADW COEXITO

Descripción: Español: Catálogo de valores de estado asociados a un tipo de estado. | English: Catalog of status values associated with a status type.

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	STATUSVALUE_OTM_ID	NUMBER	NO	“DWADW”.”ISEQ$$_220861”.nextval
2	STATUSVALUE_DESCRIPTION	VARCHAR2(960)	NO
3	AUDIT_ID	NUMBER	NO
4	ROW_ACTIVE	CHAR(1)	NO	‘A’
5	DIM_STATUSTYPE_OR_OTM_ID	NUMBER	NO

Restricciones

CHECK: DIM_STATUSVALUE_OTM_ROW_ACTIVE_CK

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

CHECK: SYS_C0044944

• Estado: ENABLED
• Columnas: STATUSVALUE_OTM_ID
• Condición: "STATUSVALUE_OTM_ID" IS NOT NULL

CHECK: SYS_C0044945

• Estado: ENABLED
• Columnas: STATUSVALUE_DESCRIPTION
• Condición: "STATUSVALUE_DESCRIPTION" IS NOT NULL

CHECK: SYS_C0085810

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

CHECK: SYS_C0085878

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

CHECK: SYS_C0087897

• Estado: ENABLED
• Columnas: DIM_STATUSTYPE_OR_OTM_ID
• Condición: "DIM_STATUSTYPE_OR_OTM_ID" IS NOT NULL

PK: DIM_STATUSVALUE_OTM_PK

• Estado: ENABLED
• Columnas: STATUSVALUE_OTM_ID

FK: DIM_STATUSVALUE_OR_OTM_DIM_STATUSTYPE_OR_OTM_FK

• Estado: ENABLED
• Columnas: DIM_STATUSTYPE_OR_OTM_ID
• Referencia: DWADW.DIM_STATUSTYPE_OR_OTM (constraint DIM_STATUSTYPE_PK)

UK: DIM_STATUSVALUE_OR_OTM_UN

• Estado: ENABLED
• Columnas: STATUSVALUE_DESCRIPTION, DIM_STATUSTYPE_OR_OTM_ID

UK: DIM_STATUSVALUE_OTM_UN

• Estado: ENABLED
• Columnas: STATUSVALUE_DESCRIPTION

DDL

CREATE TABLE "DWADW"."DIM_STATUSVALUE_OR_OTM" 
   (	"STATUSVALUE_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, 
	"STATUSVALUE_DESCRIPTION" VARCHAR2(960) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	"DIM_STATUSTYPE_OR_OTM_ID" NUMBER NOT NULL ENABLE, 
	 CONSTRAINT "DIM_STATUSVALUE_OTM_PK" PRIMARY KEY ("STATUSVALUE_OTM_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_STATUSVALUE_OTM_UN" UNIQUE ("STATUSVALUE_DESCRIPTION")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_STATUSVALUE_OTM_ROW_ACTIVE_CK" CHECK (ROW_ACTIVE IN ('A','I')) ENABLE, 
	 CONSTRAINT "DIM_STATUSVALUE_OR_OTM_UN" UNIQUE ("STATUSVALUE_DESCRIPTION", "DIM_STATUSTYPE_OR_OTM_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_STATUSVALUE_OR_OTM_DIM_STATUSTYPE_OR_OTM_FK" FOREIGN KEY ("DIM_STATUSTYPE_OR_OTM_ID")
	  REFERENCES "DWADW"."DIM_STATUSTYPE_OR_OTM" ("STATUSTYPE_OTM_ID") ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."DIM_STATUSVALUE_OR_OTM"  IS 'Español: Catálogo de valores de estado asociados a un tipo de estado. | English: Catalog of status values associated with a status type.';

CREATE UNIQUE INDEX "DWADW"."DIM_STATUSVALUE_OTM_PK" ON "DWADW"."DIM_STATUSVALUE_OR_OTM" ("STATUSVALUE_OTM_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."DIM_STATUSVALUE_OTM_UN" ON "DWADW"."DIM_STATUSVALUE_OR_OTM" ("STATUSVALUE_DESCRIPTION") 
  ;
  CREATE UNIQUE INDEX "DWADW"."DIM_STATUSVALUE_OR_OTM_UN" ON "DWADW"."DIM_STATUSVALUE_OR_OTM" ("STATUSVALUE_DESCRIPTION", "DIM_STATUSTYPE_OR_OTM_ID") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal