api_key.py 869 B

1234567891011121314151617181920
  1. """
  2. API密钥模型
  3. """
  4. from sqlalchemy import Column, Integer, Text, DateTime, SmallInteger
  5. from app.database import Base
  6. class APIKey(Base):
  7. """API密钥表"""
  8. __tablename__ = "api_keys"
  9. id = Column(Integer, primary_key=True, index=True, comment="主键ID")
  10. public_key = Column(Text, nullable=False, comment="RSA公钥")
  11. private_key = Column(Text, nullable=False, comment="RSA私钥")
  12. key_version = Column(Integer, nullable=False, index=True, comment="密钥版本号")
  13. is_active = Column(SmallInteger, default=1, index=True, comment="是否激活")
  14. is_deleted = Column(SmallInteger, default=0, index=True, comment="是否删除:0-否,1-是")
  15. created_at = Column(DateTime, comment="创建时间")
  16. updated_at = Column(DateTime, comment="更新时间")
  17. expire_at = Column(DateTime, index=True, comment="过期时间")