visualCV
Tables (4)
categories
- category_key (id) — int — Primary key — NOT NULL
- name — char(50)
foods
- id — int — Primary key — NOT NULL
- category — int — Foreign key → categories.category_key — NOT NULL
- name — char(50)
- kcal per g (kcal) — decimal(4,2)
- carbohydrate per serving size (carbohydrate) — decimal(3,2)
- protein per serving size (protein) — decimal(3,2)
- fat per serving size (fat) — decimal(3,2)
- sugar per serving size (sugar) — decimal(3,2)
- serving size (amount) — int
intakes
- id — int — Primary key — NOT NULL
- foods — int — Foreign key → foods.id — NOT NULL
- user — int — Foreign key → users.id — NOT NULL
- date — varchar(50)
- intake amount (amount) — int
users
- id — int — Primary key — NOT NULL
- hashed_password — varchar(100)
- nickname — varchar(50)
- 하루 권장 섭취량 (dailykcal) — decimal(5,2)
- is active (is_active) — bool