졸작

테이블 (14)

cocktail_ingredients

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

cocktails

  • id — INT
  • store_id — INT — 외래 키 → stores.id
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • alcohol_level — FLOAT
  • sweetness_level — FLOAT
  • acidity_level — FLOAT
  • bitterness_level — FLOAT
  • emotion_vector — JSON
  • popularity_score — FLOAT
  • is_custom — BOOLEAN
  • created_at — DATETIME

emotion_logs

  • id — INT
  • user_id — INT — 외래 키 → users.id
  • session_id — INT — 외래 키 → guest_sessions.id
  • emotion_vector — JSON
  • raw_text — TEXT
  • created_at — DATETIME

guest_sessions

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

ingredients

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

order_items

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

orders

  • id — INT
  • 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 — VARCHAR(50)
  • created_at — DATETIME

owners

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

recommendation_logs

  • id — INT
  • user_id — INT — 외래 키 → users.id
  • session_id — INT — 외래 키 → guest_sessions.id
  • cocktail_id — INT — 외래 키 → cocktails.id — NOT NULL
  • final_score — FLOAT
  • created_at — DATETIME

session_preferences

  • id — INT
  • session_id — INT — 외래 키 → guest_sessions.id — NOT NULL
  • cocktail_id — INT — 외래 키 → cocktails.id — 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
  • store_id — INT — 외래 키 → stores.id — NOT NULL
  • table_number — INT — NOT NULL
  • qr_url — VARCHAR(500)
  • created_at — DATETIME

user_preferences

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

users

  • id — INT
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • preferred_sweetness — FLOAT
  • preferred_alcohol — FLOAT
  • max_alcohol_limit — FLOAT
  • created_at — DATETIME