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_utc | 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_utc | 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 |