nyumnyum_db
Tables (3)
diet_records
- id (Key) — INT — Primary key — NOT NULL
- id (Key2) — INT — Foreign key → foods.id — NOT NULL
- id (Key3) — VARCHAR(50) — Foreign key → users.id — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- food_id — INT — NOT NULL
- meal_date — DATE — NOT NULL
- meal_type — ENUM('BREAKFAST','LUNCH','DINNER','SNACK') — NOT NULL
- serving — DECIMAL(6,2)
- created_at — DATETIME
- INDEX — idx_dr_user_date
foods
- id (Key) — INT — Primary key — NOT NULL
- food_name — VARCHAR(100) — NOT NULL
- calorie — DECIMAL(7,2)
- protein — DECIMAL(7,2)
- carbs — DECIMAL(7,2)
- fat — DECIMAL(7,2)
- created_at — DATETIME
users
- id (Key) — VARCHAR(50) — Primary key — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100)
- phone — VARCHAR(20)
- birth_date — DATE
- gender — ENUM('M','F','OTHER')
- height_cm — DECIMAL(5,2)
- weight_kg — DECIMAL(5,2)
- weekly_exercise — TINYINT
- exercise_type — VARCHAR(100)
- weekly_drinking — TINYINT
- drinking_amount — TINYINT
- smoking_status — VARCHAR(50)
- daily_smoking — TINYINT
- created_at — DATETIME