contact
Stores contact details for individuals, including names, roles, communication preferences, and associated accounts.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | The unique internal identifier for the contact record. | |
| altemail | String | The alternative email address associated with the contact. | |
| assistant | String | The assistant or secondary contact associated with the contact. | |
| category | String | The category assigned to the contact, such as customer, prospect, or partner. | |
| comments | String | Additional comments or notes related to the contact. | |
| company | String | The company or organization associated with the contact. | |
| contactcampaignevent | String | The campaign event associated with the contact. | |
| contactsource | String | The source from which the contact was acquired, such as a referral or marketing campaign. | |
| contactsourcecampaigncategory | String | The campaign category associated with the contact source. | |
| datecreated | Date | The date when the contact record was created. | |
| defaultbillingaddress | String | The default billing address for the contact. | |
| defaultshippingaddress | String | The default shipping address for the contact. | |
| duplicate | Boolean | Indicates whether the contact record is a duplicate of another. | |
| String | The primary email address associated with the contact. | ||
| entityid | String | The identifier of the entity (customer, vendor, etc.) associated with the contact. | |
| entitytitle | String | The title or name/ID associated with the entity. | |
| externalid | String | A unique external identifier for referencing the contact in external systems. | |
| firstname | String | The first name of the contact. | |
| globalsubscriptionstatus | String | The global subscription status of the contact, indicating whether they are subscribed or unsubscribed. | |
| isinactive | Boolean | Indicates whether the contact is inactive. | |
| isprivate | Boolean | Indicates whether the contact's information is marked as private. | |
| lastmodifieddate | Date | The date when the contact record was last modified. | |
| lastname | String | The last name of the contact. | |
| middlename | String | The middle name of the contact. | |
| phoneticname | String | The phonetic version of the contact's name, often used for pronunciation (for example, Furigana). | |
| salutation | String | The salutation used for the contact, such as Mr. or Ms. | |
| title | String | The job title or position held by the contact. |