====== Account_Address Table ======

The **Account_Address Table** is a [[technical:table_types|Link Table]] connecting the [[Account]] table with the [[Address]] table.  This table may have multiple entries for each [[Account]].

^ field ^  Type  ^  NULL  ^
| Account_idAccount |  INT  |  NO  | FK - idAccount in the [[Account]] table |
| Address_idAddress |  INT  |  NO  | FK - idAddress in the [[Address]] table |
| correspondence |  TINYINT  |  YES  | Boolean - is this the correspondence address? |
| billing|  TINYINT  |  YES  | Boolean - is this the billing address? |

Note that only one correspondence address and one billing address are permitted.  These may both be the same address.