Table: dbo.Record_Status
Generic status table that houses the types that define if a given record is active, inactive or virtually deleted.
Columns
NameTypeConstraintsDescription
record_status_KEYint (4)NOT NULLPrimary key for this table
descriptionnvarchar (40)NOT NULLThe status of a record. Active, Inactive or Deleted.
Primary key
NameColumnsDescription
PK_Record_Statusrecord_status_KEY
Unique constraints
NameColumnsDescription
UK_Record_Status$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client__Record_Status__record_status_KEYrecord_status_KEYClient
FK_Bank__Record_Status__record_status_KEYrecord_status_KEYBank
FK_Client_Benefit__Record_Status__record_status_KEYrecord_status_KEYClient_Benefit
FK_Client_Billing_Item__Record_Status__record_status_KEYrecord_status_KEYClient_Billing_Item
FK_Employee__Record_Status__record_status_KEYrecord_status_KEYEmployee
FK_Employee_Tax_Jurisdiction__Record_Status__record_status_KEYrecord_status_KEYEmployee_Tax_Jurisdiction
FK_Eftps_Transaction__Record_Status__record_status_KEYrecord_status_KEYEftps_Transaction

Schema diagram