on-care pillbox2
Tables (6)
device
- device_id — INT
- serial_number — VARCHAR(100)
- patient_id — INT — Foreign key → patient.patient_id
dose_schedule
- schedule_id — INT
- med_id — INT — Foreign key → medication.med_id — NOT NULL
- days_of_week — VARCHAR(50)
- time_of_day — VARCHAR(20)
- exact_time — TIME
intake_log
- log_id — INT
- schedule_id — INT — Foreign key → dose_schedule.schedule_id — NOT NULL
- scheduled_time — DATETIME
- taken_time — DATETIME
- status — VARCHAR(20)
medication
- med_id — INT
- patient_id — INT — Foreign key → patient.patient_id — NOT NULL
- med_name — VARCHAR(100) — NOT NULL
- effect — TEXT
- storage_method — VARCHAR(255)
- start_date — DATE — NOT NULL
- end_date — DATE
- dose_amount — DECIMAL(5,2)
- dose_unit — VARCHAR(20)
- before_after_meal — VARCHAR(20)
- notes — TEXT
- slot_name — VARCHAR(20)
notification
- notification_id — INT
- schedule_id — INT — Foreign key → dose_schedule.schedule_id — NOT NULL
- notify_time — DATETIME — NOT NULL
- status — VARCHAR(20)
- channel — VARCHAR(20)
- volume — INT
- repeat_count — INT
- snooze_interval_min — INT
patient
- patient_id — INT
- name — VARCHAR(50) — NOT NULL
- gender — VARCHAR(10)
- birth_date — DATE
- disease — VARCHAR(255)