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