Table for recording the association of services with a specific customer.
Data model
Fields
| Field | Type | Description |
|---|---|---|
| clie_id* | INT | Identifier of the client to be associated with the different services. |
| clse_id* | INT | Table primary key with table ID |
| cose_id | INT | Identifier of the customer to be associated with service by company. |
| serv_id* | INT | Identifier of the associated service. |
| sla_id* | INT | Associated service level agreement identifier. |
Primary Key
| PK_AFLS_CLIENT_SERVICES |
|---|
| clse_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| clie_id* | dbo.AFLS_USERS_CLIENTS | user_id | FK01_AFLS_CLIENT_SERVICES |
| cose_id | dbo.AFLS_COMPANY_SERVICES | cose_id | FK02_AFLS_CLIENT_SERVICES |
| serv_id* | dbo.AFLS_SERVICES | serv_id | FK04_AFLS_CLIENT_SERVICES |
| sla_id* | dbo.AFLS_SLA | sla_id | FK03_AFLS_CLIENT_SERVICES |