Personal-AI / app /models.py
coreleone's picture
fix module import bug
88baf17
Raw History Blame Contribute Delete
1.16 kB
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())