| 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 | |