Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
DWADW.DW_LACS_CLIENTES
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | LOCATION_ID | NUMBER | NO | ||
| 2 | SITE_USE_ID | NUMBER | NO | ||
| 3 | PARTY_SITE_ID | NUMBER | NO | ||
| 4 | ESTATUS_FLAG | VARCHAR2(50) | SI | ||
| 5 | TIPO_UBICACION | VARCHAR2(50) | SI | ||
| 6 | DIRECCION1 | VARCHAR2(1000) | SI | ||
| 7 | DIRECCION2 | VARCHAR2(1000) | SI | ||
| 8 | DIRECCION3 | VARCHAR2(1000) | SI | ||
| 9 | DIRECCION4 | VARCHAR2(1000) | SI | ||
| 10 | CIUDAD | VARCHAR2(1000) | SI | ||
| 11 | PAIS | VARCHAR2(1000) | SI | ||
| 12 | FECHA_ACTUALIZACION | DATE | SI | ||
| 13 | CODIGO_POSTAL | VARCHAR2(1000) | SI | ||
| 14 | ESTADO | VARCHAR2(1000) | SI |
Restricciones
CHECK: SYS_C0024792
- Estado: ENABLED
- Columnas: LOCATION_ID
- Condición:
"LOCATION_ID" IS NOT NULL
CHECK: SYS_C0024793
- Estado: ENABLED
- Columnas: SITE_USE_ID
- Condición:
"SITE_USE_ID" IS NOT NULL
CHECK: SYS_C0024794
- Estado: ENABLED
- Columnas: PARTY_SITE_ID
- Condición:
"PARTY_SITE_ID" IS NOT NULL
PK: DW_LACS_CLIENTES_PK
- Estado: ENABLED
- Columnas: LOCATION_ID, SITE_USE_ID, PARTY_SITE_ID
DDL
CREATE TABLE "DWADW"."DW_LACS_CLIENTES"
( "LOCATION_ID" NUMBER NOT NULL ENABLE,
"SITE_USE_ID" NUMBER NOT NULL ENABLE,
"PARTY_SITE_ID" NUMBER NOT NULL ENABLE,
"ESTATUS_FLAG" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"TIPO_UBICACION" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"DIRECCION1" VARCHAR2(1000) COLLATE "USING_NLS_COMP",
"DIRECCION2" VARCHAR2(1000) COLLATE "USING_NLS_COMP",
"DIRECCION3" VARCHAR2(1000) COLLATE "USING_NLS_COMP",
"DIRECCION4" VARCHAR2(1000) COLLATE "USING_NLS_COMP",
"CIUDAD" VARCHAR2(1000) COLLATE "USING_NLS_COMP",
"PAIS" VARCHAR2(1000) COLLATE "USING_NLS_COMP",
"FECHA_ACTUALIZACION" DATE,
"CODIGO_POSTAL" VARCHAR2(1000) COLLATE "USING_NLS_COMP",
"ESTADO" VARCHAR2(1000) COLLATE "USING_NLS_COMP"
) DEFAULT COLLATION "USING_NLS_COMP" ;
CREATE UNIQUE INDEX "DWADW"."DW_LACS_CLIENTES_PK" ON "DWADW"."DW_LACS_CLIENTES" ("LOCATION_ID", "SITE_USE_ID", "PARTY_SITE_ID")
;
ALTER TABLE "DWADW"."DW_LACS_CLIENTES" ADD CONSTRAINT "DW_LACS_CLIENTES_PK" PRIMARY KEY ("LOCATION_ID", "SITE_USE_ID", "PARTY_SITE_ID")
USING INDEX "DWADW"."DW_LACS_CLIENTES_PK" ENABLE;
GRANT INDEX ON "DWADW"."DW_LACS_CLIENTES" TO "BICC";
GRANT REFERENCES ON "DWADW"."DW_LACS_CLIENTES" TO "BICC";
GRANT ON COMMIT REFRESH ON "DWADW"."DW_LACS_CLIENTES" TO "BICC";
GRANT QUERY REWRITE ON "DWADW"."DW_LACS_CLIENTES" TO "BICC";
GRANT FLASHBACK ON "DWADW"."DW_LACS_CLIENTES" TO "BICC";
GRANT SELECT ON "DWADW"."DW_LACS_CLIENTES" TO "POWER_BI";
GRANT ALTER ON "DWADW"."DW_LACS_CLIENTES" TO "BICC";
GRANT DELETE ON "DWADW"."DW_LACS_CLIENTES" TO "BICC";
GRANT INSERT ON "DWADW"."DW_LACS_CLIENTES" TO "BICC";
GRANT SELECT ON "DWADW"."DW_LACS_CLIENTES" TO "BICC";
GRANT UPDATE ON "DWADW"."DW_LACS_CLIENTES" TO "BICC";
GRANT READ ON "DWADW"."DW_LACS_CLIENTES" TO "BICC";
GRANT DEBUG ON "DWADW"."DW_LACS_CLIENTES" TO "BICC";
CREATE UNIQUE INDEX "DWADW"."DW_LACS_CLIENTES_PK" ON "DWADW"."DW_LACS_CLIENTES" ("LOCATION_ID", "SITE_USE_ID", "PARTY_SITE_ID")
;