# Generated by Django 4.2.9 on 2026-02-26 08:43 from decimal import Decimal from django.conf import settings from django.db import migrations, models import django.db.models.deletion import django.utils.timezone class Migration(migrations.Migration): dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ('app', '0067_backupconfiguration_database_alias_and_more'), ] operations = [ migrations.CreateModel( name='SecondaryCompetency', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('code', models.CharField(max_length=30, unique=True)), ('name', models.CharField(max_length=120)), ('description', models.TextField(blank=True, null=True)), ('is_active', models.BooleanField(default=True)), ], options={ 'ordering': ['code'], }, ), migrations.CreateModel( name='SecondaryComputationPolicy', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(default='Uganda CBC Lower Secondary', max_length=100)), ('level', models.CharField(choices=[('LOWER_SECONDARY', 'Lower Secondary (S1-S4)')], default='LOWER_SECONDARY', max_length=30)), ('ca_weight', models.DecimalField(decimal_places=2, default=Decimal('20.00'), max_digits=5)), ('exam_weight', models.DecimalField(decimal_places=2, default=Decimal('80.00'), max_digits=5)), ('rounding_mode', models.CharField(choices=[('ONE_DECIMAL', 'One decimal place (69.4)'), ('WHOLE_NUMBER', 'Whole number (half up)'), ('WHOLE_NUMBER_DOWN', 'Whole number (floor)')], default='ONE_DECIMAL', max_length=30)), ('effective_from', models.DateField(default=django.utils.timezone.now)), ('effective_to', models.DateField(blank=True, null=True)), ('is_active', models.BooleanField(default=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('section', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='secondary_policies', to='app.section')), ], options={ 'ordering': ['-effective_from', '-id'], }, ), migrations.CreateModel( name='UNEBSubmissionBatch', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(default='S4 UNEB CA Submission', max_length=150)), ('level', models.CharField(choices=[('LOWER_SECONDARY', 'Lower Secondary (S1-S4)')], default='LOWER_SECONDARY', max_length=30)), ('status', models.CharField(choices=[('DRAFT', 'Draft'), ('PENDING_APPROVAL', 'Pending Approval'), ('APPROVED', 'Approved'), ('SUBMITTED', 'Submitted to UNEB'), ('LOCKED', 'Locked'), ('REJECTED', 'Rejected')], default='DRAFT', max_length=25)), ('submission_reference', models.CharField(blank=True, default='', max_length=100)), ('notes', models.TextField(blank=True, null=True)), ('approved_at', models.DateTimeField(blank=True, null=True)), ('submitted_at', models.DateTimeField(blank=True, null=True)), ('locked_at', models.DateTimeField(blank=True, null=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('academic_year', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='uneb_ca_batches', to='app.academicyear')), ('approved_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='uneb_ca_batches_approved', to=settings.AUTH_USER_MODEL)), ('candidate_class', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='uneb_ca_batches', to='app.class')), ('created_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='uneb_ca_batches_created', to=settings.AUTH_USER_MODEL)), ('section', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='uneb_ca_batches', to='app.section')), ('submitted_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='uneb_ca_batches_submitted', to=settings.AUTH_USER_MODEL)), ], options={ 'ordering': ['-created_at'], }, ), migrations.CreateModel( name='SubjectCompetency', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('is_core', models.BooleanField(default=True)), ('competency', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='subject_links', to='app.secondarycompetency')), ('section', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='subject_competencies', to='app.section')), ('subject', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='secondary_competencies', to='app.subject')), ], options={ 'unique_together': {('subject', 'competency')}, }, ), migrations.CreateModel( name='ContinuousAssessmentTask', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=150)), ('task_type', models.CharField(choices=[('PROJECT', 'Project'), ('PRACTICAL', 'Practical'), ('COURSEWORK', 'Coursework'), ('PORTFOLIO', 'Portfolio'), ('PRESENTATION', 'Presentation'), ('GROUP_WORK', 'Group Work'), ('ORAL', 'Oral Task'), ('FIELD_STUDY', 'Field Study'), ('OTHER', 'Other')], default='PROJECT', max_length=30)), ('weight', models.DecimalField(decimal_places=2, default=Decimal('0.00'), max_digits=5)), ('max_score', models.DecimalField(decimal_places=2, default=Decimal('100.00'), max_digits=6)), ('assigned_date', models.DateField(default=django.utils.timezone.now)), ('evidence_required', models.BooleanField(default=False)), ('uneb_eligible', models.BooleanField(default=True)), ('status', models.CharField(choices=[('DRAFT', 'Draft'), ('PENDING_MODERATION', 'Pending Moderation'), ('MODERATED', 'Moderated'), ('APPROVED', 'Approved'), ('LOCKED', 'Locked')], default='DRAFT', max_length=25)), ('approved_at', models.DateTimeField(blank=True, null=True)), ('locked_at', models.DateTimeField(blank=True, null=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('academic_class', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='ca_tasks', to='app.academicclass')), ('approved_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='ca_tasks_approved', to=settings.AUTH_USER_MODEL)), ('created_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='ca_tasks_created', to=settings.AUTH_USER_MODEL)), ('subject', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='ca_tasks', to='app.subject')), ('subject_competency', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='ca_tasks', to='app.subjectcompetency')), ('term', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='ca_tasks', to='app.term')), ], options={ 'ordering': ['-assigned_date', '-id'], 'unique_together': {('academic_class', 'subject', 'title', 'assigned_date')}, }, ), migrations.CreateModel( name='ContinuousAssessmentRecord', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('raw_score', models.DecimalField(decimal_places=2, max_digits=6)), ('moderated_score', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)), ('teacher_comment', models.TextField(blank=True, null=True)), ('evidence_reference', models.CharField(blank=True, default='', max_length=255)), ('moderation_status', models.CharField(choices=[('DRAFT', 'Draft'), ('PENDING', 'Pending Moderation'), ('MODERATED', 'Moderated'), ('APPROVED', 'Approved'), ('LOCKED', 'Locked'), ('REJECTED', 'Rejected')], default='DRAFT', max_length=20)), ('is_locked', models.BooleanField(default=False)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('entered_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='ca_records_entered', to=settings.AUTH_USER_MODEL)), ('student', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='ca_records', to='app.student')), ('task', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='records', to='app.continuousassessmenttask')), ('updated_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='ca_records_updated', to=settings.AUTH_USER_MODEL)), ], options={ 'ordering': ['task_id', 'student_id'], 'unique_together': {('task', 'student')}, }, ), migrations.CreateModel( name='CAModeration', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('status', models.CharField(choices=[('PENDING', 'Pending'), ('APPROVED', 'Approved'), ('REJECTED', 'Rejected'), ('ADJUSTED', 'Adjusted')], default='PENDING', max_length=20)), ('moderated_score', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)), ('comments', models.TextField(blank=True, null=True)), ('moderated_at', models.DateTimeField(auto_now=True)), ('moderated_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='ca_moderations_done', to=settings.AUTH_USER_MODEL)), ('record', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='moderation', to='app.continuousassessmentrecord')), ], options={ 'ordering': ['-moderated_at'], }, ), migrations.CreateModel( name='UNEBSubmissionItem', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('ca_mark', models.DecimalField(decimal_places=2, max_digits=5)), ('final_ca_mark', models.DecimalField(blank=True, decimal_places=2, max_digits=5, null=True)), ('source_task_count', models.PositiveIntegerField(default=0)), ('evidence_count', models.PositiveIntegerField(default=0)), ('moderation_status', models.CharField(choices=[('DRAFT', 'Draft'), ('PENDING', 'Pending Moderation'), ('MODERATED', 'Moderated'), ('APPROVED', 'Approved'), ('LOCKED', 'Locked'), ('REJECTED', 'Rejected')], default='PENDING', max_length=20)), ('is_locked', models.BooleanField(default=False)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('batch', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='items', to='app.unebsubmissionbatch')), ('student', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='uneb_ca_items', to='app.student')), ('subject', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='uneb_ca_items', to='app.subject')), ], options={ 'ordering': ['student_id', 'subject_id'], 'unique_together': {('batch', 'student', 'subject')}, }, ), migrations.CreateModel( name='SecondaryGradeBand', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('grade', models.CharField(max_length=5)), ('descriptor', models.CharField(max_length=120)), ('min_score', models.DecimalField(decimal_places=2, max_digits=5)), ('max_score', models.DecimalField(decimal_places=2, max_digits=5)), ('display_order', models.PositiveSmallIntegerField(default=0)), ('policy', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='grade_bands', to='app.secondarycomputationpolicy')), ], options={ 'ordering': ['display_order', '-min_score'], 'unique_together': {('policy', 'grade')}, }, ), ]