⭐ Magento_Review · engine innodb

rating_option_vote

Rating option values

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

flowchart LR
  c["rating_option_vote"]:::center
  n0["rating_option"]
  click n0 "/schema/table/rating_option"
  n0 -- option_id --> c
  n1["review"]
  click n1 "/schema/table/review"
  n1 -- review_id --> c
  click c "/schema/table/rating_option_vote"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (2)

option_id → rating_option review_id → review

Columns (10)

Name	Type	Null	Default	Comment
vote_id PK	bigint unsigned	no		Vote ID
option_id	int unsigned	no	0	Vote option ID
remote_ip	varchar(16)	no		Customer IP
remote_ip_long	bigint	no	0	Customer IP converted to long integer format
customer_id	int unsigned	yes	0	Customer ID
entity_pk_value	bigint unsigned	no	0	Product ID
rating_id	smallint unsigned	no	0	Rating ID
review_id	bigint unsigned	yes		Review ID
percent	smallint	no	0	Percent amount
value	smallint	no	0	Vote option value

Keys & indexes

Primary key: vote_id

Indexes

RATING_OPTION_VOTE_OPTION_ID (option_id) btree

References (2)

option_id → rating_option .option_id (on delete CASCADE)
review_id → review .review_id (on delete CASCADE)