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