mailservers
Email server configurations for sending and receiving.
| Name | Type | Nullable | Default Value | Notes |
|---|---|---|---|---|
PKID | integer | Mail server ID | ||
owneruser users.ID | integer | Owner user ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`) | ||
ownergroup groups.ID | integer | Owner group ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`) | ||
creator | integer | Creator user ID (defaults to authenticated user on creation) | ||
creationdate | bigint | date_part('epoch', now()) | Creation date and time as a Unix timestamp (defaults to current date and time on creation) | |
lastmodified | bigint | date_part('epoch', now()) | Last modification date and time as a Unix timestamp (auto-reset on modification) | |
recipientuser users.ID | integer | Recipient user ID (PUBLIC if `recipientuser`=`null` and `recipientgroup`=`null`) | ||
recipientgroup groups.ID | integer | Recipient group ID (PUBLIC if `recipientuser`=`null` and `recipientgroup`=`null`) | ||
autoreplybinfile binfiles.ID | integer | Binary file ID; is read-only (not for `PUT` or `PATCH`) | ||
signaturebinfile binfiles.ID | integer | Binary file ID; is read-only (not for `PUT` or `PATCH`) | ||
activity | smallint | 0 | Activity (`0`=ACTIVE, `1`=DEACTIVATED, `2`=DELETED) | |
name | text | Name | ||
sender | text | '' | Sender name and e-mail address | |
serverin | text | '' | Server (Inbound) | |
usernamein | text | '' | Username (Inbound) | |
serverout | text | '' | Server (Outbound) | |
usernameout | text | '' | Username (Outbound) | |
description | text | '' | Detailed general description | |
ticketing | json | JSON-encoded ticketing data (object) | ||
folders | json | JSON-encoded IMAP folders (object) | ||
passwordin | bytea | |||
passwordout | bytea |
| Name | Unique | Nulls Distinct | Primary | Partial | Method | Keys |
|---|---|---|---|---|---|---|
| fk_mailservers_autoreplybinfile | btree | autoreplybinfile | ||||
| fk_mailservers_ownergroup | gin | ownergroup | ||||
| fk_mailservers_owneruser | gin | owneruser | ||||
| fk_mailservers_signaturebinfile | btree | signaturebinfile | ||||
| i_mailservers_noowner | gin | ownergroup | ||||
| pk_mailservers | btree | ID | ||||
| s_mailservers_name | gin | name | ||||
| s_mailservers_sender | gin | sender | ||||
| s_mailservers_serverin | gin | serverin | ||||
| s_mailservers_serverout | gin | serverout |
| Name | Type |
|---|---|
| c_mailservers_owner | check |
| c_mailservers_recipient | check |
| dc_mailservers_activity | check |
| dc_mailservers_description | check |
| dc_mailservers_folders | check |
| dc_mailservers_name | check |
| dc_mailservers_sender | check |
| dc_mailservers_serverin | check |
| dc_mailservers_serverout | check |
| dc_mailservers_ticketing | check |
| dc_mailservers_usernamein | check |
| dc_mailservers_usernameout | check |
| fk_mailservers_autoreplybinfile | foreign_key |
| fk_mailservers_ownergroup | foreign_key |
| fk_mailservers_owneruser | foreign_key |
| fk_mailservers_recipientgroup | foreign_key |
| fk_mailservers_recipientuser | foreign_key |
| fk_mailservers_signaturebinfile | foreign_key |
| pk_mailservers | primary_key |
Loading...