Table slot9.WORLD.TSTA.DV_MISC_IDS
This table stores misc ids for department 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
DV_MISC_ID number 0 Unique identifier for department vehicle misc id
VEHICLE_ID number 0
DEPARTMENT_VEHICLES.VEHICLE_ID DVMISC_DV_FK R
Department vehicle id
TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE DVMISC_EJSCD_TYP_FK R
EJS code for misc id type
TYPE_CODE_TYPE varchar2 30  √  'VEHICLE_MISC_ID_CODES'
EJS_CODES.CODE_TYPE DVMISC_EJSCD_TYP_FK R
EJS code type for misc id type
MISC_ID_VALUE varchar2 255  √  null Value for misc id
STATE_CODE varchar2 30  √  null
EJS_CODES.CODE DVMISC_EJSCD_ST_FK R
EJS code for misc id state
STATE_CODE_TYPE varchar2 30  √  'STATE_CODES'
EJS_CODES.CODE_TYPE DVMISC_EJSCD_ST_FK R
EJS code type for misc id state
DATE_OF_INFO date 7  √  null Date of info for misc id record
COMMMENT varchar2 255  √  null Comment for misc id
EXPIRE_DATE date 7  √  null Expiration date for misc id
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DV_MISC_ID" IS NOT NULL DVMISC_MISC_ID_NN
"VEHICLE_ID" IS NOT NULL DVMISC_VEH_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
DV_MISC_ID Primary key Asc DVMISC_PK
TYPE_CODE_TYPE + TYPE_CODE Performance Asc/Asc DV_MISC_IDS_I
VEHICLE_ID Performance Asc DVMISC_DV_FK_I
STATE_CODE_TYPE + STATE_CODE Performance Asc/Asc DVMISC_EJSCD_ST_FK_I
MISC_ID_VALUE Performance Asc DVMISC_ID_VAL_I

Close relationships  within of separation: