Last

Tables (5)

dose_history

  • history_id — varchar(50) — Primary key — NOT NULL
  • connect — varchar(50) — NOT NULL
  • user_id — varchar(50) — NOT NULL
  • medi_id — varchar(50) — NOT NULL
  • time_of_day — enum('morning','afternoon','evening') — NOT NULL
  • dose_date — date — NOT NULL
  • scheduled_dose — int — NOT NULL
  • actual_dose — int — NOT NULL
  • status — enum('completed','missed','partial') — NOT NULL
  • completed_at — datetime
  • notes — text

machine

  • machine_id — varchar(50) — Primary key — NOT NULL
  • medi_id — varchar(50) — Primary key — NOT NULL
  • owner — varchar(50) — NOT NULL
  • error_status — varchar(50)
  • last_error_at — datetime — NOT NULL
  • total — int — NOT NULL
  • remain — int — NOT NULL
  • slot — tinyint
  • max_slot — tinyint — NOT NULL

medicine

  • medi_id — varchar(50) — Primary key — NOT NULL
  • connect — varchar(50) — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • warning — tinyint(1) — NOT NULL
  • start_date — date
  • end_date — date
  • target_users — json — 복용 대상 "user1","user2" 또는 NULL(전체)

schedule

  • schedule_id — varchar(50) — Primary key — NOT NULL
  • connect — varchar(50) — NOT NULL
  • user_id — varchar(50)
  • medi_id — varchar(50)
  • day_of_week — enum('mon','tue','wed','thu','fri','sat','sun') — NOT NULL
  • time_of_day — enum('morning','afternoon','evening')
  • dose — int — NOT NULL
  • created_at — datetime — NOT NULL

users

  • user_id — varchar(50) — Primary key — NOT NULL
  • m_uid — varchar(50)
  • connect — varchar(50)
  • password — varchar(255)
  • name — varchar(100)
  • role — enum('parent','child')
  • took_today — tinyint — NOT NULL
  • age — int
  • k_uid — varchar(50)
  • birthDate — varchar(20)
  • refresh_token — text