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