Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | null |
|
|
||||||
| sent_at | timestamp | 29,6 | null |
|
|
||||||
| successful | bool | 1 | null |
|
|
||||||
| content | text | 2147483647 | null |
|
|
||||||
| mx_server | text | 2147483647 | √ | null |
|
|
Which MX server from the RRset we attempted to contact. In the (vanishingly unlikely) event that DNS lookup failed or returned no records, an entry in this table will be created, but with this column NULL. |
||||
| remote_ip_address | inet | 2147483647 | √ | null |
|
|
The actual IP address to which the TCP connection was (attempted to be) made. |
||||
| result | text | 2147483647 | null |
|
|
Something of a free-form description of what happened. If the request was successfully accepted by the remote SMTP server, this will be the content of the SMTP receipt response. Otherwise, it’ll be a (hopefully comprehensible) explanation of what went wrong (DNS failure, no records, TCP connection stuff-up, etc). |
|||||
| issuer_contact_email_id | uuid | 2147483647 | null |
|
|
||||||
| revocation_request_id | uuid | 2147483647 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| revocation_request_emails_pkey | Primary key | Asc | id |
Relationships
Close relationships within degrees of separation
