title

Tables (4)

angle_condition (Untitled)

  • id (Key) — int — Primary key — NOT NULL — AI
  • movement_id (Field2) — int
  • frame_index (Field) — int — critical frame index
  • angle_id (Key2) — int — Foreign key → angles.id — NOT NULL
  • range_default (Field3) — int — default angle range
  • range_young (Field4) — int
  • range_adult (Field5) — int
  • range_senior (Field6) — int
  • feedback_bigger (Field7) — varchar — feedback text when user angle is bigger than the range
  • feedback_smaller (Field8) — varchar
  • feedback_bigger_audio (Field9) — varchar — feedback audio
  • feedback_smaller_audio (Field10) — varchar

angles (Untitled2)

  • id (Key) — int — Primary key — NOT NULL — AI
  • title (Field) — varchar
  • direction (Field2) — enum — Vertical/Horizontal
  • first_point (Field3) — int
  • mid_point (Field4) — int
  • last_point (Field5) — int
  • type (Field6) — enum — TWO_POINT/THREE_POINT

exercise

  • id (Key) — int — Primary key — NOT NULL — AI
  • title — varchar — NOT NULL
  • icon_path (Field) — varchar
  • json_path (Field2) — varchar
  • preview_video_path (Field3) — varchar
  • trainer_video_path (Field4) — varchar
  • trainer_video_duration (Field5) — int — in second

posture_definition (Untitled3)

  • id (Key) — int — Primary key — NOT NULL — AI
  • exercise_id (Key2) — int — Foreign key → exercise.id — NOT NULL
  • frame_index (Field) — int — critical frame index
  • Field2