The Association table stores the associations between accounts and other accounts, and contacts and other contacts. These associations are found on the Association tab in the Account and Contact Detail views. Associations can identify a personal or business connection between accounts and/or contacts.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
ASSOCIATIONID (PK) |
STANDARDID |
NOT NULL |
ASSOCIATION_ASSOCIATIONID_PK (CA) |
|
|
|
ACCOUNTASSOCIATION |
BOOLEAN |
NULLS |
|
|
|
|
FROMID (FK) |
STANDARDID |
NOT NULL |
ASSOCIATION_FROMID (IE) |
(Many) to (One) |
|
|
(Many) to (One) |
|||||
|
TOID (FK) |
STANDARDID |
NOT NULL |
ASSOCIATION_TOID (IE) |
(Many) to (One) |
|
|
(Many) to (One) |
|||||
|
FORWARDRELATION |
varchar(64) |
NULLS |
|
|
|
|
BACKRELATION |
varchar(64) |
NULLS |
|
|
|
|
FORWARDNOTES |
varchar(128) |
NULLS |
|
|
|
|
BACKNOTES |
varchar(128) |
NULLS |
|
|
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |