Table slot9.WORLD.TSTA.SCHEDULES
This table stores schedules created in the scheduling module in the application
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
SCHEDULE_ID number 0
EMP_SCHEDULES.SCHEDULE_ID ES1_SCHED_FK R
START_DATE date 7  √  null
END_DATE date 7  √  null
MONDAY varchar2 1
MON_START_TIME date 7  √  null
MON_END_TIME date 7  √  null
SCHEDULE_TYPE_CODE varchar2 30
EJS_CODES.CODE SCHED_SCHEDULE_TYP_EJS_CODE_FK R
TUESDAY varchar2 1
TUE_START_TIME date 7  √  null
TUE_END_TIME date 7  √  null
WEDNESDAY varchar2 1
WED_START_TIME date 7  √  null
WED_END_TIME date 7  √  null
THURSDAY varchar2 1
THU_START_TIME date 7  √  null
THU_END_TIME date 7  √  null
FRIDAY varchar2 1
FRI_START_TIME date 7  √  null
FRI_END_TIME date 7  √  null
SATURDAY varchar2 1
SAT_START_TIME date 7  √  null
SAT_END_TIME date 7  √  null
SUNDAY varchar2 1
SUN_START_TIME date 7  √  null
SUN_END_TIME date 7  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
MONTHLY_OCCUR_CODE varchar2 30  √  null
EJS_CODES.CODE SCHED_MONTHLY_OCCU_EJS_CODE_FK R
MONTHLY_OCCUR_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE SCHED_MONTHLY_OCCU_EJS_CODE_FK R
SCHEDULE_TYPE_CODE_TYPE varchar2 30  √  'SCHEDULE_TYPE_CODES'
EJS_CODES.CODE_TYPE SCHED_SCHEDULE_TYP_EJS_CODE_FK R
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
FRIDAY IN ('Y', 'N') CK_SCHED_FRIDAY
MONDAY IN ('Y', 'N') CK_SCHED_MONDAY
SATURDAY IN ('Y', 'N') CK_SCHED_SATURDAY
SUNDAY IN ('Y', 'N') CK_SCHED_SUNDAY
THURSDAY IN ('Y', 'N') CK_SCHED_THURSDAY
TUESDAY IN ('Y', 'N') CK_SCHED_TUESDAY
WEDNESDAY IN ('Y', 'N') CK_SCHED_WEDNESDAY
"FRIDAY" IS NOT NULL SCHED_FRIDAY_NN
"MONDAY" IS NOT NULL SCHED_MONDAY_NN
"SATURDAY" IS NOT NULL SCHED_SATURDAY_NN
"SCHEDULE_ID" IS NOT NULL SCHED_SCHEDULE_ID_NN
"SCHEDULE_TYPE_CODE" IS NOT NULL SCHED_SCHEDULE_TYPE_CODE_NN
"SUNDAY" IS NOT NULL SCHED_SUNDAY_NN
"THURSDAY" IS NOT NULL SCHED_THURSDAY_NN
"TUESDAY" IS NOT NULL SCHED_TUESDAY_NN
"WEDNESDAY" IS NOT NULL SCHED_WEDNESDAY_NN

Indexes:
Column(s) Type Sort Constraint Name
SCHEDULE_ID Primary key Asc SCHED_PK
MONTHLY_OCCUR_CODE Performance Asc SCHED_MOCD_FK_I
MONTHLY_OCCUR_CODE_TYPE + MONTHLY_OCCUR_CODE Performance Asc/Asc SCHED_MONTHLY_OCCU_EJS_CODE_I
SCHEDULE_TYPE_CODE_TYPE + SCHEDULE_TYPE_CODE Performance Asc/Asc SCHED_SCHEDULE_TYP_EJS_CODE_I
SCHEDULE_TYPE_CODE Performance Asc SCHED_STC2_FK_I

Close relationships  within of separation: