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