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