Table: dbo.Employee_W4_Setting
Columns
NameTypeConstraintsDescription
employee_w4_setting_KEYint (4)NOT NULLPrimary key for this table
employee_KEYint (4)NOT NULLReference to employee
ste_state_code_KEYnvarchar (4)NOT NULLSTE state code
employee_w4_setting_guiduniqueidentifier (16)NOT NULLA unique GUID key for this row
Primary key
NameColumnsDescription
PK_Employee_W4_Settingemployee_w4_setting_KEY
Unique constraints
NameColumnsDescription
UK_Employee_W4_Setting$employee_KEY$ste_state_code_KEYemployee_KEY, ste_state_code_KEY
UK_Employee_W4_Setting$employee_w4_setting_guidemployee_w4_setting_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_W4_Setting__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Employee_W4_Setting__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Employee_W4_Setting_Parameter__Employee_W4_Setting__employee_w4_setting_KEYemployee_w4_setting_KEYEmployee_W4_Setting_Parameter

Schema diagram