4GeeksAcademy / latam-pt30-PROYECTO-FINAL-GYM-WEBAPP

GYM app, check sets, input routine and chronometer
1 stars 1 forks source link

BACKEND: Como usuario quisiera crear rutinas de ejercicios para entrenar. #7

Closed gespana26 closed 1 month ago

gespana26 commented 1 month ago
gespana26 commented 1 month ago

Se insertan los grupos musculares a la tabla "muscle_group", se arregló inconsistencias en las tablas y relaciones. se aumentaron categorías de grupos musculares.

example=# select * from "muscle_group"; Id_musclegroup | Name
----------------+----------------- 2 | Back 3 | Quads 4 | Biceps 5 | Triceps 6 | Forearms 7 | Shoulders 8 | Trapeze 9 | Hamstrings 10 | Glutes 11 | ABS 12 | Forearm muscles 13 | Neck muscles 14 | Calf 1 | Chest (14 rows)

gespana26 commented 1 month ago

Se cargaron datos de pruebas a la tabla de ejercicios:

Id_exercise | Name | Link_video | Id_musclegroup -------------+--------------------------------+---------------------------------------------+---------------- 5 | Z Bar French Press | https://www.youtube.com/watch?v=ANd7uB6wCVw | 5 6 | Close Grip Bench Press | https://www.youtube.com/shorts/43rg7fBNP2w | 5 7 | Parallel Bars Dips | https://www.youtube.com/shorts/QGoS22SITEM | 5 8 | Barbell bent over row | https://www.youtube.com/watch?v=vnGSs0qnD8Q | 2 9 | Row gironda | https://www.youtube.com/watch?v=GBXQBhuCT3U | 2 10 | Chest pull | https://www.youtube.com/shorts/Jz7oEmzhnfE | 2 11 | Barbell row | https://www.youtube.com/shorts/Nqh7q3zDCoQ | 2 12 | Gironde rowing | https://www.youtube.com/shorts/fPbfYDgzIgA | 2 13 | T Bar Row | https://www.youtube.com/watch?v=hYo72r8Ivso | 2 14 | Rack pull | https://www.youtube.com/watch?v=qknGn76BK80 | 2 15 | Dumbbell shrug | https://www.youtube.com/watch?v=xDt6qbKgLkY | 2 16 | Back Extension | https://www.youtube.com/watch?v=Tb9yp81fI9s | 2 17 | Pull-ups for biceps | https://www.youtube.com/shorts/Oi3bW9nQmGI | 4 18 | Z bar curl scott bench | https://www.youtube.com/watch?v=Gydpcouclx8 | 4 19 | Concentration Curl | https://www.youtube.com/shorts/cHxRJdSVIkA | 4 21 | Hack Squat | https://www.youtube.com/shorts/bGbHOeHXnB8 | 3 22 | Squat | https://www.youtube.com/shorts/gslEzVggur8 | 3 23 | Leg Press | https://www.youtube.com/shorts/ahaJTts1f3s | 9 24 | Legs Extensions | https://www.youtube.com/watch?v=PQRY75OY2TY | 3 25 | Lunges | https://www.youtube.com/shorts/20wSs0bp2Gs | 9 26 | Seated Calf Raise Machine | https://www.youtube.com/watch?v=HSGjUouQZCQ | 14 27 | Hip thrust | https://www.youtube.com/shorts/W86oVlnLqY4 | 10 1 | Flat bench press | https://www.youtube.com/shorts/SidmT09GXz8 | 1 3 | Cable Crossover Flat Bench Fly | https://www.youtube.com/watch?v=-8aurlfuYk4 | 1 4 | Pulley crossover press | https://www.youtube.com/shorts/NyO5y-G5Ceg | 1 28 | military press | https://www.youtube.com/shorts/qLfQbDHWJvE | 1