UMC_WEB_1_senior
Tables (8)
foodCategory
- id — INT
- name — VARCHAR(255)
member
- id — INT
- name — VARCHAR(255)
- gender — ENUM('M', 'F')
- birth — DATE
- address — VARCHAR(255)
memberFoodPreference
- id — INT
- member_id — INT
- food_category_id — INT
mission
- id — INT
- start_at — DATETIME
- end_at — DATETIME
- status — ENUM('waiting', 'completed', 'failed')
missionDetails
- member_id — INT
- mission_id — INT
- restaurant_id — INT
missionReward
- id — INT
- mission_id — INT
- member_id — INT
- restaurant_id — INT
- points — INT
- created_at — DATETIME
restaurant
- id — INT
- name — VARCHAR(255)
- address — VARCHAR(255)
restaurantFoodCategory
- id — INT
- restaurant_id — INT
- food_category_id — INT