DWADW.FACT_ORDERRELEASE_OTM

Base de datos origen: ADW COEXITO

Descripción: Español: Tabla de hechos de order releases con métricas de demanda y enlaces a dimensiones principales. | English: Fact table of order releases with demand metrics linked to core dimensions.

Columnas

#	Columna	Tipo	Nulo	Default
1	ORDERRELEASE_OTM_ID	NUMBER	NO	“DWADW”.”ISEQ$$_220885”.nextval
2	ORDER_RELEASE_GID	VARCHAR2(404)	NO
3	ORDER_RELEASE_XID	VARCHAR2(200)	NO
4	ORDER_RELEASE_NAME	VARCHAR2(480)	SI
5	ORDER_RELEASE_TYPE_GID	VARCHAR2(404)	SI
6	ASSIGNED_ITINERARY_GID	VARCHAR2(404)	SI
7	SOURCE_LOCATION_GID	VARCHAR2(404)	SI
8	DEST_LOCATION_GID	VARCHAR2(404)	SI
9	EARLY_PICKUP_DATE	DATE	SI
10	TOTAL_ITEM_PACKAGE_COUNT	NUMBER	SI
11	INDICATOR	VARCHAR2(4)	SI
12	TOTAL_NET_WEIGHT	NUMBER	SI
13	TOTAL_NET_WEIGHT_UOM_CODE	VARCHAR2(256)	SI
14	TOTAL_NET_WEIGHT_BASE	NUMBER	SI
15	TOTAL_NET_VOLUME	NUMBER	SI
16	TOTAL_NET_VOLUME_UOM_CODE	VARCHAR2(256)	SI
17	TOTAL_NET_VOLUME_BASE	NUMBER	SI
18	PICKUP_IS_APPT	VARCHAR2(4)	NO
19	DELIVERY_IS_APPT	VARCHAR2(4)	NO
20	IS_KNOWN_SHIPPER	VARCHAR2(4)	NO
21	RELEASE_METHOD_GID	VARCHAR2(404)	SI
22	LOC_AMOUNT	NUMBER	NO
23	LOC_AMOUNT_CURRENCY_GID	VARCHAR2(404)	NO
24	LOC_AMOUNT_BASE	NUMBER	NO
25	SECONDARY_T_WEIGHT	NUMBER	SI
26	SECONDARY_T_WEIGHT_UOM_CODE	VARCHAR2(256)	SI
27	SECONDARY_T_WEIGHT_BASE	NUMBER	SI
28	SECONDARY_T_VOLUME	NUMBER	SI
29	SECONDARY_T_VOLUME_UOM_CODE	VARCHAR2(256)	SI
30	SECONDARY_T_VOLUME_BASE	NUMBER	SI
31	MUST_SHIP_DIRECT	VARCHAR2(4)	NO
32	MUST_SHIP_THRU_X_DOCK	VARCHAR2(4)	NO
33	MUST_SHIP_THRU_POOL	VARCHAR2(4)	NO
34	IMPORT_LICENSE_REQUIRED	VARCHAR2(200)	SI
35	IS_LOC_REQUIRED	VARCHAR2(4)	NO
36	INSPECTION_REQUIRED	VARCHAR2(200)	SI
37	CUSTOMER_UNITIZATION_REQUEST	VARCHAR2(4)	NO
38	IS_LOC_STALE	VARCHAR2(4)	NO
39	BUNDLING_TYPE	VARCHAR2(200)	NO
40	IS_CONSOLIDATE_OR_EQUIPMENT	VARCHAR2(4)	NO
41	DUTY_PAID	VARCHAR2(32)	NO
42	TOTAL_DECLARED_VALUE	NUMBER	SI
43	TOTAL_DECLARED_VALUE_GID	VARCHAR2(404)	SI
44	TOTAL_DECLARED_VALUE_BASE	NUMBER	SI
45	BULK_PLAN_GID	VARCHAR2(404)	SI
46	TOTAL_SHIP_UNIT_COUNT	NUMBER	SI
47	TOTAL_WEIGHT	NUMBER	SI
48	TOTAL_WEIGHT_UOM_CODE	VARCHAR2(256)	SI
49	TOTAL_WEIGHT_BASE	NUMBER	SI
50	TOTAL_VOLUME	NUMBER	SI
51	TOTAL_VOLUME_UOM_CODE	VARCHAR2(256)	SI
52	ON_RT_EXECUTION	VARCHAR2(4)	NO
53	IS_SPLITTABLE	VARCHAR2(4)	SI
54	OTM_VERSION	VARCHAR2(60)	SI
55	TOTAL_VOLUME_BASE	NUMBER	SI
56	MARKED_FOR_PURGE	VARCHAR2(4)	NO
57	IS_PRE_ENTERED_PU	VARCHAR2(4)	NO
58	IS_TOPOFF	VARCHAR2(4)	NO
59	SHIP_UNIT_WIDTH	NUMBER	SI
60	SHIP_UNIT_WIDTH_UOM_CODE	VARCHAR2(256)	SI
61	SHIP_UNIT_WIDTH_BASE	NUMBER	SI
62	SHIP_UNIT_LENGTH	NUMBER	SI
63	SHIP_UNIT_LENGTH_UOM_CODE	VARCHAR2(256)	SI
64	SHIP_UNIT_LENGTH_BASE	NUMBER	SI
65	SHIP_UNIT_HEIGHT	NUMBER	SI
66	SHIP_UNIT_HEIGHT_UOM_CODE	VARCHAR2(256)	SI
67	SHIP_UNIT_HEIGHT_BASE	NUMBER	SI
68	PRIORITY	NUMBER	NO
69	IS_TEMPLATE	VARCHAR2(4)	NO
70	DOMAIN_NAME	VARCHAR2(200)	NO
71	SOURCE_LOCATION_ADDRESS_OTM_ID	NUMBER	SI
72	DEST_LOCATION_ADDRESS_OTM_ID	NUMBER	SI
73	DIM_ORDERRELEASETYPE_OTM_ID	NUMBER	SI
74	INSERT_USER	VARCHAR2(512)	NO
75	INSERT_DATE	DATE	NO
76	UPDATE_USER	VARCHAR2(512)	SI
77	UPDATE_DATE	DATE	SI
78	DIM_BULKPLAN_OTM_ID	NUMBER	SI
79	DIM_ITINERARY_OTM_ID	NUMBER	SI
80	DIM_TIME_OTM_ID	NUMBER	SI
81	AUDIT_ID	NUMBER	NO
82	ROW_ACTIVE	CHAR(1)	NO	‘A’

