Summer Sale! All accounts are 50% off this week.

junaidalie91-rgb's avatar

junaidalie91-rgb wrote a reply+100 XP

1mo 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.