📣 Magento_Newsletter · engine innodb

newsletter_queue

Newsletter Queue

Neighbourhood (1-hop foreign-key graph — showing 4 of 4)

flowchart LR
  c["newsletter_queue"]:::center
  n0["newsletter_template"]
  click n0 "/schema/table/newsletter_template"
  n0 -- template_id --> c
  n1["newsletter_problem"]
  click n1 "/schema/table/newsletter_problem"
  c -- queue_id --> n1
  n2["newsletter_queue_link"]
  click n2 "/schema/table/newsletter_queue_link"
  c -- queue_id --> n2
  n3["newsletter_queue_store_link"]
  click n3 "/schema/table/newsletter_queue_store_link"
  c -- queue_id --> n3
  click c "/schema/table/newsletter_queue"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (4)

template_id → newsletter_template newsletter_problem → queue_id newsletter_queue_link → queue_id newsletter_queue_store_link → queue_id

Columns (11)

Name	Type	Null	Default	Comment
queue_id PK	int unsigned	no		Queue ID
template_id	int unsigned	no	0	Template ID
newsletter_type	int	yes		Newsletter Type
newsletter_text	text	yes		Newsletter Text
newsletter_styles	text	yes		Newsletter Styles
newsletter_subject	varchar(200)	yes		Newsletter Subject
newsletter_sender_name	varchar(200)	yes		Newsletter Sender Name
newsletter_sender_email	varchar(200)	yes		Newsletter Sender Email
queue_status	int unsigned	no	0	Queue Status
queue_start_at	timestamp	yes		Queue Start At
queue_finish_at	timestamp	yes		Queue Finish At

Keys & indexes

Primary key: queue_id

Indexes

NEWSLETTER_QUEUE_TEMPLATE_ID (template_id) btree

References (1)

template_id → newsletter_template .template_id (on delete CASCADE)

Referenced by (3)

newsletter_problem .queue_id → .queue_id (on delete CASCADE)
newsletter_queue_link .queue_id → .queue_id (on delete CASCADE)
newsletter_queue_store_link .queue_id → .queue_id (on delete CASCADE)