I have a table for users, series, and movies, and I need to create a ‘Watchlist’ table that includes the movies and series a user plans to watch in the future. How is this best implemented? I understand how to link just two tables, but I struggle when it comes to three.
<code>class User(Base):
__tablename__ = "users"
id: Mapped[int] = mapped_column(primary_key=True)
class Movie(Base):
__tablename__ = "movies"
id: Mapped[int] = mapped_column(primary_key=True)
class Series(Base):
__tablename__ = "series"
id: Mapped[int] = mapped_column(primary_key=True)
</code>
<code>class User(Base):
__tablename__ = "users"
id: Mapped[int] = mapped_column(primary_key=True)
class Movie(Base):
__tablename__ = "movies"
id: Mapped[int] = mapped_column(primary_key=True)
class Series(Base):
__tablename__ = "series"
id: Mapped[int] = mapped_column(primary_key=True)
</code>
class User(Base):
__tablename__ = "users"
id: Mapped[int] = mapped_column(primary_key=True)
class Movie(Base):
__tablename__ = "movies"
id: Mapped[int] = mapped_column(primary_key=True)
class Series(Base):
__tablename__ = "series"
id: Mapped[int] = mapped_column(primary_key=True)
And in general, is a many-to-many relationship appropriate for this scenario?