# coding=utf-8 """ 用户管理扩展模型: 1. UserActivationApplication:初次注册用户的待激活审核申请(独立数据对象) 2. UserRoleAssignment:用户-角色-工作空间授权关系(独立数据对象) 说明:这两个模型用于规格书 2.2.2「设置初次注册用户为激活用户」「更改用户角色」 两个功能过程的独立申报,避免与「启用/停用用户账号」「更改用户信息」共用同一数据对象。 """ import uuid_utils.compat as uuid from django.db import models class ActivationStatus(models.TextChoices): PENDING = "PENDING", "待审核" APPROVED = "APPROVED", "已通过" REJECTED = "REJECTED", "已拒绝" class UserActivationApplication(models.Model): """初次注册用户的激活审核申请。""" id = models.UUIDField(primary_key=True, max_length=128, default=uuid.uuid7, editable=False, verbose_name="主键id") user = models.OneToOneField('users.User', on_delete=models.CASCADE, db_constraint=False, related_name="activation_application", verbose_name="关联用户") email = models.EmailField(verbose_name="注册邮箱", blank=True, default="") email_verified = models.BooleanField(default=False, verbose_name="邮箱是否已验证") status = models.CharField(max_length=20, choices=ActivationStatus.choices, default=ActivationStatus.PENDING, db_index=True, verbose_name="审核状态") applied_at = models.DateTimeField(auto_now_add=True, db_index=True, verbose_name="申请时间") audit_by = models.ForeignKey('users.User', on_delete=models.SET_NULL, db_constraint=False, null=True, blank=True, related_name="+", verbose_name="审核人") audit_time = models.DateTimeField(null=True, blank=True, verbose_name="审核时间") reject_reason = models.CharField(max_length=500, blank=True, default="", verbose_name="拒绝原因") class Meta: db_table = "user_activation_application" ordering = ["-applied_at"] class UserRoleAssignment(models.Model): """用户-角色-工作空间授权关系。""" id = models.UUIDField(primary_key=True, max_length=128, default=uuid.uuid7, editable=False, verbose_name="主键id") user = models.ForeignKey('users.User', on_delete=models.CASCADE, db_constraint=False, related_name="role_assignments", verbose_name="用户") role_id = models.CharField(max_length=64, default="USER", db_index=True, verbose_name="角色标识") workspace_id = models.CharField(max_length=128, default="default", db_index=True, verbose_name="工作空间id") granted_by = models.ForeignKey('users.User', on_delete=models.SET_NULL, db_constraint=False, null=True, blank=True, related_name="+", verbose_name="授权人") granted_at = models.DateTimeField(auto_now_add=True, verbose_name="授权时间") class Meta: db_table = "user_role_assignment" unique_together = ("user", "role_id", "workspace_id") ordering = ["granted_at"]