Table slot9.WORLD.TSTA.GANG_PEOPLE
This table stores the association to the MASTER PEOPLE added to the 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
GP_COMMENT varchar2 2000  √  null Comment field for the gang person.
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
GANG_PERSON_REASONS.GANG_ID GPR_GP_FK R
GANGS.GANG_ID GP_GAN_FK R
The gang id used to uniquely identify the gang.
PERSON_ID number 38
GANG_PERSON_REASONS.PERSON_ID GPR_GP_FK R
PEOPLE.PERSON_ID GP_PER_FK R
Person ID number
REC_ID number 0  √  null
STATUS_DATE date 7  √  null
STATUS_CODE varchar2 30  √  null
EJS_CODES.CODE GP_GANGST_EJS_CODES_FK R
STATUS_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE GP_GANGST_EJS_CODES_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"GANG_ID" IS NOT NULL GP_GANG_ID_NN
"PERSON_ID" IS NOT NULL GP_PERSON_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
GANG_ID + PERSON_ID Primary key Asc/Asc GP_PK
GANG_ID Performance Asc GP_GAN_FK_I
STATUS_CODE_TYPE + STATUS_CODE Performance Asc/Asc GP_GANGST_EJS_CODES_FK_I
PERSON_ID Performance Asc GP_PER_FK_I

Close relationships  within of separation: