Table: dbo.Active_Status
This table stores the values to be used for showing the Status values for various entities.
Columns
NameTypeConstraintsDescription
active_status_KEYtinyint (1)NOT NULLThe primary key.
descriptionnvarchar (16)NOT NULLThe description.
Primary key
NameColumnsDescription
PK_Active_Statusactive_status_KEY
Unique constraints
NameColumnsDescription
UK_Active_Status$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Pay_Schedule$active_status_KEYactive_status_KEYClient_Pay_Schedule

Schema diagram