Yak-Ssok

Tables (8)

alarm_settings

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • schedule_id — BIGINT — Foreign key → medicine_schedules.id — NOT NULL
  • alarm_time — TIME — NOT NULL
  • is_enabled — BOOLEAN — NOT NULL
  • snooze_min — INT — NOT NULL
  • push_token — TEXT — FCM 토큰

health_records

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • record_date — DATE — NOT NULL
  • water_ml — INT — 수분 섭취량 (ml)
  • steps — INT — 걸음 수
  • created_at — TIMESTAMP — NOT NULL

medication_logs

  • id — BIGINT — Primary key — NOT NULL
  • schedule_id — BIGINT — Foreign key → medicine_schedules.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • scheduled_date — DATE — NOT NULL
  • taken_at — TIMESTAMP — 실제 복용 시각
  • status — ENUM('TAKEN', 'SKIPPED', 'MISSED') — NOT NULL
  • note — TEXT

medicine_schedules

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • medicine_id — BIGINT — Foreign key → medicines.id — NOT NULL
  • meal_time — ENUM('MORNING', 'LUNCH', 'DINNER', 'BEDTIME') — NOT NULL
  • scheduled_time — TIME — NOT NULL
  • dosage — VARCHAR(50) — NOT NULL — 예: 1알, 500mg
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • repeat_days — VARCHAR(20) — NOT NULL — 월화수목금토일 (1=복용)
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

medicine_warnings

  • id — BIGINT — Primary key — NOT NULL
  • medicine_a_id — BIGINT — Foreign key → medicines.id — NOT NULL
  • medicine_b_id — BIGINT — Foreign key → medicines.id — NOT NULL
  • severity — ENUM('DANGER', 'WARNING', 'CAUTION') — NOT NULL
  • reason — TEXT — NOT NULL
  • source — VARCHAR(100) — 출처 (식약처 등)

medicines

  • id — BIGINT — Primary key — NOT NULL
  • item_seq — VARCHAR(20) — NOT NULL — 식약처 품목기준코드
  • name — VARCHAR(200) — NOT NULL
  • english_name — VARCHAR(200)
  • company — VARCHAR(100) — NOT NULL
  • ingredient — TEXT
  • efficacy — TEXT
  • dosage_info — TEXT
  • precautions — TEXT
  • image_url — TEXT
  • shape — VARCHAR(20)
  • color — VARCHAR(20)
  • storage_method — VARCHAR(100)
  • synced_at — TIMESTAMP — NOT NULL

pharmacies

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(300) — NOT NULL
  • phone — VARCHAR(20)
  • latitude — DECIMAL(10, 7) — NOT NULL
  • longitude — DECIMAL(10, 7) — NOT NULL
  • open_hours — JSON — {"mon":"09:00-18:00", ...}
  • is_24h — BOOLEAN — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • birth_date — DATE
  • gender — ENUM('M','F','OTHER')
  • phone — VARCHAR(20)
  • is_caregiver — BOOLEAN — NOT NULL
  • emergency_contact — VARCHAR(20)
  • created_at — TIMESTAMP — NOT NULL