UMC_WEB_1
Tables (7)
foodCategory
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255)
member
- id — INT — Primary key — NOT NULL
- gender — ENUM('M', 'F')
- birth — DATE
- address — VARCHAR(255)
- status — ENUM('active', 'inactive')
- inactive_date — DATE
- total_missions_completed — INT
- points — INT
- name — VARCHAR(255)
- phone_num — VARCHAR(15)
- email — VARCHAR(255)
memberFoodPreference
- id — INT — Primary key — NOT NULL
- member_id — INT — Foreign key → member.id — NOT NULL
- food_category_id — INT — Foreign key → foodCategory.id — NOT NULL
member_mission
- id — INT — Primary key — NOT NULL
- member_id — INT — Foreign key → member.id — NOT NULL
- store_id — INT — Foreign key → store.id — NOT NULL
- start_at — DATETIME
- end_at — DATETIME
- status — ENUM('waiting', 'completed', 'failed')
mission
- id — INT — Primary key — NOT NULL
- member_mission_id — INT — Foreign key → member_mission.id — NOT NULL
- store_id — INT — Foreign key → member_mission.store_id — NOT NULL
- points — INT
- created_at — DATETIME
- content — VARCHAR(255)
review
- id — INT — Primary key — NOT NULL
- store_id — INT — Foreign key → store.id — NOT NULL
- member_id — INT — Foreign key → member.id — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- score — INT — NOT NULL
- content — VARCHAR(255)
store
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255)
- address — VARCHAR(255)