"""Ledger Reserve Release model."""

from sqlalchemy import Column
from sqlalchemy import ForeignKey
from sqlalchemy import Integer
from sqlalchemy import Numeric

from moneyhub.models.mysql_base import BaseModel


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

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