캡스톤

테이블 (6)

Food (Untitled3)

  • food id (food_id) — bigint — 기본 키 — NOT NULL
  • food list id (food_list_id) — bigint — 외래 키 → Food List.food list id — NOT NULL
  • restaurant id (restaurant_id) — bigint — 외래 키 → Food List.restaurant id — NOT NULL
  • name — varchar
  • food picture (food_picture) — varchar
  • price — int
  • is vegeterian (is_vegeterian) — boolean
  • is vegan — boolean
  • is gluten free (is_gluten_free) — boolean
  • is kosher (is_kosher) — boolean
  • is halal (is_halal) — boolean

Food List (Untitled6)

  • food list id (food_list_id) — bigint — 기본 키 — NOT NULL
  • restaurant id (restaurant_id) — bigint — 외래 키 → Restaurant.restaurant id — NOT NULL

Restaurant (Untitled2)

  • restaurant id (restaurant_id) — bigint — 기본 키 — NOT NULL
  • name — varchar
  • category — enum
  • main picture (main_pic) — varchar
  • address — varchar
  • open time (open_time) — varchar
  • food list (food_list) — list
  • review list (review_list) — list

Review (Untitled4)

  • review id (review_id) — bigint — 기본 키 — NOT NULL
  • review list id (review_list_id) — bigint — 외래 키 → Review List.review list id — NOT NULL
  • restaurant id (restaurant_id) — bigint — 외래 키 → Review List.restaurant id — NOT NULL
  • writer — varchar
  • content — varchar
  • review picture (review_pic) — varchar
  • stars — int

Review List (Untitled5)

  • review list id (review_list_id) — bigint — 기본 키 — NOT NULL
  • restaurant id (restaurant_id) — bigint — 외래 키 → Restaurant.restaurant id — NOT NULL

User (Untitled)

  • user id (user_id) — bigint — 기본 키 — NOT NULL
  • name (user_name) — varchar
  • email (user_email) — varchar
  • pw (user_pw) — varchar
  • diet preference (user_diet_preference) — enum
  • notification setting (noti_setting) — boolean