from django.db import models


class CertLMSLearner(models.Model):
    user_gid = models.CharField(max_length=20, primary_key=True)
    login = models.CharField(max_length=200, unique=True)
    first_name = models.CharField(max_length=50, null=True)
    last_name = models.CharField(max_length=50, null=True)
    email = models.CharField(max_length=200, unique=True)
    user_type = models.CharField(max_length=30, null=True)
    user_id = models.CharField(max_length=30, unique=True)
    status = models.CharField(max_length=30, null=True)
    language = models.CharField(max_length=10, null=True)
    country = models.CharField(max_length=30, null=True)
    phone_number = models.CharField(max_length=50, null=True)
    company_name = models.CharField(max_length=100, null=True)

    class Meta:
        db_table = "global_lms_learners"
        managed = False


class CertLMSLearnerExam(models.Model):
    user_id = models.CharField(max_length=30)
    login = models.CharField(max_length=200)
    exam_id = models.CharField(max_length=30)
    exam_name = models.CharField(max_length=180)
    complete_date = models.DateTimeField(null=True)
    status = models.CharField(max_length=20, null=True)
    certificate_unique_identifier = models.CharField(max_length=60, primary_key=True)
    certificate_name = models.CharField(max_length=60)

    class Meta:
        db_table = "global_lms_learner_exams"
        managed = False