from django.db import models from django.conf import settings class UserLessonLearnHistory(models.Model): user = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.DO_NOTHING) course = models.ForeignKey('university.Course', on_delete=models.DO_NOTHING) chapter = models.ForeignKey('university.Chapter', on_delete=models.DO_NOTHING) lesson = models.ForeignKey('university.Lesson', on_delete=models.DO_NOTHING) total_visited_count = models.IntegerField(default=1) progress = models.FloatField(default=0) first_visited_at = models.DateTimeField(auto_now_add=True) last_visited_at = models.DateTimeField(auto_now=True) class Meta: db_table = 'user_lesson_learn_history' unique_together = ('user', 'lesson', 'course', 'chapter')