| 1234567891011121314151617181920212223242526272829303132333435 |
- 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"),
- )
|