from db import db


class StreamRate(db.Model):
    """StreamRate model"""

    __tablename__ = "StreamRate"

    id = db.Column(db.BigInteger, primary_key=True)
    territory_id = db.Column(db.BigInteger, db.ForeignKey("Territory.id", ondelete="CASCADE"), nullable=False)
    cross_platform_blended_rate = db.Column(db.DECIMAL, nullable=False)
    spotify_blended_rate = db.Column(db.DECIMAL, nullable=False)
    apple_blended_rate = db.Column(db.DECIMAL, nullable=False)
    amazon_blended_rate = db.Column(db.DECIMAL, nullable=False)
    youtube_blended_rate = db.Column(db.DECIMAL, nullable=False)
    imported_date = db.Column(db.Date, nullable=False)