umc_week1

Tables (9)

User

  • user_id — bigint — Primary key — NOT NULL
  • user_password — varchar(30)
  • user_name — varchar(20)
  • user_phoneNum — varchar(20)
  • user_gender — varchar(5)
  • user_email — varchar(40)
  • user_point — bigint
  • user_address — varchar(40)

category

  • user_id — bigint — Foreign key → User.user_id — NOT NULL
  • category_num — bigint
  • food_name — ENUM("한식", " 일식" , "중식" , "양식", "치킨" , "분식", "고기/구이", "도시락", "야식(족발/보쌈)"
  • 아시안푸드 — NULL

inquiry

  • user_id — bigint — Foreign key → User.user_id — NOT NULL
  • inquiry_num — bigint
  • inqury_name — varchar(30)
  • inquiry_content — varchar(200)
  • inquiry_picture — BLOB
  • inquiry_answer — status`
  • inquiry_answer — content`

local

  • local_num — bigint — Primary key

mission

  • user_id — bigint — Foreign key → User.user_id — NOT NULL
  • mission_num — bigint
  • missoin_content — varchar(50)
  • mission_mission — completed`
  • misson_point — Inteager

notification

  • user_id — bigint — Foreign key → User.user_id — NOT NULL
  • notification_num — bigint
  • new_event_status — Boolean
  • review_event_status — Boolean
  • inquiry_history_status — Boolean

point

  • user_id — bigint — Foreign key → User.user_id — NOT NULL
  • user_id2 — bigint — Foreign key → mission.user_id — NOT NULL
  • mission_num — bigint — Foreign key → mission.mission_num
  • point_num — bigint
  • point_change — inteager

review_num

  • review_num — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → User.user_id — NOT NULL
  • store_num — bigint
  • review_content — varchar(200)
  • review_picture — BLOB
  • review_gpa — double(20)

store

  • store_num — bigint — Primary key
  • local_num — bigint — Foreign key → local.local_num
  • store_name — varchar(50)
  • store_location — varchar(50)
  • store_picture — BLOB — 이미지 저장 변수 BLOB