졸작 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