SafeMed
Tables (9)
caregiver_patient_link
- link_id — BIGINT — Primary key — NOT NULL
- caregiver_id — BIGINT — Foreign key → users.user_id — NOT NULL
- patient_id — BIGINT — Foreign key → users.user_id — NOT NULL
- relation_type — VARCHAR(30)
- approved_at — DATETIME
- created_at — DATETIME — NOT NULL
dose_log
- log_id — BIGINT — Primary key — NOT NULL
- schedule_id — BIGINT — Foreign key → dose_schedule.schedule_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- scheduled_at — DATETIME — NOT NULL
- taken_at — DATETIME
- status — VARCHAR(10) — NOT NULL
dose_schedule
- schedule_id — BIGINT — Primary key — NOT NULL
- user_med_id — BIGINT — Foreign key → user_medication.user_med_id — NOT NULL
- time_of_day — TIME — NOT NULL
- days_of_week — VARCHAR(10) — NOT NULL
- meal_relation — VARCHAR(10) — NOT NULL
- is_active — TINYINT — NOT NULL
drug_interaction
- interaction_id — BIGINT — Primary key — NOT NULL
- medication_id_a — BIGINT — Foreign key → medication.medication_id — NOT NULL
- medication_id_b — BIGINT — Foreign key → medication.medication_id — NOT NULL
- interaction_type — VARCHAR(20) — NOT NULL
- severity — VARCHAR(10) — NOT NULL
- description — VARCHAR(500)
- synced_at — DATETIME
interaction_alert
- alert_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- interaction_id — BIGINT — Foreign key → drug_interaction.interaction_id
- alert_type — VARCHAR(20) — NOT NULL
- medication_id — BIGINT — Foreign key → medication.medication_id
- detected_at — DATETIME — NOT NULL
- acknowledged — TINYINT — NOT NULL
medication
- medication_id — BIGINT — Primary key — NOT NULL
- drug_name — VARCHAR(200) — NOT NULL
- ingredient_name — VARCHAR(200) — NOT NULL
- dur_code — VARCHAR(50)
- manufacturer — VARCHAR(100)
- caution_senior — TINYINT — NOT NULL
- caution_pregnant — TINYINT — NOT NULL
- synced_at — DATETIME
prescription
- prescription_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- hospital_name — VARCHAR(100)
- department — VARCHAR(50)
- prescribed_date — DATE
- created_at — DATETIME — NOT NULL
user_medication
- user_med_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- medication_id — BIGINT — Foreign key → medication.medication_id — NOT NULL
- prescription_id — BIGINT — Foreign key → prescription.prescription_id
- dosage — VARCHAR(50)
- start_date — DATE — NOT NULL
- end_date — DATE
- is_active — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20)
- birth_date — DATE
- role — VARCHAR(20) — NOT NULL
- link_code — VARCHAR(20)
- created_at — DATETIME — NOT NULL