Table slot9.WORLD.TSTA.GANG_NAMES
This table stores the names added to a MASTER GANG in the application
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
NAME varchar2 80  √  null
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
GANG_ID number 20
GANGS.GANG_ID GN_GAN_FK R
The gang id used to uniquely identify the gang.
NAME_TYPE_CODE varchar2 2
EJS_CODES.CODE GNT_GNTC_EJS_CODES_FK R
GANG_NAME_ID number 38 The id for a gang name.
REC_ID number 0  √  null
NAME_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE GNT_GNTC_EJS_CODES_FK R
DATE_OF_INFO date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"GANG_ID" IS NOT NULL GN_GANG_ID_NN
"GANG_NAME_ID" IS NOT NULL GN_GANG_NAME_ID_NN
"NAME_TYPE_CODE" IS NOT NULL GN_NAME_TYPE_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
GANG_ID + NAME_TYPE_CODE + GANG_NAME_ID Primary key Asc/Asc/Asc GN_PK
GANG_ID Performance Asc GN_GAN_FK_I
NAME_TYPE + NAME_TYPE_CODE Performance Asc/Asc GNT_GNTC_EJS_CODES_FK_I

Close relationships  within of separation: