| Table: dbo.Employee_W4_Setting | |||
| Columns | |||
| Name | Type | Constraints | Description |
| employee_w4_setting_KEY | int (4) | NOT NULL | Primary key for this table |
| employee_KEY | int (4) | NOT NULL | Reference to employee |
| ste_state_code_KEY | nvarchar (4) | NOT NULL | STE state code |
| employee_w4_setting_guid | uniqueidentifier (16) | NOT NULL | A unique GUID key for this row |
| Primary key | |||
| Name | Columns | Description | |
| PK_Employee_W4_Setting | employee_w4_setting_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Employee_W4_Setting$employee_KEY$ste_state_code_KEY | employee_KEY, ste_state_code_KEY | ||
| UK_Employee_W4_Setting$employee_w4_setting_guid | employee_w4_setting_guid | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Employee_W4_Setting__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) | |
| FK_Employee_W4_Setting__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) | |
| Incoming foreign keys | |||
| Name | Columns | Referencing table | Description |
| FK_Employee_W4_Setting_Parameter__Employee_W4_Setting__employee_w4_setting_KEY | employee_w4_setting_KEY | Employee_W4_Setting_Parameter | |