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 Primary key Asc/Asc/Asc/Asc mailserver + mailbox + uidvalidity + uid
u_imapids_mailserver_hash Must be unique Asc/Asc mailserver + hash
u_imapids_message Must be unique Asc message

Relationships

Close relationships within degrees of separation