UMC_9th
Tables (11)
food_category
- food_category_id — BIGINT
- name — VARCHAR(255)
member
- member_id — BIGINT
- name — VARCHAR(255)
- gender — ENUM('MALE', 'FEMALE', 'NONE')
- birth — DATE
- detail_address — VARCHAR(255)
- social_type — ENUM('KAKAO', 'NAVER', 'APPLE', 'GOOGLE')
- social_uid — VARCHAR(255)
- point — INT
- email — VARCHAR(255)
- phone_number — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
member_agree
- member_agree_id — BIGINT
- member_id — BIGINT
- term_id — BIGINT
- is_agreed — BOOLEAN
member_mission
- member_mission_id — BIGINT
- member_id — BIGINT
- mission_id — BIGINT
- status — ENUM('CHALLENGING', 'COMPLETE')
member_prefer
- member_prefer_id — BIGINT
- member_id — BIGINT
- food_category_id — BIGINT
mission
- mission_id — BIGINT
- store_id — BIGINT
- name — VARCHAR(255)
- content — VARCHAR(255)
- reward — INT
region
- region_id — BIGINT
- name — VARCHAR(255)
review
- review_id — BIGINT
- store_id — BIGINT
- member_id — BIGINT
- content — TEXT
- score — INT
- created_at — DATETIME
- updated_at — DATETIME
review_image
- review_image_id — BIGINT
- review_id — BIGINT
- url — VARCHAR(255)
store
- store_id — BIGINT
- name — VARCHAR(255)
- address — VARCHAR(255)
- region_id — BIGINT
- food_category_id — BIGINT
- created_at — DATETIME
- updated_at — DATETIME
term
- term_id — BIGINT
- name — ENUM('AGE', 'SERVICE', 'PRIVACY', 'LOCATION', 'MARKETING')