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