Table slot9.WORLD.TSTA.EMP_SERVICE_HISTORIES
This table stores the history of service assigned to an employee
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
EMPSRVHST_ID number 38 Unique id for service history record.
START_DATE date 7  √  null Start Date of Promotion/Assignment/Termination.
END_DATE date 7  √  null End Date of Promotion/Assignment/Termination.
SERVICE_COMMENT varchar2 1000  √  null Comments about Promotion/Assignment/Termination.
CREATOR_DATE date 7  √  null Audit Trail information.
CREATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
UPDATOR_DATE date 7  √  null Audit Trail information.
UPDATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
EJS_EMP_ID number 30
EMPLOYEES.EJS_EMP_ID EMPSRVHST_EMP1_FK R
EJS sequence to uniquely identify an employee.
RANK_TITLE_CODE varchar2 5  √  null
EMP_RANK_TITLE_CODES.CODE EMPSRVHST_EMPRTC_FK R
SRV_ASSIGN_CODE varchar2 5  √  null
EMP_SERVICE_ASSIGN_CODES.CODE EMPSRVHST_EMPSRVASC_FK R
ASSIGN_CODE varchar2 30  √  null
ASSIGNMENT_SHIFT_CODES.SHIFT_CODE EMPSRVHST_ASSCD_FK R
EMP_CATCD_CAT_CODE varchar2 5  √  null
DUTY_STATION varchar2 255  √  null
REC_ID number 0  √  null
DATE_OF_INFO date 7  √  null Employee Service History record date of info

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"EJS_EMP_ID" IS NOT NULL EMPSRVHST_EJS_EMP_ID_NN
"EMPSRVHST_ID" IS NOT NULL EMPSRVHST_EMPSRVHST_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
EMPSRVHST_ID + EJS_EMP_ID Primary key Asc/Asc EMPSRVHST_PK
ASSIGN_CODE Performance Asc EMPSRVHST_ASCD_FK_I
EJS_EMP_ID Performance Asc EMPSRVHST_EMP1_FK_I
RANK_TITLE_CODE Performance Asc EMPSRVHST_EMPRTC_FK_I
SRV_ASSIGN_CODE Performance Asc EMPSRVHST_EMPSRVASC_FK_I

Close relationships  within of separation: