# Generated by Django 4.2.11 on 2025-05-26 15:20

from django.db import migrations, models
import django.db.models.deletion


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Classe',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('class_code', models.CharField(blank=True, max_length=50, null=True)),
                ('serie', models.CharField(blank=True, max_length=20, null=True)),
                ('niveau', models.CharField(blank=True, max_length=20, null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
            ],
            options={
                'db_table': 'classe',
            },
        ),
        migrations.CreateModel(
            name='Enseignant',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('nom', models.CharField(blank=True, max_length=100, null=True)),
                ('tel', models.CharField(blank=True, max_length=30, null=True)),
                ('email', models.EmailField(max_length=254, unique=True)),
                ('login', models.CharField(blank=True, max_length=50, null=True)),
                ('password', models.CharField(blank=True, max_length=100, null=True)),
                ('status', models.CharField(blank=True, max_length=20, null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
            ],
            options={
                'db_table': 'enseignant',
            },
        ),
        migrations.CreateModel(
            name='Entete',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('nom_etab', models.CharField(blank=True, max_length=50, null=True)),
                ('annee_scol', models.CharField(blank=True, max_length=30, null=True)),
                ('region', models.CharField(blank=True, max_length=30, null=True)),
                ('department', models.CharField(blank=True, max_length=30, null=True)),
                ('status', models.CharField(blank=True, max_length=20, null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
            ],
            options={
                'db_table': 'entete',
            },
        ),
        migrations.CreateModel(
            name='Epreuve',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('libelle', models.CharField(blank=True, max_length=50, null=True)),
                ('nbre_point', models.IntegerField(blank=True, null=True)),
                ('coef', models.IntegerField(blank=True, null=True)),
                ('duree', models.CharField(blank=True, max_length=20, null=True)),
                ('status', models.CharField(blank=True, max_length=20, null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
            ],
            options={
                'db_table': 'epreuve',
            },
        ),
        migrations.CreateModel(
            name='Exercice',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('titre', models.TextField(blank=True, null=True)),
                ('enoncer', models.TextField(blank=True, null=True)),
                ('nbre_point', models.IntegerField(blank=True, null=True)),
                ('status', models.CharField(blank=True, max_length=20, null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('id_classe', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='epreuveApp.classe')),
                ('id_enseignant', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='epreuveApp.enseignant')),
            ],
            options={
                'db_table': 'exercice',
            },
        ),
        migrations.CreateModel(
            name='Matiere',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('libelle', models.CharField(blank=True, max_length=30, null=True, unique=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
            ],
            options={
                'db_table': 'matiere',
            },
        ),
        migrations.CreateModel(
            name='Question',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('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(blank=True, max_length=20, null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
            ],
            options={
                'db_table': 'question',
            },
        ),
        migrations.CreateModel(
            name='Recompense',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('libelle', models.CharField(blank=True, max_length=50, null=True)),
                ('score', models.IntegerField(blank=True, null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('id_enseignant', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='epreuveApp.enseignant')),
            ],
            options={
                'db_table': 'recompense',
            },
        ),
        migrations.CreateModel(
            name='QuestionExercice',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('id_exercice', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='epreuveApp.exercice')),
                ('id_question', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='epreuveApp.question')),
            ],
            options={
                'db_table': 'question_exercice',
            },
        ),
        migrations.CreateModel(
            name='MonterSujet',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date_montage', models.DateField(blank=True, null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('id_enseignant', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='epreuveApp.enseignant')),
                ('id_entete', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='epreuveApp.entete')),
                ('id_epreuve', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='epreuveApp.epreuve')),
            ],
            options={
                'db_table': 'monter_sujet',
            },
        ),
        migrations.CreateModel(
            name='ExerciceEpreuve',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('id_epreuve', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='epreuveApp.epreuve')),
                ('id_exercice', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='epreuveApp.exercice')),
            ],
            options={
                'db_table': 'exercice_epreuve',
            },
        ),
        migrations.AddField(
            model_name='exercice',
            name='id_matiere',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='epreuveApp.matiere'),
        ),
    ]