junaidalie91-rgb's avatar

junaidalie91-rgb wrote a reply+100 XP

2w ago

Movie database relationships

Based on your description, I'd use many-to-many relationships with pivot tables (actor_movie and actor_clip). If a clip belongs to only one movie, keeping movie_id on the clips table makes sense. I wouldn't use hasManyThrough for this structure.