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