Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
Base de datos origen: ADW COEXITO
Descripción: Español: Catálogo de direcciones asociadas a ubicaciones para análisis detallado de origen y destino. | English: Catalog of addresses linked to locations for detailed origin and destination analysis.
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | LOCATION_ADDRESS_OTM_ID | NUMBER | NO | “DWADW”.”ISEQ$$_220803”.nextval | |
| 2 | LOCATION_GID | VARCHAR2(404) | NO | ||
| 3 | LINE_SEQUENCE | NUMBER | NO | ||
| 4 | ADDRESS_LINE | VARCHAR2(4000) | SI | ||
| 5 | DOMAIN_NAME | VARCHAR2(200) | NO | ||
| 6 | INSERT_USER | VARCHAR2(512) | NO | ||
| 7 | INSERT_DATE | DATE | NO | ||
| 8 | UPDATE_USER | VARCHAR2(512) | SI | ||
| 9 | UPDATE_DATE | DATE | SI | ||
| 10 | DIM_LOCATION_OTM_ID | NUMBER | NO | ||
| 11 | AUDIT_ID | NUMBER | NO | ||
| 12 | ROW_ACTIVE | CHAR(1) | NO | ‘A’ |
ROW_ACTIVE IN ('A','I')"LOCATION_ADDRESS_OTM_ID" IS NOT NULL"LOCATION_GID" IS NOT NULL"LINE_SEQUENCE" IS NOT NULL"DOMAIN_NAME" IS NOT NULL"INSERT_USER" IS NOT NULL"INSERT_DATE" IS NOT NULL"DIM_LOCATION_OTM_ID" IS NOT NULL"AUDIT_ID" IS NOT NULL"ROW_ACTIVE" IS NOT NULL-- Error obteniendo DDL completo: ORA-01745: invalid host/bind variable name