# Generated by Django 3.2.4 on 2021-07-30 05:28

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name='Classroom',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=30)),
                ('grade', models.CharField(max_length=4)),
                ('average_at_risk', models.IntegerField(blank=True, default=0)),
                ('teacher', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='Student',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('first_name', models.CharField(max_length=30)),
                ('last_name', models.CharField(max_length=30)),
                ('date_of_birth', models.DateField()),
                ('grade', models.CharField(max_length=4)),
                ('gender', models.CharField(choices=[('M', 'Male'), ('F', 'Female')], max_length=1)),
                ('exam_taken', models.CharField(choices=[('Y', 'Student has taken the exam'), ('N', 'Student has not taken the exam')], default='N', max_length=1)),
                ('risk', models.CharField(choices=[('GREAT', 'Student is not at risk'), ('AT_RISK', 'Student is at risk.'), ('UNKNOWN', 'Student risk level is unknown')], default='UNKNOWN', max_length=7)),
                ('question_1', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_2', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_3', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_4', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_5', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_6', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_7', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_8', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_9', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_10', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_11', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_12', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_13', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_14', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_15', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_16', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_17', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_18', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_19', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_20', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_21', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_22', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_23', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_24', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_25', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('question_26', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_1', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_2', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_3', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_4', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_5', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_6', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_7', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_8', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_9', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_10', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_11', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_12', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_13', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_14', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_15', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_16', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_17', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_18', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_19', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_20', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_21', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_22', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_23', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_24', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_25', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_26', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_27', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_28', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_29', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_30', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p2question_31', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p3question_1', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p3question_2', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p3question_3', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p3question_4', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p3question_5', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p3question_6', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p3question_7', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p3question_8', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p4question_1', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p4question_2', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p4question_3', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p4question_4', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p4question_5', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p4question_6', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p5question_1', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p5question_2', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p5question_3', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p5question_4', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('p5question_5', models.CharField(choices=[('Y', 'Correct Answer'), ('N', 'Incorrect Answer'), ('D', 'No Answer')], default='D', max_length=1)),
                ('timespent', models.IntegerField(default=0)),
                ('max_questions_wrong', models.IntegerField(default=0)),
                ('classroom', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='student_info.classroom')),
                ('teacher', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
            ],
        ),
    ]
