shot.py

class ShotTakerModel(Base):
    __tablename__ = "shot_taker"

    id = sa.Column(sa.BIGINT, primary_key=True)

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

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