Contains the relationship between a project and a user (client/specialist)
Data model
Fields
| Field | Type | Description |
|---|---|---|
| calendar_id | INT | Calendar ID for the project and specialist |
| profile_id | INT | Profile ID for the project and specialist |
| proj_id* | INT | Unique Project Identifier |
| type_id* | INT | Type identifier for the project and user (customer/specialist) |
| user_id* | INT | Unique user identifier |
Primary Key
| PX_ASMS_PROJECT_USER |
|---|
| proj_id, user_id, type_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| proj_id* | dbo.ASMS_PROJECTS | proj_id | FK01_ASMS_PROJECT_USER |
| user_id* | dbo.AFW_USERS | user_id | FK02_ASMS_PROJECT_USER |