Column Type Size Nulls Auto Default Children Parents Comments
ID int4 10 null
imapids.mailserver fk_imapids_mailserver C
messages.mailserver fk_messages_mailserver N

Mail server ID

owneruser int4 10 null
users.ID fk_mailservers_owneruser C

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)

ownergroup int4 10 null
groups.ID fk_mailservers_ownergroup C

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)

creator int4 10 null
users.ID fk_mailservers_creator N

Creator user ID (defaults to authenticated user on creation)

creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)

recipientuser int4 10 null
users.ID fk_mailservers_recipientuser N

Recipient user ID (PUBLIC if recipientuser=null and recipientgroup=null)

recipientgroup int4 10 null
groups.ID fk_mailservers_recipientgroup N

Recipient group ID (PUBLIC if recipientuser=null and recipientgroup=null)

autoreplybinfile int4 10 null
signaturebinfile int4 10 null
activity int2 5 0


name text 2147483647 null


sender text 2147483647 ''::text

Sender name and e-mail address

serverin text 2147483647 ''::text

Server (Inbound)

usernamein text 2147483647 ''::text

Username (Inbound)

passwordin text 2147483647 ''::text
serverout text 2147483647 ''::text

Server (Outbound)

usernameout text 2147483647 ''::text

Username (Outbound)

passwordout text 2147483647 ''::text
description text 2147483647 ''::text

Detailed general description

ticketing json 2147483647 null
folders json 2147483647 null

Table contained 0 rows


Constraint Name Type Sort Column(s)
pk_mailservers Primary key Asc ID
i_mailservers_noowner Performance Asc ownergroup
i_mailservers_owner Performance Asc/Asc owneruser + ownergroup
s_mailservers Performance Asc/Asc/Asc/Asc name + sender + serverin + serverout