# Generated by Django 5.2.4 on 2026-03-22 17:52

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


class Migration(migrations.Migration):

    dependencies = [
        ('api', '0008_audittrail_role_color_role_created_at_and_more'),
    ]

    operations = [
        migrations.CreateModel(
            name='EsExamPeriod',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('code', models.CharField(max_length=150)),
                ('name', models.CharField(max_length=150)),
                ('start_date', models.DateField()),
                ('end_date', models.DateField()),
                ('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)),
            ],
            options={
                'db_table': 'es_exam_period',
            },
        ),
        migrations.CreateModel(
            name='EsExamPeriodUnavailability',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('unavailable_date', models.DateField()),
                ('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)),
                ('exam_period', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='api.esexamperiod')),
            ],
            options={
                'db_table': 'es_exam_period_unavailability',
            },
        ),
    ]