Trying to understand relationships in supabase
Hey
I am trying to set up a few tables for my database, and add data.
It is for a workout api... and I am creating the following tables:
actions
id - code - name - description - updated_at - created_at
joints
id - code - name - latinName - updated_at - created_at
directions
id - code - name - description - updated_at - created_at
planes
id - code - name - description - updated_at - created_at
Every joint have actions which is movement. I have created a relation table for that
joint_actions
id - action_code (fk) - join_code (fk) - created_at - updated_at
The goal is that I want all the actions to come when i query a joint for example. Can i set this up in supabase or does this need to be done in the code?!
I am trying to set up a few tables for my database, and add data.
It is for a workout api... and I am creating the following tables:
actions
id - code - name - description - updated_at - created_at
joints
id - code - name - latinName - updated_at - created_at
directions
id - code - name - description - updated_at - created_at
planes
id - code - name - description - updated_at - created_at
Every joint have actions which is movement. I have created a relation table for that
joint_actions
id - action_code (fk) - join_code (fk) - created_at - updated_at
The goal is that I want all the actions to come when i query a joint for example. Can i set this up in supabase or does this need to be done in the code?!
