건강원 HealthWon ERD

테이블 (21)

activity_records

  • id — BIGINT
  • health_event_id — BIGINT — 외래 키 → health_events.id — NOT NULL
  • steps — INT
  • kcal — DECIMAL(8,2)
  • workout — VARCHAR(100)

ai_analysis_results

  • id — BIGINT
  • health_event_id — BIGINT — 외래 키 → health_events.id — NOT NULL
  • model — VARCHAR(100)
  • confidence — DECIMAL(3,2)
  • payload — TEXT

beverage_logs

  • id — BIGINT
  • health_event_id — BIGINT — 외래 키 → health_events.id — NOT NULL
  • volume_ml — INT
  • caffeine_mg — DECIMAL(8,2)
  • sugar_g — DECIMAL(8,2)
  • kcal — DECIMAL(8,2)

cosmetic_ingredients

  • id — BIGINT
  • product_id — BIGINT — 외래 키 → cosmetic_products.id
  • safety — VARCHAR(50)
  • effect — VARCHAR(200)
  • caution — TEXT

cosmetic_products

  • id — BIGINT
  • brand — VARCHAR(100)
  • type — VARCHAR(50)
  • skin_target — VARCHAR(100)

cosmetic_usage_logs

  • id — BIGINT
  • health_event_id — BIGINT — 외래 키 → health_events.id — NOT NULL
  • product_id — BIGINT — 외래 키 → cosmetic_products.id
  • body_area — VARCHAR(50)
  • reaction_note — TEXT

data_sources

  • id — BIGINT
  • type — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100)

food_items

  • id — BIGINT
  • name — VARCHAR(200) — NOT NULL
  • serving — VARCHAR(50)
  • kcal — DECIMAL(8,2)

health_events

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • source_id — BIGINT — 외래 키 → data_sources.id — NOT NULL
  • event_type — VARCHAR(50) — NOT NULL
  • external_record_id — VARCHAR(255)
  • started_at — TIMESTAMP — NOT NULL
  • ended_at — TIMESTAMP
  • timezone — VARCHAR(50)
  • confidence_score — DECIMAL(3,2)
  • raw_payload — TEXT

intake_logs

  • id — BIGINT
  • health_event_id — BIGINT — 외래 키 → health_events.id — NOT NULL
  • medication_item_id — BIGINT — 외래 키 → medication_items.id
  • supplement_item_id — BIGINT — 외래 키 → supplement_items.id

interaction_check_items

  • id — BIGINT
  • check_id — BIGINT — 외래 키 → interaction_checks.id — NOT NULL
  • medication_item_id — BIGINT — 외래 키 → medication_items.id
  • supplement_item_id — BIGINT — 외래 키 → supplement_items.id

interaction_checks

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • risk_level — VARCHAR(20)
  • summary — TEXT
  • recommendation — TEXT

meal_logs

  • id — BIGINT
  • health_event_id — BIGINT — 외래 키 → health_events.id — NOT NULL
  • food_item_id — BIGINT — 외래 키 → food_items.id
  • kcal — DECIMAL(8,2)
  • carbs — DECIMAL(8,2)
  • protein — DECIMAL(8,2)
  • fat — DECIMAL(8,2)

media_assets

  • id — BIGINT
  • health_event_id — BIGINT — 외래 키 → health_events.id
  • storage_url — VARCHAR(500)
  • purpose — VARCHAR(50)

medication_items

  • id — BIGINT
  • name — VARCHAR(200) — NOT NULL
  • ingredient — VARCHAR(200)
  • dose — VARCHAR(100)

notification_logs

  • id — BIGINT
  • reminder_rule_id — BIGINT — 외래 키 → reminder_rules.id — NOT NULL
  • scheduled_at — TIMESTAMP
  • status — VARCHAR(50)

reminder_rules

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → users.id
  • target — VARCHAR(100)
  • rrule — VARCHAR(255)
  • is_active — BOOLEAN

sleep_records

  • id — BIGINT
  • health_event_id — BIGINT — 외래 키 → health_events.id — NOT NULL
  • minutes — INT
  • score — INT
  • quality — VARCHAR(50)

supplement_items

  • id — BIGINT
  • name — VARCHAR(200) — NOT NULL
  • ingredient — VARCHAR(200)
  • dose — VARCHAR(100)

user_profiles

  • user_id — BIGINT — 외래 키 → users.id
  • height — DECIMAL(5,2)
  • weight — DECIMAL(5,2)
  • allergies — TEXT

users

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • display_name — VARCHAR(100)