Table slot9.WORLD.TSTA.AGENCY_NUM_GENERATIONS
This table defines number generations for INCIDENTS, ARRESTS, etc. in the application for an agency
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
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE ANGT_AGNCY_CD_FK R
Agency involved
NUMBER_TYPE varchar2 30
EJS_CODES.CODE ANGT_NUMBER_TYPE_EJS_CODE_FK R
FORMAT_TYPE varchar2 20
NEXT_NUMBER number 0  √  null
CREATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
UPDATOR_DATE date 7  √  null
EFFECTIVE_DATE date 7
END_DATE date 7  √  null
AGENCY_NUM_GEN_ID number 38
NUMBER_TYPE_TYPE varchar2 30  √  'AGENCY_NUM_TYPES'
EJS_CODES.CODE_TYPE ANGT_NUMBER_TYPE_EJS_CODE_FK R
REC_ID number 0  √  null
REPORT_FORMAT_CODE varchar2 30  √  null
EJS_CODES.CODE ANGT_EJS_CODE_FK R
REPORT_FORMAT_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ANGT_EJS_CODE_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"EFFECTIVE_DATE" IS NOT NULL ANGT_EFFECTIVE_DATE_NN
"FORMAT_TYPE" IS NOT NULL ANGT_FORMAT_TYPE_NN
"NUMBER_TYPE" IS NOT NULL ANGT_NUMBER_TYPE_NN

Indexes:
Column(s) Type Sort Constraint Name
AGENCY_NUM_GEN_ID Primary key Asc ANGT_PK
AGENCY_CODE + NUMBER_TYPE Performance Asc/Asc AGNCY_NUM_GEN_TYP_AGNCY_EFF_UI
AGENCY_CODE Performance Asc ANGT_AGNCY_CD_FK_I
NUMBER_TYPE Performance Asc ANGT_ANT_FK_I
REPORT_FORMAT_CODE_TYPE + REPORT_FORMAT_CODE Performance Asc/Asc ANGT_EJS_CODE_FK_I
NUMBER_TYPE_TYPE + NUMBER_TYPE Performance Asc/Asc ANGT_NUMBER_TYPE_EJS_CODE_I

Close relationships  within of separation: