test

Tables (4)

body (Untitled5)

  • num (Key) — INT(11) — Primary key — NOT NULL
  • userid (Field) — VHARCHAR(10)
  • year (Field2) — INT(11)
  • month (Field3) — INT(11)
  • day (Field4) — INT(11)
  • image (Field5)

exercisediary (Untitled)

  • num (Key) — INT(11) — Primary key — NOT NULL
  • userid (Field) — VARCHAR(10)
  • year (Field2) — INT(11)
  • month (Field3) — INT(11)
  • day (Field4) — INT(11)Q
  • image1 (Field5) — VARCHAR(300)
  • image2 (Field6) — VARHCHAR(300)
  • exercisetime (Field7) — INT(11)
  • exercisekcal (Field8) — INT(11)
  • exercisememo (Field9) — VARCHAR(100)

exercisegroup (Untitled6)

  • name (Key) — VARCHAR(30) — Primary key — NOT NULL
  • password (Field) — INT(11)

users (Untitled2)

  • usernum (Key) — INT — Primary key — NOT NULL
  • userid (Key2) — VARCHAR(45) — Primary key — NOT NULL
  • password (Field) — VARCHAR(45)
  • email (Field2) — VARCHAR(45)
  • favorite (Field3) — VARCHAR(45)
  • height (Field4) — VARCHAR(45)
  • weight (Field5) — VARCHAR(45)
  • age (Field6) — VARHCAR(45)
  • sex (Field7) — char(2)
  • groupname (Field8) — VARCHAR(30)