# Generated by Django 5.2.4 on 2026-05-29 16:55

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


class Migration(migrations.Migration):

    dependencies = [
        ('api', '0052_update_first_admin_role'),
    ]

    operations = [
        migrations.CreateModel(
            name='EsInvigilatorSuitability',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('invigilator', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.esinvigilator')),
            ],
            options={
                'db_table': 'es_invigilator_suitability',
            },
        ),
        migrations.CreateModel(
            name='EsLocationSuitability',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('location', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.eslocation')),
            ],
            options={
                'db_table': 'es_location_suitability',
            },
        ),
        migrations.CreateModel(
            name='EsSuitability',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('code', models.CharField(max_length=100)),
                ('name', models.CharField(max_length=100)),
                ('desc', models.TextField(null=True)),
                ('extra_data_1', models.TextField(null=True)),
                ('extra_data_2', models.TextField(null=True)),
                ('extra_data_3', models.TextField(null=True)),
                ('extra_data_4', models.TextField(null=True)),
                ('extra_data_5', models.TextField(null=True)),
                ('extra_data_6', models.TextField(null=True)),
                ('extra_data_7', models.TextField(null=True)),
                ('extra_data_8', models.TextField(null=True)),
                ('extra_data_9', models.TextField(null=True)),
                ('extra_data_10', models.TextField(null=True)),
                ('status', models.SmallIntegerField()),
                ('created_by', models.BigIntegerField(null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_by', models.BigIntegerField(null=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('department', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='api.esdepartment')),
                ('invigilator', models.ManyToManyField(through='api.EsInvigilatorSuitability', to='api.esinvigilator')),
                ('location', models.ManyToManyField(through='api.EsLocationSuitability', to='api.eslocation')),
            ],
            options={
                'db_table': 'es_suitability',
            },
        ),
        migrations.AddField(
            model_name='eslocationsuitability',
            name='suitability',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.essuitability'),
        ),
        migrations.AddField(
            model_name='esinvigilatorsuitability',
            name='suitability',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.essuitability'),
        ),
        migrations.CreateModel(
            name='EsExamRequirementLocationSuitability',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('exam_requirement', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.esexamrequirement')),
                ('suitability', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.essuitability')),
            ],
            options={
                'db_table': 'es_exam_requirement_location_suitability',
                'unique_together': {('exam_requirement', 'suitability')},
            },
        ),
        migrations.CreateModel(
            name='EsExamRequirementInvigilatorSuitability',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('exam_requirement', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.esexamrequirement')),
                ('suitability', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.essuitability')),
            ],
            options={
                'db_table': 'es_exam_requirement_invigilator_suitability',
                'unique_together': {('exam_requirement', 'suitability')},
            },
        ),
        migrations.CreateModel(
            name='EsExamActivityLocationSuitability',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('exam_activity', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.esexamactivity')),
                ('suitability', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.essuitability')),
            ],
            options={
                'db_table': 'es_exam_activity_location_suitability',
                'unique_together': {('exam_activity', 'suitability')},
            },
        ),
        migrations.CreateModel(
            name='EsExamActivityInvigilatorSuitability',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('exam_activity', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.esexamactivity')),
                ('suitability', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.essuitability')),
            ],
            options={
                'db_table': 'es_exam_activity_invigilator_suitability',
                'unique_together': {('exam_activity', 'suitability')},
            },
        ),
        migrations.AddField(
            model_name='esexamactivity',
            name='invigilator_suitability',
            field=models.ManyToManyField(related_name='exam_activity_invigilator_suitability', through='api.EsExamActivityInvigilatorSuitability', to='api.essuitability'),
        ),
        migrations.AddField(
            model_name='esexamactivity',
            name='location_suitability',
            field=models.ManyToManyField(related_name='exam_activity_location_suitability', through='api.EsExamActivityLocationSuitability', to='api.essuitability'),
        ),
        migrations.AddField(
            model_name='esexamrequirement',
            name='invigilator_suitability',
            field=models.ManyToManyField(related_name='exam_requirement_invigilator_suitability', through='api.EsExamRequirementInvigilatorSuitability', to='api.essuitability'),
        ),
        migrations.AddField(
            model_name='esexamrequirement',
            name='location_suitability',
            field=models.ManyToManyField(related_name='exam_requirement_location_suitability', through='api.EsExamRequirementLocationSuitability', to='api.essuitability'),
        ),
        migrations.AddField(
            model_name='esinvigilator',
            name='suitability',
            field=models.ManyToManyField(through='api.EsInvigilatorSuitability', to='api.essuitability'),
        ),
        migrations.AddField(
            model_name='eslocation',
            name='suitability',
            field=models.ManyToManyField(through='api.EsLocationSuitability', to='api.essuitability'),
        ),
        migrations.AlterUniqueTogether(
            name='eslocationsuitability',
            unique_together={('location', 'suitability')},
        ),
        migrations.AlterUniqueTogether(
            name='esinvigilatorsuitability',
            unique_together={('invigilator', 'suitability')},
        ),
    ]