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