⭐ Magento_Review · engine innodb

rating

Ratings

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

flowchart LR
  c["rating"]:::center
  n0["rating_entity"]
  click n0 "/schema/table/rating_entity"
  n0 -- entity_id --> c
  n1["rating_option"]
  click n1 "/schema/table/rating_option"
  c -- rating_id --> n1
  n2["rating_option_vote_aggregated"]
  click n2 "/schema/table/rating_option_vote_aggregated"
  c -- rating_id --> n2
  n3["rating_store"]
  click n3 "/schema/table/rating_store"
  c -- rating_id --> n3
  n4["rating_title"]
  click n4 "/schema/table/rating_title"
  c -- rating_id --> n4
  click c "/schema/table/rating"
  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 → rating_entity rating_option → rating_id rating_option_vote_aggregated → rating_id rating_store → rating_id rating_title → rating_id

Columns (5)

Name	Type	Null	Default	Comment
rating_id PK	smallint unsigned	no		Rating ID
entity_id	smallint unsigned	no	0	Entity ID
rating_code	varchar(64)	no		Rating Code
position	smallint unsigned	no	0	Rating Position On Storefront
is_active	smallint	no	1	Rating is active.

Keys & indexes

Primary key: rating_id

Unique

RATING_RATING_CODE (rating_code)

Indexes

RATING_ENTITY_ID (entity_id) btree

References (1)

entity_id → rating_entity .entity_id (on delete CASCADE)

Referenced by (4)

rating_option .rating_id → .rating_id (on delete CASCADE)
rating_option_vote_aggregated .rating_id → .rating_id (on delete CASCADE)
rating_store .rating_id → .rating_id (on delete CASCADE)
rating_title .rating_id → .rating_id (on delete CASCADE)