Table: dbo.Zero_Hours_Code
This table stores the zero hours codes and their descriptions. These are explanations of why an employee may have wages without having any hours.
Columns
NameTypeConstraintsDescription
zero_hours_code_KEYtinyint (1)NOT NULLthe primary key of this table.
zero_hours_codenvarchar (4)NOT NULLThe zero hour code.
descriptionnvarchar (240)NOT NULLThe zero hours code description.
Primary key
NameColumnsDescription
PK_Zero_Hours_Codezero_hours_code_KEY
Unique constraints
NameColumnsDescription
UK_Zero_Hours_Code$zero_hours_codezero_hours_code
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Zero_Hours_Code__zero_hours_code_KEYzero_hours_code_KEYEmployee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override

Schema diagram