Table slot9.WORLD.TSTA.VEHICLE_INSURANCE
This table stores the insurance information added to a 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
VEH_INS_ID number 0
IMPOUND.VEH_INS_ID IMPD_VEHINS_FK R
Vehicle Insurance ID - Unique Generated Number
VEHICLE_ID number 38
VEHICLES.VEHICLE_ID VEHINS_VEH_FK C
Vehicle ID number
INSURANCE_COMPANY varchar2 80 Insurance Company Name
POLICY_NUMBER varchar2 40 Insurance Policy Number
EXPIRATION_DATE date 7 Expiration Date
CREATOR_ID varchar2 100  √  null Person creating the record
UPDATOR_ID varchar2 100  √  null Person who last updated the record
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_DATE date 7  √  null Date of last update
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"EXPIRATION_DATE" IS NOT NULL VEHINS_EXPIRATION_DATE_NN
"INSURANCE_COMPANY" IS NOT NULL VEHINS_INSURANCE_COMPANY_NN
"POLICY_NUMBER" IS NOT NULL VEHINS_POLICY_NUMBER_NN
"VEH_INS_ID" IS NOT NULL VEHINS_VEH_INS_ID_NN
"VEHICLE_ID" IS NOT NULL VEHINS_VEHICLE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
VEH_INS_ID Primary key Asc VEHINS_PK
INSURANCE_COMPANY + POLICY_NUMBER + EXPIRATION_DATE + VEHICLE_ID Must be unique Asc/Asc/Asc/Asc VEH_INS_CO_POLICY_EXP_I
VEHICLE_ID Performance Asc VEHINS_VEH_FK_I

Close relationships  within of separation: