final_project
테이블 (10)
products
- category1 (Field) — text
- category2 (Field2) — text
- category_url (Field3) — text
- product_name (Field4) — text
- product_url (Field5) — text
- review_count (Field6) — text
- product_rating (Field7) — text
reviews
- index (Field) — text
- reviewer_name (Field2) — text
- userid (Field3) — text
- ratings (Field4) — text
- review_contents (Field5) — text
- help (Field6) — text
- date (Field7) — text
- category1 (Field8) — text
- category2 (Field9) — text
- product_name (Field10) — text
상품 리뷰 (reviews_table)
- review_id (Key2) — text — 기본 키 — NOT NULL
- reviewer_name (Field3) — text
- userid (Field4) — text
- review_contents (Key) — text — NOT NULL
- ratings (Field5) — text
- product_id (Key4) — text — 외래 키 → 상품 정보.product_id — NOT NULL
상품 정보 (products_table)
- product_id (Key4) — text — 기본 키 — NOT NULL
- product_url (Field3) — text — NOT NULL
- product_name (Field4) — text — NOT NULL
- category2 (Field5) — text — NOT NULL
- category_url (Field6) — text
- category1 (Field7) — text
상품별리뷰요약 (products_review_info)
- product_id (Key4) — text — 외래 키 → 상품 정보.product_id — NOT NULL
- product_rating (Field2) — text
- review_count (Field3) — text
시나리오1 (review_rating_predict)
- review_id (Key2) — text — 외래 키 → 상품 리뷰.review_id — NOT NULL
- ratings (Field) — text
- review_contents (Field2) — text
시나리오2 로그인 안한 사람 제품, 카테고리 추천 (no_login_recommend)
- product_id (Key4) — text — 외래 키 → 상품별리뷰요약.product_id — NOT NULL
- rating (Field4) — text
- review_cnt (Field5) — text
- category1 (Field) — text
- category2 (Field2) — text
- product_name (Field3) — text
- product_url (Field6) — text
시나리오2 로그인 한 사람 카테고리, 제품 추천 (login_recommend)
- review_id (Key22) — text — 외래 키 → 상품 리뷰.review_id — NOT NULL
- userid (Field) — text
- ratings (Field2) — text
- category1 (Field3) — text
- category2 (Field4) — text
- product_name (Field5) — text
- product_url (Field6) — text
시나리오3 상품별 리뷰 개수 (products_review_visualization)
- product_id (Key4) — text — 외래 키 → 상품별리뷰요약.product_id — NOT NULL
- product_rating (Field) — text
- review_count (Field2) — text
- product_name (Field3) — text
- category1 (Field4) — text
- category2 (Field5) — text
시나리오3 워드클라우드 (wordcloud)
- review_id (Key2) — text — 외래 키 → 상품 리뷰.review_id — NOT NULL
- category1 (Field) — text
- category2 (Field2) — text
- ratings (Field3) — text
- review_contents (Field4) — text