I just need your suggestion on how to approach this.
I have a table of users and table of videos.
Now I want to create concept of Albums. Basically a user can have multiple albums and every album can have multiple videos. So I was thinking of the following:
Create Album table with the following fields:
-Owner: One-to-One mapping with User Table
-Videos: One-to-Many mapping with Video Table
I want to do one call to get all albums that user has and all videos belonging to each Album.
How can I achieve that? I am open to suggestion on changing the format of tables