on-care pillbox1

Tables (8)

AlarmConfig

  • alarm_id — INT
  • plan_id — INT — Foreign key → MedicationPlan.plan_id
  • patient_id — INT — Foreign key → Patient.patient_id
  • volume — INT
  • repeat_count — INT
  • snooze_interval_min — INT
  • notification_channel — VARCHAR(50)

Device

  • device_id — INT
  • serial_number — VARCHAR(100)
  • patient_id — INT — Foreign key → Patient.patient_id
  • location — VARCHAR(100)
  • fw_version — VARCHAR(50)
  • last_sync_at — TIMESTAMP

DoseSchedule

  • schedule_id — INT
  • plan_id — INT — Foreign key → MedicationPlan.plan_id — NOT NULL
  • days_of_week — VARCHAR(50)
  • time_of_day — VARCHAR(20)
  • exact_time — TIME
  • repeat_type — VARCHAR(20)

IntakeLog

  • log_id — INT
  • plan_id — INT — Foreign key → MedicationPlan.plan_id — NOT NULL
  • schedule_id — INT — Foreign key → DoseSchedule.schedule_id
  • scheduled_time — TIMESTAMP
  • taken_time — TIMESTAMP
  • status — VARCHAR(20)
  • source — VARCHAR(20)
  • reason_code — VARCHAR(50)

Medication

  • med_id — INT
  • name — VARCHAR(100) — NOT NULL
  • effect — TEXT
  • storage_method — VARCHAR(255)
  • form — VARCHAR(50)
  • unit_dose — VARCHAR(50)

MedicationPlan

  • plan_id — INT
  • patient_id — INT — Foreign key → Patient.patient_id — NOT NULL
  • med_id — INT — Foreign key → Medication.med_id — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • dose_amount — DECIMAL(5,2)
  • dose_unit — VARCHAR(20)
  • before_after_meal — VARCHAR(20)
  • notes — TEXT

Patient

  • patient_id — INT
  • name — VARCHAR(50) — NOT NULL
  • gender — VARCHAR(10)
  • birth_date — DATE
  • disease — VARCHAR(255)
  • phone — VARCHAR(20)
  • guardian_name — VARCHAR(50)
  • guardian_phone — VARCHAR(20)

PillSlot

  • slot_id — INT
  • slot_name — VARCHAR(20)
  • plan_id — INT — Foreign key → MedicationPlan.plan_id