database - Historicity in Django -

i want create couple of object's in django model. such room[idroom, nameroom] , user[iduser, nameuser].

i want have multiple users in room's , room's user. want user's in specific room , rooms user.

also, want make history of changing room , user table.

anybody can me this?

this sketch of need have:

class user(models.model):     pass  class room(models.model):     users = models.manytomanyfield(user, related_name="rooms")  class history(models.model):     room = models.foreignkey(room)     user = models.foreignkey(user)     time = models.datetimefield(auto_now_add=true)  # add objects first_user = user() first_user.save() first_room = room() first_room.save() first_user.rooms.add(first_room) history(room=first_room, user=first_user).save() # ^^^ automatically adds current date , time  # fetch them this: room.objects.get(pk=the_room).users.all() user.objects.get(pk=the_user).rooms.all() user.objects.get(pk=the_user).history_set.order_by("-time")