58 lines
3.1 KiB
Python
58 lines
3.1 KiB
Python
# 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"]
|