Table: dbo.Health_Plan_Type
Types of health plans available for payroll items.
Columns
NameTypeConstraintsDescription
health_plan_type_KEYint (4)NOT NULLPrimary key
descriptionnvarchar (40)NOT NULLContains the different health plan types such as individual or family.
Primary key
NameColumnsDescription
PK_Health_Plan_Typehealth_plan_type_KEY
Unique constraints
NameColumnsDescription
UK_Health_Plan_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Payroll_Item__Health_Plan_Type__health_plan_type_KEYhealth_plan_type_KEYClient_Payroll_Item
FK_Employee_Payroll_Item__Health_Plan_Type__health_plan_type_KEYhealth_plan_type_KEYEmployee_Payroll_Item

Schema diagram