S206_ERD

Tables (24)

body_tb

  • body_id — INT
  • user_id — INT — NOT NULL
  • measurement_date — DATE — NOT NULL
  • weight — DECIMAL(38,2) — NOT NULL
  • height — DECIMAL(38,2)
  • body_fat — DECIMAL(38,2)
  • skeletal_muscle — DECIMAL(38,2)
  • input_type — ENUM('MANUAL', 'OCR') — NOT NULL
  • is_deleted — BIT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

disease_tb

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • category — VARCHAR(50) — NOT NULL

exercise_category_tb

  • exercise_category_id — INT
  • exercise_category_name — VARCHAR(50) — NOT NULL
  • is_deleted — BIT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

exercise_tb

  • exercise_id — INT
  • user_id — INT — NOT NULL
  • exercise_type_id — INT — NOT NULL
  • exercise_date — DATETIME(6) — NOT NULL
  • exercise_time — INT — NOT NULL
  • exercise_calorie — INT — NOT NULL
  • health_connect_uuid — VARCHAR(255)
  • is_deleted — BIT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

exercise_type_tb

  • exercise_type_id — INT
  • exercise_category_id — INT — NOT NULL
  • exercise_name — VARCHAR(50) — NOT NULL
  • exercise_english_name — VARCHAR(50) — NOT NULL
  • exercise_number — INT — NOT NULL
  • exercise_calorie — INT — NOT NULL
  • is_deleted — BIT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

favorite_exercise_tb

  • favorite_id — INT
  • user_id — INT — NOT NULL
  • exercise_type_id — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

favorite_food_tb

  • favorite_id — INT
  • user_id — INT — NOT NULL
  • food_id — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

female_nutrient_intake

  • id — BIGINT
  • age_group — ENUM('ALL', 'TEENS', 'TWENTIES', 'THIRTIES', 'FORTIES', 'FIFTIES', 'SIXTIES', 'ELDERLY') — NOT NULL
  • calories — DOUBLE — NOT NULL
  • carbohydrates — DOUBLE — NOT NULL
  • protein — DOUBLE — NOT NULL
  • fat — DOUBLE — NOT NULL
  • sodium — DOUBLE — NOT NULL
  • sugar — DOUBLE — NOT NULL

female_nutrient_standard

  • id — BIGINT
  • age_group — ENUM('ALL', 'TEENS', 'TWENTIES', 'THIRTIES', 'FORTIES', 'FIFTIES', 'SIXTIES', 'ELDERLY') — NOT NULL
  • calories_min — INT — NOT NULL
  • calories_max — INT
  • carbohydrates_min — INT — NOT NULL
  • carbohydrates_max — INT
  • protein_min — INT — NOT NULL
  • protein_max — INT
  • fat_min — DOUBLE — NOT NULL
  • fat_max — DOUBLE
  • sodium — INT — NOT NULL

food_allergy_tb

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL

food_information_tb

  • food_id — INT
  • food_name — VARCHAR(50) — NOT NULL
  • base_amount — VARCHAR(255) — NOT NULL
  • calorie — INT — NOT NULL
  • carbohydrate — DECIMAL(6,2) — NOT NULL
  • protein — DECIMAL(6,2) — NOT NULL
  • fat — DECIMAL(6,2) — NOT NULL
  • saturated_fat — DECIMAL(6,2) — NOT NULL
  • trans_fat — DECIMAL(6,2) — NOT NULL
  • cholesterol — DECIMAL(6,2) — NOT NULL
  • sodium — DECIMAL(6,2) — NOT NULL
  • sweet — DECIMAL(6,2) — NOT NULL
  • is_deleted — BIT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

food_set_food_tb

  • food_set_food_id — INT
  • food_set_id — INT — NOT NULL
  • food_id — INT — NOT NULL
  • quantity — FLOAT — NOT NULL

food_set_tb

  • food_set_id — INT
  • user_id — INT — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • is_deleted — BIT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

