종프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