Represents the shift configuration where a group or associated user is available
Data model
Fields
| Field | Type | Description |
|---|---|---|
| calendar_id | INT | Related calendar ID, reference the ASMS_CALENDAR table. CALENDAR_ID |
| end_date | DATETIME | Shift End Date |
| group_id | INT | Related group identifier for the shift, reference the AFW_GROUPS.grou_id |
| id* | INT | Unique Shift Identifier |
| start_date | DATETIME | Shift Start Date |
| user_id | INT | Related user ID for the shift, reference table AFW_USERS.user_id |
Primary Key
| PK_ASMS_SHIFTS |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| calendar_id | dbo.ASMS_CALENDAR | calendar_id | FK03_ASMS_SHIFTS |
| group_id | dbo.AFW_GROUPS | grou_id | FK02_ASMS_SHIFTS |
| user_id | dbo.AFW_USERS | user_id | FK01_ASMS_SHIFTS |