imapids

Module: messages

IMAP message identifiers for email deduplication.

Name	Type	Nullable	Default Value	Notes
mailserver mailservers.ID	integer
message messages.ID	integer
uidvalidity	bigint
uid	bigint
size	integer		0
date	bigint
mailbox	text

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
u_imapids_mailserver_size_date					btree	mailserver, size, date
u_imapids_mailserver_uidvalidity_mailbox_uid					btree	mailserver, uidvalidity, mailbox, uid
u_imapids_message					btree	message

Name	Type
dc_imapid_size	check
dc_imapids_mailbox	check
dc_imapids_uid	check
dc_imapids_uidvalidity	check
fk_imapids_mailserver	foreign_key
fk_imapids_message	foreign_key

Loading...