roufit

Tables (9)

Copy Of Untitled (set_template)

  • Key (set_template_id) — bigint(20) — Primary key — NOT NULL
  • Key (workout_template_id) — bigint(20) — Foreign key → routine.Key — NOT NULL
  • Key (exercise_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (set_count) — bigint(20) — NOT NULL
  • Field (rest_period) — datetime — NOT NULL
  • Field (goal_repetition) — bigint(20)
  • Field (goal_time) — bigint(20)
  • Field (type) — varchar(255) — NOT NULL
  • Field (additional_weight) — bigint(20)

Untitled (workout_record)

  • Key (workout_record_id) — bigint(20) — Primary key — NOT NULL
  • member_id (user_id) — bigint(20) — Foreign key → member.member_id — NOT NULL
  • Key (workout_template_id) — bigint(20) — Foreign key → routine.Key — NOT NULL
  • Field (duration) — datetime — NOT NULL
  • Field (start_time) — datetime — NOT NULL
  • Field (end_time) — datetime — NOT NULL
  • Field (is_completed) — tinyint(1) — NOT NULL

Untitled (exercise)

  • Key (exercise_id) — bigint(20) — Primary key — NOT NULL
  • Field (name) — varchar(255) — NOT NULL
  • Field (description) — varchar(255) — NOT NULL
  • Field (equipment) — varchar(255) — NOT NULL

Untitled (category)

  • Key (category_id) — bigint(20) — Primary key — NOT NULL
  • Key (parant_id) — bigint(20) — Foreign key → Untitled.Key
  • Field (title) — varchar(255) — NOT NULL
  • Field (level) — varchar(255) — NOT NULL
  • Field (category_order) — varchar(255) — NOT NULL

Untitled (base_entity)

  • Field (created_date) — datetime — NOT NULL
  • Field (modified_dated) — datetime — NOT NULL
  • Field (created_by) — bigint(20) — NOT NULL
  • Field (modified_by) — bigint(20) — NOT NULL
  • Field (status) — varchar(20) — NOT NULL

Untitled (set_record)

  • Key (set_record_id) — bigint(20) — Primary key — NOT NULL
  • Key (workout_record_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (exercise_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (set_template_id) — bigint(20) — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Field (set_count) — bigint(20) — NOT NULL
  • Field (rest_period) — datetime — NOT NULL
  • Field (goal_repetition) — bigint(20)
  • Field (goal_time) — bigint(20)
  • Field (type) — varchar(20) — NOT NULL
  • Field (additional_weight) — bigint(20)
  • Field (success_set) — varchar(20) — NOT NULL
  • Field (is_completed) — tinyint(1) — NOT NULL
  • Field (is_success) — tinyint(1) — NOT NULL

Untitled (exercise_category)

  • Key (exercise_category_id) — bigint(20) — Primary key
  • Key (exercise_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (category_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL

member (users)

  • member_id (user_id) — bigint(20) — Primary key — NOT NULL
  • Field (device_code) — varchar(255) — NOT NULL
  • Field (email) — varchar(255) — NOT NULL
  • Field (nickname) — varchar(255) — NOT NULL
  • Field (profile_image) — varchar(255)
  • Field (weight) — bigint(255) — NOT NULL
  • Field (height) — bigint(255) — NOT NULL
  • Field (muscle_mass) — bigint(255)
  • Field (role) — varchar(255) — NOT NULL
  • Field

routine (workout_template)

  • Key (workout_template_id) — bigint(20) — Primary key — NOT NULL
  • member_id (user_id) — bigint(20) — Foreign key → member.member_id — NOT NULL
  • Field (routine_name) — varchar(255) — NOT NULL
  • Field (recent_perform_date) — datetime