Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
DWADW.DW_GLCCOMBINATION
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | CODE_COMBINATION_ID | NUMBER | NO | ||
| 2 | ENABLE_FLAG | VARCHAR2(2000) | SI | ||
| 3 | DESCRIPTION | VARCHAR2(2000) | SI | ||
| 4 | CREATION_DATE | DATE | SI | ||
| 5 | SEGMENT1 | VARCHAR2(2000) | SI | ||
| 6 | SEGMENT2 | VARCHAR2(2000) | SI | ||
| 7 | SEGMENT3 | VARCHAR2(2000) | SI | ||
| 8 | SEGMENT4 | VARCHAR2(2000) | SI | ||
| 9 | SEGMENT5 | VARCHAR2(2000) | SI | ||
| 10 | SEGMENT6 | VARCHAR2(2000) | SI | ||
| 11 | SEGMENT7 | VARCHAR2(2000) | SI | ||
| 12 | SEGMENT8 | VARCHAR2(2000) | SI | ||
| 13 | SEGMENT9 | VARCHAR2(2000) | SI | ||
| 14 | SEGMENT10 | VARCHAR2(2000) | SI |
Restricciones
CHECK: SYS_C0024703
- Estado: ENABLED
- Columnas: CODE_COMBINATION_ID
- Condición:
"CODE_COMBINATION_ID" IS NOT NULL
PK: SYS_C0024704
- Estado: ENABLED
- Columnas: CODE_COMBINATION_ID
DDL
CREATE TABLE "DWADW"."DW_GLCCOMBINATION"
( "CODE_COMBINATION_ID" NUMBER(*,0) NOT NULL ENABLE,
"ENABLE_FLAG" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"DESCRIPTION" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"CREATION_DATE" DATE,
"SEGMENT1" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"SEGMENT2" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"SEGMENT3" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"SEGMENT4" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"SEGMENT5" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"SEGMENT6" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"SEGMENT7" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"SEGMENT8" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"SEGMENT9" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"SEGMENT10" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
PRIMARY KEY ("CODE_COMBINATION_ID")
USING INDEX ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;
GRANT INDEX ON "DWADW"."DW_GLCCOMBINATION" TO "BICC";
GRANT REFERENCES ON "DWADW"."DW_GLCCOMBINATION" TO "BICC";
GRANT ON COMMIT REFRESH ON "DWADW"."DW_GLCCOMBINATION" TO "BICC";
GRANT QUERY REWRITE ON "DWADW"."DW_GLCCOMBINATION" TO "BICC";
GRANT FLASHBACK ON "DWADW"."DW_GLCCOMBINATION" TO "BICC";
GRANT DELETE ON "DWADW"."DW_GLCCOMBINATION" TO "BICC";
GRANT INSERT ON "DWADW"."DW_GLCCOMBINATION" TO "BICC";
GRANT SELECT ON "DWADW"."DW_GLCCOMBINATION" TO "BICC";
GRANT UPDATE ON "DWADW"."DW_GLCCOMBINATION" TO "BICC";
GRANT ALTER ON "DWADW"."DW_GLCCOMBINATION" TO "BICC";
GRANT SELECT ON "DWADW"."DW_GLCCOMBINATION" TO "POWER_BI";
GRANT DELETE ON "DWADW"."DW_GLCCOMBINATION" TO "MANAGE_DW_ST";
GRANT INSERT ON "DWADW"."DW_GLCCOMBINATION" TO "MANAGE_DW_ST";
GRANT SELECT ON "DWADW"."DW_GLCCOMBINATION" TO "MANAGE_DW_ST";
GRANT UPDATE ON "DWADW"."DW_GLCCOMBINATION" TO "MANAGE_DW_ST";
GRANT ALTER ON "DWADW"."DW_GLCCOMBINATION" TO "MANAGE_DW_ST";
GRANT READ ON "DWADW"."DW_GLCCOMBINATION" TO "MANAGE_DW_ST";
GRANT DEBUG ON "DWADW"."DW_GLCCOMBINATION" TO "MANAGE_DW_ST";
GRANT READ ON "DWADW"."DW_GLCCOMBINATION" TO "BICC";
GRANT DEBUG ON "DWADW"."DW_GLCCOMBINATION" TO "BICC";
CREATE UNIQUE INDEX "DWADW"."SYS_C0024704" ON "DWADW"."DW_GLCCOMBINATION" ("CODE_COMBINATION_ID")
;