# -*- coding: utf-8 -*- # Generated by Django 1.9 on 2017-04-23 15:19 from __future__ import unicode_literals from django.db import migrations, models import django.db.models.deletion class Migration(migrations.Migration): initial = True dependencies = [ ] operations = [ migrations.CreateModel( name='Courses_Table', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('course_id', models.CharField(max_length=6, unique=True)), ('course_name', models.CharField(max_length=50)), ('course_credits', models.IntegerField()), ('course_alias', models.CharField(default='None', max_length=15)), ], ), migrations.CreateModel( name='Date_wise_attendance', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('date', models.DateField()), ('number_of_hours', models.IntegerField(default=1)), ], ), migrations.CreateModel( name='Professor_Tables', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('username', models.CharField(max_length=10, unique=True)), ('Name', models.CharField(max_length=50)), ('password', models.CharField(max_length=15)), ('designation', models.CharField(max_length=30)), ('date_of_birth', models.DateField()), ], ), migrations.CreateModel( name='Student_attendance', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('classes_held', models.IntegerField(default=0)), ('classes_attended', models.IntegerField(default=0)), ('attendance_persentage', models.FloatField(default=0.0)), ], ), migrations.CreateModel( name='Student_course', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('course', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Validate.Courses_Table')), ], ), migrations.CreateModel( name='Students_Table', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('student_dept', models.CharField(max_length=3)), ('student_year', models.CharField(max_length=4)), ('student_section', models.CharField(max_length=1)), ('student_rollno', models.CharField(max_length=2)), ('student_name', models.CharField(max_length=50)), ], ), migrations.CreateModel( name='Teacher_Course', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('batch', models.CharField(max_length=4)), ('section', models.CharField(max_length=1)), ('courses_taken', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Validate.Courses_Table')), ('prof', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Validate.Professor_Tables')), ], ), migrations.AlterUniqueTogether( name='students_table', unique_together=set([('student_dept', 'student_year', 'student_section', 'student_rollno')]), ), migrations.AddField( model_name='student_course', name='student', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Validate.Students_Table'), ), migrations.AddField( model_name='student_attendance', name='student_course', field=models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to='Validate.Student_course'), ), migrations.AddField( model_name='date_wise_attendance', name='student_attendance', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Validate.Student_attendance'), ), migrations.AlterUniqueTogether( name='teacher_course', unique_together=set([('prof', 'courses_taken', 'batch', 'section')]), ), migrations.AlterUniqueTogether( name='student_course', unique_together=set([('student', 'course')]), ), ]