Table that stores the relationship between customer and project in the integration.
Data model
Fields
| Field | Type | Description |
|---|---|---|
| project_id* | INT | Project ID |
| user_id* | INT | Customer ID |
Primary Key
| PK_AFLS_CLIENTS_PROJECTS |
|---|
| user_id, project_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| project_id* | dbo.AFLS_JSONSCHEMA_ASMS | project_asms_id | FK01_AFLS_CLIENTS_PROJECTS |
| user_id* | dbo.AFLS_USERS_CLIENTS | user_id | FK02_AFLS_CLIENTS_PROJECTS |