"""Abacus event model."""

from sqlalchemy import Column
from sqlalchemy import DateTime
from sqlalchemy import ForeignKey
from sqlalchemy import Integer
from sqlalchemy import String

from moneyhub.models.mysql_base import BaseModel
from moneyhub.models.statement_period import StatementPeriod


class AbacusEvent(BaseModel):
    """Abacus event model."""

    __tablename__ = 'abacus_event'

    abacus_event_id = Column(Integer, primary_key=True)
    statement_period_id = Column(
        Integer, ForeignKey(StatementPeriod.statement_period_id), nullable=True)
    event_name = Column(String(32), nullable=True)
    target_type = Column(String(32), nullable=True)
    target_id = Column(Integer, nullable=True)
    event_date = Column(DateTime, nullable=True)
    previous_abacus_event_id = Column(Integer, nullable=True)
    rolled_back_at = Column(DateTime, nullable=True)
    created_by = Column(String(180), nullable=True)