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 |