MyMeal
Tables (10)
food_tags
- tag — VARCHAR(50) — Primary key — NOT NULL
- food_id — BIGINT — Foreign key → foods.id — NOT NULL
- created_at — TIMESTAMP
food_user_stats
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- food_id — BIGINT — Foreign key → foods.id — NOT NULL
- average_score — NUMERIC(5,2) — NOT NULL
- meal_count — INTEGER — NOT NULL
- last_meal_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
foods
- id — BIGSERIAL
- name — VARCHAR(100) — NOT NULL
- calories — NUMERIC(7,2)
- carbohydrates — NUMERIC(7,2)
- protein — NUMERIC(7,2)
- fat — NUMERIC(7,2)
- average_score — NUMERIC(5,2)
- meal_count — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
meal_analyses
- id — BIGSERIAL
- meal_id — BIGINT — Foreign key → meals.id — NOT NULL
- food_id — BIGINT — Foreign key → foods.id
- meal_name — VARCHAR(100)
- calories — NUMERIC(7,2)
- carbohydrates — NUMERIC(7,2)
- protein — NUMERIC(7,2)
- fat — NUMERIC(7,2)
- confidence — NUMERIC(3,2)
- raw_response — JSONB
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
meals
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- meal_type — meal_type — NOT NULL
- meal_time — TIMESTAMP — NOT NULL
- photo_url — VARCHAR(500) — NOT NULL
- photo_key — VARCHAR(500) — NOT NULL
- memo — TEXT
- analysis_status — analysis_status
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
notifications
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- type — notification_type — NOT NULL
- title — VARCHAR(200) — NOT NULL
- body — VARCHAR(500) — NOT NULL
- data — JSONB
- is_read — BOOLEAN
- read_at — TIMESTAMP
- sent_at — TIMESTAMP
- created_at — TIMESTAMP
reactions
- id — BIGSERIAL
- meal_id — BIGINT — Foreign key → meals.id — NOT NULL
- digestion_level — SMALLINT — NOT NULL
- fullness_level — SMALLINT — NOT NULL
- energy_level — SMALLINT — NOT NULL
- has_heartburn — BOOLEAN
- has_gas — BOOLEAN
- has_bloating — BOOLEAN
- has_headache — BOOLEAN
- memo — TEXT
- overall_score — NUMERIC(5,2)
- grade — grade_type
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user_settings
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- recommendation_enabled — BOOLEAN
- reaction_reminder_enabled — BOOLEAN
- meal_reminder_enabled — BOOLEAN
- breakfast_time — TIME
- lunch_time — TIME
- dinner_time — TIME
- fcm_token — VARCHAR(512)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user_withdrawals
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- reason — withdrawal_reason — NOT NULL
- reason_detail — TEXT
- created_at — TIMESTAMP
users
- id — BIGSERIAL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- name — VARCHAR(50) — NOT NULL
- profile_image — VARCHAR(500)
- provider — provider_type — NOT NULL
- provider_id — VARCHAR(255)
- is_active — BOOLEAN
- last_login_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP