Table: dbo.Client_Service_Type
Table to name the services that the client can subscribe to
Columns
NameTypeConstraintsDescription
client_service_type_KEYint (4)NOT NULLPrimary key; type key
descriptionnvarchar (60)NOT NULLtype description
Primary key
NameColumnsDescription
PK_Client_Service_Typeclient_service_type_KEY
Unique constraints
NameColumnsDescription
UK_Client_Service_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_N_Client_Service_Type__Client_Service_Type__client_service_type_KEYclient_service_type_KEYClient_N_Client_Service_Type

Schema diagram