UMC-7th-week2

Tables (7)

mission

  • missionId (mission_id) — bigint — Primary key — NOT NULL
  • storeId (store_id) — bigint — Foreign key → store.storeId — NOT NULL
  • foodType (food_type) — string
  • deadline — date
  • minMoney (min_money) — int
  • point — int
  • locationField (location_field) — string
  • createdAt (created_at) — datetime
  • updatedAt (updated_at) — datetime

review

  • reviewId (review_id) — bigint — Primary key — NOT NULL
  • userId (user_id) — bigint — Foreign key → user.userId — NOT NULL
  • storeId (store_id) — bigint — Foreign key → store.storeId — NOT NULL
  • reviewContent (review_content) — string
  • reviewDate (review_date) — date
  • score — float
  • createdAt (created_at) — datetime
  • updatedAt (updated_at) — datetime

reviewPicture (review_picture)

  • reviewPictureId (review_picture_id) — bigint — Primary key — NOT NULL
  • reviewId (review_id) — bigint — Foreign key → review.reviewId — NOT NULL
  • reviewPicture (review_picture) — string
  • createdAt (created_at) — datetime
  • updatedAt (updated_at) — datetime

store

  • storeId (store_id) — bigint — Primary key — NOT NULL
  • region — string
  • name — string
  • address — string
  • score — string
  • createdAt (created_at) — datetime
  • updatedAt (updated_at) — datetime

user

  • userId (user_id) — bigint — Primary key — NOT NULL
  • email — string
  • sex — string — NOT NULL
  • name — string
  • birth — date
  • location — string
  • simpleLogIn (simple_log_in) — string
  • isTrueLocation (is_true_location) — boolean
  • isTrueSendMarketing (is_true_send_marketing) — boolean
  • isTrueSendEvent (is_true_send_event) — boolean
  • isTrueAlarmReview (is_true_alarm_review) — boolean
  • isTrueAlarmInquiry (is_true_alarm_inquiry) — boolean
  • callNumber (call_number) — string
  • myPoint (my_point) — int
  • createdAt (created_at) — datetime
  • updatedAt (updated_at) — datetime

userFavorFood (user_favor_food)

  • userFavorFoodId (user_favor_food_id) — bigint — Primary key — NOT NULL
  • userId (user_id2) — bigint — Foreign key → user.userId — NOT NULL
  • food — string
  • createdAt (created_at) — datetime
  • updatedAt (updated_at) — datetime

userMission (user_mission)

  • userMissionId (user_mission_id) — bigint — Primary key — NOT NULL
  • userId (user_id) — bigint — Foreign key → user.userId — NOT NULL
  • missionId (mission_id2) — bigint — Foreign key → mission.missionId — NOT NULL
  • status — string
  • createdAt (created_at) — datetime
  • updatedAt (updated_at) — datetime