video.py

class TagClass(Base):
    __tablename__ = "tag_class_join"
    id = sa.Column(sa.BIGINT, primary_key=True)
    tag_id = sa.Column(
        sa.BIGINT,
        sa.ForeignKey("tag.id", onupdate="CASCADE", ondelete="CASCADE"),
        nullable=False,
    )


class TagClassJoin(Base):
    __tablename__ = "tag_class_join"
    id = sa.Column(sa.BIGINT, primary_key=True)
    tag_id = sa.Column(
        sa.BIGINT,
        sa.ForeignKey("tag.id", onupdate="CASCADE", ondelete="CASCADE"),
        nullable=False,
    )

    tag_class_id = sa.Column(
        sa.BIGINT,
        sa.ForeignKey("tag.id", onupdate="CASCADE", ondelete="CASCADE"),
        nullable=False,
    )


class Tag(Base):
    __tablename__ = "tag"
    id = sa.Column(sa.BIGINT, primary_key=True)
    # or maybe just have a foreign key into tag class


class VideoTag(Base):
    __tablename__ = "video_tag"
    id = sa.Column(sa.BIGINT, primary_key=True)

    tag_id = sa.Column(
        sa.BIGINT,
        sa.ForeignKey("tag.id", onupdate="CASCADE", ondelete="CASCADE"),
        nullable=False,
    )

    video_id = sa.Column(
        sa.BIGINT,
        sa.ForeignKey("video.id", onupdate="CASCADE", ondelete="CASCADE"),
        nullable=False,
        unique=True,
    )