Table slot9.WORLD.TSTA.OFFICER_CASE_LOAD_BY_MONTHS
This table is not currently used
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
OFF1_OFFICER_ID number 38
OFFICER_CASE_LOAD.OFF1_OFFICER_ID OCLBM_OCL_FK C
Officer ID number
LOAD_MONTH number 2
MONTH_ASSIGNED number 5
MONTH_CLEARED number 5
MONTH_PENDING number 5
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"LOAD_MONTH" IS NOT NULL OCLBM_LOAD_MONTH_NN
"MONTH_ASSIGNED" IS NOT NULL OCLBM_MONTH_ASSIGNED_NN
"MONTH_CLEARED" IS NOT NULL OCLBM_MONTH_CLEARED_NN
"MONTH_PENDING" IS NOT NULL OCLBM_MONTH_PENDING_NN
"OFF1_OFFICER_ID" IS NOT NULL OCLBM_OFF1_OFFICER_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
OFF1_OFFICER_ID + LOAD_MONTH Primary key Asc/Asc OCLBM_PK
OFF1_OFFICER_ID Performance Asc OCLBM_OCL_FK_I

Close relationships  within of separation: