TABLES
6
VIEWS
4
COLUMNS
60
Constraints
5
Anomalies
1
Routines
0
Database Properties
Database Type: PostgreSQL - 9.5.15
Schema _outgoing
Odyssey Outgoing - Transactional mail sending
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| mail_attachment | 0 | 1 | 7 | 2298 | Table | |
| mail_recipient | 0 | 2 | 4 | 331632 | Table | |
| mail_recipient_type | 1 | 0 | 1 | 4 | Table | |
| mail_message | 8 | 0 | 10 | 306433 | Table | |
| mail_message_loopback | 0 | 1 | 2 | 415894 | Table | |
| mail_message_sent | 0 | 1 | 2 | 416111 | Table | |
| mail_message_sent_most_recent | 0 | 1 | 3 | 0 | View | |
| mail_message_loopback_most_recent | 0 | 1 | 3 | 0 | View | |
| mail_message_current_status | 0 | 1 | 14 | 0 | View | |
| mail_message_to_send | 0 | 1 | 14 | 0 | View |