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