Table slot9.WORLD.TSTA.WARRANT_SERVING_OFFICERS
This tables stores the Serving Officers of Warrants
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
LOG_ID number 38
ACCESS_LOGS.LOG_ID Implied Constraint R
WARRANT_ID number 38
E_WARRANTS.WARRANT_ID WARSERV_EWAR_FK R
ID of the Warrant the Officer is Serving.
OFFICER_ID number 38
OFFICERS.OFFICER_ID WARSERV_OFF1_FK R
ID of the Officer Serving the Warrant.
SERVED_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null USER ID of the person updating record.
UPDATOR_DATE date 7  √  null Date the record was updated.
CREATOR_DATE date 7  √  null Date the record was created.
CREATOR_ID varchar2 100  √  null USER ID of the person who created the record.
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"LOG_ID" IS NOT NULL WARSERV_LOG_ID_NN
"OFFICER_ID" IS NOT NULL WARSERV_OFFICER_ID_NN
"WARRANT_ID" IS NOT NULL WARSERV_WARRANT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
LOG_ID Primary key Asc WARSERV_PK
WARRANT_ID Performance Asc WARSERV_EWAR_FK_I
OFFICER_ID Performance Asc WARSERV_OFF1_FK_I
SERVED_DATE Performance Asc WARSERV_SERVED_DATE_I

Close relationships  within of separation: