Table to store vendor assignment shift settings
Data model
Fields
| Field | Type | Description |
|---|---|---|
| id* | INT | Primary Table Key |
| lastassing* | DATETIME | Column for Last Assignment Date Record |
| providerid* | INT | Column that contains the vendor ID related to the vendor shift assignment. |
| serviceid* | INT | Column that contains the service ID related to vendor shift assignment. |
Primary Key
| PK_AFLS_PROVIDER_ASSING_TURN |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| providerid* | dbo.AFLS_PROVIDERS | providerid | FK01_AFLS_PROVIDER_ASSING_TURN |
| serviceid* | dbo.AFLS_SERVICES | serv_id | FK02_AFLS_PROVIDER_ASSING_TURN |