Table: dbo.Affordable_Care_Act_Employee_Status
This table stores the employee status allowed for selection with regard to affordable care act information
Columns
NameTypeConstraintsDescription
affordable_care_act_employee_status_KEYtinyint (1)NOT NULLThe primary key.
descriptionnvarchar (60)NOT NULLThe description.
Primary key
NameColumnsDescription
PK_Affordable_Care_Act_Employee_Statusaffordable_care_act_employee_status_KEY
Unique constraints
NameColumnsDescription
UK_Affordable_Care_Act_Employee_Status$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Employee__Affordable_Care_Act_Employee_Status__affordable_care_act_employee_status_KEYaffordable_care_act_employee_status_KEYEmployee

Schema diagram