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