"""Ledger Reserve Release model."""

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


class LedgerReserveRelease(BaseModel):
    """Ledger Reserve Release model."""

    __tablename__ = 'ledger_reserve_release'
    ledger_reserve_release_id = db.Column(db.Integer, primary_key=True)
    abacus_event_id = db.Column(db.Integer, nullable=False)
    statement_period_id = db.Column(db.Integer, nullable=False)
    ledger_reserve_release_schedule_id = db.Column(
        db.Integer,
        db.ForeignKey(
            'ledger_reserve_release_schedule.ledger_reserve_release_schedule_id'
        ),
        nullable=False,
    )
    installment_amount = db.Column(db.Numeric(20, 2), nullable=False)