"""Payment Hold HistoryModel."""

from abacus_common_logic.models.base import BaseModel, db


class PaymentHoldHistory(BaseModel):
    """Payment Hold History model.

    NOTE: Inserts to the table are done by database trigger.
    """

    __tablename__ = 'payment_hold_history'
    payment_hold_history_id = db.Column(db.Integer, primary_key=True)
    payment_hold_id = db.Column(
        db.Integer, db.ForeignKey('payment_hold.payment_hold_id'), nullable=False
    )
    account_id = db.Column(
        db.Integer, db.ForeignKey('account.account_id'), nullable=False
    )
    is_on_hold = db.Column(db.Boolean, nullable=False)
    start_date = db.Column(db.Date, nullable=False)
    end_date = db.Column(db.Date, nullable=False)
    reason = db.Column(db.String(255), nullable=False)