from sqlalchemy import Column, String, Integer, Boolean, Text, ForeignKey, DateTime from sqlalchemy.dialects.postgresql import UUID, JSONB from sqlalchemy.sql import func import uuid from app.database import Base class Agent(Base): __tablename__ = "agents" id = Column(UUID(as_uuid=True), primary_key=True, default=uuid.uuid4) name = Column(String(255), nullable=False) description = Column(Text, nullable=False) system_prompt = Column(Text, nullable=False) job_category = Column(String(100), nullable=False) logo_url = Column(Text, nullable=True) downloads = Column(Integer, default=0) is_public = Column(Boolean, default=True) # Store tools and skills natively as JSONB tools = Column(JSONB, nullable=False, default=list) skills = Column(JSONB, nullable=False, default=list) parent_agent_id = Column(UUID(as_uuid=True), ForeignKey("agents.id"), nullable=True) created_by = Column(UUID(as_uuid=True), nullable=True) created_at = Column(DateTime(timezone=True), server_default=func.now()) updated_at = Column(DateTime(timezone=True), server_default=func.now(), onupdate=func.now())