⭐ Magento_Review · engine innodb

review

Review base information

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

flowchart LR
  c["review"]:::center
  n0["review_entity"]
  click n0 "/schema/table/review_entity"
  n0 -- entity_id --> c
  n1["review_status"]
  click n1 "/schema/table/review_status"
  n1 -- status_id --> c
  n2["review_detail"]
  click n2 "/schema/table/review_detail"
  c -- review_id --> n2
  n3["rating_option_vote"]
  click n3 "/schema/table/rating_option_vote"
  c -- review_id --> n3
  n4["review_store"]
  click n4 "/schema/table/review_store"
  c -- review_id --> n4
  click c "/schema/table/review"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (5)

entity_id → review_entity status_id → review_status rating_option_vote → review_id review_detail → review_id review_store → review_id

Columns (5)

Name	Type	Null	Default	Comment
review_id PK	bigint unsigned	no		Review ID
created_at	timestamp	no	CURRENT_TIMESTAMP	Review create date
entity_id	smallint unsigned	no	0	Entity ID
entity_pk_value	int unsigned	no	0	Product ID
status_id	smallint unsigned	no	0	Status code

Keys & indexes

Primary key: review_id

Indexes

REVIEW_ENTITY_ID (entity_id) btree
REVIEW_STATUS_ID (status_id) btree
REVIEW_ENTITY_PK_VALUE (entity_pk_value) btree

References (2)

entity_id → review_entity .entity_id (on delete CASCADE)
status_id → review_status .status_id (on delete NO ACTION)

Referenced by (3)

rating_option_vote .review_id → .review_id (on delete CASCADE)
review_detail .review_id → .review_id (on delete CASCADE)
review_store .review_id → .review_id (on delete CASCADE)