"""Account Payee History Model."""

from abacus_common_logic.models.base import BaseModel, db


class AccountPayeeHistory(BaseModel):
    """Account Payee History model.

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

    __tablename__ = 'account_payee_history'
    account_payee_history_id = db.Column(db.Integer, primary_key=True)
    account_payee_id = db.Column(
        db.Integer, db.ForeignKey('account_payee.account_payee_id'), nullable=False
    )
    account_id = db.Column(
        db.Integer, db.ForeignKey('account.account_id'), nullable=False
    )
    payoneer_program_id = db.Column(db.Integer, nullable=True)
    payoneer_payee_id = db.Column(db.Integer, nullable=True)
    payoneer_payee_name = db.Column(db.String(180), nullable=True)
    payoneer_iframe_url = db.Column(db.String(180), nullable=True)
    payoneer_iframe_url_date = db.Column(db.Date, nullable=True)
    payoneer_session_id = db.Column(db.String(180), nullable=True)