# Generated by Django 5.2.4 on 2026-08-20 16:39

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


class Migration(migrations.Migration):

    dependencies = [
        ('api', '0014_insert_setting'),
    ]

    operations = [
        migrations.CreateModel(
            name='TtStudent',
            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=255)),
                ('email', models.EmailField(max_length=254, null=True)),
                ('department', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='api.ttdepartment')),
                ('desc', 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': 'tt_student',
            },
        ),
        migrations.CreateModel(
            name='TtStudentAcademicTerm',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('academic_term', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.ttacademicterm')),
                ('student', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.ttstudent')),
            ],
            options={
                'db_table': 'tt_student_academic_term',
                'unique_together': {('student', 'academic_term')},
            },
        ),
        migrations.AddField(
            model_name='ttstudent',
            name='academic_term',
            field=models.ManyToManyField(through='api.TtStudentAcademicTerm', to='api.ttacademicterm'),
        ),
        migrations.CreateModel(
            name='TtStudentPos',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('pos', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.ttpos')),
                ('student', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.ttstudent')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
            ],
            options={
                'db_table': 'tt_student_pos',
                'unique_together': {('student', 'pos')},
            },
        ),
        migrations.AddField(
            model_name='ttstudent',
            name='pos',
            field=models.ManyToManyField(through='api.TtStudentPos', to='api.ttpos'),
        ),
        migrations.CreateModel(
            name='TtStudentPosModule',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('pos_module_group_module', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.ttposmodulegroupmodule')),
                ('student', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.ttstudent')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
            ],
            options={
                'db_table': 'tt_student_pos_module',
                'unique_together': {('student', 'pos_module_group_module')},
            },
        ),
        migrations.AddField(
            model_name='ttstudent',
            name='pos_module',
            field=models.ManyToManyField(through='api.TtStudentPosModule', to='api.ttposmodulegroupmodule'),
        ),
        migrations.CreateModel(
            name='TtStudentSetStudent',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('student', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.ttstudent')),
                ('student_set', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.ttstudentset')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
            ],
            options={
                'db_table': 'tt_student_set_student',
                'unique_together': {('student_set', 'student')},
            },
        ),
        migrations.AddField(
            model_name='ttstudentset',
            name='student',
            field=models.ManyToManyField(related_name='student_set', through='api.TtStudentSetStudent', to='api.ttstudent'),
        ),
    ]