"""LedgerAdjustmentDetailApplied model."""

from abacus_common_logic.connectors.database import db
from abacus_common_logic.models.base import BaseModel


class LedgerAdjustmentDetailApplied(BaseModel):
    """Ledger Adjustment Detail Applied model."""

    __tablename__ = 'ledger_adjustment_detail_applied'
    ledger_adjustment_detail_applied_id = db.Column(db.Integer, primary_key=True)
    # TODO: Remove this column when ledger adjustment and detail tables are dropped
    ledger_adjustment_detail_id = db.Column(
        db.Integer,
        db.ForeignKey('ledger_adjustment_detail.ledger_adjustment_detail_id'),
        nullable=True,
    )
    # TODO: Update worksheet_adjustment_id and worksheet_adjustment_detail_id
    # to non-nullable
    worksheet_adjustment_id = db.Column(db.Integer, nullable=True)
    worksheet_adjustment_detail_id = db.Column(db.Integer, nullable=True)
    adjustment_amount = db.Column(db.Numeric(20, 18), nullable=False)
    adjustment_currency_code = db.Column(db.String(3), nullable=False)
    adjustment_amount_payee_currency = db.Column(db.Numeric(20, 18), nullable=False)
    adjustment_payee_currency_code = db.Column(db.String(3), nullable=False)
    apply_to_flowthrough_payment = db.Column(db.Boolean, nullable=True)

    ledger_adjustment_detail = db.relationship(
        'LedgerAdjustmentDetail',
        backref='ledger_adjustment_detail_applied',
        uselist=False,
    )