# This is an auto-generated Django model module.
# You'll have to do the following manually to clean this up:
#   * Rearrange models' order
#   * Make sure each model has one field with primary_key=True
#   * Make sure each ForeignKey and OneToOneField has `on_delete` set to the desired behavior
#   * Remove `managed = False` lines if you wish to allow Django to create, modify, and delete the table
# Feel free to rename the models, but don't rename db_table values or field names.
from django.db import models


class Enseignant(models.Model):
    nom = models.CharField(max_length=100, blank=True, null=True)
    tel = models.CharField(max_length=30, blank=True, null=True)
    email = models.CharField(max_length=50, blank=True, null=True)
    login = models.CharField(max_length=50, blank=True, null=True)
    password = models.CharField(max_length=100, blank=True, null=True)
    status = models.CharField(max_length=20, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'enseignant'


class Entete(models.Model):
    nom_etab = models.CharField(max_length=50, blank=True, null=True)
    classe = models.CharField(max_length=30, blank=True, null=True)
    annee_scol = models.CharField(max_length=30, blank=True, null=True)
    coef = models.IntegerField(blank=True, null=True)
    duree = models.CharField(max_length=20, blank=True, null=True)
    region = models.CharField(max_length=30, blank=True, null=True)
    department = models.CharField(max_length=30, blank=True, null=True)
    status = models.CharField(max_length=20, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'entete'


class Exercice(models.Model):
    enoncer = models.TextField(blank=True, null=True)
    nbre_point = models.IntegerField(blank=True, null=True)
    status = models.CharField(max_length=20, blank=True, null=True)
    id_enseignant = models.IntegerField(blank=True, null=True)
    id_matiere = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'exercice'


class ExerciceEpreuve(models.Model):
    id_epreuve = models.IntegerField(blank=True, null=True)
    id_exercice = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'exercice_epreuve'


class Matiere(models.Model):
    libelle = models.CharField(max_length=30, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'matiere'


class MonterSujet(models.Model):
    id_entete = models.IntegerField(blank=True, null=True)
    id_epreuve = models.IntegerField(blank=True, null=True)
    id_enseignant = models.IntegerField(blank=True, null=True)
    date_montage = models.DateField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'monter_sujet'


class Question(models.Model):
    enoncer = models.TextField(blank=True, null=True)
    nbre_point = models.IntegerField(blank=True, null=True)
    graphique = models.TextField(blank=True, null=True)
    status = models.CharField(max_length=20, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'question'


class QuestionExercice(models.Model):
    id_exercice = models.IntegerField(blank=True, null=True)
    id_question = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'question_exercice'


class Recompense(models.Model):
    libelle = models.CharField(max_length=50, blank=True, null=True)
    score = models.IntegerField(blank=True, null=True)
    id_enseignant = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'recompense'