"""Contract Reserve Model."""

from sqlalchemy import Column
from sqlalchemy import ForeignKey
from sqlalchemy import Integer
from sqlalchemy import JSON
from sqlalchemy import Numeric
from sqlalchemy import SmallInteger

from moneyhub.models.mysql_base import BaseModel


class ContractReserve(BaseModel):
    """Contract Reserve Model."""

    __tablename__ = 'contract_reserve'
    contract_reserve_id = Column(Integer, primary_key=True)
    contract_id = Column(
        Integer,
        ForeignKey('contract.contract_id'),
        nullable=False
    )
    reserve_rate = Column(Numeric(5, 2), nullable=True)
    reserve_release_offset_in_months = Column(SmallInteger, nullable=True)
    installments_in_months = Column(SmallInteger, nullable=True)
    release_schedule = Column(
        JSON,
        nullable=True
    )