Magneto 2 - Review & Rating - Roxoa
Tables (13)
rating
- rating_id — smallint(5) — Primary key — NOT NULL — Rating Id' NOT NUL
- entity_id — smallint(5) — NOT NULL — Entity Id' NOT NULL DEFAULT '0
- rating_code — varchar(64) — NOT NULL — Rating Code' NOT NUL
- position — smallint(5) — NOT NULL — Rating Position On Storefront' NOT NULL DEFAULT '0
- is_active — smallint(6) — NOT NULL — Rating is active.' NOT NULL DEFAULT '1
rating_entity
- entity_id — smallint(5) — Primary key — NOT NULL — Entity Id' NOT NUL
- entity_code — varchar(64) — NOT NULL — Entity Code' NOT NUL
rating_option
- option_id — int(10) — Primary key — NOT NULL — Rating Option Id' NOT NUL
- rating_id — smallint(5) — NOT NULL — Rating Id' NOT NULL DEFAULT '0
- code — varchar(32) — NOT NULL — Rating Option Code' NOT NUL
- value — smallint(5) — NOT NULL — Rating Option Value' NOT NULL DEFAULT '0
- position — smallint(5) — NOT NULL — Ration option position on Storefront' NOT NULL DEFAULT '0
rating_option_vote
- vote_id — bigint(20) — Primary key — NOT NULL — Vote id' NOT NUL
- option_id — int(10) — NOT NULL — Vote option id' NOT NULL DEFAULT '0
- remote_ip — varchar(16) — NOT NULL — Customer IP' NOT NUL
- remote_ip_long — bigint(20) — NOT NULL — Customer IP converted to long integer format' NOT NULL DEFAULT '0
- customer_id — int(10) — Customer Id' NULL DEFAULT '0
- entity_pk_value — bigint(20) — NOT NULL — Product id' NOT NULL DEFAULT '0
- rating_id — smallint(5) — NOT NULL — Rating id' NOT NULL DEFAULT '0
- review_id — bigint(20) — Review id' NUL
- percent — smallint(6) — NOT NULL — Percent amount' NOT NULL DEFAULT '0
- value — smallint(6) — NOT NULL — Vote option value' NOT NULL DEFAULT '0
rating_option_vote_aggregated
- primary_id — int(11) — Primary key — NOT NULL — Vote aggregation id' NOT NUL
- rating_id — smallint(5) — NOT NULL — Rating id' NOT NULL DEFAULT '0
- entity_pk_value — bigint(20) — NOT NULL — Product id' NOT NULL DEFAULT '0
- vote_count — int(10) — NOT NULL — Vote dty' NOT NULL DEFAULT '0
- vote_value_sum — int(10) — NOT NULL — General vote sum' NOT NULL DEFAULT '0
- percent — smallint(6) — NOT NULL — Vote percent' NOT NULL DEFAULT '0
- percent_approved — smallint(6) — Vote percent approved by admin' NULL DEFAULT '0
- store_id — smallint(5) — NOT NULL — Store Id' NOT NULL DEFAULT '0
rating_store
- rating_id — smallint(5) — Primary key — NOT NULL — Rating id' NOT NULL DEFAULT '0
- store_id — smallint(5) — Primary key — NOT NULL — Store id' NOT NULL DEFAULT '0
rating_title
- rating_id — smallint(5) — Primary key — NOT NULL — Rating Id' NOT NULL DEFAULT '0
- store_id — smallint(5) — Primary key — NOT NULL — Store Id' NOT NULL DEFAULT '0
- value — varchar(255) — NOT NULL — Rating Label' NOT NUL
review
- review_id — bigint(20) — Primary key — NOT NULL — Review id' NOT NUL
- created_at — timestamp — NOT NULL — Review create date' NOT NULL DEFAULT CURRENT_TIMESTAM
- entity_id — smallint(5) — NOT NULL — Entity id' NOT NULL DEFAULT '0
- entity_pk_value — int(10) — NOT NULL — Product id' NOT NULL DEFAULT '0
- status_id — smallint(5) — NOT NULL — Status code' NOT NULL DEFAULT '0
- answer — text — Admin answer' NUL
- verified_buyer — smallint(6) — Verified Buyer' NULL DEFAULT '0
- is_recommended — smallint(6) — Is Recommended' NULL DEFAULT '0
review_detail
- detail_id — bigint(20) — Primary key — NOT NULL — Review detail id' NOT NUL
- review_id (review_id2) — bigint(20) — Foreign key → review.review_id — NOT NULL — Review id' NOT NUL
- review_id — bigint(20) — NOT NULL — Review id' NOT NULL DEFAULT '0
- store_id — smallint(5) — Store id' NULL DEFAULT '0
- title — varchar(255) — NOT NULL — Title' NOT NUL
- detail — text — NOT NULL — Detail description' NOT NUL
- nickname — varchar(128) — NOT NULL — User nickname' NOT NUL
- customer_id — int(10) — Customer Id' NUL
- like_about — text — Customer like about this product' NUL
- not_like_about — text — Customer do not like about this product' NUL
- guest_email — text — Guest Email' NUL
review_entity
- entity_id — smallint(5) — Primary key — NOT NULL — Review entity id' NOT NUL
- review_id — bigint(20) — Foreign key → review.review_id — NOT NULL — Review id' NOT NUL
- entity_code — varchar(32) — NOT NULL — Review entity code' NOT NUL
review_entity_summary
- primary_id — bigint(20) — Primary key — NOT NULL — Summary review entity id' NOT NUL
- entity_pk_value — bigint(20) — NOT NULL — Product id' NOT NULL DEFAULT '0
- entity_type — smallint(6) — NOT NULL — Entity type id' NOT NULL DEFAULT '0
- reviews_count — smallint(6) — NOT NULL — Qty of reviews' NOT NULL DEFAULT '0
- rating_summary — smallint(6) — NOT NULL — Summarized rating' NOT NULL DEFAULT '0
- store_id — smallint(5) — NOT NULL — Store id' NOT NULL DEFAULT '0
review_status
- status_id — smallint(5) — Primary key — NOT NULL — Status id' NOT NUL
- status_code — varchar(32) — NOT NULL — Status code' NOT NUL
review_store
- review_id — bigint(20) — Primary key — NOT NULL — Review Id' NOT NUL
- store_id — smallint(5) — Primary key — NOT NULL — Store Id' NOT NUL