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

class Migration(migrations.Migration):
  initial = True
  dependencies = [
      ('students', '0001_initial'),
      ('teachers', '0001_initial'),
  ]
  operations = [
      migrations.CreateModel(
          name='Grade',
          fields=[
              ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
              ('term', models.CharField(choices=[('1', 'Term 1'), ('2', 'Term 2'), ('3', 'Term 3'), ('final', 'Final')], default='1', max_length=10)),
              ('score', models.DecimalField(decimal_places=2, max_digits=5)),
              ('max_score', models.DecimalField(decimal_places=2, default=100, max_digits=5)),
              ('academic_year', models.CharField(default='2024-2025', max_length=20)),
              ('remarks', models.TextField(blank=True)),
              ('created_at', models.DateTimeField(auto_now_add=True)),
              ('student', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='grades', to='students.student')),
              ('subject', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='grades', to='teachers.subject')),
          ],
          options={'ordering': ['-created_at']},
      ),
  ]