# Generated by Django 5.2.4 on 2026-05-15 11:07

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


class Migration(migrations.Migration):

    dependencies = [
        ('api', '0043_update_session_first_admin_role'),
    ]

    operations = [
        migrations.CreateModel(
            name='EsExamRequirementPrecedingExaminationGroup',
            fields=[
                ('id', models.BigAutoField(primary_key=True, serialize=False)),
            ],
            options={
                'db_table': 'es_exam_requirement_preceding_examination_group',
            },
        ),
        migrations.CreateModel(
            name='EsExamRequirementSameLocationGroup',
            fields=[
                ('id', models.BigAutoField(primary_key=True, serialize=False)),
            ],
            options={
                'db_table': 'es_exam_requirement_same_location_group',
            },
        ),
        migrations.CreateModel(
            name='EsExamRequirementSameTimeGroup',
            fields=[
                ('id', models.BigAutoField(primary_key=True, serialize=False)),
            ],
            options={
                'db_table': 'es_exam_requirement_same_time_group',
            },
        ),
        migrations.CreateModel(
            name='EsExamRequirementPrecedingExamination',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('exam_activity', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.esexamactivity')),
                ('exam_requirement', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.esexamrequirement')),
                ('group', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.esexamrequirementprecedingexaminationgroup')),
            ],
            options={
                'db_table': 'es_exam_requirement_preceding_examination',
                'constraints': [models.UniqueConstraint(fields=('group', 'exam_requirement', 'exam_activity'), name='unique_exam_requirement_preceding_examination')],
            },
        ),
        migrations.CreateModel(
            name='EsExamRequirementSameLocation',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('exam_activity', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.esexamactivity')),
                ('exam_requirement', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.esexamrequirement')),
                ('group', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.esexamrequirementsamelocationgroup')),
            ],
            options={
                'db_table': 'es_exam_requirement_same_location',
                'constraints': [models.UniqueConstraint(fields=('group', 'exam_requirement', 'exam_activity'), name='unique_exam_requirement_same_location')],
            },
        ),
        migrations.CreateModel(
            name='EsExamRequirementSameTime',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('exam_activity', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.esexamactivity')),
                ('exam_requirement', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.esexamrequirement')),
                ('group', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.esexamrequirementsametimegroup')),
            ],
            options={
                'db_table': 'es_exam_requirement_same_time',
                'constraints': [models.UniqueConstraint(fields=('group', 'exam_requirement', 'exam_activity'), name='unique_exam_requirement_same_time')],
            },
        ),
    ]