mail

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
setting_id INT 10 null
report_email_settings.id mail_setting_id_fkey R
to VARCHAR 191 null
cc VARCHAR 191 √ null
subject VARCHAR 191 null
text VARCHAR 191 null
delivery enum('SENT', 'FAILED', 'DELIVERED', 'RETRYING') 9 SENT
attempt_count INT 10 0
last_attempt DATETIME 23 √ null
sent_at DATETIME 23 √ null
created_at DATETIME 23 CURRENT_TIMESTAMP(3)

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
mail_setting_id_fkey Performance Asc setting_id

Relationships

Close relationships within degrees of separation