Table: Tax_Area_Taxing_Authority
Maps the relationship that Tax Areas are made up of a collection of Tax Authorities.
Columns
NameTypeConstraintsDescription
tax_area_taxing_authority_KEYintNOT NULL
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
tax_area_KEYintNOT NULLKEY value from the Tax Area table.
taxing_authority_KEYintNOT NULLKEY value from the Tax Authority table.
create_date_utcdatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Tax_Area_Taxing_Authority$tax_area_taxing_authority_KEYtax_area_taxing_authority_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Tax_Area_Taxing_Authority$tax_area_KEY$taxing_authority_KEYtax_area_KEY, taxing_authority_KEY
Indexes
NameColumnsDescription
IX_Tax_Area_Taxing_Authority$taxing_authority_KEYtaxing_authority_KEYIndex supports foreign key FK_Tax_Area_Taxing_Authority__Taxing_Authority__taxing_authority_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_Area_Taxing_Authority__Tax_Area__tax_area_KEYtax_area_KEYTax_Area
FK_Tax_Area_Taxing_Authority__Taxing_Authority__taxing_authority_KEYtaxing_authority_KEYTaxing_Authority

Schema diagram