email_folder table - SuperOffice

email_folder Table (492)

Corresponds to an email folder on a mail server

Fields

Name	Description	Type	Nullable
email_folder_id	Primary key	PK	No
account_id	Account id	FK email_account	Yes
parent_folder_id	Parent folder	FK email_folder	Yes
name	Folder name	String(255)	Yes
attributes	Folder attributes like Subscribed, HasChildren, Junk, Sent…	Int	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
folder_separator	Character separating subfolders	String(255)	Yes

email_folder table relationship diagram

Indexes

Fields	Types	Description
account_id	FK	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
email_account	Email account information
email_folder	Corresponds to an email folder on a mail server
email_item	Email data

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

email_account table emailfolder Cache Folder List What's new in version 10.3.11.910 What's new in version 10.3.12.929 What's new in version 10.3.2.841

⌘I