"""Project territory model."""

from db import db


class ArtistGenre(db.Model):
    """Project genres model."""

    __tablename__ = "ArtistGenre"

    artist_id = db.Column(
        db.BigInteger, db.ForeignKey("Artist.id", ondelete="CASCADE"), nullable=False, primary_key=True
    )

    genre_id = db.Column(db.Integer, db.ForeignKey("Genre.id"), nullable=False, primary_key=True)

    artist = db.relationship("Artist", back_populates="genres")

    genre = db.relationship("Genre")