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)