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