Intermediate table for provider-specialist partnership
Data model
Fields
| Field | Type | Description |
|---|---|---|
| providerid* | INT | Column that stores the related vendor ID. |
| specialistid* | INT | Column containing the identification of the related web user. |
Primary Key
| PK_AFLS_PROVIDER_SPECIALIST |
|---|
| providerid, specialistid |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| providerid* | dbo.AFLS_PROVIDERS | providerid | FK01_AFLS_PROVIDER_SPECIALIST |
| specialistid* | dbo.AFLS_USERS_SPECIALISTS | user_id | FK02_AFLS_PROVIDER_SPECIALIST |