musinsa

Tables (5)

product_daily_stats

  • product_id — INT — Primary key — NOT NULL
  • date — DATE — Primary key — NOT NULL
  • review_count — INT
  • avg_rating — NUMERIC(4,2)
  • pos_ratio — NUMERIC(4,3)
  • neg_ratio — NUMERIC(4,3)
  • top_keywords — TEXT

products

  • product_id — INT — Primary key — NOT NULL
  • goods_no — BIGINT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • brand_name — VARCHAR(128)
  • url — VARCHAR(512)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

review_analysis

  • analysis_id — INT — Primary key — NOT NULL
  • sentiment_pos (sentiment) — BOOLEAN — NOT NULL
  • main_keyword (keyword) — VARCHAR(64) — NOT NULL
  • analyzed_at — TIMESTAMP
  • review_id — BIGINT — Foreign key → reviews.review_id — NOT NULL

review_sentence_analysis

  • sentence_id — INT — Primary key — NOT NULL
  • sentence_index — INT — NOT NULL
  • sentence_text — TEXT — NOT NULL
  • sentiment_pos (sentiment) — BOOLEAN — NOT NULL
  • Field (category) — VARCHAR(16) — NOT NULL
  • review_id — BIGINT — Foreign key → reviews.review_id — NOT NULL

reviews

  • review_id — BIGINT — Primary key — NOT NULL
  • type — VARCHAR(32)
  • content — TEXT
  • rating — INT
  • reviewed_at — TIMESTAMP
  • crawled_at — TIMESTAMP
  • user_nickname — VARCHAR(128)
  • user_gender — VARCHAR(16)
  • user_height — INT
  • user_weight — INT
  • user_profile_image — VARCHAR(512)
  • image_url — VARCHAR(512)
  • like_count — INT
  • product_id — INT — Foreign key → products.product_id — NOT NULL