messages


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID serial 10 nextval('"messages_ID_seq"'::regclass)
imapids.message FK_imapids_message N
messagereads.message FK_messagereads_message C
messages.reference FK_messages_reference N
owneruser int4 10 null
users.ID FK_messages_owneruser C

The owner user

ownergroup int4 10 null
groups.ID FK_messages_ownergroup C

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

creator int4 10 null
users.ID FK_messages_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)

mailserver int4 10 null
mailservers.ID FK_messages_mailserver N
ticket int4 10 null
tickets.ID FK_messages_ticket N

Reference to the associated ticket

opportunity int4 10 null
opportunities.ID FK_messages_opportunity N
mailinglist int4 10 null
mailinglists.ID FK_messages_mailinglist N
reference int4 10 null
messages.ID FK_messages_reference N
mailbox int2 5 0

0: Inbox, 1: Drafts, 2: Sent, 3: Templates, 4: Mailings, 5: Archive, 6: Trash, 7: Junk

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

Unix timestamp in seconds

subject text 2147483647 ''::text
sender text 2147483647 ''::text
sender_email text 2147483647 ''::text
sender_name text 2147483647 ''::text
to text 2147483647 ''::text
to_email text 2147483647 ''::text
to_name text 2147483647 ''::text
to_count int4 10 0
cc text 2147483647 ''::text
bcc text 2147483647 ''::text
contenttype text 2147483647 ''::text
size int4 10 0
text text 2147483647 ''::text
senddate int8 19 null
senderror text 2147483647 ''::text
binfile int4 10 null

Table contained 0 rows

Indexes

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

Relationships