Table slot9.WORLD.TSTA.SALARY
Legacy table. 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
SALARY_ID number 38
EMPLOYEE_SALARY_VW.SALARY_ID Implied Constraint R
EMPLOYEE_ID number 38
EMPLOYEES.EJS_EMP_ID SALY_EMP_FK R
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE SALY_AGNCY_FK R
SALARY number 0  √  null
SALARY_START date 7  √  null
SALARY_END date 7  √  null
HR_MO_FLAG varchar2 1  √  null
VACATION number 0  √  null
SICK number 0  √  null
SUPERVISOR_ID number 38  √  null
EMPLOYEES.EJS_EMP_ID SALY_S_EMP_FK R
DUTY_STATION varchar2 255  √  null
OVERTIME_BONUS_FLAG varchar2 1  √  null
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
"AGENCY_CODE" IS NOT NULL SALY_AGENCY_CODE_NN
"EMPLOYEE_ID" IS NOT NULL SALY_EMPLOYEE_ID_NN
"SALARY_ID" IS NOT NULL SALY_SALARY_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
SALARY_ID Primary key Asc SALY_PK
AGENCY_CODE Performance Asc SALY_AG_FK_I
EMPLOYEE_ID Performance Asc SALY_EMP_FK_I
SUPERVISOR_ID Performance Asc SALY_S_EMP_FK_I

Close relationships  within of separation: