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)