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