"""Revenue By Recording Distro Model."""

from sqlalchemy import Column
from sqlalchemy import Numeric
from sqlalchemy import String

from moneyhub.models.revenue_by_recording_base import RevenueByRecordingBase
from moneyhub.models.snowflake_base import BaseModel


class RevenueByRecordingDistro(BaseModel, RevenueByRecordingBase):
    """Revenue By Recording Distro model."""

    __tablename__ = 'revenue_by_recording_distro_dbt'

    recording_id = Column(Numeric(32, 0), nullable=False, primary_key=True)
    activity_period_id = Column(Numeric(38, 0), nullable=True)
    store_id = Column(Numeric(32, 0), nullable=True)
    country_code = Column(String(3), nullable=True)
    imprint_id = Column(Numeric(32, 0), nullable=True)
    transaction_type_id = Column(Numeric(32, 0), nullable=True)