email_item table

email_item Table (494)

Email data

Name	Description	Type	Nullable
email_item_id	Primary key	PK	No
account_id	Account id	FK email_account	Yes
server_id	Email server id of this email item	Int	No
flags	Email flags - answered, deleted, seen, flagged, draft, recent…	Enum EMailFlags	Yes
email_folder_id	Folder this email is in on the imap server	FK email_folder	Yes
mime	Mime text	Clob	Yes
messageId	Email MessageId	String(512)	Yes
sent_at	Sent datetime from mime	DateTime	Yes
received_at	Received by email server	DateTime	Yes
subject	Email subject	String(255)	Yes
plain_body	Plain body text	Clob	Yes
html_body	Html body text	Clob	Yes
priority	Email priority	Enum EMailPriority	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No
has_attachment	Has attachment(s)	Bool	Yes
from	From address	String(4000)	Yes
to	To	String(4000)	Yes
size	The size of the email	Int	No
person_id	From person	FK person	Yes
contact_id	From company	FK contact	Yes
document_id	Archived document	FK document	Yes
appointment_id	Archived on appointment	FK appointment	Yes
sale_id	Archived on sale	FK sale	Yes
replied_at	When this email was replied to	DateTime	Yes
in_reply_to	In reply to, a message-id, used for threading	String(512)	Yes
cc	Cc	String(4000)	Yes
cal_data	Calendar data	Clob	Yes
server_identifier	Server identifier of this email item (GraphApi uses string Id’s)	String(1024)	No

Table	Description
appointment	Tasks, appointments, followups, phone calls; and documents (document_id != 0). An appointment always has a corresponding record in VisibleFor specifying who may see this.
associate	Employees, resources and other users - except for External persons
contact	Companies and Organizations.
document	Documents, this table is an extension of the Appointment table. There is always a corresponding appointment record; the relation between appointment and document is navigable in both directions. A document-type appointment record always has a corresponding document record and a record in VisibleFor specifying who may see this.
email_account	Email account information
email_attachment	Attachment info related to an email_item
email_folder	Corresponds to an email folder on a mail server
person	Persons
sale	Sales For every Sale record edited through the SuperOffice GUI, a copy of the current version of the record will be saved in the SaleHist table. This also applies to editing done through the SaleModel COM interface, but not to editing done through the OLE DB Provider or other channels.