imapids


Columns

Column Type Size Nulls Auto Default Children Parents Comments
mailserver int4 10 null
mailservers.ID FK_imapids_mailserver C
mailbox text 2147483647 null
uidvalidity int4 10 null
uid int4 10 null
message int4 10 null
messages.ID FK_imapids_message N
hash varchar 32 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_imapids_mailserver_mailbox_uidvalidity_uid Primary key Asc/Asc/Asc/Asc mailserver + mailbox + uidvalidity + uid
UNQ_imapids_mailserver_hash Must be unique Asc/Asc mailserver + hash
UNQ_imapids_message Must be unique Asc message

Relationships