Table: dbo.Tax_Agent_Form_Filing_Address
Table for all the current form filing address for the tax agents.
Columns
NameTypeConstraintsDescription
tax_agent_form_filing_address_KEYint (4)NOT NULLPrimary Key
tax_agent_KEYint (4)NOT NULLForeign key to the related tax agent.
tax_form_KEYint (4)NOT NULLForeign key to the related tax form.
address_KEYint (4)NOT NULLForeign key to the address table.
tax_agent_form_filing_address_scenario_KEYint (4)NOT NULLForeign key to the tax agent form filing address scenario type table.
addresseenvarchar (200)NOT NULLThe name of the addressee for this address.
Primary key
NameColumnsDescription
PK_Tax_Agent_Form_Filing_Addresstax_agent_form_filing_address_KEY
Unique constraints
NameColumnsDescription
UK_Tax_Agent_Form_Filing_Address$tax_agent_KEY$tax_form_KEY$tax_agent_form_filing_address_scenario_KEYtax_agent_KEY, tax_form_KEY, tax_agent_form_filing_address_scenario_KEY
UK_Tax_Agent_Form_Filing_Address$address_KEYaddress_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_Agent_Form_Filing_Address__Address__address_KEYaddress_KEYAddress (address_KEY)
FK_Tax_Agent_Form_Filing_Address__Tax_Agent__tax_agent_KEYtax_agent_KEYTax_Agent (tax_agent_KEY)
FK_Tax_Agent_Form_Filing_Address__Tax_Agent_Form_Filing_Address_Scenario__tax_agent_form_filing_address_scenario_KEYtax_agent_form_filing_address_scenario_KEYTax_Agent_Form_Filing_Address_Scenario (tax_agent_form_filing_address_scenario_KEY)
FK_Tax_Agent_Form_Filing_Address__Tax_Form__tax_form_KEYtax_form_KEYTax_Form (tax_form_KEY)

Schema diagram