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