| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | int4 | 10 | √ | null |
|
|
Message ID |
|||||||
| owneruser | int4 | 10 | √ | null |
|
|
Owner user ID (PUBLIC if |
|||||||
| ownergroup | int4 | 10 | √ | null |
|
|
Owner group ID (PUBLIC if |
|||||||
| creator | int4 | 10 | √ | null |
|
|
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) |
||||||||
| mailserver | int4 | 10 | √ | null |
|
|
Mail server ID |
|||||||
| ticket | int4 | 10 | √ | null |
|
|
Ticket ID; is mutually exclusive to |
|||||||
| opportunity | int4 | 10 | √ | null |
|
|
Opportunity ID; is mutually exclusive to |
|||||||
| mailinglist | int4 | 10 | √ | null |
|
|
Mailing list ID |
|||||||
| reference | int4 | 10 | √ | null |
|
|
Reference message (reply-to) ID; must be distinct from |
|||||||
| binfile | int4 | 10 | √ | null |
|
|
||||||||
| mailbox | int2 | 5 | 0 |
|
|
Type ( |
||||||||
| date | int8 | 19 | date_part('epoch'::text, now()) |
|
|
Designated date and time as a Unix time stamp (defaults to current date and time on creation) |
||||||||
| subject | text | 2147483647 | ''::text |
|
|
Subject |
||||||||
| sender | text | 2147483647 | ''::text |
|
|
Sender name and e-mail address |
||||||||
| sender_email | text | 2147483647 | ''::text |
|
|
Sender e-mail address |
||||||||
| sender_name | text | 2147483647 | ''::text |
|
|
Sender name |
||||||||
| to | text | 2147483647 | ''::text |
|
|
All regular recipient names and e-mail addresses |
||||||||
| to_email | text | 2147483647 | ''::text |
|
|
First regular recipient e-mail address |
||||||||
| to_name | text | 2147483647 | ''::text |
|
|
First regular recipient name |
||||||||
| to_count | int4 | 10 | 0 |
|
|
Number of regular recipients |
||||||||
| cc | text | 2147483647 | ''::text |
|
|
All carbon copy recipient names and e-mail addresses |
||||||||
| bcc | text | 2147483647 | ''::text |
|
|
All blind carbon copy recipient names and e-mail addresses |
||||||||
| contenttype | text | 2147483647 | ''::text |
|
|
|||||||||
| size | int4 | 10 | 0 |
|
|
Size in bytes |
||||||||
| text | text | 2147483647 | ''::text |
|
|
Plain text version of content |
||||||||
| senddate | int8 | 19 | √ | null |
|
|
Scheduled send date and time as a Unix time stamp |
|||||||
| senderror | text | 2147483647 | ''::text |
|
|
Last error message from failure to send |
Table contained 0 rows
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk_messages | Primary key | Asc | ID |
| fk_messages_mailinglist | Performance | Asc | mailinglist |
| fk_messages_mailserver | Performance | Asc | mailserver |
| fk_messages_opportunity | Performance | Asc | opportunity |
| fk_messages_reference | Performance | Asc | reference |
| fk_messages_ticket | Performance | Asc | ticket |
| i_messages_date_ID | Performance | Desc/Desc | date + ID |
| i_messages_mailbox | Performance | Asc | mailbox |
| i_messages_noowner | Performance | Asc | ownergroup |
| i_messages_owner | Performance | Asc/Asc | owneruser + ownergroup |
| s_messages | Performance | Asc/Asc/Asc | subject + sender + to |
