imapids - ZeyOS Schema Documentation

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 6 of 6 entries

Table contained 0 rows

Indexes

Search:

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

Showing 1 to 3 of 3 entries

Relationships

Close relationships within degrees of separation

One
Two degrees