# Generated by Django 4.2.7 on 2026-02-18 14:07

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


class Migration(migrations.Migration):

    dependencies = [
        ('exams', '0013_examschoolresult_uploadprogress_process_type_and_more'),
    ]

    operations = [
        migrations.CreateModel(
            name='ExamSubjectResult',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('with_results', models.IntegerField()),
                ('subj_avg', models.FloatField(blank=True, null=True)),
                ('subj_avg_grd', models.CharField(blank=True, max_length=5, null=True)),
                ('subj_avg_status', models.CharField(blank=True, max_length=15, null=True)),
                ('subj_gpa', models.FloatField(blank=True, null=True)),
                ('subj_gpa_grade', models.CharField(blank=True, max_length=5, null=True)),
                ('subj_gpa_status', models.CharField(blank=True, max_length=15, null=True)),
                ('subj_release_status', models.BooleanField(default=False)),
                ('subj_rank_involvement', models.BooleanField(default=True)),
                ('processed_at', models.DateTimeField(auto_now=True)),
                ('project', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='exams.jointexamproject')),
                ('school', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='exams.school')),
                ('subject', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='exams.examsubject')),
            ],
            options={
                'indexes': [models.Index(fields=['project', 'subject'], name='exams_exams_project_3aeaa3_idx'), models.Index(fields=['school'], name='exams_exams_school__c1db82_idx')],
                'unique_together': {('project', 'subject', 'school')},
            },
        ),
    ]