Table slot9.WORLD.TSTA.COLLAPSE_VEHICLE_DESC_LOG
This table stores a log entry for the vehicle description for collapsed vehicles
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
CVLE_ID number 38
COLLAPSE_VEHICLE_LOG_ENTRIES.CVLE_ID CVDL_CVLE_FK R
COLLAPSE_VEHICLE_ID number 38
DATE_OF_INFO date 7
LIC_NUMBER varchar2 12  √  null
LIC_TYPE_CODE varchar2 30  √  null
LIC_STATE_CODE varchar2 30  √  null
COND_CODE varchar2 30  √  null
MISC_ID varchar2 20  √  null
VALUE number 10  √  null
BOTTOM_COLOR varchar2 30  √  null
TOP_COLOR varchar2 30  √  null
DAMAGE varchar2 240  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
ODOMETER_READING number 10  √  null
DAMAGE_CODE varchar2 30  √  null
BOTTOM_COLOR_TYPE varchar2 30  √  null
COND_CODE_TYPE varchar2 30  √  null
DAMAGE_CODE_TYPE varchar2 30  √  null
LIC_STATE_CODE_TYPE varchar2 30  √  null
LIC_TYPE_CODE_TYPE varchar2 30  √  null
TOP_COLOR_TYPE varchar2 30  √  null
LIC_MONTH number 2  √  null
LIC_YEAR number 4  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"CVLE_ID" IS NOT NULL CVDL_CVLE_ID_NN
"DATE_OF_INFO" IS NOT NULL CVDL_DATE_OF_INFO_NN
"COLLAPSE_VEHICLE_ID" IS NOT NULL CVDL_VEHICLE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
CVLE_ID + COLLAPSE_VEHICLE_ID + DATE_OF_INFO Primary key Asc/Asc/Asc CVDL_PK
CVLE_ID Performance Asc CVDL_CVLE_FK_I

Close relationships: