Column Type Size Nulls Auto Default Children Parents Comments
ID serial 10 nextval('"mailservers_ID_seq"'::regclass)
imapids.mailserver FK_imapids_mailserver C
messages.mailserver FK_messages_mailserver N
owneruser int4 10 null
users.ID FK_mailservers_owneruser C

The owner user

ownergroup int4 10 null
groups.ID FK_mailservers_ownergroup C

The owner group (if owneruser and ownergroup are NULL, the element is public)

creator int4 10 null
users.ID FK_mailservers_creator N

The object creator

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

Last modification date/time (Unix timestamp in seconds)

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

Last modification date/time (Unix timestamp in seconds)

recipientuser int4 10 null
users.ID FK_mailservers_recipientuser N
recipientgroup int4 10 null
groups.ID FK_mailservers_recipientgroup N
activity int2 5 0

0: Active, 1: Deactivated

name text 2147483647 null
sender text 2147483647 ''::text
serverin text 2147483647 ''::text
usernamein text 2147483647 ''::text
passwordin text 2147483647 ''::text
serverout text 2147483647 ''::text
usernameout text 2147483647 ''::text
passwordout text 2147483647 ''::text
description text 2147483647 ''::text

The general description field

autoreplybinfile int4 10 null
signaturebinfile int4 10 null
ticketing json 2147483647 null
folders json 2147483647 null

Table contained 0 rows


Constraint Name Type Sort Column(s)
PK_mailservers_ID Primary key Asc ID