SWDB
← Versions / 5.7.6 /

s_mail_log

Fields (9)

Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
type_id int(11) YES MUL NULL
order_id int(11) YES MUL NULL
shop_id int(10) unsigned YES MUL NULL
subject longtext YES NULL
sender varchar(255) NO NULL
sent_at datetime NO NULL
content_html longtext YES NULL
content_text longtext YES NULL

Indexes (4)

Name Columns Unique
PRIMARY id Yes
s_mail_log_idx_order_id order_id No
s_mail_log_idx_shop_id shop_id No
s_mail_log_idx_type_id type_id No

Relations From (3)

order_id s_order . id
shop_id s_core_shops . id
type_id s_core_config_mails . id

Referenced By (2)

s_mail_log_document . log_id id
s_mail_log_recipient . log_id id