Contains the information of the specialists associated with the advanced shift
Data model
Fields
| Field | Type | Description |
|---|---|---|
| shift_id* | INT | Related Advanced Shift ID |
| user_id* | INT | Related Specialist Identifier |
Primary Key
| PK_ASMS_SHIFT_USER |
|---|
| user_id, shift_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| shift_id* | dbo.ASMS_ADVANCED_SHIFTS | id | FK01_ASMS_SHIFT_USER |
| user_id* | dbo.AFW_USERS | user_id | FK02_ASMS_SHIFT_USER |