Skip to content
Snippets Groups Projects
Select Git revision
  • 8a8cbfbc3a7d66b0bc1b588885d5aa23c273bba5
  • master default protected
2 results

0001_initial.py

Blame
    • 0001_initial.py 4.76 KiB
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    64
    65
    66
    67
    68
    69
    70
    71
    72
    73
    74
    75
    76
    77
    78
    79
    80
    81
    82
    83
    84
    85
    86
    87
    88
    89
    90
    91
    92
    93
    94
    95
    96
    97
    98
    99
    100
    101
    102
    103
    104
    105
    106
    107
    108
    109
    110
    111 
    

    

    

    # -*- 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')]),
        ),
    ]