on-care pillbox3

Tables (6)

device

  • device_id — INT — Primary key — NOT NULL
  • serial_number — VARCHAR(100)

dose_schedule

  • schedule_id — INT — Primary key
  • med_id — INT — Foreign key → medication.med_id
  • days_of_week — VARCHAR(50)
  • time_of_day — VARCHAR(20)
  • exact_time — TIME

intake_log

  • log_id — INT — Primary key
  • schedule_id — INT — Foreign key → dose_schedule.schedule_id
  • scheduled_time — DATETIME
  • taken_time — DATETIME
  • status — VARCHAR(20)

medication

  • med_id — INT — Primary key
  • patient_id — INT — Foreign key → patient.patient_id

notification

  • notification_id — INT — Primary key
  • schedule_id — INT — Foreign key → dose_schedule.schedule_id
  • notify_time — DATETIME — NOT NULL
  • status — VARCHAR(20)
  • channel — VARCHAR(20)
  • volume — INT
  • repeat_count — INT
  • snooze_interval_min — INT

patient

  • patient_id — INT — Primary key
  • device_id — INT — Foreign key → device.device_id — NOT NULL
  • gender — VARCHAR(10)
  • birth_date — DATE