종프2
테이블 (3)
product_information
- product_id — INT — 기본 키 — NOT NULL
- product_name — VARCHAR(255)
- brand — VARCHAR(100)
- explanation — TEXT
- technical_info — TEXT
- management_guidelines — TEXT
- url — VARCHAR(500)
- updated_at — DATETIME
- product_id (product_id2) — INT — 외래 키 → product_summary.product_id — NOT NULL
product_summary
- product_id — INT — 기본 키 — NOT NULL
- product_name — VARCHAR(255)
- category — VARCHAR(100)
- subcategory — VARCHAR(100)
- brand — VARCHAR(100)
- price — INT
- avg_rating — DECIMAL(3, 1)
- total_reviews — INT
- positive_reviews — INT
- mixed_reviews — INT
- negative_reviews — INT
- url — VARCHAR(500)
- thumbnail_url — VARCHAR(1000)
reviews
- review_id — INT — 기본 키 — NOT NULL
- product_id — INT — NOT NULL
- product_name — VARCHAR(255)
- category — VARCHAR(100)
- subcategory — VARCHAR(100)
- brand — VARCHAR(100)
- rating — DECIMAL(3, 1)
- review_text — TEXT
- sentiment — VARCHAR(50)
- review_date — DATETIME
- product_id (product_id2) — INT — 외래 키 → product_summary.product_id — NOT NULL