Table: Tax_Area
A Tax Area is a collection of Taxing Authorites. This holds the list of Tax Areas the Firm has setup.
Columns
NameTypeConstraintsDescription
tax_area_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
descriptionnvarchar (250)NOT NULLDescribes a Tax Area
create_date_utcdatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Tax_Area$tax_area_KEYtax_area_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Tax_Area$descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Tax_Area_Taxing_Authority__Tax_Area__tax_area_KEYtax_area_KEYTax_Area_Taxing_Authority
FK_Engagement__Tax_Area__tax_area_KEYtax_area_KEYEngagement

Schema diagram