| Table slot9.WORLD.TSTA.EMP_SCHEDULES This table stores the association between an employee and a schedule
|
| ||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | ||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "EJS_EMP_ID" IS NOT NULL | ES1_EJS_EMP_ID_NN |
| "SCHEDULE_ID" IS NOT NULL | ES1_SCHEDULE_ID_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| EJS_EMP_ID + SCHEDULE_ID | Primary key | Asc/Asc | ES1_PK |
| EJS_EMP_ID | Performance | Asc | ES1_EMP1_FK_I |
| SCHEDULE_ID | Performance | Asc | ES1_SCHED_FK_I |
|