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