UMC_WEB_1_senior

Tables (8)

foodCategory

  • id — INT
  • name — VARCHAR(255)

member

  • id — INT
  • name — VARCHAR(255)
  • gender — ENUM('M', 'F')
  • birth — DATE
  • address — VARCHAR(255)

memberFoodPreference

  • id — INT
  • member_id — INT
  • food_category_id — INT

mission

  • id — INT
  • start_at — DATETIME
  • end_at — DATETIME
  • status — ENUM('waiting', 'completed', 'failed')

missionDetails

  • member_id — INT
  • mission_id — INT
  • restaurant_id — INT

missionReward

  • id — INT
  • mission_id — INT
  • member_id — INT
  • restaurant_id — INT
  • points — INT
  • created_at — DATETIME

restaurant

  • id — INT
  • name — VARCHAR(255)
  • address — VARCHAR(255)

restaurantFoodCategory

  • id — INT
  • restaurant_id — INT
  • food_category_id — INT