Restricciones

CHECK: FACT_ORDERRELEASE_OTM_ROW_ACTIVE_CK

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

CHECK: SYS_C0045016

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

CHECK: SYS_C0045017

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

CHECK: SYS_C0045018

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

CHECK: SYS_C0045019

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

CHECK: SYS_C0045020

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

CHECK: SYS_C0045021

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

CHECK: SYS_C0045022

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

CHECK: SYS_C0045023

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

CHECK: SYS_C0045024

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

CHECK: SYS_C0045025

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

CHECK: SYS_C0045026

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

CHECK: SYS_C0045027

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

CHECK: SYS_C0045028

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

CHECK: SYS_C0045029

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

CHECK: SYS_C0045030

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

CHECK: SYS_C0045031

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

CHECK: SYS_C0045032

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

CHECK: SYS_C0045033

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

CHECK: SYS_C0045034

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

CHECK: SYS_C0045035

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

CHECK: SYS_C0045036

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

CHECK: SYS_C0045037

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

CHECK: SYS_C0045038

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

CHECK: SYS_C0045039

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

CHECK: SYS_C0045040

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

CHECK: SYS_C0045042

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

CHECK: SYS_C0045043

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

CHECK: SYS_C0085816

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

CHECK: SYS_C0085890

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

PK: FACT_ORDERRELEASE_OTM_PK

Estado: ENABLED
Columnas: ORDERRELEASE_OTM_ID

FK: FACT_ORDERRELEASE_ORTYPE_OTM_FK

Estado: ENABLED
Columnas: DIM_ORDERRELEASETYPE_OTM_ID
Referencia: DWADW.DIM_ORDERRELEASETYPE_OTM (constraint DIM_ORDERRELEASETYPE_OTM_PK)

FK: FACT_ORDERRELEASE_OTM_DIM_BULKPLAN_OTM_FK

Estado: ENABLED
Columnas: DIM_BULKPLAN_OTM_ID
Referencia: DWADW.DIM_BULKPLAN_OTM (constraint DIM_BULKPLAN_OTM_PK)

FK: FACT_ORDERRELEASE_OTM_DIM_ITINERARY_OTM_FK

Estado: ENABLED
Columnas: DIM_ITINERARY_OTM_ID
Referencia: DWADW.DIM_ITINERARY_OTM (constraint DIM_ITINERARY_OTM_PK)

FK: FACT_ORDERRELEASE_OTM_DIM_LOCATION_ADDRESS_OTM_FK

