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