from sqlalchemy import Column, Integer, ForeignKey, String, Text, DateTime
from sqlalchemy.sql import func
from sqlalchemy.orm import relationship
from src.apps.base.models.base import Base
from sqlalchemy.ext.hybrid import hybrid_property


class SiteMasterIndustry(Base):
    """
    SiteMasterIndustry Model: ORM class for SiteMasterIndustry Entity
    """

    __tablename__ = "site_master_industries"

    id = Column(Integer, primary_key=True, index=True, autoincrement=True)
    value = Column(Text)
    label = Column(Text)
    mcc_code = Column(Integer)
    display_order = Column(Integer, default=0)
    created_at = Column(DateTime, server_default=func.now())
    updated_at = Column(DateTime, nullable=True, onupdate=func.now())
    deleted_at = Column(DateTime, nullable=True)