Table: dbo.Tax_Agent_Payment_Address
Holds payment addresses for tax agents and their payment types
Columns
NameTypeConstraintsDescription
tax_agent_payment_address_KEYint (4)NOT NULLPrimary key for this table
tax_agent_KEYint (4)NOT NULLReference to tax agent
address_KEYint (4)NOT NULLReference to address
addresseenvarchar (100)NOT NULLAddressee to use instead of tax agent name; if it is blank, tax agent name should be used
Primary key
NameColumnsDescription
PK_Tax_Agent_Payment_Addresstax_agent_payment_address_KEY
Unique constraints
NameColumnsDescription
UK_Tax_Agent_Payment_Address$address_KEYaddress_KEY
UK_Tax_Agent_Payment_Address$tax_agent_KEYtax_agent_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_Agent_Payment_Address__Address__address_KEYaddress_KEYAddress (address_KEY)
FK_Tax_Agent_Payment_Address__Tax_Agent__tax_agent_KEYtax_agent_KEYTax_Agent (tax_agent_KEY)

Schema diagram