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