yakssok
Tables (6)
dur_alerts
- alert_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.user_id — NOT NULL
- medicine_a_id — INT — Foreign key → medicines.medicine_id — NOT NULL
- medicine_b_id — INT — Foreign key → medicines.medicine_id — NOT NULL
- alert_type — VARCHAR(50) — NOT NULL
- checked_at — DATETIME
meal_events
- event_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.user_id — NOT NULL
- meal_type — VARCHAR(20) — NOT NULL
- event_time — DATETIME — NOT NULL
medicines
- medicine_id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- ingredient — TEXT
- effect_summary — TEXT
- dosage_guide — VARCHAR(100)
- shape — VARCHAR(50)
- color — VARCHAR(50)
- manufacturer — VARCHAR(100)
- public_code — VARCHAR(50)
notification_logs
- log_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.user_id — NOT NULL
- user_medicine_id — INT — Foreign key → user_medicines.user_medicine_id — NOT NULL
- meal_event_id — INT — Foreign key → meal_events.event_id
- scheduled_time — DATETIME — NOT NULL
- is_taken — BOOLEAN — NOT NULL
user_medicines
- user_medicine_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.user_id — NOT NULL
- medicine_id — INT — Foreign key → medicines.medicine_id — NOT NULL
- dosage_time — VARCHAR(20)
- start_date — DATE — NOT NULL
- end_date — DATE
users
- user_id — INT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- age — INT
- meal_time_breakfast — TIME
- meal_time_lunch — TIME
- meal_time_dinner — TIME
- created_at — DATETIME — NOT NULL