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