건강원 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)