offtoreviews

Tables (6)

review

  • review_id — bigint(20) — Primary key — NOT NULL — Review id
  • created_at — timestamp — NOT NULL — Review create date
  • entity_id — smallint(5) — NOT NULL — Entity id
  • entity_pk_value — int(10) — NOT NULL — Product id
  • status_id — smallint(5) — NOT NULL — Status code

review_detail

  • detail_id — bigint(20) — Primary key — NOT NULL — Review detail id
  • review_id — bigint(20) — NOT NULL — Review id
  • store_id — smallint(5) — Store id
  • title — varchar(255) — NOT NULL — Title
  • detail — text — NOT NULL — Detail description
  • nickname — varchar(128) — NOT NULL — User nickname
  • customer_id — int(10) — Customer Id
  • merchantid — varchar(255) — Merchant ID

review_entity

  • entity_id — smallint(5) — Primary key — NOT NULL — Review entity id
  • entity_code — varchar(32) — NOT NULL — Review entity code

review_entity_summary

  • primary_id — bigint(20) — Primary key — NOT NULL — Summary review entity id
  • entity_pk_value — bigint(20) — NOT NULL — Product id
  • entity_type — smallint(6) — NOT NULL — Entity type id
  • reviews_count — smallint(6) — NOT NULL — Qty of reviews
  • rating_summary — smallint(6) — NOT NULL — Summarized rating
  • store_id — smallint(5) — NOT NULL — Store id

review_status

  • status_id — smallint(5) — Primary key — NOT NULL — Status id
  • status_code — varchar(32) — NOT NULL — Status code

review_store

  • store_id — smallint(5) — Primary key — NOT NULL — Store Id
  • review_id — bigint(20) — Foreign key → review.review_id — NOT NULL — Review Id