Table slot9.WORLD.TSTA.EMP_SUB_ASSIGN_CODES
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
SUB_CODE varchar2 5
ASSIGNMENTS.SUB_CODE ASSIG_EMP_SUB_CD_FK R
Sub assignment code unique id
CAT_CODE varchar2 5
ASSIGNMENTS.SUB_CAT_CODE ASSIG_EMP_SUB_CD_FK R
category unique id
DESCRIPTION varchar2 50  √  null Sub assignment description
ASSIGN_CODE varchar2 5
ASSIGNMENTS.SUB_ASSIGN_CODE ASSIG_EMP_SUB_CD_FK R
ASSIGNMENT_SHIFT_CODES.SHIFT_CODE EMP_SUB_ASSCD_FK R
Assignment code unique id
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ASSIGN_CODE" IS NOT NULL EMP_SUB_CD_ASSIGN_CODE_NN
"CAT_CODE" IS NOT NULL EMP_SUB_CD_CAT_CODE_NN
"SUB_CODE" IS NOT NULL EMP_SUB_CD_SUB_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
SUB_CODE + CAT_CODE + ASSIGN_CODE Primary key Asc/Asc/Asc EMP_SUB_CD_PK
ASSIGN_CODE Performance Asc EMP_SUB_ASSCD_FK_I

Close relationships  within of separation: