LAB

Tables (3)

Product (Untitled)

  • product_id (primary key) — varchar(500) — Primary key — NOT NULL
  • product_name (not null) — varchar(2000)
  • brand (null) — varchar(1000)
  • avg_rating (Field2) — decimal(10, 2)
  • review_sentiment (Field) — varchar(50)
  • sentiment_score (Field3) — decimal(10, 2)
  • best_review (Field4) — text
  • product_url (Field5) — varchar(2048)

ocr_texts (Untitled3)

  • ocr_id (primary key) — bigint — Primary key — NOT NULL
  • product_id (primary key2) — varchar(500) — Foreign key → Product.product_id — NOT NULL
  • ocr_text (Field) — longtext
  • final_text (Field2) — longtext

reviews (Untitled2)

  • review_id (primary key) — bigint — Primary key — NOT NULL
  • product_id (primary key2) — varchar(500) — Foreign key → Product.product_id — NOT NULL
  • user_id (Field) — varchar(250)
  • rating (Field2) — decimal(1,0)
  • review_text (Field3) — longtext
  • skin_info (Field4) — varchar(1000)
  • skin_type (Field5) — varchar(250)
  • skin_trouble (Field6) — varchar(250)
  • skin_sensitivity (Field7) — varchar(250)
  • created_at (Field8) — date