from sqlalchemy import Column, Integer, String, Text, DateTime
from src.infrastructure.models.user_model import Base


class MerchantCategoryMailModel(Base):
    """SQLAlchemy ORM model mapping to 'merchant_category_common_mail' table.

    Each row associates one email address with a set of merchant categories.
    The category IDs are stored as a comma-separated string in
    merchant_category_list (e.g. "1,3,7") — this matches the existing Laravel
    schema and must not be changed.
    """

    __tablename__ = "merchant_category_common_mail"

    id = Column(Integer, primary_key=True)
    merchant_category_list = Column(Text, nullable=True)   # "1,3,7"
    email = Column(String(255), nullable=True)
    created_by = Column(Integer, nullable=True)
    updated_by = Column(Integer, nullable=True)
    deleted_at = Column(DateTime, nullable=True)
    created_at = Column(DateTime, nullable=True)
    updated_at = Column(DateTime, nullable=True)