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