Estado: ENABLED
Columnas: SOURCE_LOCATION_ADDRESS_OTM_ID
Referencia: DWADW.DIM_LOCATION_ADDRESS_OTM (constraint DIM_LOCATION_ADDRESS_OTM_PK)

FK: FACT_ORDERRELEASE_OTM_DIM_LOCATION_ADDRESS_OTM_FKV2

Estado: ENABLED
Columnas: DEST_LOCATION_ADDRESS_OTM_ID
Referencia: DWADW.DIM_LOCATION_ADDRESS_OTM (constraint DIM_LOCATION_ADDRESS_OTM_PK)

FK: FACT_ORDERRELEASE_OTM_DIM_TIME_OTM_FK

Estado: ENABLED
Columnas: DIM_TIME_OTM_ID
Referencia: DWADW.DIM_TIME_OTM (constraint DIM_TIEMPO_OTM_PK)

UK: DIM_ORDERRELEASE_OTM_UN

Estado: ENABLED
Columnas: ORDER_RELEASE_GID

DDL

CREATE TABLE "DWADW"."FACT_ORDERRELEASE_OTM" 
   (	"ORDERRELEASE_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, 
	"ORDER_RELEASE_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"ORDER_RELEASE_XID" VARCHAR2(200) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"ORDER_RELEASE_NAME" VARCHAR2(480) COLLATE "USING_NLS_COMP", 
	"ORDER_RELEASE_TYPE_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"ASSIGNED_ITINERARY_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"SOURCE_LOCATION_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"DEST_LOCATION_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"EARLY_PICKUP_DATE" DATE, 
	"TOTAL_ITEM_PACKAGE_COUNT" NUMBER, 
	"INDICATOR" VARCHAR2(4) COLLATE "USING_NLS_COMP", 
	"TOTAL_NET_WEIGHT" NUMBER, 
	"TOTAL_NET_WEIGHT_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP", 
	"TOTAL_NET_WEIGHT_BASE" NUMBER, 
	"TOTAL_NET_VOLUME" NUMBER, 
	"TOTAL_NET_VOLUME_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP", 
	"TOTAL_NET_VOLUME_BASE" NUMBER, 
	"PICKUP_IS_APPT" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"DELIVERY_IS_APPT" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_KNOWN_SHIPPER" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"RELEASE_METHOD_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"LOC_AMOUNT" NUMBER NOT NULL ENABLE, 
	"LOC_AMOUNT_CURRENCY_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"LOC_AMOUNT_BASE" NUMBER NOT NULL ENABLE, 
	"SECONDARY_T_WEIGHT" NUMBER, 
	"SECONDARY_T_WEIGHT_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP", 
	"SECONDARY_T_WEIGHT_BASE" NUMBER, 
	"SECONDARY_T_VOLUME" NUMBER, 
	"SECONDARY_T_VOLUME_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP", 
	"SECONDARY_T_VOLUME_BASE" NUMBER, 
	"MUST_SHIP_DIRECT" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"MUST_SHIP_THRU_X_DOCK" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"MUST_SHIP_THRU_POOL" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IMPORT_LICENSE_REQUIRED" VARCHAR2(200) COLLATE "USING_NLS_COMP", 
	"IS_LOC_REQUIRED" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"INSPECTION_REQUIRED" VARCHAR2(200) COLLATE "USING_NLS_COMP", 
	"CUSTOMER_UNITIZATION_REQUEST" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_LOC_STALE" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"BUNDLING_TYPE" VARCHAR2(200) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_CONSOLIDATE_OR_EQUIPMENT" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"DUTY_PAID" VARCHAR2(32) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"TOTAL_DECLARED_VALUE" NUMBER, 
	"TOTAL_DECLARED_VALUE_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"TOTAL_DECLARED_VALUE_BASE" NUMBER, 
	"BULK_PLAN_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"TOTAL_SHIP_UNIT_COUNT" NUMBER, 
	"TOTAL_WEIGHT" NUMBER, 
	"TOTAL_WEIGHT_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP", 
	"TOTAL_WEIGHT_BASE" NUMBER, 
	"TOTAL_VOLUME" NUMBER, 
	"TOTAL_VOLUME_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP", 
	"ON_RT_EXECUTION" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_SPLITTABLE" VARCHAR2(4) COLLATE "USING_NLS_COMP", 
	"OTM_VERSION" VARCHAR2(60) COLLATE "USING_NLS_COMP", 
	"TOTAL_VOLUME_BASE" NUMBER, 
	"MARKED_FOR_PURGE" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_PRE_ENTERED_PU" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_TOPOFF" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"SHIP_UNIT_WIDTH" NUMBER, 
	"SHIP_UNIT_WIDTH_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP", 
	"SHIP_UNIT_WIDTH_BASE" NUMBER, 
	"SHIP_UNIT_LENGTH" NUMBER, 
	"SHIP_UNIT_LENGTH_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP", 
	"SHIP_UNIT_LENGTH_BASE" NUMBER, 
	"SHIP_UNIT_HEIGHT" NUMBER, 
	"SHIP_UNIT_HEIGHT_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP", 
	"SHIP_UNIT_HEIGHT_BASE" NUMBER, 
	"PRIORITY" NUMBER NOT NULL ENABLE, 
	"IS_TEMPLATE" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"DOMAIN_NAME" VARCHAR2(200) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"SOURCE_LOCATION_ADDRESS_OTM_ID" NUMBER, 
	"DEST_LOCATION_ADDRESS_OTM_ID" NUMBER, 
	"DIM_ORDERRELEASETYPE_OTM_ID" NUMBER, 
	"INSERT_USER" VARCHAR2(512) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"INSERT_DATE" DATE NOT NULL ENABLE, 
	"UPDATE_USER" VARCHAR2(512) COLLATE "USING_NLS_COMP", 
	"UPDATE_DATE" DATE, 
	"DIM_BULKPLAN_OTM_ID" NUMBER, 
	"DIM_ITINERARY_OTM_ID" NUMBER, 
	"DIM_TIME_OTM_ID" NUMBER, 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	 CONSTRAINT "FACT_ORDERRELEASE_OTM_PK" PRIMARY KEY ("ORDERRELEASE_OTM_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_ORDERRELEASE_OTM_UN" UNIQUE ("ORDER_RELEASE_GID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_ORDERRELEASE_OTM_ROW_ACTIVE_CK" CHECK (ROW_ACTIVE IN ('A','I')) ENABLE, 
	 CONSTRAINT "FACT_ORDERRELEASE_ORTYPE_OTM_FK" FOREIGN KEY ("DIM_ORDERRELEASETYPE_OTM_ID")
	  REFERENCES "DWADW"."DIM_ORDERRELEASETYPE_OTM" ("ORDERRELEASETYPE_OTM_ID") ENABLE, 
	 CONSTRAINT "FACT_ORDERRELEASE_OTM_DIM_BULKPLAN_OTM_FK" FOREIGN KEY ("DIM_BULKPLAN_OTM_ID")
	  REFERENCES "DWADW"."DIM_BULKPLAN_OTM" ("BULKPLAN_OTM_ID") ENABLE, 
	 CONSTRAINT "FACT_ORDERRELEASE_OTM_DIM_ITINERARY_OTM_FK" FOREIGN KEY ("DIM_ITINERARY_OTM_ID")
	  REFERENCES "DWADW"."DIM_ITINERARY_OTM" ("ITINERARY_OTM_ID") ENABLE, 
	 CONSTRAINT "FACT_ORDERRELEASE_OTM_DIM_LOCATION_ADDRESS_OTM_FK" FOREIGN KEY ("SOURCE_LOCATION_ADDRESS_OTM_ID")
	  REFERENCES "DWADW"."DIM_LOCATION_ADDRESS_OTM" ("LOCATION_ADDRESS_OTM_ID") ENABLE, 
	 CONSTRAINT "FACT_ORDERRELEASE_OTM_DIM_LOCATION_ADDRESS_OTM_FKV2" FOREIGN KEY ("DEST_LOCATION_ADDRESS_OTM_ID")
	  REFERENCES "DWADW"."DIM_LOCATION_ADDRESS_OTM" ("LOCATION_ADDRESS_OTM_ID") ENABLE, 
	 CONSTRAINT "FACT_ORDERRELEASE_OTM_DIM_TIME_OTM_FK" FOREIGN KEY ("DIM_TIME_OTM_ID")
	  REFERENCES "DWADW"."DIM_TIME_OTM" ("TIME_OTM_ID") ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."FACT_ORDERRELEASE_OTM"  IS 'Español: Tabla de hechos de order releases con métricas de demanda y enlaces a dimensiones principales. | English: Fact table of order releases with demand metrics linked to core dimensions.';

CREATE UNIQUE INDEX "DWADW"."FACT_ORDERRELEASE_OTM_PK" ON "DWADW"."FACT_ORDERRELEASE_OTM" ("ORDERRELEASE_OTM_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."DIM_ORDERRELEASE_OTM_UN" ON "DWADW"."FACT_ORDERRELEASE_OTM" ("ORDER_RELEASE_GID") 
  ;

← Volver a tablas de DWADW

🏠 Volver al menú principal