Table: dbo.Client_N_Client_Service_Type
Table to subscribe services that the client belongs to
Columns
NameTypeConstraintsDescription
client_n_client_service_type_KEYint (4)NOT NULLPrimary key; service attributed to the client
client_KEYint (4)NOT NULLForeign key; Associated client
client_service_type_KEYint (4)NOT NULLForeign key; Associated type of service
Primary key
NameColumnsDescription
PK_Client_N_Client_Service_Typeclient_n_client_service_type_KEY
Unique constraints
NameColumnsDescription
UK_Client_N_Client_Service_Type$client_KEY$client_service_type_KEYclient_KEY, client_service_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_N_Client_Service_Type__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_N_Client_Service_Type__Client_Service_Type__client_service_type_KEYclient_service_type_KEYClient_Service_Type (client_service_type_KEY)

Schema diagram