Contains the information of time slots of the advanced shifts for the assignment of specialists
Data model
Fields
| Field | Type | Description |
|---|---|---|
| end_date | DATETIME | Time slot end date |
| end_time | TIME | End time of the time slot |
| id* | INT | Unique identifier for advanced shift hours |
| start_date | DATETIME | Time slot start date |
| start_time | TIME | Time slot start time |
Primary Key
| PK_ASMS_SHIFT_STRIP |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| shift_id* | dbo.ASMS_ADVANCED_SHIFTS | id | FK01_ASMS_SHIFT_STRIP |