Answer the question
In order to leave comments, you need to log in
How to implement relationships?
There is a table with audio records Audio - id | name | slug
:. Audio has owners and members and is stored in the people table. What is the best way to link audio to people
The first option is to make tables
audio_owners - audio_id | owner_id ;
audio_members - audio_id | member_id .
id - 1 | name - 'Owner',
id - 2 | name - 'Member
id | audio_id | person_id | role_id
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question