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)