safe
Tables (10)
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
- item_seq_a — VARCHAR(20) — NOT NULL
- item_name_a — VARCHAR(200)
- item_seq_b — VARCHAR(20) — NOT NULL
- item_name_b — VARCHAR(200)
- ingr_code_a — VARCHAR(20)
- ingr_code_b — VARCHAR(20)
- interaction_type — VARCHAR(20) — NOT NULL
- severity — VARCHAR(200)
- description — TEXT
- 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
- ingr_code — VARCHAR(20)
- dur_code — VARCHAR(50)
- manufacturer — VARCHAR(100)
- caution_senior — TINYINT — NOT NULL
- caution_pregnant — TINYINT — NOT NULL
- caution_age — TINYINT — NOT NULL
- caution_dosage — TINYINT — NOT NULL
- caution_period — TINYINT — NOT NULL
- caution_split — TINYINT — NOT NULL
- caution_efficacy — 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_drug_interaction
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- item_name_a — VARCHAR(200) — NOT NULL
- item_name_b — VARCHAR(200) — NOT NULL
- interaction_type — VARCHAR(20)
- severity — VARCHAR(200)
- description — TEXT
- detected_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
- username — VARCHAR(50) — 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)
- elderly_mode — TINYINT(1) — NOT NULL
- fcm_token — VARCHAR(255)
- created_at — DATETIME — NOT NULL