Table slot9.WORLD.TSTA.EMPLOYEE_CONTACTS
This table stores employee contacts
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
PK Unique id for employee contact record
EJS_EMP_ID number 0
EMPLOYEES.EJS_EMP_ID EMPCONT_EMP1_FK R
FK to employees table
RELATIONSHIP_CODE varchar2 30  √  null
EJS_CODES.CODE EMPCONT_EJSCD_REL_CD_FK R
FK to ejs codes for relationship code
RELATIONSHIP_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EMPCONT_EJSCD_REL_CD_FK R
FK to ejs codes for relationship code type
ENC_CONTACT_NAME raw 224  √  null Employee contact name
START_DATE date 7  √  null Employee contact start date
END_DATE date 7  √  null Employee contact end date
COMMENTS varchar2 1000  √  null Employee contact comments
ENC_PHONE_NUMBER raw 32  √  null Employee contact phone number
ENC_EMAIL raw 224  √  null Employee contact email address
ADDRESS_ID number 0  √  null
ADDRESSES.ADDRESS_ID EMPCONT_ADDR_FK R
FK to addresses for employee contact address
EC_FLAG varchar2 1  √  null Y/N flag for emergency contact
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
"EJS_EMP_ID" IS NOT NULL EMPCONT_EMP_ID_NN
"ID" IS NOT NULL EMPCONT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc EMPCONT_PK
ADDRESS_ID Performance Asc EMPCONT_ADDR_FK_I
RELATIONSHIP_CODE_TYPE + RELATIONSHIP_CODE Performance Asc/Asc EMPCONT_EJSCD_REL_CD_FK_I
EJS_EMP_ID Performance Asc EMPCONT_EMP1_FK_I

Close relationships  within of separation: