License/backend/app/models/domain.py

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())  # 更新时间