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

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

    __tablename__ = "merchant_location"

    id = Column(Integer, primary_key=True, index=True)
    merchant_id = Column(Integer, ForeignKey("merchant.id"), nullable=False)
    name = Column(String(191))
    slug = Column(String(191))
    email = Column(String(191))
    phone = Column(String(191))
    location = Column(String(191))
    gst_number = Column(String(191))
    state = Column(String(191))
    total_revenue_per_month = Column(Integer)
    percentage_of_sales_in_emi = Column(Integer)
    number_of_lenders = Column(Integer)
    number_of_visits = Column(Integer)
    landmark = Column(String(191))
    target_number_application = Column(String(191))
    target_value_application = Column(String(191))
    avg_ticket_size = Column(Integer)
    rm_id = Column(Integer)
    deleted_at = Column(DateTime)
    created_at = Column(DateTime)
    updated_at = Column(DateTime)