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


class ProductModel(Base):
    """SQLAlchemy ORM model mapping to existing 'products' table in MySQL."""

    __tablename__ = "products"

    id = Column(Integer, primary_key=True, index=True)
    merchant_id = Column(Integer, nullable=False, index=True)
    name = Column(String(255), nullable=False)
    code = Column(String(255), nullable=True)
    warranty = Column(String(255), nullable=True)
    description = Column(String(1000), nullable=True)
    amount = Column(String(255), nullable=True)
    center_id = Column(Integer, nullable=True)
    user_id = Column(Integer, nullable=True)
    deleted_at = Column(DateTime, nullable=True)