APT
Tables (5)
Basictest (기초체력테스트)
- id — int — Primary key — NOT NULL
- id (user_id) — int — Foreign key → User.id
- _count — int
- user_level — int
Predata (운동부위 선호데이터)
- id (pre_id) — int — Primary key — NOT NULL
- id (user_id) — int — Foreign key → User.id — NOT NULL
- body — int
- arm — int
- shoulder (shdoulder) — int
- back (Field2) — int
- stomach — int
- core — int
- hip — int
- thigh — int
- chest — int
Result (측정결과)
- id (result_id) — int — Primary key — NOT NULL
- id (id2) — int — Foreign key → Basictest.id — NOT NULL
- id (user_id) — int — Foreign key → Basictest.id
- id (pre_id) — int — Foreign key → Predata.id — NOT NULL
- ex_name1 — varchar
- ex_name2 — varchar
- ex_name3 — varchar
- re_count1 (Field4) — int
- re_count2 — int
- re_count3 — int
- re_set1 — int
- re_set2 — int
- re_set3 — int
- kcal1 — int
- kcal2 — int
- kcal3 — int
Test (추천운동)
- id — int — Primary key — NOT NULL
- id (pre_id) — int — Foreign key → Predata.id — NOT NULL
- id (user_id) — int — Foreign key → Predata.id — NOT NULL
- ex_name1 — varchar
- ex_name2 — varchar
- ex_name3 — varchar
- count — int
- sett — int
User (사용자)
- id (user_id) — int — Primary key
- username — varchar — NOT NULL
- password — varchar — NOT NULL
- email — varchar
- gender — varchar
- age — int
- height — int
- weight — int
- bodyshape — vartchar
- purpose — varchar