from datetime import datetime from sqlalchemy import ( Column, Integer, BigInteger, SmallInteger, String, DateTime, JSON, UniqueConstraint, Index, ) from app.core.database import Base class Provider(Base): __tablename__ = "providers" id = Column(BigInteger, primary_key=True, autoincrement=True) name = Column(String(128), nullable=False, unique=True, index=True) enabled = Column(SmallInteger, nullable=False, default=1) plugin_config = Column(JSON, nullable=False, default=dict) role_templates = Column(JSON, nullable=False, default=dict) version = Column(Integer, nullable=False, default=0) updated_by = Column(String(64), nullable=True, default="system") created_at = Column(DateTime, default=datetime.utcnow, nullable=False) updated_at = Column( DateTime, default=datetime.utcnow, onupdate=datetime.utcnow, nullable=False ) __table_args__ = ( UniqueConstraint("name", name="uk_providers_name"), Index("idx_providers_enabled", "enabled"), Index("idx_providers_updated_at", "updated_at"), )