my
Tables (4)
diet_item
- item_id — INT
- diet_id — INT — NOT NULL
- food_id — INT — NOT NULL
- grams — DOUBLE — NOT NULL
- kcal — DOUBLE
- carb — DOUBLE
- protein — DOUBLE
- fat — DOUBLE
- sodium — DOUBLE
- created_at — TIMESTAMP
diet_log
- diet_id — INT
- user_id — INT — NOT NULL
- meal_date — DATE — NOT NULL
- meal_type — VARCHAR(10) — NOT NULL
- memo — VARCHAR(255)
- created_at — TIMESTAMP
foods_cp
- id — INT
- name — VARCHAR(100)
- grams — FLOAT
- carb — FLOAT
- protein — FLOAT
- fat — FLOAT
- sodium — FLOAT
- kcal — FLOAT
users
- id — INT
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- height — DECIMAL(5,2)
- weight — DECIMAL(5,2)
- disease — VARCHAR(100)
- created_at — TIMESTAMP