mealdang
Tables (15)
blood_sugar_logs
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- meal_log_id — BIGINT — Foreign key → meal_logs.id
- value — NUMERIC(5,1) — NOT NULL
- measured_at — TIMESTAMP — NOT NULL
- risk_level — VARCHAR(20)
- record_type — VARCHAR(20) — NOT NULL
- memo — TEXT
blood_sugar_sensitivity
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- food_id — BIGINT — Foreign key → food_info.id — NOT NULL
- food_name — VARCHAR(200)
- avg_spike — NUMERIC(5,2)
- sample_count — INT — NOT NULL
- sensitivity_level — VARCHAR(20)
- last_meal_log_id — BIGINT — Foreign key → meal_logs.id
- last_updated — TIMESTAMP — NOT NULL
chat_messages
- id — BIGSERIAL
- session_id — BIGINT — Foreign key → chat_sessions.id — NOT NULL
- role — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- rag_sources — JSON
- created_at — TIMESTAMP — NOT NULL
chat_sessions
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → users.id
- device_id — VARCHAR(100)
- locale — VARCHAR(10)
- started_at — TIMESTAMP — NOT NULL
- ended_at — TIMESTAMP
diet_recommendations
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- meal_log_id — BIGINT — Foreign key → meal_logs.id
- result — JSON — NOT NULL
- reason — TEXT
- user_rating — INT
- is_applied — BOOLEAN
- created_at — TIMESTAMP — NOT NULL
faq_items
- id — BIGSERIAL
- faq_key — VARCHAR(50) — NOT NULL
- question — TEXT — NOT NULL
- answer — TEXT — NOT NULL
- tags — JSON
- source — VARCHAR(200)
- is_active — BOOLEAN — NOT NULL
- version — INT — NOT NULL
food_info
- id — BIGSERIAL
- creator_id — BIGINT — Foreign key → users.id
- food_name — VARCHAR(200) — NOT NULL
- yolo_label — VARCHAR(100)
- kcal_per_100 — NUMERIC(7,2)
- carbs_per_100 — NUMERIC(7,2)
- protein_per_100 — NUMERIC(7,2)
- fat_per_100 — NUMERIC(7,2)
- fiber_per_100 — NUMERIC(7,2)
- sugar_per_100 — NUMERIC(7,2)
- sodium_per_100 — NUMERIC(7,2)
- gi_index — INT
- serving_size — NUMERIC(7,2)
- is_user_added — BOOLEAN — NOT NULL
meal_items
- id — BIGSERIAL
- meal_log_id — BIGINT — Foreign key → meal_logs.id — NOT NULL
- food_id — BIGINT — Foreign key → food_info.id
- recorded_name — VARCHAR(200) — NOT NULL
- predicted_name — VARCHAR(200)
- serving_size — NUMERIC(7,2)
- amount_g — NUMERIC(7,2)
- kcal — NUMERIC(8,2)
- carbs — NUMERIC(7,2)
- protein — NUMERIC(7,2)
- fat — NUMERIC(7,2)
- fiber — NUMERIC(7,2)
- sugar — NUMERIC(7,2)
- is_manual — BOOLEAN — NOT NULL
- yolo_confidence — NUMERIC(4,3)
- bbox_x — INT
- bbox_y — INT
- bbox_w — INT
- bbox_h — INT
- is_user_modified — BOOLEAN — NOT NULL
meal_logs
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- restaurant_id — BIGINT — Foreign key → restaurant.id
- meal_type — VARCHAR(20) — NOT NULL
- eaten_at — TIMESTAMP — NOT NULL
- img_url — TEXT
- foods — JSON
- total_kcal — NUMERIC(8,2)
- total_carbs — NUMERIC(7,2)
- total_protein — NUMERIC(7,2)
- total_fat — NUMERIC(7,2)
- nausea_level — INT
- user_rating — INT
- yolo_raw_result — JSON
- is_analyzed — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
predicted_blood_sugar_logs
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- meal_log_id — BIGINT — Foreign key → meal_logs.id — NOT NULL
- predicted_value — NUMERIC(5,1) — NOT NULL
- risk_level — VARCHAR(20)
- confidence — NUMERIC(4,3)
- advice — TEXT
- created_at — TIMESTAMP — NOT NULL
reference_blood_sugar
- id — BIGSERIAL
- patient_group_id — VARCHAR(10) — NOT NULL
- fasting_glucose — NUMERIC(5,1) — NOT NULL
- meal_type — VARCHAR(20)
- post_1h_glucose — NUMERIC(5,1)
- post_2h_glucose — NUMERIC(5,1)
- foods — JSON
- kcal — NUMERIC(8,2)
- carbs — NUMERIC(7,2)
- sugar — NUMERIC(7,2)
- fiber — NUMERIC(7,2)
- protein — NUMERIC(7,2)
- fat — NUMERIC(7,2)
- recorded_at — TIMESTAMP
restaurant
- id — BIGSERIAL
- kakao_place_id — VARCHAR(50) — NOT NULL
- name — VARCHAR(200) — NOT NULL
- category — VARCHAR(100)
- address — TEXT
- lat — DOUBLE
- lng — DOUBLE
- phone — VARCHAR(50)
- cached_at — TIMESTAMP — NOT NULL
restaurant_safety_scores
- id — BIGSERIAL
- restaurant_id — BIGINT — Foreign key → restaurant.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- base_score — NUMERIC(5,2)
- distance_score — NUMERIC(5,2)
- personal_score — NUMERIC(5,2)
- total_score — NUMERIC(5,2)
- visit_count — INT — NOT NULL
- last_actual_glucose — NUMERIC(5,1)
- ema_updated_at — TIMESTAMP
- calculated_at — TIMESTAMP — NOT NULL
user_profiles
- user_id — BIGINT — Foreign key → users.id
- due_date — DATE
- dietary_restrictions — JSON
- flavor_preferences — JSON
- target_carb_per_meal — INT
- target_calories — INT
- target_bloodsugar — INT
- health_notes — JSON
users
- id — BIGSERIAL
- email — VARCHAR(255)
- password — VARCHAR(255)
- nickname — VARCHAR(50) — NOT NULL
- provider — VARCHAR(20)
- provider_uid — VARCHAR(255)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL