졸작 ERD(수정)

테이블 (14)

cocktail_ingredients

  • id — INT — 기본 키 — NOT NULL
  • cocktail_id — INT — 외래 키 → cocktails.id — NOT NULL
  • ingredient_id — INT — 외래 키 → ingredients.id — NOT NULL
  • amount_ml — FLOAT — NOT NULL

cocktail_views

  • id — INT — 기본 키 — NOT NULL
  • cocktail_id — INT — 외래 키 → cocktails.id — NOT NULL
  • session_id — INT — 외래 키 → guest_sessions.id
  • created_at — DATETIME

cocktails

  • id — INT — 기본 키 — NOT NULL
  • store_id — INT — 외래 키 → stores.id
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • image_url — VARCHAR(500)
  • is_custom — BOOLEAN — NOT NULL
  • alcohol_level — FLOAT — NOT NULL
  • sweetness_level — FLOAT — NOT NULL
  • acidity_level — FLOAT — NOT NULL
  • bitterness_level — FLOAT — NOT NULL
  • emotion_joy — FLOAT — NOT NULL
  • emotion_sadness — FLOAT — NOT NULL
  • emotion_stress — FLOAT — NOT NULL
  • emotion_fatigue — FLOAT — NOT NULL
  • emotion_excitement — FLOAT — NOT NULL
  • is_refreshing — BOOLEAN — NOT NULL
  • is_sweet — BOOLEAN — NOT NULL
  • is_strong — BOOLEAN — NOT NULL
  • is_citrus — BOOLEAN — NOT NULL
  • is_bitter — BOOLEAN — NOT NULL
  • popularity_score — FLOAT — NOT NULL
  • created_at — DATETIME

emotion_logs

  • id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → users.id
  • session_id — INT — 외래 키 → guest_sessions.id
  • raw_text — TEXT
  • emotion_joy — FLOAT — NOT NULL
  • emotion_sadness — FLOAT — NOT NULL
  • emotion_stress — FLOAT — NOT NULL
  • emotion_fatigue — FLOAT — NOT NULL
  • emotion_excitement — FLOAT — NOT NULL
  • created_at — DATETIME

guest_sessions

  • id — INT — 기본 키 — NOT NULL
  • store_id — INT — 외래 키 → stores.id — NOT NULL
  • table_id — INT — 외래 키 → tables.id — NOT NULL
  • session_token — VARCHAR(255) — NOT NULL
  • preferred_sweetness — FLOAT — NOT NULL
  • preferred_alcohol — FLOAT — NOT NULL
  • max_alcohol_limit — FLOAT — NOT NULL
  • created_at — DATETIME
  • expires_at — DATETIME — NOT NULL

ingredients

  • id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • abv — FLOAT — NOT NULL
  • sweet_score — FLOAT — NOT NULL
  • sour_score — FLOAT — NOT NULL
  • bitter_score — FLOAT — NOT NULL

order_items

  • id — INT — 기본 키 — NOT NULL
  • order_id — INT — 외래 키 → orders.id — NOT NULL
  • cocktail_id — INT — 외래 키 → cocktails.id — NOT NULL
  • quantity — INT — NOT NULL

orders

  • id — INT — 기본 키 — NOT NULL
  • store_id — INT — 외래 키 → stores.id — NOT NULL
  • table_id — INT — 외래 키 → tables.id — NOT NULL
  • user_id — INT — 외래 키 → users.id
  • session_id — INT — 외래 키 → guest_sessions.id
  • status — ENUM('PENDING','MAKING','DONE','CANCELLED') — NOT NULL
  • created_at — DATETIME

owners

  • id — INT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — DATETIME

recommendation_logs

  • id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → users.id
  • session_id — INT — 외래 키 → guest_sessions.id
  • cocktail_id — INT — 외래 키 → cocktails.id — NOT NULL
  • final_score — FLOAT — NOT NULL
  • emotion_score — FLOAT — NOT NULL
  • preference_score — FLOAT — NOT NULL
  • popularity_score — FLOAT — NOT NULL
  • rank — INT — NOT NULL
  • rating — INT
  • created_at — DATETIME

stores

  • id — INT — 기본 키 — NOT NULL
  • owner_id — INT — 외래 키 → owners.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • created_at — DATETIME

tables

  • id — INT — 기본 키 — NOT NULL
  • store_id — INT — 외래 키 → stores.id — NOT NULL
  • table_number — INT — NOT NULL
  • qr_url — VARCHAR(500)
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME

user_preferences

  • id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → users.id — NOT NULL
  • cocktail_id — INT — NOT NULL
  • rating — INT — NOT NULL
  • created_at — DATETIME

users

  • id — INT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • preferred_sweetness — FLOAT — NOT NULL
  • preferred_alcohol — FLOAT — NOT NULL
  • max_alcohol_limit — FLOAT — NOT NULL
  • created_at — DATETIME