Intermediate Table for Vendor Association with Groups
Data model
Fields
| Field | Type | Description |
|---|---|---|
| created_by_provider | BIT | Column for associating vendor ID |
| group_id* | INT | Column that contains the identification of the vendor-related group. |
| id* | INT | Primary Table Key |
| provider_id | INT | Column containing the identification of the supplier related to the group. |
Primary Key
| PK_AFLS_PROVIDER_GROUP |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| group_id* | dbo.AFW_GROUPS | grou_id | FK01_AFLS_PROVIDER_GROUP |