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