nyamnyam
Tables (7)
food
- food_id — BIGINT — Primary key
- name_kor — VARCHAR(255) — NOT NULL
- manufacturer — VARCHAR(255)
- category — VARCHAR(100)
- base_amount_g — DECIMAL(8,2)
- is_liquid — TINYINT(1) — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — idx_food_name
- meal_id — BIGINT — Foreign key → meal_log.meal_id
food_nutrient
- nutrient_code — VARCHAR(32) — Primary key — NOT NULL
- food_id — BIGINT — Foreign key → food.food_id
- amount_per_100 — DECIMAL(10,4) — NOT NULL
meal_log
- meal_id — BIGINT — Primary key
- meal_date — DATE — NOT NULL
- meal_time — TIME
- meal_type — ENUM('BREAKFAST','LUNCH','DINNER','SNACK') — NOT NULL
- note — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — idx_meal_user_date
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
user_condition
- condition_code — VARCHAR(32) — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- diagnosed_at — DATE
- note — VARCHAR(255)
user_goal
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- goal_id — BIGINT
- goal_type — ENUM('WEIGHT_LOSS','MUSCLE_GAIN','DISEASE_CONTROL','GENERAL') — NOT NULL
- target_kcal — INT
- target_protein_g — DECIMAL(6,2)
- target_carb_g — DECIMAL(6,2)
- target_fat_g — DECIMAL(6,2)
- start_date — DATE — NOT NULL
- end_date — DATE
- is_active — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — idx_goal_user_active
user_profile
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- sex — ENUM('MALE','FEMALE','OTHER')
- birthdate — DATE
- height_cm — DECIMAL(5,2)
- weight_kg — DECIMAL(5,2)
- activity_level — ENUM('SEDENTARY','LIGHT','MODERATE','ACTIVE','VERY_ACTIVE')
- updated_at — DATETIME — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(30)
- status — ENUM('ACTIVE','INACTIVE','DELETED') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL