nyam
Tables (4)
food (Untitled)
- id (Key) — INT UNSIGNED NOT NULL AUTO_INCREMENT — Primary key — NOT NULL
- name (Field2) — VARCHAR(200) NOT NULL
- servingSize (Field3) — DECIMAL(8,2) NOT NULL
- servingUnit (Field4) — VARCHAR(20) NOT NULL
- totalCalories (Field5) — INT NOT NULL
- carbohydrates (Field6) — DECIMAL(7,2) NOT NULL
- protein (Field7) — DECIMAL(7,2) NOT NULL
- fat (Field8) — DECIMAL(7,2) NOT NULL
- sugar (Field9) — DECIMAL(7,2) NOT NULL
- sodium (Field10) — DECIMAL(9,2) NOT NULL
- cholesterol (Field11) — DECIMAL(7,2) NOT NULL
- category (Field12) — VARCHAR(100) NOT NULL
- created_at (Field13) — TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
- updated_at (Field14) — TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
- meal_id (Key3) — INT UNSIGNED NOT NULL AUTO_INCREMENT — Foreign key → meal.id — NOT NULL
- meal_food_id (Key2) — INT UNSIGNED NOT NULL AUTO_INCREMENT — Foreign key → meal_food.id — NOT NULL
meal (Untitled3)
- id (Key3) — INT UNSIGNED NOT NULL AUTO_INCREMENT — Primary key — NOT NULL
- eaten_at (Field3) — DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
- memo (Field4) — VARCHAR(200) NULL
- created_at (Field5) — TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
- user_id (Key32) — INT UNSIGNED NOT NULL AUTO_INCREMENT — Foreign key → user.id — NOT NULL
meal_food (Untitled4)
- id (Key2) — INT UNSIGNED NOT NULL AUTO_INCREMENT — Primary key — NOT NULL
- servings (Field3) — DECIMAL(8,2) NOT NULL
- added_at (Field4) — TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
- meal_id (Key3) — INT UNSIGNED NOT NULL AUTO_INCREMENT — Foreign key → meal.id — NOT NULL
user (CopyOfUntitled3)
- id (Key3) — INT UNSIGNED NOT NULL AUTO_INCREMENT — Primary key — NOT NULL
- login_id (Field) — VARCHAR(50) NOT NULL
- pw (Field2) — VARCHAR(50) NOT NULL
- height (Field3) — DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
- weight (Field4) — VARCHAR(200) NULL
- created_at (Field5) — TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP