AI
Tables (6)
Account
- id — BIGINT(20) — Primary key — NOT NULL
- email — VARCHAR(30) — NOT NULL
- password — VARCHAR(100)
- username — VARCHAR(100)
- nickname — VARCHAR(30) — NOT NULL
- phone — VARCHAR(100)
- sex — TINYINT(4) — NOT NULL
- profileImg — VARCHAR(500)
Course
- id — BIGINT(20) — Primary key — NOT NULL
- account — BIGINT(20) — Foreign key → Account.id — NOT NULL
- trainingId — BIGINT(20) — Foreign key → Training.id — NOT NULL
- name — VARCHAR(200) — NOT NULL
- cycle — INT(11) — NOT NULL
- count — INT(11) — NOT NULL
- breaktime (breacktime) — INT(11)
Level
- id — BIGINT(20) — Primary key — NOT NULL
- account — BIGINT(20) — Foreign key → Account.id — NOT NULL
- part — VARCHAR(50) — NOT NULL
- exp — BIGINT(20) — NOT NULL
Training
- id — BIGINT(20) — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- train_level — INT(11) — NOT NULL
- time_per — INT(11) — NOT NULL
- part — VARCHAR(200) — NOT NULL
- info — VARCHAR(1000) — NOT NULL
- kcal — INT(11) — NOT NULL
- img — VARCHAR(500)
UserBody
- id — BIGINT(20) — Primary key — NOT NULL
- account — BIGINT(20) — Foreign key → Account.id — NOT NULL
- height — DOUBLE — NOT NULL
- weight — DOUBLE — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — VARCHAR(1000) — NOT NULL
- bodyImg — VARCHAR(500)
UserTrainInfo
- id — BIGINT(20) — Primary key — NOT NULL
- account — BIGINT(20) — Foreign key → Account.id — NOT NULL
- trainingId — BIGINT(20) — Foreign key → Training.id — NOT NULL
- mykcal — INT(11) — NOT NULL
- mySet — INT(11) — NOT NULL
- myCount — INT(11) — NOT NULL
- accuracy — DOUBLE — NOT NULL