Table slot9.WORLD.TSTA.DV_INSURANCE_CLAIM
This table stores department vehicle insurance claims
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
CLAIM_ID number 0 Unique identifier for insurance claim record
INSURANCE_ID number 0
DV_INSURANCE.INSURANCE_ID DVCLAIM_DVINSUR_FK R
Department vehicle insurance id
CLAIM_NUMBER varchar2 100  √  null Claim number
CLAIM_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE DVCLAIM_EJSCD_CLAIM_FK R
EJS CODES code for claim type
CLAIM_TYPE_CODE_TYPE varchar2 30  √  'INSURANCE_CLAIM_TYPE_CODES'
EJS_CODES.CODE_TYPE DVCLAIM_EJSCD_CLAIM_FK R
EJS CODES code type for claim type
DATE_OF_INFO date 7  √  null Date of info
COMMENTS varchar2 255  √  null Claim comments (could include "totaled" or a summary of the damage)
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
"CLAIM_ID" IS NOT NULL DVCLAIM_ID_NN
"INSURANCE_ID" IS NOT NULL DVCLAIM_INSUR_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
CLAIM_ID Primary key Asc DVCLAIM_PK
INSURANCE_ID Performance Asc DVCLAIM_DVINSUR_FK_I
CLAIM_TYPE_CODE_TYPE + CLAIM_TYPE_CODE Performance Asc/Asc DVCLAIM_EJSCD_CLAIM_FK_I

Close relationships  within of separation: