umc 0th database

Tables (13)

User

  • id (user_id) — Primary key — NOT NULL
  • birthday
  • password
  • nickname
  • Phone_number
  • create_account_date
  • gender
  • email
  • status
  • enable_date
  • point

food

  • id (food_id) — Primary key — NOT NULL
  • name (food_name)

food_restaurant (Untitled5)

  • id (food_restaurant_id) — Primary key — NOT NULL
  • id (store_id) — i — Foreign key → restaurant.id — NOT NULL
  • id (food_id) — Foreign key → food.id — NOT NULL

image (Untitled)

  • id (image_id) — Primary key — NOT NULL
  • id (review_id) — Foreign key → review.id — NOT NULL
  • id (store_id) — i — Foreign key → review.id — NOT NULL
  • url (image_url)

mission

  • id (mission_id) — Primary key — NOT NULL
  • name (미션 이름)
  • point
  • content (미션 내용)
  • created_at (미션 생성 일자)

mission_restaurant (Untitled7)

  • id — Primary key — NOT NULL
  • id (restaurant_id) — Foreign key → restaurant.id — NOT NULL
  • id (mission_id) — Foreign key → mission.id — NOT NULL

region

  • id (region_id) — Primary key — NOT NULL
  • address

restaurant (store)

  • id (store_id) — i — Primary key — NOT NULL
  • id (region_id) — Foreign key → region.id — NOT NULL
  • store_name — va
  • master — v
  • average_score

review

  • id (review_id) — Primary key — NOT NULL
  • id (user_id) — Foreign key → User.id — NOT NULL
  • id (store_id) — Foreign key → restaurant.id — NOT NULL
  • create_date
  • score
  • title
  • content

service_term (Untitled2)

  • id (term_id) — Primary key — NOT NULL
  • title
  • body
  • created_at

service_use_agree (Untitled3)

  • id (service_use_agree_id) — Primary key — NOT NULL
  • id (term_id) — Foreign key → service_term.id — NOT NULL
  • id (user_id) — Foreign key → User.id — NOT NULL

user_mission (Untitled4)

  • id (user_mission_id) — Primary key — NOT NULL
  • user_id — Foreign key → User.id — NOT NULL
  • mission_restaurant_id — Foreign key → mission_restaurant.id — NOT NULL
  • status
  • started_at (시작날짜)
  • end_at (종료날짜)

user_prefer_food (Untitled6)

  • id (user_prefer_food_id) — Primary key — NOT NULL
  • id (user_id) — Foreign key → User.id — NOT NULL
  • id (food_id) — Foreign key → food.id — NOT NULL