Table for recording the association of services with a certain company.
Data model
Fields
| Field | Type | Description |
|---|---|---|
| comp_id* | INT | Field with associated company ID record. |
| cose_id* | INT | Table primary key with table ID |
| serv_id* | INT | Field with associated service ID record. |
| sla_id* | INT | Field with associated service agreement level identifier record. |
Primary Key
| PK_AFLS_COMPANY_SERVICES |
|---|
| cose_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| comp_id* | dbo.AFLS_COMPANIES | comp_id | FK01_AFLS_COMPANY_SERVICES |
| serv_id* | dbo.AFLS_SERVICES | serv_id | FK02_AFLS_COMPANY_SERVICES |
| sla_id* | dbo.AFLS_SLA | sla_id | FK03_AFLS_COMPANY_SERVICES |