Table: dbo.Client_Inactive_Reason
Columns
NameTypeConstraintsDescription
client_inactive_reason_KEYint (4)NOT NULLPrimary key for table.
descriptionnvarchar (60)NOT NULLDescription of why client is no longer active.
Primary key
NameColumnsDescription
PK_Client_Inactive_Reasonclient_inactive_reason_KEY
Unique constraints
NameColumnsDescription
UK_Client_Inactive_Reason$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client__Client_Inactive_Reason__client_inactive_reason_KEYclient_inactive_reason_KEYClient

Schema diagram