from sqlalchemy import Column, Integer, DateTime, SmallInteger
from sqlalchemy import Float as SAFloat
from src.infrastructure.models.user_model import Base


class MerchantModuleModel(Base):
    """SQLAlchemy ORM model mapping to 'merchant_module' table."""

    __tablename__ = "merchant_module"

    id = Column(Integer, primary_key=True)
    merchant_id = Column(Integer)
    tenure = Column(Integer)
    subvention = Column(SAFloat)
    status = Column(SmallInteger)
    created_at = Column(DateTime)
    created_by = Column(SmallInteger)
    updated_at = Column(DateTime)
    deleted_at = Column(DateTime)
    module_set_by = Column(SmallInteger)