Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_SHIPMENTSTOP_HIST
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | IDMAESTROCARGUE | NUMBER(18,0) | NO | ||
| 2 | SHIPMENT_GID | VARCHAR2(404) | NO | ||
| 3 | STOP_NUM | NUMBER | NO | ||
| 4 | LOCATION_GID | VARCHAR2(404) | NO | ||
| 5 | LOCATION_ROLE_GID | VARCHAR2(404) | SI | ||
| 6 | PLANNED_ARRIVAL | DATE | SI | ||
| 7 | ESTIMATED_ARRIVAL | DATE | SI | ||
| 8 | IS_FIXED_ARRIVAL | CHAR(4) | NO | ||
| 9 | PLANNED_DEPARTURE | DATE | SI | ||
| 10 | ESTIMATED_DEPARTURE | DATE | SI | ||
| 11 | IS_FIXED_DEPARTURE | CHAR(4) | NO | ||
| 12 | WAIT_TIME | NUMBER | SI | ||
| 13 | WAIT_TIME_UOM_CODE | VARCHAR2(256) | SI | ||
| 14 | WAIT_TIME_BASE | NUMBER | SI | ||
| 15 | REST_TIME | NUMBER | SI | ||
| 16 | REST_TIME_UOM_CODE | VARCHAR2(256) | SI | ||
| 17 | REST_TIME_BASE | NUMBER | SI | ||
| 18 | DRIVE_TIME | NUMBER | SI | ||
| 19 | DRIVE_TIME_UOM_CODE | VARCHAR2(256) | SI | ||
| 20 | DRIVE_TIME_BASE | NUMBER | SI | ||
| 21 | DIST_FROM_PREV_STOP | NUMBER | SI | ||
| 22 | DIST_FROM_PREV_STOP_UOM_CODE | VARCHAR2(256) | SI | ||
| 23 | DIST_FROM_PREV_STOP_BASE | NUMBER | SI | ||
| 24 | ACTIVITY_TIME | NUMBER | SI | ||
| 25 | ACTIVITY_TIME_UOM_CODE | VARCHAR2(256) | SI | ||
| 26 | ACTIVITY_TIME_BASE | NUMBER | SI | ||
| 27 | IS_PERMANENT | VARCHAR2(4) | NO | ||
| 28 | IS_DEPOT | VARCHAR2(4) | NO | ||
| 29 | ACCESSORIAL_TIME | NUMBER | SI | ||
| 30 | ACCESSORIAL_TIME_UOM_CODE | VARCHAR2(256) | SI | ||
| 31 | ACCESSORIAL_TIME_BASE | NUMBER | SI | ||
| 32 | IS_FIXED_DISTANCE | VARCHAR2(4) | NO | ||
| 33 | RUSH_HOUR_TIME | NUMBER | SI | ||
| 34 | RUSH_HOUR_TIME_UOM_CODE | VARCHAR2(256) | SI | ||
| 35 | RUSH_HOUR_TIME_BASE | NUMBER | SI | ||
| 36 | IS_MOTHER_VESSEL | VARCHAR2(4) | NO | ||
| 37 | STOP_TYPE | VARCHAR2(64) | SI | ||
| 38 | DRIVER_NON_PAYABLE | VARCHAR2(4) | NO | ||
| 39 | DISTANCE_TYPE | VARCHAR2(4) | SI | ||
| 40 | RUNNING_WEIGHT | NUMBER | SI | ||
| 41 | RUNNING_WEIGHT_UOM_CODE | VARCHAR2(256) | SI | ||
| 42 | RUNNING_WEIGHT_BASE | NUMBER | SI | ||
| 43 | DOMAIN_NAME | VARCHAR2(200) | NO | ||
| 44 | INSERT_USER | VARCHAR2(512) | NO | ||
| 45 | INSERT_DATE | DATE | NO | ||
| 46 | UPDATE_USER | VARCHAR2(512) | SI | ||
| 47 | UPDATE_DATE | DATE | SI |
Restricciones
CHECK: SYS_C0036169
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
CHECK: SYS_C0036170
- Estado: ENABLED
- Columnas: SHIPMENT_GID
- Condición:
"SHIPMENT_GID" IS NOT NULL
CHECK: SYS_C0036171
- Estado: ENABLED
- Columnas: STOP_NUM
- Condición:
"STOP_NUM" IS NOT NULL
CHECK: SYS_C0036172
- Estado: ENABLED
- Columnas: LOCATION_GID
- Condición:
"LOCATION_GID" IS NOT NULL
CHECK: SYS_C0036173
- Estado: ENABLED
- Columnas: IS_FIXED_ARRIVAL
- Condición:
"IS_FIXED_ARRIVAL" IS NOT NULL
CHECK: SYS_C0036174
- Estado: ENABLED
- Columnas: IS_FIXED_DEPARTURE
- Condición:
"IS_FIXED_DEPARTURE" IS NOT NULL
CHECK: SYS_C0036175
- Estado: ENABLED
- Columnas: IS_PERMANENT
- Condición:
"IS_PERMANENT" IS NOT NULL
CHECK: SYS_C0036176
- Estado: ENABLED
- Columnas: IS_DEPOT
- Condición:
"IS_DEPOT" IS NOT NULL
CHECK: SYS_C0036177
- Estado: ENABLED
- Columnas: IS_FIXED_DISTANCE
- Condición:
"IS_FIXED_DISTANCE" IS NOT NULL
CHECK: SYS_C0036178
- Estado: ENABLED
- Columnas: IS_MOTHER_VESSEL
- Condición:
"IS_MOTHER_VESSEL" IS NOT NULL
CHECK: SYS_C0036179
- Estado: ENABLED
- Columnas: DRIVER_NON_PAYABLE
- Condición:
"DRIVER_NON_PAYABLE" IS NOT NULL
CHECK: SYS_C0036180
- Estado: ENABLED
- Columnas: DOMAIN_NAME
- Condición:
"DOMAIN_NAME" IS NOT NULL
CHECK: SYS_C0036181
- Estado: ENABLED
- Columnas: INSERT_USER
- Condición:
"INSERT_USER" IS NOT NULL
CHECK: SYS_C0036182
- Estado: ENABLED
- Columnas: INSERT_DATE
- Condición:
"INSERT_DATE" IS NOT NULL
DDL
-- Error obteniendo DDL completo: ORA-01745: invalid host/bind variable name