UMC

Tables (6)

Mission (mission)

  • missionId (mission_id) — bigint — Primary key — NOT NULL
  • storeId (store_id) — bigint — Foreign key → Store.storeId — NOT NULL
  • storeId — bigint
  • minPrice (min_price) — int
  • point — int
  • location — string
  • createdAt (created_at) — datetime
  • updatedAt (updated_at) — datetime

Store (store)

  • storeId (store_id) — bigint — Primary key — NOT NULL
  • storeName (store_name) — string
  • storeAddress (store_address) — string
  • location — string
  • createdAt (created_at) — datetime
  • updatedAt (updated_at) — datetime

User (user)

  • userId (user_id) — bigint — Primary key — NOT NULL
  • userName (user_name) — string
  • sex — string
  • bithday (birthday) — date
  • address — string

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

review

  • reviewId (review_id) — bigint — Primary key — NOT NULL
  • reviewContent (review_content) — string
  • reviewDate (review_date) — date
  • createdAt (created_at) — datetime
  • updatedAt (updated_at) — datetime
  • userId (user_id) — bigint — Foreign key → User.userId — NOT NULL
  • storeId (store_id) — bigint — Foreign key → Store.storeId — NOT NULL
  • Field (reviewPictureUrl) — string

userFavoriteFood (user_favorite_food)

  • userFavoriteFoodId (user_favorite_food_id) — bigint — Primary key — NOT NULL
  • userId (user_id) — bigint — Foreign key → User.userId — NOT NULL
  • food — string
  • createdAt (created_at) — datetime
  • updatedAt (updated_at) — datetime