Table: dbo.Employee_Tax_Jurisdiction
Columns
Name | Type | Constraints | Description
employee_tax_jurisdiction_KEY | int (4) | NOT NULL | Primary key for this table
employee_KEY | int (4) | NOT NULL | Reference to employee
tax_jurisdiction_KEY | int (4) | NOT NULL | Reference to tax jurisdiction
record_status_KEY | int (4) | NOT NULL | The status of the employee tax jurisdiction record.

Primary key
Name | Columns | Description
PK_Employee_Tax_Jurisdiction | employee_tax_jurisdiction_KEY |
Unique constraints
Name | Columns | Description
UK_Employee_Tax_Jurisdiction$employee_KEY$tax_jurisdiction_KEY | employee_KEY, tax_jurisdiction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Tax_Jurisdiction__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |
FK_Employee_Tax_Jurisdiction__Record_Status__record_status_KEY | record_status_KEY | Record_Status (record_status_KEY) |
FK_Employee_Tax_Jurisdiction__Tax_Jurisdiction__tax_jurisdiction_KEY | tax_jurisdiction_KEY | Tax_Jurisdiction (tax_jurisdiction_KEY) |