Table: dbo.Client_N_Client_Service_Type | |||
Table to subscribe services that the client belongs to | |||
Columns | |||
Name | Type | Constraints | Description |
client_n_client_service_type_KEY | int (4) | NOT NULL | Primary key; service attributed to the client |
client_KEY | int (4) | NOT NULL | Foreign key; Associated client |
client_service_type_KEY | int (4) | NOT NULL | Foreign key; Associated type of service |
Primary key | |||
Name | Columns | Description | |
PK_Client_N_Client_Service_Type | client_n_client_service_type_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Client_N_Client_Service_Type$client_KEY$client_service_type_KEY | client_KEY, client_service_type_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Client_N_Client_Service_Type__Client__client_KEY | client_KEY | Client (client_KEY) | |
FK_Client_N_Client_Service_Type__Client_Service_Type__client_service_type_KEY | client_service_type_KEY | Client_Service_Type (client_service_type_KEY) |