erd
Tables (12)
food
- food_id — BIGINT — Primary key — NOT NULL
- name — ENUM('NONE', 'KOREAN', 'JAPANESE', 'CHINESE', 'WESTERN', 'VIETNAMESE', 'MEXICAN') — NOT NULL
location
- location_id — BIGINT — Primary key — NOT NULL
- name — ENUM('NONE', 'GANGNAM', 'JONGNO', 'DONGJAK', 'ETC') — NOT NULL
member
- member_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(5) — NOT NULL
- gender — ENUM('MALE', 'FEMALE', 'NONE') — NOT NULL
- birth — DATE — NOT NULL
- address — ENUM('NONE', 'GANGNAM', 'JONGNO', 'DONGJAK', 'ETC') — NOT NULL
- detail_address — VARCHAR(255) — NOT NULL
- social_id — VARCHAR(255) — NOT NULL
- social_type — ENUM('KAKAO', 'NAVER', 'APPLE', 'GOOGLE') — NOT NULL
- point — INTEGER — NOT NULL
- email — VARCHAR(50) — NOT NULL
- phone_number — VARCHAR(11)
- profile_url — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
member_food
- member_food_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- food_id — BIGINT — Foreign key → food.food_id — NOT NULL
member_mission
- member_mission_id — BIGINT — Primary key — NOT NULL
- is_complete — BIT(1) — NOT NULL
- mission_id — BIGINT — Foreign key → mission.mission_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
member_term
- member_term_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- term_id — BIGINT — Foreign key → term.term_id — NOT NULL
mission
- mission_id — BIGINT — Primary key — NOT NULL
- deadline — DATE — NOT NULL
- mission_condition — TEXT — NOT NULL
- point — INTEGER — NOT NULL
- store_id — BIGINT — Foreign key → store.store_id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
reply
- reply_id — BIGINT — Primary key — NOT NULL
- content — TEXT — NOT NULL
review
- review_id — BIGINT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- star — FLOAT — NOT NULL
- store_id — BIGINT — Foreign key → store.store_id — NOT NULL
- user_id — BIGINT — Foreign key → member.member_id — NOT NULL
- reply_id — BIGINT — Foreign key → reply.reply_id
- created_at — TIMESTAMP — NOT NULL
review_photo
- review_photo_id — BIGINT — Primary key — NOT NULL
- photo_url — TEXT — NOT NULL
- review_id — BIGINT — Foreign key → review.review_id — NOT NULL
store
- store_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- manager_number — BIGINT — NOT NULL
- detail_address — VARCHAR(255) — NOT NULL
- location_id — BIGINT — Foreign key → location.location_id — NOT NULL
term
- term_id — BIGINT — Primary key — NOT NULL
- name — ENUM('NONE', 'AGE', 'SERVICE', 'PRIVACY', 'LOCATION', 'MARKETING') — NOT NULL