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