"""Payment Group Payment Account Detail model."""

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

from moneyhub.models.mysql_base import BaseModel


class PaymentGroupPaymentAccountDetail(BaseModel):
    """Payment Group Payment Account Detail model."""

    __tablename__ = 'payment_group_payment_account_detail'

    payment_group_payment_account_detail_id = Column(Integer, nullable=False, primary_key=True)
    payment_group_payment_account_id = Column(Integer, nullable=False, primary_key=True)
    worksheet_account_contract_payable_after_tax_id = Column(Integer, nullable=True)
    account_id = Column(Integer, nullable=True)
    contract_id = Column(Integer, nullable=True)
    payable_amount_pre_tax = Column(Numeric(20, 2), nullable=True)
    tax_withholding_amount = Column(Numeric(20, 2), nullable=True)
    vat_amount = Column(Numeric(20, 2), nullable=True)
    payable_amount_post_tax = Column(Numeric(20, 2), nullable=True)
    currency_code = Column(String(3), 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)
    deleted_at = Column(DateTime, nullable=True)
    deleted_by = Column(String(255), nullable=True)