Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
DWADW.MLOG$_FACT_FULFILLLINE_OM
Base de datos origen: ADW COEXITO
Descripción: snapshot log for master table DWADW.FACT_FULFILLLINE_OM
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | M_ROW$$ | VARCHAR2(255) | SI | ||
| 2 | SEQUENCE$$ | NUMBER | SI | ||
| 3 | SNAPTIME$$ | DATE | SI | ||
| 4 | DMLTYPE$$ | VARCHAR2(1) | SI | ||
| 5 | OLD_NEW$$ | VARCHAR2(1) | SI | ||
| 6 | CHANGE_VECTOR$$ | RAW | SI | ||
| 7 | XID$$ | NUMBER | SI | ||
| 8 | FULFILLLINE_OM_ID | NUMBER | SI |
Restricciones
Sin restricciones visibles (P/R/U/C).
DDL
CREATE TABLE "DWADW"."MLOG$_FACT_FULFILLLINE_OM"
( "M_ROW$$" VARCHAR2(255) COLLATE "USING_NLS_COMP",
"SEQUENCE$$" NUMBER,
"SNAPTIME$$" DATE,
"DMLTYPE$$" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"OLD_NEW$$" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"CHANGE_VECTOR$$" RAW(513),
"XID$$" NUMBER,
"FULFILLLINE_OM_ID" NUMBER
) DEFAULT COLLATION "USING_NLS_COMP" ;
COMMENT ON TABLE "DWADW"."MLOG$_FACT_FULFILLLINE_OM" IS 'snapshot log for master table DWADW.FACT_FULFILLLINE_OM';
CREATE INDEX "DWADW"."I_MLOG$_FACT_FULFILLLINE_OM" ON "DWADW"."MLOG$_FACT_FULFILLLINE_OM" ("XID$$")
;