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