Table slot9.WORLD.TSTA.LIENHOLDERS
This table store lien information for a lien placed on a MASTER VEHICLE in the application
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
LIENHOLDER_ID number 0 Business or Personal ID of lienholder
VEH_VEHICLE_ID number 0
VEHICLES.VEHICLE_ID LIENHLDR_VEH_FK C
Vehicle ID number
STATE_CD_STATE_CODE varchar2 30  √  null
EJS_CODES.CODE LIENHLDR_STATE_CD__EJS_CODE_FK R
State code designator
CITY_CD_CITY_CODE varchar2 30  √  null
EJS_CODES.CODE LIENHLDR_CITY_CD_C_EJS_CODE_FK R
City/Unincorp. code (I-UCR)
LIENHOLDER_NAME varchar2 30  √  null Name of the lienholder
LIENHOLDER_STREET_ADDRESS varchar2 140  √  null Lienholder street address
LIENHOLDER_ZIP number 0  √  null Lienholder ZIP
LIENHOLDER_CITY varchar2 40  √  null
PHONE_AREA varchar2 3  √  null Lienholder phone
PHONE_PREFIX varchar2 3  √  null Lienholder phone prefix
PHONE_SUFFIX varchar2 4  √  null Lienholder phone suffix
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
CITY_CD_CITY_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE LIENHLDR_CITY_CD_C_EJS_CODE_FK R
STATE_CD_STATE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE LIENHLDR_STATE_CD__EJS_CODE_FK R
REC_ID number 0  √  null
DATE_OF_INFO date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"LIENHOLDER_ID" IS NOT NULL LIENHLDR_LIENHOLDER_ID_NN
"VEH_VEHICLE_ID" IS NOT NULL LIENHLDR_VEH_VEHICLE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
LIENHOLDER_ID Primary key Asc LIENHLDR_PK
CITY_CD_CITY_CODE_TYPE + CITY_CD_CITY_CODE Performance Asc/Asc LIENHLDR_CITY_CD_C_EJS_CODE_I
CITY_CD_CITY_CODE Performance Asc LIENHLDR_CITY_CD_FK_I
STATE_CD_STATE_CODE_TYPE + STATE_CD_STATE_CODE Performance Asc/Asc LIENHLDR_STATE_CD__EJS_CODE_I
STATE_CD_STATE_CODE Performance Asc LIENHLDR_STATE_CD_FK_I
VEH_VEHICLE_ID Performance Asc LIENHLDR_VEH_FK_I

Close relationships  within of separation: