| Table: dbo.Tax_Agent_Payment_Address | |||
| Holds payment addresses for tax agents and their payment types | |||
| Columns | |||
| Name | Type | Constraints | Description |
| tax_agent_payment_address_KEY | int (4) | NOT NULL | Primary key for this table |
| tax_agent_KEY | int (4) | NOT NULL | Reference to tax agent |
| address_KEY | int (4) | NOT NULL | Reference to address |
| addressee | nvarchar (100) | NOT NULL | Addressee to use instead of tax agent name; if it is blank, tax agent name should be used |
| Primary key | |||
| Name | Columns | Description | |
| PK_Tax_Agent_Payment_Address | tax_agent_payment_address_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Tax_Agent_Payment_Address$address_KEY | address_KEY | ||
| UK_Tax_Agent_Payment_Address$tax_agent_KEY | tax_agent_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Tax_Agent_Payment_Address__Address__address_KEY | address_KEY | Address (address_KEY) | |
| FK_Tax_Agent_Payment_Address__Tax_Agent__tax_agent_KEY | tax_agent_KEY | Tax_Agent (tax_agent_KEY) | |