from sqlalchemy import Column, Integer, String, Boolean, DateTime, ForeignKey, func from app.models import 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()) # 更新时间