Table slot9.WORLD.TSTA.WARRANT_SERVICE_ADDRESSES
Associates Service Addresses to a Warrant. Joins to Master Index ADDRESSES
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
ID number 38
DS_ICR_CAT_QUERIES.ID Implied Constraint R
WARRANT_ID number 0
E_WARRANTS.WARRANT_ID WARSA_EWAR_FK R
ADDRESS_ID number 0
ADDRESSES.ADDRESS_ID WARSA_ADDR_FK R
PRIMARY_FLAG varchar2 1  √  'N'
COMMENTS varchar2 500  √  null
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
"ADDRESS_ID" IS NOT NULL WARSA_ADDR_ID_NN
"ID" IS NOT NULL WARSA_ID_NN
"WARRANT_ID" IS NOT NULL WARSA_WARRANT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc WARSA_PK
ADDRESS_ID Performance Asc WARSA_ADDR_FK_I
WARRANT_ID Performance Asc WARSA_EWAR_FK_I

Close relationships  within of separation: