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)