Fitness

Tables (3)

Untitled (Routine)

  • Key (id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → User.Key — NOT NULL
  • Field (body) — varchar(255) — NOT NULL
  • Field2 (status) — enum — NOT NULL
  • Field4 (workout_id) — int — NOT NULL

Untitled (Workout)

  • Key (id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → User.Key
  • Field (name) — varchar(255) — NOT NULL
  • Field2 (type) — enum — NOT NULL

User

  • Key (id) — int — Primary key — NOT NULL
  • Field (userId) — varchar(255) — NOT NULL
  • Field2 (password) — varchar(255) — NOT NULL
  • Field3 (nickname) — varchar(255) — NOT NULL