License/backend/app/models/license.py

from sqlalchemy import Column, Integer, String, Text, DateTime, Numeric, Boolean, func
from app.models import Base


class SuperAdminLicense(Base):
    """超级管理员 License 授权表"""
    __tablename__ = "super_admin_license"
    __table_args__ = {"schema": "domain_monitor"}

    id = Column(Integer, primary_key=True, autoincrement=True)
    super_admin_id = Column(Integer, nullable=False, index=True)
    license_key = Column(String(200), nullable=False)
    expires_at = Column(DateTime(timezone=True), nullable=False, index=True)
    status = Column(String(20), nullable=False, server_default="active", index=True)
    max_tenants = Column(Integer)
    max_users_per_tenant = Column(Integer)
    remark = Column(Text)
    warning_sent = Column(Boolean, server_default="false", default=False)
    expired_sent = Column(Boolean, server_default="false", default=False)
    created_at = Column(DateTime(timezone=True), server_default=func.now())
    updated_at = Column(DateTime(timezone=True), onupdate=func.now())