pho
Tables (10)
broth_types
- broth_id — INT
- restaurant_id — INT — Foreign key → restaurants.restaurant_id — NOT NULL
- broth_name — ENUM('맑은국물','얼큰국물','짬뽕국물','마라국물')
extras
- extra_id — INT
- restaurant_id — INT — Foreign key → restaurants.restaurant_id — NOT NULL
- extra_name — ENUM('짜조','윙봉','스프링롤','볶음쌀국수')
favorites
- favorite_id — INT
- user_id — INT — Foreign key → users.user_id — NOT NULL
- restaurant_id — INT — Foreign key → restaurants.restaurant_id — NOT NULL
- created_at — DATETIME
meat_types
- meat_id — INT
- restaurant_id — INT — Foreign key → restaurants.restaurant_id — NOT NULL
- meat_name — ENUM('차돌','양지','스지','닭','혼합')
noodle_types
- noodle_id — INT
- restaurant_id — INT — Foreign key → restaurants.restaurant_id — NOT NULL
- noodle_name — ENUM('가는면','넓은면','보통면')
restaurants
- restaurant_id — INT
- user_id — INT — Foreign key → users.user_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(200) — NOT NULL
- is_delivery — TINYINT(1)
- avg_rating — DECIMAL(3,2)
- lat — DECIMAL(10,7)
- lng — DECIMAL(10,7)
- is_active — TINYINT(1)
- created_at — DATETIME
review_likes
- like_id — INT
- user_id — INT — Foreign key → users.user_id — NOT NULL
- review_id — INT — Foreign key → reviews.review_id — NOT NULL
- created_at — DATETIME
reviews
- review_id — INT
- restaurant_id — INT — Foreign key → restaurants.restaurant_id — NOT NULL
- user_id — INT — Foreign key → users.user_id — NOT NULL
- rating — TINYINT — NOT NULL
- content — TEXT
- img_url — VARCHAR(255)
- is_hidden — TINYINT(1)
- created_at — DATETIME
side_dishes
- side_id — INT
- restaurant_id — INT — Foreign key → restaurants.restaurant_id — NOT NULL
- side_name — ENUM('양파절임','단무지','고추장아찌')
users
- user_id — INT
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- profile_img — VARCHAR(255)
- role — ENUM('USER','ADMIN')
- created_at — DATETIME