Table: dbo.Tax_Agent_Form_Filing_Address
Table for all the current form filing address for the tax agents.
Columns
Name | Type | Constraints | Description
tax_agent_form_filing_address_KEY | int (4) | NOT NULL | Primary Key
tax_agent_KEY | int (4) | NOT NULL | Foreign key to the related tax agent.
tax_form_KEY | int (4) | NOT NULL | Foreign key to the related tax form.
address_KEY | int (4) | NOT NULL | Foreign key to the address table.
tax_agent_form_filing_address_scenario_KEY | int (4) | NOT NULL | Foreign key to the tax agent form filing address scenario type table.
addressee | nvarchar (200) | NOT NULL | The name of the addressee for this address.

Primary key
Name | Columns | Description
PK_Tax_Agent_Form_Filing_Address | tax_agent_form_filing_address_KEY |
Unique constraints
Name | Columns | Description
UK_Tax_Agent_Form_Filing_Address$tax_agent_KEY$tax_form_KEY$tax_agent_form_filing_address_scenario_KEY | tax_agent_KEY, tax_form_KEY, tax_agent_form_filing_address_scenario_KEY |
UK_Tax_Agent_Form_Filing_Address$address_KEY | address_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Tax_Agent_Form_Filing_Address__Address__address_KEY | address_KEY | Address (address_KEY) |
FK_Tax_Agent_Form_Filing_Address__Tax_Agent__tax_agent_KEY | tax_agent_KEY | Tax_Agent (tax_agent_KEY) |
FK_Tax_Agent_Form_Filing_Address__Tax_Agent_Form_Filing_Address_Scenario__tax_agent_form_filing_address_scenario_KEY | tax_agent_form_filing_address_scenario_KEY | Tax_Agent_Form_Filing_Address_Scenario (tax_agent_form_filing_address_scenario_KEY) |
FK_Tax_Agent_Form_Filing_Address__Tax_Form__tax_form_KEY | tax_form_KEY | Tax_Form (tax_form_KEY) |