from sqlalchemy import Column, Integer, String, Text
from app.database import Base

class CompanyProfileModel(Base):
    __tablename__ = "company_profile"

    id = Column(Integer, primary_key=True, index=True)
    name = Column(String(255))
    industry = Column(String(255))
    services = Column(Text)
    experience = Column(Text)
    certifications = Column(Text)
    regions = Column(Text)
    documents_available = Column(Text)
    keywords = Column(Text)  # Comma separated keywords for recommendations