"""Platform-wide roles and additive grants in the default workspace.""" import uuid from django.db import models from django.contrib.postgres.fields import ArrayField class PlatformRole(models.Model): id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False) name = models.CharField(max_length=64, unique=True) description = models.CharField(max_length=256, blank=True, default='') enabled = models.BooleanField(default=True) is_default = models.BooleanField(default=False) modules = models.JSONField(default=list) created_at = models.DateTimeField(auto_now_add=True) updated_at = models.DateTimeField(auto_now=True) class Meta: db_table = 'platform_role' class PlatformRoleMember(models.Model): role = models.ForeignKey(PlatformRole, on_delete=models.CASCADE, related_name='members') user = models.ForeignKey('users.User', on_delete=models.CASCADE, related_name='platform_roles') class Meta: db_table = 'platform_role_member' constraints = [models.UniqueConstraint(fields=['role', 'user'], name='unique_platform_role_member')] class PlatformGrant(models.Model): id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False) subject_type = models.CharField(max_length=8, choices=[('ALL', '所有用户'), ('ROLE', '角色'), ('USER', '用户')]) subject_id = models.CharField(max_length=64, blank=True, default='') workspace_id = models.CharField(max_length=128, default='default', db_index=True) resource_type = models.CharField(max_length=32) target = models.CharField(max_length=128) actions = models.JSONField(default=list) expires_at = models.DateTimeField(null=True, blank=True) granted_by = models.ForeignKey('users.User', null=True, on_delete=models.SET_NULL, related_name='+') updated_at = models.DateTimeField(auto_now=True) class Meta: db_table = 'platform_grant' constraints = [models.UniqueConstraint(fields=['workspace_id', 'subject_type', 'subject_id', 'resource_type', 'target'], name='unique_platform_grant')] indexes = [models.Index(fields=['subject_type', 'subject_id'], name='platform_grant_subject_idx')] class EffectiveResourcePermission(models.Model): """Read-only SQL view merging legacy, role, user and public resource grants.""" id = models.UUIDField(primary_key=True) workspace_id = models.CharField(max_length=128) user_id = models.UUIDField() auth_target_type = models.CharField(max_length=128) target = models.CharField(max_length=128) auth_type = models.CharField(max_length=64) permission_list = ArrayField(models.CharField(max_length=256)) create_time = models.DateTimeField() update_time = models.DateTimeField() class Meta: managed = False db_table = 'effective_resource_permission'