food

Tables (3)

Food

  • foodNum (Key) — Int — Primary key — NOT NULL
  • foodGroup (Field) — String
  • foodName (Field2) — Stirng
  • supplyFood (Field3) — Int
  • kcal (Field4) — Double

Menu

  • menuNum (Key) — Int — Primary key — NOT NULL
  • menuName (Field) — String
  • supplyMenu (Field2) — Int
  • menuKcal (Field3) — Double

User

  • ID (Key) — String — Primary key — NOT NULL
  • password (Field) — String
  • name (Field2) — String
  • age (Field3) — Int
  • sex (Field4) — Char
  • weight (Field5) — Double
  • height (Field6) — Double
  • targetWeight (Field7) — Double
  • stepNum (Field8) — Int