23
Tables (7)
tb_crawled_review
- crawled_id — int — Primary key — NOT NULL
- ws_id — int — Foreign key → tb_whisky.ws_id — NOT NULL
- user_name — varchar(100) — NOT NULL
- content — text
- nose — text
- taste — text
- finish — text
- rating — decimal(3,1)
- review_date — varchar(50)
tb_flavor_score
- flavor_id — int — Primary key — NOT NULL
- ws_id — int — Foreign key → tb_whisky.ws_id — NOT NULL
- label — varchar(50) — NOT NULL
- score — float — NOT NULL
- match_keywords — varchar(500)
tb_like
- like_id — int — Primary key — NOT NULL
- user_id — int — Foreign key → tb_user.user_id — NOT NULL
- ws_id — int — Foreign key → tb_whisky.ws_id — NOT NULL
- created_at — datetime
tb_review
- review_id — int — Primary key — NOT NULL
- user_id — int — Foreign key → tb_user.user_id — NOT NULL
- ws_id — int — Foreign key → tb_whisky.ws_id — NOT NULL
- content — text
- nose — varchar(500)
- taste — varchar(500)
- finish — varchar(500)
- rating — decimal(3,1) — NOT NULL
- created_at — datetime
tb_social
- social_id — int — Primary key — NOT NULL
- user_id — int — Foreign key → tb_user.user_id — NOT NULL
- provider — varchar(20) — NOT NULL
- provider_user_id — varchar(100) — NOT NULL
tb_user
- user_id — int — Primary key — NOT NULL
- email — varchar(100) — NOT NULL
- password — varchar(100)
- nickname — varchar(50) — NOT NULL
- user_name — varchar(100) — NOT NULL
- gender — varchar(10)
- user_birth — date — NOT NULL
tb_whisky
- ws_id — int — Primary key — NOT NULL
- ws_name — varchar(255) — NOT NULL
- ws_distillery — varchar(100)
- ws_category — varchar(100)
- ws_age — int
- ws_abv — float
- ws_price — int
- ws_image — varchar(500)
- ws_vol — int
- ws_rating — decimal(3,1)
- ws_vote_cnt — int