"""Expenses model."""
from sqlalchemy import Column
from sqlalchemy import Integer
from sqlalchemy import String
from sqlalchemy import Text

from moneyhub.models.expenses_base import ExpensesBase
from moneyhub.models.snowflake_base import BaseModel


class Expenses(ExpensesBase, BaseModel):
    """Expenses model."""

    __tablename__ = 'combined_expenses_dbt'

    distribution_type = Column(String(8), nullable=False)
    note = Column(Text, nullable=True)
    subaccount_id = Column(Integer, nullable=True)
    subaccount_name = Column(String(500), nullable=True)