Table: Tax_Area_Taxing_Authority
Maps the relationship that Tax Areas are made up of a collection of Tax Authorities.
Columns
Name | Type | Constraints | Description
tax_area_taxing_authority_KEY | int | NOT NULL |
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
tax_area_KEY | int | NOT NULL | KEY value from the Tax Area table.
taxing_authority_KEY | int | NOT NULL | KEY value from the Tax Authority table.
create_date | datetime | NOT NULL |

Primary key
Name | Columns | Description
PK_Tax_Area_Taxing_Authority$tax_area_taxing_authority_KEY | tax_area_taxing_authority_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Tax_Area_Taxing_Authority__tax_area_KEY__taxing_authority_KEY | tax_area_KEY, taxing_authority_KEY |
Indexes
Name | Columns | Description
IX_Tax_Area_Taxing_Authority$taxing_authority_KEY | taxing_authority_KEY | Index supports foreign key FK_Tax_Area_Taxing_Authority__Taxing_Authority__taxing_authority_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Tax_Area_Taxing_Authority__Tax_Area__tax_area_KEY | tax_area_KEY | Tax_Area |
FK_Tax_Area_Taxing_Authority__Taxing_Authority__taxing_authority_KEY | taxing_authority_KEY | Taxing_Authority |