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