Table: dbo.Work_Location_Tax_Jurisdiction
Columns
NameTypeConstraintsDescription
work_location_tax_jurisdiction_KEYint (4)NOT NULLPrimary key for this table
work_location_KEYint (4)NOT NULLReference to work location
tax_jurisdiction_KEYint (4)NOT NULLReference to tax jurisdiction
Primary key
NameColumnsDescription
PK_Work_Location_Tax_Jurisdictionwork_location_tax_jurisdiction_KEY
Unique constraints
NameColumnsDescription
UK_Work_Location_Tax_Jurisdiction$work_location_KEY$tax_jurisdiction_KEYwork_location_KEY, tax_jurisdiction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Work_Location_Tax_Jurisdiction__Tax_Jurisdiction__tax_jurisdiction_KEYtax_jurisdiction_KEYTax_Jurisdiction (tax_jurisdiction_KEY)
FK_Work_Location_Tax_Jurisdiction__Work_Location__work_location_KEYwork_location_KEYWork_Location (work_location_KEY)

Schema diagram