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