male_nutrient_intake

  • id — BIGINT
  • age_group — ENUM('ALL', 'TEENS', 'TWENTIES', 'THIRTIES', 'FORTIES', 'FIFTIES', 'SIXTIES', 'ELDERLY') — NOT NULL
  • calories — DOUBLE — NOT NULL
  • carbohydrates — DOUBLE — NOT NULL
  • protein — DOUBLE — NOT NULL
  • fat — DOUBLE — NOT NULL
  • sodium — DOUBLE — NOT NULL
  • sugar — DOUBLE — NOT NULL

male_nutrient_standard

  • id — BIGINT
  • age_group — ENUM('ALL', 'TEENS', 'TWENTIES', 'THIRTIES', 'FORTIES', 'FIFTIES', 'SIXTIES', 'ELDERLY') — NOT NULL
  • calories_min — INT — NOT NULL
  • calories_max — INT
  • carbohydrates_min — INT — NOT NULL
  • carbohydrates_max — INT
  • protein_min — INT — NOT NULL
  • protein_max — INT
  • fat_min — DOUBLE — NOT NULL
  • fat_max — DOUBLE
  • sodium — INT — NOT NULL

meal_food_tb

  • meal_food_id — INT
  • meal_time_id — INT — NOT NULL
  • food_id — INT — NOT NULL
  • quantity — FLOAT — NOT NULL
  • food_image_url — VARCHAR(250)

meal_tb

  • meal_id — INT
  • user_id — INT — NOT NULL
  • meal_date — DATE — NOT NULL
  • is_meal — BIT(1) — NOT NULL
  • is_deleted — BIT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

meal_time_tb

  • meal_time_id — INT
  • meal_id — INT — NOT NULL
  • meal_type — ENUM('BREAKFAST', 'LUNCH', 'DINNER', 'SNACK') — NOT NULL
  • eating_time — TIME — NOT NULL
  • meal_time_image_url — VARCHAR(250)
  • is_deleted — BIT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

notification_tb

  • notification_id — BIGINT
  • user_id — INT — NOT NULL
  • notification_type — ENUM('DIET', 'EXERCISE', 'WEIGHT', 'INACTIVE') — NOT NULL
  • title — VARCHAR(255)
  • message — VARCHAR(255)
  • is_read — BIT(1) — NOT NULL
  • is_deleted — BIT(1) — NOT NULL
  • sent_at — DATETIME(6)

step_count_tb

  • step_count_id — INT
  • user_id — INT — NOT NULL
  • step_date — DATE — NOT NULL
  • step_count — INT
  • is_deleted — BIT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

user_allergy_tb

  • id — INT
  • user_id — INT — NOT NULL
  • allergy_id — BIGINT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

user_disease_tb

  • id — INT
  • user_id — INT — NOT NULL
  • disease_id — BIGINT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

user_physical_info_tb

  • user_physical_info_id — BIGINT
  • user_id — INT — NOT NULL
  • date — DATE — NOT NULL
  • birthday — DATE — NOT NULL
  • height — DECIMAL(6,2) — NOT NULL
  • weight — DECIMAL(6,2) — NOT NULL
  • goal — ENUM('WEIGHT_GAIN', 'WEIGHT_LOSS', 'WEIGHT_MAINTENANCE') — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

user_tb

  • user_id — INT
  • email — VARCHAR(50) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • birthday — DATE — NOT NULL
  • gender — ENUM('F', 'M') — NOT NULL
  • height — DECIMAL(6,2) — NOT NULL
  • weight — DECIMAL(6,2) — NOT NULL
  • goal — ENUM('WEIGHT_GAIN', 'WEIGHT_LOSS', 'WEIGHT_MAINTENANCE') — NOT NULL
  • provider — VARCHAR(50) — NOT NULL
  • fcm_token — VARCHAR(255)
  • notification_enabled — BIT(1) — NOT NULL
  • consent_personal — BIT(1) — NOT NULL
  • location_personal — CHAR(1) — NOT NULL
  • is_deleted — BIT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)