Table: dbo.Employee_Tax_Jurisdiction
Columns
NameTypeConstraintsDescription
employee_tax_jurisdiction_KEYint (4)NOT NULLPrimary key for this table
employee_KEYint (4)NOT NULLReference to employee
tax_jurisdiction_KEYint (4)NOT NULLReference to tax jurisdiction
record_status_KEYint (4)NOT NULLThe status of the employee tax jurisdiction record.
Primary key
NameColumnsDescription
PK_Employee_Tax_Jurisdictionemployee_tax_jurisdiction_KEY
Unique constraints
NameColumnsDescription
UK_Employee_Tax_Jurisdiction$employee_KEY$tax_jurisdiction_KEYemployee_KEY, tax_jurisdiction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Tax_Jurisdiction__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Employee_Tax_Jurisdiction__Record_Status__record_status_KEYrecord_status_KEYRecord_Status (record_status_KEY)
FK_Employee_Tax_Jurisdiction__Tax_Jurisdiction__tax_jurisdiction_KEYtax_jurisdiction_KEYTax_Jurisdiction (tax_jurisdiction_KEY)

Schema diagram