How to have multiple types of users in separated tables?

Question

I'm building a project in which I'll have 3 types of users.

Super Admin Teacher Student

Teacher and Student will be in a table called Class, each Class will have one teacher and several Student.

As far as I know(Very limited), Django only provide one user table for all kinds of users, But I don't know how to go on, because I will need separated tables to keep the data organized and without redudance, in addition to relate with other tables.

Is there any kind of solution to solve this problem ?

FYI please avoid python reserved words such as `Class`. – nik_m Mar 20 '17 at 15:52 — nik_m, Mar 20 '17 at 15:52

score 1 · Accepted Answer · edited May 23 '17 at 12:09

You can implement related_name attributes something similar to this:

from django.contrib.auth.models import User

class ClassRoom(models.Model):
    # One classroom one teacher
    teacher = models.ForeignKey(User, related_name="teacher")
    # One classroom many students
    student = models.ManytoManyField(User, blank=True, null=True,
                                     related_name="students")
    .....

Also refer to these links for more info:

Django teacher students easy solution. Use separate tables, or permissions and groups? How? Other ideas?

Django model with Foreign Key and ManyToMany relations to same model

Two sets of users (teacher and student) in Django authentication

Thanks man, I think that will do, could you please show how the UserManager would be ? — Goun2, Mar 20 '17 at 16:18

How to have multiple types of users in separated tables?

1 Answers1