Table slot9.WORLD.TSTA.EMP_INFO_TYPE_CODE_ROLES
This table stores the employee information type code relations to role codes
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
ID number 0
COURT_CASE_DELETE.ID Implied Constraint R
Unique id for employee information type code role relations
TYPE_CODE_ID number 0
EMPLOYEE_INFO_TYPE_CODES.ID EITCROLE_EITYPE_FK R
FK to employee information type code id
ROLE_CODE varchar2 30  √  null
ROLE_SECURITIES.ROLE_NAME EITCROLE_RS_FK R
FK to role securities role codes
ACTION_CODE varchar2 30  √  null
EJS_CODES.CODE EITCROLE_EJSCD_ACTION_CD_FK R
Action ejs code
ACTION_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EITCROLE_EJSCD_ACTION_CD_FK R
Action ejs code type
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ID" IS NOT NULL EITCROLE_ID_NN
"TYPE_CODE_ID" IS NOT NULL EITCROLE_TYPE_NN

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc EITCROLE_PK
TYPE_CODE_ID Performance Asc EITCROLE_EITYPE_FK_I
ACTION_CODE_TYPE + ACTION_CODE Performance Asc/Asc EITCROLE_EJSCD_ACTION_CD_FK_I
ROLE_CODE Performance Asc EITCROLE_RS_FK_I

Close relationships  within of separation: