The Account_Address Table is a 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.