MyMeal

MyMeal 프로젝트 ERD

테이블 (10)

food_reaction_profiles

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • food_id — BIGINT — 외래 키 → foods.id — NOT NULL
  • eat_count — INT — NOT NULL
  • reaction_count — INT — NOT NULL
  • avg_energy_level — DECIMAL(5,2)
  • avg_digestion_level — DECIMAL(5,2)
  • common_symptoms — JSONB
  • reaction_score — DECIMAL(5,2) — NOT NULL
  • last_eaten_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

foods

  • id — BIGSERIAL
  • name — VARCHAR(100) — NOT NULL
  • name_ko — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • subcategory — VARCHAR(50)
  • image_url — VARCHAR(500)
  • serving_size — DECIMAL(6,2)
  • calories — DECIMAL(7,2)
  • nutrition_data — JSONB
  • ingredients — JSONB
  • taste_profile — JSONB
  • data_source — VARCHAR(50)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

meal_items

  • id — BIGSERIAL
  • meal_id — BIGINT — 외래 키 → meals.id — NOT NULL
  • food_id — BIGINT — 외래 키 → foods.id
  • food_name — VARCHAR(100) — NOT NULL
  • is_ai_recognized — BOOLEAN — NOT NULL
  • calories — DECIMAL(7,2)
  • carbs — DECIMAL(6,2)
  • protein — DECIMAL(6,2)
  • fat — DECIMAL(6,2)
  • sort_order — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

meal_reactions

  • id — BIGSERIAL
  • meal_id — BIGINT — 외래 키 → meals.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • check_time — TIMESTAMP — NOT NULL
  • is_no_reaction — BOOLEAN — NOT NULL
  • symptoms — JSONB
  • other_symptom — TEXT
  • energy_level — INT
  • digestion_level — INT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

meals

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • meal_type — VARCHAR(20) — NOT NULL
  • meal_date — DATE — NOT NULL
  • meal_time — TIME — NOT NULL
  • image_urls — JSONB
  • ai_recognition_status — VARCHAR(20) — NOT NULL
  • total_calories — DECIMAL(7,2)
  • total_carbs — DECIMAL(6,2)
  • total_protein — DECIMAL(6,2)
  • total_fat — DECIMAL(6,2)
  • memo — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

notifications

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • notification_type — VARCHAR(20) — NOT NULL
  • target_id — BIGINT
  • title — VARCHAR(100) — NOT NULL
  • body — VARCHAR(255) — NOT NULL
  • scheduled_at — TIMESTAMP — NOT NULL
  • sent_at — TIMESTAMP
  • status — VARCHAR(20) — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

recommendations

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • meal_type — VARCHAR(20) — NOT NULL
  • recommend_date — DATE — NOT NULL
  • food_id — BIGINT — 외래 키 → foods.id — NOT NULL
  • recommend_type — VARCHAR(20) — NOT NULL
  • recommend_reason — TEXT
  • user_response — VARCHAR(20)
  • response_time — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

user_profiles

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • age — INT
  • gender — VARCHAR(10)
  • height — DECIMAL(5,1)
  • weight — DECIMAL(5,1)
  • goal_type — VARCHAR(20) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • onboarding_completed — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user_settings

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • notification_enabled — BOOLEAN — NOT NULL
  • pre_meal_reminder_enabled — BOOLEAN — NOT NULL
  • post_meal_check_enabled — BOOLEAN — NOT NULL
  • breakfast_time — TIME
  • lunch_time — TIME
  • dinner_time — TIME
  • preferred_foods — JSONB
  • avoided_foods — JSONB
  • dark_mode — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • id — BIGSERIAL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • nickname — VARCHAR(50) — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_id — VARCHAR(255)
  • status — VARCHAR(20) — NOT NULL
  • failed_login_count — INT — NOT NULL
  • last_login_at — TIMESTAMP
  • agreed_marketing — BOOLEAN — NOT NULL
  • agreed_terms — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP