| 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 | ||