"""Payment Group Payment model."""

from sqlalchemy import Column
from sqlalchemy import DateTime
from sqlalchemy import Integer
from sqlalchemy import String

from moneyhub.models.mysql_base import BaseModel


class PaymentGroupPayment(BaseModel):
    """Payment Group Payment model."""

    __tablename__ = 'payment_group_payment'

    payment_group_payment_id = Column(Integer, nullable=False, primary_key=True)
    payment_group_id = Column(Integer, nullable=False, primary_key=True)
    statement_period_id = Column(Integer, nullable=True)
    payment_name = Column(String(180), nullable=True)
    created_at = Column(DateTime, nullable=True)
    created_by = Column(String(255), nullable=True)
    last_modified = Column(DateTime, nullable=True)
    last_modified_by = Column(String(255), nullable=True)