| 12345678910111213141516171819 |
- from sqlalchemy import Column, Integer, String, Boolean, DateTime, ForeignKey, func
- from sqlalchemy.orm import declarative_base
- Base = declarative_base()
- class MonitoredDomain(Base):
- """监控域名表模型"""
- __tablename__ = "monitored_domains"
- __table_args__ = {"schema": "domain_monitor"} # 指定 schema
- id = Column(Integer, primary_key=True, index=True) # 主键
- domain = Column(String, unique=True, nullable=False, index=True) # 域名
- remark = Column(String(500)) # 备注
- super_admin_id = Column(Integer) # 关联的超管ID
- is_active = Column(Boolean, default=True) # 是否启用
- created_at = Column(DateTime(timezone=True), server_default=func.now()) # 创建时间
- updated_at = Column(DateTime(timezone=True), onupdate=func.now()) # 更新时间
|
