"""LedgerAdjustmentAdjustmentDetail model."""

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


class LedgerAdjustmentAdjustmentDetail(db.Model, CRUDMixin):
    """Ledger Adjustment Adjustment Detail model."""

    __tablename__ = 'ledger_adjustment_adjustment_detail'
    ledger_adjustment_adjustment_detail_id = db.Column(db.Integer, primary_key=True)
    ledger_adjustment_id = db.Column(
        db.Integer,
        db.ForeignKey('ledger_adjustment.ledger_adjustment_id'),
        nullable=False,
    )
    ledger_adjustment_detail_id = db.Column(
        db.Integer,
        db.ForeignKey('ledger_adjustment_detail.ledger_adjustment_detail_id'),
        nullable=False,
    )
    detail_count = db.Column(db.Integer, nullable=False)

    ledger_adjustment = db.relationship(
        'LedgerAdjustment', backref='ledger_adjustment_adjustment_detail', uselist=False
    )
    ledger_adjustment_detail = db.relationship(
        'LedgerAdjustmentDetail',
        backref='ledger_adjustment_adjustment_detail',
        uselist=False,
    )