recom

Tables (4)

Food (음식)

  • 음식 id (food_id) — Int — Primary key — NOT NULL
  • 음식점 id (restaurant_id) — Int — Foreign key → Restaurant.음식점 id — NOT NULL
  • 음식 이름 (name) — VARCHAR(255)
  • 카테고리 (category) — Int

Restaurant (음식점)

  • 음식점 id (restaurant_id) — Int — Primary key — NOT NULL
  • 이름 (name) — VARCHAR(255)

Review (리뷰)

  • 리뷰id (review_id) — Int — Primary key — NOT NULL
  • 유저 id (user_id) — int — Foreign key → User.유저 id — NOT NULL
  • 음식 id (food_id) — Int — Foreign key → Food.음식 id — NOT NULL
  • 음식점 id (restaurant_id) — Int — Foreign key → Food.음식점 id — NOT NULL
  • 내용 (content) — VARCHAR(255)
  • 별점 (rating) — INT

User (유저)

  • 유저 id (user_id) — int — Primary key — NOT NULL
  • 닉네임 (nickname) — VARCHAR(255)