Affiliations and Best Times

This ERD (see the following figure) illustrates how contacts and accounts can be affiliated with one another, and how best times can be stored. Contacts can have multiple account affiliations, and can store multiple types or roles and best times for each account affiliation. Contacts can have multiple addresses and can share address records with other contacts. Contacts can also have a primary address for each position that is on the team. Accounts can also have multiple addresses and can share address records with other accounts. Contacts and accounts can share address records. Best times are stored for each address for each contact. Best times are also stored for each account.

The following table lists the entities in this ERD and their corresponding tables.

Entity	Table
Account Affiliation	S_PARTY_PER
Address	S_ADDR_PER
Address Usage	S_CON_ADDR
Best Times (Account)	S_BEST_CALL_HRS
Best Times (Account Affiliation)	S_PARTY_PER_HRS
Best Times (Contact Address)	S_CON_ADDR_HRS
Organization	S_ORG_EXT, S_PARTY
Person	S_CONTACT, S_PARTY
Person Position	S_POSTN_CON
Position	S_POSTN, S_PARTY
Type	S_PARTY_PER_DTL