mail_in_uidl table - SuperOffice

mail_in_uidl Table (272)

This table is used to avoid spamming the system by importing the same message several times (normally a result of a crash somewhere). When a mailbox is openede, then unique id for each message is stored in this table, and then removed only when the message has been correctly imported and deleted from mailbox.

Fields

Name	Description	Type	Nullable
id	Primary key	PK	No
filter_id	The mailbox for this UIDL entry.	FK mail_in_filter	No
uidl	The actual UIDL (i.e. the unique string identifying a specific message).	String(2047)	Yes
last_checked	The last time this message was attempted to be imported.	DateTime	Yes
status	The status of this UIDL entry (enum).	status	Yes
retries	The number of attempts for importing this message.	Int	Yes

Indexes

Fields	Types	Description
filter_id	FK	Index

Relationships

Table	Description
mail_in_filter	This table contains entries for the mailboxes the eJournal system is fetching mail from (POP3 or IMAP).

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

mail_in_filter table inbox table What's new in version 10.1.2.686 What's new in version 10.1.5 What's new in version 10.2.1.1517 What's new in version 10.2.2.707

⌘I