alert_system_alertemaillog

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
message_id varchar 255 null
status int4 10 null
email_sent_at timestamptz 35,6 √ null
item_id int8 19 null
alert_system_loaditem.id alert_system_alertem_item_id_d6f2fa56_fk_alert_sysR
subscription_id int4 10 null
notifications_alertsubscription.id alert_system_alertem_subscription_id_357cc3d7_fk_notificatR
thread_id int8 19 √ null
alert_system_alertemailthread.id alert_system_alertem_thread_id_def85ccb_fk_alert_sysR
user_id int4 10 null
auth_user.id alert_system_alertemaillog_user_id_42b9e0e0_fk_auth_user_idR

Indexes

Constraint Name Type Sort Column(s)
alert_system_alertemaillog_pkey Primary key Asc id
alert_syste_user_id_06a2ee_idx Performance Asc/Asc/Asc user_id + subscription_id + email_sent_at
alert_syste_user_id_e51594_idx Performance Asc/Asc/Asc user_id + item_id + status
alert_system_alertemaillog_item_id_d6f2fa56 Performance Asc item_id
alert_system_alertemaillog_message_id_f3ebea59_like Performance Asc message_id
alert_system_alertemaillog_message_id_key Must be unique Asc message_id
alert_system_alertemaillog_status_deac2e3e Performance Asc status
alert_system_alertemaillog_subscription_id_357cc3d7 Performance Asc subscription_id
alert_system_alertemaillog_thread_id_def85ccb Performance Asc thread_id
alert_system_alertemaillog_user_id_42b9e0e0 Performance Asc user_id

Relationships

Close relationships within degrees of separation