졸작
테이블 (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