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.