Table for detailed record of each supplier
Data model
Fields
| Field | Type | Description |
|---|---|---|
| creation_date | DATETIME | Date of creation |
| description* | NVARCHAR (500) | Column containing the description of the supplier |
| isactive* | BIT | Boolean to identify whether the provider is in an active or inactive state |
| isdeleted* | BIT | Boolean to identify if the provider is removed |
| name* | NVARCHAR (100) | Column that stores the vendor name |
| priority* | INT | Identification of the priority assigned to each supplier. 1 - Bronze, 2 - Silver, 3 - Gold |
| providerid* | INT | Primary Table Key |
| servicedefault* | BIT | Identification of the default service for each provider |
| type* | BIT | Identifying the type of supplier |
Primary Key
| PK_AFLS_PROVIDERS |
|---|
| providerid |