1
테이블 (6)
마이픽
- id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- whiskey_id — BIGINT — NOT NULL
- score — INT
- memo — VARCHAR(512)
- is_public_for_share — TINYINT(1) — NOT NULL — bottle share
- removed_at — DATETIME(6) — soft remove
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6
사용자
- id — BIGINT — NOT NULL
- email — VARCHAR(255)
- password_hash — VARCHAR(255) — local auth only
- auth_provider — VARCHAR(32) — NOT NULL — local, google, kakao, naver
- provider_id — VARCHAR(255)
- nickname — VARCHAR(64) — NOT NULL
- name — VARCHAR(128)
- role — VARCHAR(32) — NOT NULL — user, admin, pro
- level — VARCHAR(32) — beginner, enthusiast
- bottle_share_opt_in — TINYINT(1) — NOT NULL — My Pick bottle share
- is_email_verified — TINYINT(1) — NOT NULL
- email_verified_at — DATETIME(6)
- is_deleted — TINYINT(1) — NOT NULL
- deleted_at — DATETIME(6)
- last_login_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
위스키
- id — BIGINT — NOT NULL
- name — VARCHAR(200) — NOT NULL
- type — VARCHAR(30) — NOT NULL — 싱글몰트, 블렌디드, 버번, 라이, 기타
- distillery — VARCHAR(100)
- region — VARCHAR(100)
- country — VARCHAR(50)
- abv — DECIMAL(4, 2)
- volume_ml — INT
- cask — VARCHAR(200)
- age_years — INT — NULL = NAS
- is_nas — TINYINT(1) — NOT NULL
- official_nose — INT — NULL이면 사용자 평균 표시
- official_palate — INT
- official_finish — INT
- status — VARCHAR(20) — NOT NULL — active, pending
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
취향
- id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- level — VARCHAR(32) — NOT NULL — beginner, enthusiast
- summary_text — VARCHAR(512) — 취향 요약 문장 (FN-015)
- raw_answers — JSON — 설문 원본 응답
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL — 재설문 시 갱신 (FN-091)
태그
- id — BIGINT — NOT NULL
- category — VARCHAR(20) — NOT NULL — nose, palate, finish, type, region
- name — VARCHAR(50) — NOT NULL — 시트러스, 베리류, 피트, 스모키 등
- display_order — INT — NOT NULL
팔로워
- id — BIGINT — NOT NULL
- follower_id — BIGINT — NOT NULL
- following_id — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL