"""Project territory model."""

from db import db


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

    __tablename__ = "ProjectGenre"

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

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

    project = db.relationship("Project")

    genre = db.relationship("Genre")