This is an old revision of the document!

Account_Address Table

The **Account_Address Table is a Link Table connecting the Account table with the Address table. There may be multiple entries in this table 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.