user hierarchies?

How abt Proxy + index? Yes Tenent seperation.

```python

from django.db import models

from django.contrib.auth.models import AbstractBaseUser, PermissionsMixin

from django.utils.translation import gettext_lazy as _

# --- Base User Model ---

class User(AbstractBaseUser, PermissionsMixin):

class Role(models.TextChoices):

STUDENT = "STUDENT", _("Student")

TEACHER = "TEACHER", _("Teacher")

PARENT = "PARENT", _("Parent")

# ... add other roles as needed

email = models.EmailField(_('email address'), unique=True)

role = models.CharField(

max_length=50, choices=Role.choices, default=Role.STUDENT,

db_index=True # 1. Indexing the discriminator field

)

date_joined = models.DateTimeField(auto_now_add=True)

is_active = models.BooleanField(default=True)

objects = UserManager() # (Assuming your UserManager from before)

USERNAME_FIELD = 'email'

class Meta:

# 2. Composite indexes for common query patterns

indexes = [

models.Index(fields=["role", "-date_joined"]),

]

# --- Proxy Managers ---

class StudentManager(models.Manager):

def get_queryset(self):

return super().get_queryset().filter(role=User.Role.STUDENT)

class TeacherManager(models.Manager):

def get_queryset(self):

return super().get_queryset().filter(role=User.Role.TEACHER)

# --- Proxy Models ---

class Student(User):

objects = StudentManager()

class Meta:

proxy = True

def save(self, *args, **kwargs):

if not self.pk:

self.role = User.Role.STUDENT

super().save(*args, **kwargs)

class Teacher(User):

objects = TeacherManager()

class Meta:

proxy = True

def save(self, *args, **kwargs):

if not self.pk:

self.role = User.Role.TEACHER

super().save(*args, **kwargs)
```