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