# Generated by Django 5.2.12 on 2026-04-16 18:53 import datetime import django.db.models.deletion import django.utils.timezone import std_app.models from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name='GlobalSMSSettings', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('api_key', models.CharField(blank=True, max_length=255, null=True)), ('sender_id', models.CharField(blank=True, max_length=100, null=True)), ('is_active', models.BooleanField(default=False)), ('site_domain', models.CharField(blank=True, default='', help_text='Production domain for SMS links, e.g. https://school.example.com (no trailing slash)', max_length=255, null=True)), ('msg_check_in', models.TextField(default='Dear, Your Child {student_name} {status} at {time}. Details: {history_url}', help_text='Variables: {student_name}, {status}, {time}, {history_url}')), ('msg_check_out', models.TextField(default='Dear, Your Child {student_name} {status} at {time}. Details: {history_url}', help_text='Variables: {student_name}, {status}, {time}, {history_url}')), ], ), migrations.CreateModel( name='School', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=255)), ('code', models.CharField(max_length=50, unique=True)), ('admin_username', models.CharField(blank=True, max_length=100, null=True)), ('password', models.CharField(blank=True, max_length=255, null=True)), ('address', models.TextField(blank=True, null=True)), ('is_sms_enabled', models.BooleanField(default=False)), ('is_hold_enabled', models.BooleanField(default=True)), ('is_time_test_enabled', models.BooleanField(default=False)), ('is_time_test_active', models.BooleanField(default=False)), ('test_timestamp', models.DateTimeField(blank=True, null=True)), ('test_set_at', models.DateTimeField(blank=True, null=True)), ('monthly_announcement_limit', models.IntegerField(default=5)), ('announcements_sent_this_month', models.IntegerField(default=0)), ('last_announcement_reset', models.DateField(default=datetime.date.today)), ('is_individual_sms_enabled', models.BooleanField(default=False)), ('subscription_end_date', models.DateField(blank=True, null=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ], ), migrations.CreateModel( name='Holiday', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('date', models.DateField()), ('note', models.CharField(max_length=255)), ('day_type', models.CharField(choices=[('HOLIDAY', 'Holiday'), ('WORKING_DAY', 'Working Day')], default='HOLIDAY', max_length=20)), ('is_full_day', models.BooleanField(default=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('school', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='holidays', to='std_app.school')), ], ), migrations.CreateModel( name='GradeConfig', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('grade_name', models.CharField(max_length=10)), ('min_marks', models.DecimalField(decimal_places=2, max_digits=5)), ('max_marks', models.DecimalField(decimal_places=2, max_digits=5)), ('gpa_value', models.DecimalField(decimal_places=2, max_digits=3)), ('created_at', models.DateTimeField(auto_now_add=True)), ('school', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='grade_configs', to='std_app.school')), ], options={ 'ordering': ['-min_marks'], }, ), migrations.CreateModel( name='FeeType', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=255)), ('default_amount', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)), ('created_at', models.DateTimeField(auto_now_add=True)), ('school', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='fee_types', to='std_app.school')), ], ), migrations.CreateModel( name='Exam', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=255)), ('year', models.IntegerField(default=2026)), ('created_at', models.DateTimeField(auto_now_add=True)), ('school', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='exams', to='std_app.school')), ], ), migrations.CreateModel( name='Device', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('serial_number', models.CharField(max_length=100, unique=True)), ('name', models.CharField(default='ZK Device', max_length=255)), ('is_authorized', models.BooleanField(default=False)), ('is_terminated', models.BooleanField(default=False)), ('last_seen', models.DateTimeField(auto_now=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('school', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='devices', to='std_app.school')), ], ), migrations.CreateModel( name='DetectionFee', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('reason', models.CharField(max_length=255)), ('amount', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)), ('grace_minutes', models.IntegerField(default=0)), ('created_at', models.DateTimeField(auto_now_add=True)), ('school', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='detection_fees', to='std_app.school')), ], ), migrations.CreateModel( name='Announcement', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('message', models.TextField()), ('is_bulk', models.BooleanField(default=False)), ('created_at', models.DateTimeField(auto_now_add=True)), ('schools', models.ManyToManyField(blank=True, related_name='announcements', to='std_app.school')), ('seen_by', models.ManyToManyField(blank=True, related_name='seen_announcements', to='std_app.school')), ], ), migrations.CreateModel( name='SMSLog', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('recipient', models.CharField(max_length=20)), ('message', models.TextField()), ('status', models.CharField(default='SENT', max_length=50)), ('timestamp', models.DateTimeField(auto_now_add=True)), ('school', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='sms_logs', to='std_app.school')), ], ), migrations.CreateModel( name='Student', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('pin', models.CharField(max_length=50)), ('roll', models.IntegerField(blank=True, null=True)), ('name', models.CharField(max_length=255)), ('photo', models.ImageField(blank=True, null=True, upload_to=std_app.models.student_photo_upload_path)), ('father_name', models.CharField(blank=True, max_length=255, null=True)), ('mother_name', models.CharField(blank=True, max_length=255, null=True)), ('dob', models.DateField(blank=True, null=True)), ('birth_certificate_number', models.CharField(blank=True, max_length=100, null=True)), ('contact_number', models.CharField(blank=True, max_length=20, null=True)), ('address', models.TextField(blank=True, null=True)), ('admission_date', models.DateField(default=django.utils.timezone.now)), ('late_cleared_until', models.DateField(blank=True, null=True)), ('absent_cleared_until', models.DateField(blank=True, null=True)), ('is_active', models.BooleanField(default=True)), ('is_sms_enabled', models.BooleanField(default=True)), ('secret_code', models.CharField(blank=True, max_length=10, null=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('school', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='students', to='std_app.school')), ], ), migrations.CreateModel( name='FeeTransaction', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('total_amount', models.DecimalField(decimal_places=2, max_digits=10)), ('discount_amount', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)), ('fine_amount', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)), ('payment_method', models.CharField(choices=[('CASH', 'Cash'), ('BKASH', 'bKash'), ('NOGOD', 'Nagad'), ('ROCKET', 'Rocket'), ('BANK', 'Bank'), ('OTHERS', 'Others')], default='CASH', max_length=20)), ('reference_number', models.CharField(blank=True, max_length=100, null=True)), ('timestamp', models.DateTimeField(auto_now_add=True)), ('school', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='fee_transactions', to='std_app.school')), ('student', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='fee_history', to='std_app.student')), ], ), migrations.CreateModel( name='AttendanceLog', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('timestamp', models.DateTimeField()), ('check_type', models.CharField(default='IN', max_length=10)), ('status', models.CharField(blank=True, max_length=50, null=True)), ('unidentified_pin', models.CharField(blank=True, max_length=50, null=True)), ('is_manually_edited', models.BooleanField(default=False)), ('created_at', models.DateTimeField(auto_now_add=True)), ('device', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='std_app.device')), ('school', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='attendance_records', to='std_app.school')), ('student', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='logs', to='std_app.student')), ], options={ 'ordering': ['-timestamp'], }, ), migrations.CreateModel( name='AdmitPass', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(help_text='e.g. Half Yearly Exam 2026', max_length=255)), ('start_date', models.DateField()), ('end_date', models.DateField()), ('issued_date', models.DateField(auto_now_add=True)), ('note', models.TextField(blank=True, null=True)), ('school', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='admit_passes', to='std_app.school')), ('student', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='issued_passes', to='std_app.student')), ], ), migrations.CreateModel( name='StudentClass', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=100)), ('created_at', models.DateTimeField(auto_now_add=True)), ('school', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='classes', to='std_app.school')), ], ), migrations.AddField( model_name='student', name='student_class', field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='students', to='std_app.studentclass'), ), migrations.AddField( model_name='device', name='assigned_class', field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='assigned_devices', to='std_app.studentclass'), ), migrations.CreateModel( name='ClassSchedule', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('punch_in_start', models.TimeField()), ('punch_in_end', models.TimeField()), ('checkout_start', models.TimeField()), ('checkout_end', models.TimeField()), ('lunch_start', models.TimeField(blank=True, null=True)), ('lunch_end', models.TimeField(blank=True, null=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('school', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='schedules', to='std_app.school')), ('student_class', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='schedule', to='std_app.studentclass')), ], ), migrations.CreateModel( name='StudentFee', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('amount', models.DecimalField(decimal_places=2, max_digits=10)), ('paid_amount', models.DecimalField(decimal_places=2, default=0.0, max_digits=10)), ('is_paid', models.BooleanField(default=False)), ('paid_at', models.DateTimeField(blank=True, null=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('fee_type', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='std_app.feetype')), ('student', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='fees', to='std_app.student')), ('student_class', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='recorded_fees', to='std_app.studentclass')), ], ), migrations.CreateModel( name='FeeTransactionItem', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('amount_paid', models.DecimalField(decimal_places=2, max_digits=10)), ('transaction', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='items', to='std_app.feetransaction')), ('fee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='std_app.studentfee')), ], ), migrations.CreateModel( name='StudentLeave', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('start_date', models.DateField()), ('end_date', models.DateField()), ('leave_type', models.CharField(max_length=100)), ('reason', models.TextField(blank=True, null=True)), ('is_approved', models.BooleanField(default=True)), ('is_deleted', models.BooleanField(default=False)), ('deleted_at', models.DateTimeField(blank=True, null=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('school', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='leaves', to='std_app.school')), ('student', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='leaves', to='std_app.student')), ], ), migrations.CreateModel( name='Subject', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=255)), ('code', models.CharField(blank=True, max_length=50, null=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('school', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='subjects', to='std_app.school')), ], ), migrations.AddField( model_name='studentclass', name='subjects', field=models.ManyToManyField(blank=True, related_name='classes', to='std_app.subject'), ), migrations.AddField( model_name='student', name='subjects', field=models.ManyToManyField(blank=True, related_name='students', to='std_app.subject'), ), migrations.CreateModel( name='SubjectGroup', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=255)), ('created_at', models.DateTimeField(auto_now_add=True)), ('school', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='subject_groups', to='std_app.school')), ], ), migrations.AddField( model_name='subject', name='group', field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='subjects', to='std_app.subjectgroup'), ), migrations.CreateModel( name='UserProfile', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('role', models.CharField(choices=[('SUPERUSER', 'Superuser'), ('SCHOOL_ADMIN', 'School Admin'), ('TEACHER', 'Teacher')], default='SCHOOL_ADMIN', max_length=20)), ('phone_number', models.CharField(blank=True, max_length=20, null=True)), ('nid', models.CharField(blank=True, max_length=50, null=True)), ('address', models.TextField(blank=True, null=True)), ('dob', models.DateField(blank=True, null=True)), ('qualification', models.TextField(blank=True, null=True)), ('school', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='admins', to='std_app.school')), ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='profile', to=settings.AUTH_USER_MODEL)), ], ), migrations.AddField( model_name='studentclass', name='teacher', field=models.ForeignKey(blank=True, limit_choices_to={'role': 'TEACHER'}, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='assigned_classes', to='std_app.userprofile'), ), migrations.CreateModel( name='VirtualClass', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=255)), ('join_link', models.URLField()), ('meeting_code', models.CharField(blank=True, max_length=100, null=True)), ('schedule_time', models.DateTimeField()), ('is_sms_sent', models.BooleanField(default=False)), ('created_at', models.DateTimeField(auto_now_add=True)), ('school', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='virtual_classes', to='std_app.school')), ('student_class', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='virtual_classes', to='std_app.studentclass')), ('students', models.ManyToManyField(blank=True, related_name='invited_virtual_classes', to='std_app.student')), ('subjects', models.ManyToManyField(blank=True, to='std_app.subject')), ('teacher', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='virtual_classes', to='std_app.userprofile')), ], options={ 'verbose_name_plural': 'Virtual Classes', 'ordering': ['-schedule_time'], }, ), migrations.AlterUniqueTogether( name='student', unique_together={('school', 'pin')}, ), migrations.CreateModel( name='ResultRecord', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('marks', models.DecimalField(decimal_places=2, max_digits=5)), ('grade', models.CharField(blank=True, max_length=5)), ('gpa', models.DecimalField(decimal_places=2, default=0.0, max_digits=3)), ('is_sms_sent', models.BooleanField(default=False)), ('created_at', models.DateTimeField(auto_now_add=True)), ('exam', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='records', to='std_app.exam')), ('student', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='results', to='std_app.student')), ('student_class', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='recorded_results', to='std_app.studentclass')), ('subject', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='records', to='std_app.subject')), ], options={ 'unique_together': {('student', 'exam', 'subject')}, }, ), ]