| PKID | integer | plain | | | Mail server ID |
| owneruser | integer | plain | | users.ID | Owner user ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`) |
| ownergroup | integer | plain | | groups.ID | Owner group ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`) |
| creator | integer | plain | | users.ID | Creator user ID (defaults to authenticated user on creation) |
| creationdate | bigint | plain | | | Default: date_part('epoch', now())Creation date and time as a Unix timestamp (defaults to current date and time on creation) |
| lastmodified | bigint | plain | | | Default: date_part('epoch', now())Last modification date and time as a Unix timestamp (auto-reset on modification) |
| recipientuser | integer | plain | | users.ID | Recipient user ID (PUBLIC if `recipientuser`=`null` and `recipientgroup`=`null`) |
| recipientgroup | integer | plain | | groups.ID | Recipient group ID (PUBLIC if `recipientuser`=`null` and `recipientgroup`=`null`) |
| activity | smallint | plain | | | Default: 0Activity (`0`=ACTIVE, `1`=DEACTIVATED, `2`=DELETED) |
| name | text | main | | | Name |
| sender | text | main | | | Default: ''Sender name and e-mail address |
| serverin | text | extended | | | Default: ''Server (Inbound) |
| usernamein | text | extended | | | Default: ''Username (Inbound) |
| serverout | text | extended | | | Default: ''Server (Outbound) |
| usernameout | text | extended | | | Default: ''Username (Outbound) |
| description | text | extended | | | Default: ''Detailed general description |
| autoreplybinfile | integer | plain | | binfiles.ID | Binary file ID; is read-only (not for `PUT` or `PATCH`) |
| signaturebinfile | integer | plain | | binfiles.ID | Binary file ID; is read-only (not for `PUT` or `PATCH`) |
| ticketing | json | extended | | | JSON-encoded ticketing data (object) |
| folders | json | extended | | | JSON-encoded IMAP folders (object) |
| passwordin | bytea | extended | | | No description provided. |
| passwordout | bytea | extended | | | No description provided. |