# Generated by Django 3.0.8 on 2020-07-25 10:06

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='bio_technology_dept',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200)),
                ('designation', models.CharField(max_length=200)),
                ('image', models.ImageField(upload_to='department/BT/image/')),
                ('detail', models.FileField(blank='True', upload_to='department/BT/data/')),
                ('sno', models.IntegerField(default='1')),
                ('staff_type', models.CharField(choices=[('HOD', 'Head Of Department'), ('FACULTY', 'Faculty Member'), ('TECHNICAL', 'Technical Staff'), ('SUPPORTING', 'Supporting Staff')], default='FACULTY', max_length=100)),
                ('description', models.TextField(blank=True, help_text='Enter description only for HOD. For others this field can be skipped.')),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_accreditation',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('designation', models.TextField(blank=True)),
                ('member_type', models.CharField(choices=[('PAC', 'Program Assessment Committee (PAC)'), ('DAB', 'Department Advisory Board (DAB)')], default='DAB', max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_achievements',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('achievement_description', models.TextField()),
                ('achievement_type', models.CharField(choices=[('STUDENT', 'Student Achievement'), ('STAFF', 'Staff Achievement')], default='STAFF', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_activities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('activity_name', models.CharField(max_length=200)),
                ('activity_description', models.TextField()),
                ('activity_type', models.CharField(choices=[('RE', 'Forum Activity'), ('STC', 'Department Activity')], default='RE', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_alumni',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=500)),
                ('designation', models.CharField(max_length=500)),
                ('description', models.TextField()),
                ('image', models.ImageField(upload_to='department/alumni/BT/')),
                ('sno', models.IntegerField(default='1')),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_book_chapters',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sl_no', models.IntegerField()),
                ('name_of_book_chapter', models.CharField(max_length=500)),
                ('names_of_authors', models.CharField(max_length=500)),
                ('year_of_pub', models.IntegerField()),
                ('name_of_pub', models.CharField(max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_classroom',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('classroom', models.FileField(upload_to='department/BT/data/classroom/')),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_classroom_description',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_events',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('events', models.FileField(upload_to='department/BT/data/events/')),
                ('semester', models.CharField(max_length=10)),
                ('name', models.CharField(max_length=30)),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_forum',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField(help_text="Enter a short description about your department's forum.")),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_gallery',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('image', models.ImageField(upload_to='department/gallery/BT/')),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_grants_and_patents',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
                ('grant_or_patent', models.CharField(choices=[('GRANT', 'Grant'), ('PATENT', 'Patent')], default='GRANT', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_lab_facilities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('qty', models.IntegerField()),
                ('config_specs', models.TextField()),
                ('softwares', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_laboratory_facilities_gallary',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('image', models.ImageField(upload_to='department/gallery/BT/laboratory/')),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_learning_materials',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(3, 3), (4, 4), (5, 5), (6, 6), (7, 7), (8, 8)])),
                ('subject_code', models.CharField(max_length=100)),
                ('material', models.FileField(upload_to='department/BT/data/learning-materials')),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_library',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_major_equipments',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('equipment_description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_placement',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('company_name', models.CharField(max_length=500)),
                ('latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2020)),
                ('students_selected_for_latest_year', models.IntegerField()),
                ('second_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2019)),
                ('students_selected_for_2nd_latest_year', models.IntegerField()),
                ('third_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2018)),
                ('students_selected_for_3rd_latest_year', models.IntegerField()),
                ('fourth_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2017)),
                ('students_selected_for_4th_latest_year', models.IntegerField()),
                ('fifth_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2016)),
                ('students_selected_for_5th_latest_year', models.IntegerField()),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_publications',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name_of_faculty', models.CharField(max_length=100)),
                ('y15', models.IntegerField(blank=True, null=True)),
                ('y16', models.IntegerField(blank=True, null=True)),
                ('y17', models.IntegerField(blank=True, null=True)),
                ('y18', models.IntegerField(blank=True, null=True)),
                ('y19', models.IntegerField(blank=True, null=True)),
                ('national_or_inter', models.CharField(max_length=13)),
                ('indexing', models.CharField(blank=True, max_length=500, null=True)),
                ('citations', models.IntegerField(blank=True, null=True)),
                ('impact_factor', models.CharField(blank=True, max_length=80, null=True)),
                ('i10_index', models.IntegerField(blank=True, null=True)),
                ('h_index', models.IntegerField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_research_guide',
            fields=[
                ('sno', models.IntegerField(primary_key=True, serialize=False)),
                ('guide_name', models.CharField(max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_result_analysis',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(3, '3rd'), (4, '4th'), (5, '5th'), (6, '6th'), (7, '7th'), (8, '8th')])),
                ('result_analysis_pdf', models.FileField(upload_to='department/BT/result-analysis/')),
                ('result_analysis_image', models.ImageField(help_text='Upload image of result analysis bar graph or pie chart', upload_to='department/BT/result-analysis/', validators=[department.models.bio_technology_dept_result_analysis.validate_image])),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_timetable',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('course', models.CharField(choices=[('BE', 'B.E.'), ('MT', 'M.Tech')], default='BE', max_length=100)),
                ('semester', models.IntegerField()),
                ('section', models.CharField(max_length=1)),
                ('timetable', models.FileField(upload_to='department/BT/data/timetable/')),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200)),
                ('designation', models.CharField(max_length=200)),
                ('image', models.ImageField(upload_to='department/CH/image/')),
                ('detail', models.FileField(blank='True', upload_to='department/CH/data/')),
                ('sno', models.IntegerField(default='1')),
                ('staff_type', models.CharField(choices=[('HOD', 'Head Of Department'), ('FACULTY', 'Faculty Member'), ('TECHNICAL', 'Technical Staff'), ('SUPPORTING', 'Supporting Staff')], default='FACULTY', max_length=100)),
                ('description', models.TextField(blank=True, help_text='Enter description only for HOD. For others this field can be skipped.')),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_accreditation',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('designation', models.TextField(blank=True)),
                ('member_type', models.CharField(choices=[('PAC', 'Program Assessment Committee (PAC)'), ('DAB', 'Department Advisory Board (DAB)')], default='DAB', max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_achievements',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('achievement_description', models.TextField()),
                ('achievement_type', models.CharField(choices=[('STUDENT', 'Student Achievement'), ('STAFF', 'Staff Achievement')], default='STAFF', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_activities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('activity_name', models.CharField(max_length=200)),
                ('activity_description', models.TextField()),
                ('activity_type', models.CharField(choices=[('RE', 'Forum Activity'), ('STC', 'Department Activity')], default='RE', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_alumni',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=500)),
                ('designation', models.CharField(max_length=500)),
                ('description', models.TextField()),
                ('image', models.ImageField(upload_to='department/alumni/CH/')),
                ('sno', models.IntegerField(default='1')),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_book_chapters',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sl_no', models.IntegerField()),
                ('name_of_book_chapter', models.CharField(max_length=500)),
                ('names_of_authors', models.CharField(max_length=500)),
                ('year_of_pub', models.IntegerField()),
                ('name_of_pub', models.CharField(max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_classroom',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('classroom', models.FileField(upload_to='department/CH/data/classroom/')),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_classroom_description',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_events',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('events', models.FileField(upload_to='department/CH/data/events/')),
                ('semester', models.CharField(max_length=10)),
                ('name', models.CharField(max_length=30)),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_forum',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField(help_text="Enter a short description about your department's forum.")),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_gallery',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('image', models.ImageField(upload_to='department/gallery/CH/')),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_grants_and_patents',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
                ('grant_or_patent', models.CharField(choices=[('GRANT', 'Grant'), ('PATENT', 'Patent')], default='GRANT', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_lab_facilities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('qty', models.IntegerField()),
                ('config_specs', models.TextField()),
                ('softwares', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_laboratory_facilities_gallary',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('image', models.ImageField(upload_to='department/gallery/CH/laboratory/')),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_learning_materials',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(3, 3), (4, 4), (5, 5), (6, 6), (7, 7), (8, 8)])),
                ('subject_code', models.CharField(max_length=100)),
                ('material', models.FileField(upload_to='department/CH/data/learning-materials')),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_library',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_major_equipments',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('equipment_description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_placement',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('company_name', models.CharField(max_length=500)),
                ('latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2020)),
                ('students_selected_for_latest_year', models.IntegerField()),
                ('second_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2019)),
                ('students_selected_for_2nd_latest_year', models.IntegerField()),
                ('third_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2018)),
                ('students_selected_for_3rd_latest_year', models.IntegerField()),
                ('fourth_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2017)),
                ('students_selected_for_4th_latest_year', models.IntegerField()),
                ('fifth_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2016)),
                ('students_selected_for_5th_latest_year', models.IntegerField()),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_publications',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name_of_faculty', models.CharField(max_length=100)),
                ('y15', models.IntegerField(blank=True, null=True)),
                ('y16', models.IntegerField(blank=True, null=True)),
                ('y17', models.IntegerField(blank=True, null=True)),
                ('y18', models.IntegerField(blank=True, null=True)),
                ('y19', models.IntegerField(blank=True, null=True)),
                ('national_or_inter', models.CharField(max_length=13)),
                ('indexing', models.CharField(blank=True, max_length=500, null=True)),
                ('citations', models.IntegerField(blank=True, null=True)),
                ('impact_factor', models.CharField(blank=True, max_length=80, null=True)),
                ('i10_index', models.IntegerField(blank=True, null=True)),
                ('h_index', models.IntegerField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_research_guide',
            fields=[
                ('sno', models.IntegerField(primary_key=True, serialize=False)),
                ('guide_name', models.CharField(max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_result_analysis',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(3, '3rd'), (4, '4th'), (5, '5th'), (6, '6th'), (7, '7th'), (8, '8th')])),
                ('result_analysis_pdf', models.FileField(upload_to='department/CH/result-analysis/')),
                ('result_analysis_image', models.ImageField(help_text='Upload image of result analysis bar graph or pie chart', upload_to='department/CH/result-analysis/', validators=[department.models.chemical_dept_result_analysis.validate_image])),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_timetable',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('course', models.CharField(choices=[('BE', 'B.E.'), ('MT', 'M.Tech')], default='BE', max_length=100)),
                ('semester', models.IntegerField()),
                ('section', models.CharField(max_length=1)),
                ('timetable', models.FileField(upload_to='department/CH/data/timetable/')),
            ],
        ),
        migrations.CreateModel(
            name='chemistry_dept',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200)),
                ('designation', models.CharField(max_length=200)),
                ('image', models.ImageField(upload_to='department/CHEM/image/')),
                ('detail', models.FileField(blank='True', upload_to='department/CHEM/data/')),
                ('sno', models.IntegerField(default='1')),
                ('staff_type', models.CharField(choices=[('HOD', 'Head Of Department'), ('FACULTY', 'Faculty Member'), ('TECHNICAL', 'Technical Staff'), ('SUPPORTING', 'Supporting Staff')], default='FACULTY', max_length=100)),
                ('description', models.TextField(blank=True, help_text='Enter description only for HOD. For others this field can be skipped.')),
            ],
        ),
        migrations.CreateModel(
            name='chemistry_dept_accreditation',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('designation', models.TextField(blank=True)),
                ('member_type', models.CharField(choices=[('PAC', 'Program Assessment Committee (PAC)'), ('DAB', 'Department Advisory Board (DAB)')], default='DAB', max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='chemistry_dept_achievements',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('achievement_description', models.TextField()),
                ('achievement_type', models.CharField(choices=[('STUDENT', 'Student Achievement'), ('STAFF', 'Staff Achievement')], default='STAFF', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='chemistry_dept_activities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('activity_name', models.CharField(max_length=200)),
                ('activity_description', models.TextField()),
                ('activity_type', models.CharField(choices=[('STC', 'Department Activity')], default='STC', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='chemistry_dept_book_chapters',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sl_no', models.IntegerField()),
                ('name_of_book_chapter', models.CharField(max_length=500)),
                ('names_of_authors', models.CharField(max_length=500)),
                ('year_of_pub', models.IntegerField()),
                ('name_of_pub', models.CharField(max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='chemistry_dept_classroom',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('classroom', models.FileField(upload_to='department/CHEM/data/classroom/')),
            ],
        ),
        migrations.CreateModel(
            name='chemistry_dept_classroom_description',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='chemistry_dept_events',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('events', models.FileField(upload_to='department/CHEM/data/events/')),
                ('semester', models.CharField(max_length=10)),
                ('name', models.CharField(max_length=30)),
            ],
        ),
        migrations.CreateModel(
            name='chemistry_dept_forum',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField(help_text="Enter a short description about your department's forum.")),
            ],
        ),
        migrations.CreateModel(
            name='chemistry_dept_gallery',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('image', models.ImageField(upload_to='department/gallery/CHEM/')),
            ],
        ),
        migrations.CreateModel(
            name='chemistry_dept_grants_and_patents',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
                ('grant_or_patent', models.CharField(choices=[('GRANT', 'Grant'), ('PATENT', 'Patent')], default='GRANT', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='chemistry_dept_lab_facilities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('qty', models.IntegerField()),
                ('config_specs', models.TextField()),
                ('softwares', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='chemistry_dept_laboratory_facilities_gallary',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('image', models.ImageField(upload_to='department/gallery/CHEM/laboratory/')),
            ],
        ),
        migrations.CreateModel(
            name='chemistry_dept_learning_materials',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(1, 1), (2, 2)])),
                ('subject_code', models.CharField(max_length=100)),
                ('material', models.FileField(upload_to='department/CHEM/data/learning-materials')),
            ],
        ),
        migrations.CreateModel(
            name='chemistry_dept_library',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='chemistry_dept_major_equipments',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('equipment_description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='chemistry_dept_publications',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name_of_faculty', models.CharField(max_length=100)),
                ('y15', models.IntegerField(blank=True, null=True)),
                ('y16', models.IntegerField(blank=True, null=True)),
                ('y17', models.IntegerField(blank=True, null=True)),
                ('y18', models.IntegerField(blank=True, null=True)),
                ('y19', models.IntegerField(blank=True, null=True)),
                ('national_or_inter', models.CharField(max_length=13)),
                ('indexing', models.CharField(blank=True, max_length=500, null=True)),
                ('citations', models.IntegerField(blank=True, null=True)),
                ('impact_factor', models.CharField(blank=True, max_length=80, null=True)),
                ('i10_index', models.IntegerField(blank=True, null=True)),
                ('h_index', models.IntegerField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='chemistry_dept_research_guide',
            fields=[
                ('sno', models.IntegerField(primary_key=True, serialize=False)),
                ('guide_name', models.CharField(max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='chemistry_dept_result_analysis',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(1, '1st'), (2, '2nd')])),
                ('result_analysis_pdf', models.FileField(upload_to='department/CHEM/result-analysis/')),
                ('result_analysis_image', models.ImageField(help_text='Upload image of result analysis bar graph or pie chart', upload_to='department/CHEM/result-analysis/', validators=[department.models.chemistry_dept_result_analysis.validate_image])),
            ],
        ),
        migrations.CreateModel(
            name='chemistry_dept_timetable',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('course', models.CharField(choices=[('BE', 'B.E.'), ('MT', 'M.Tech')], default='BE', max_length=100)),
                ('semester', models.IntegerField()),
                ('section', models.CharField(max_length=1)),
                ('timetable', models.FileField(upload_to='department/CHEM/data/timetable/')),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200)),
                ('designation', models.CharField(max_length=200)),
                ('image', models.ImageField(upload_to='department/CV/image/')),
                ('detail', models.FileField(blank='True', upload_to='department/CV/data/')),
                ('sno', models.IntegerField(default='1')),
                ('staff_type', models.CharField(choices=[('HOD', 'Head Of Department'), ('FACULTY', 'Faculty Member'), ('TECHNICAL', 'Technical Staff'), ('SUPPORTING', 'Supporting Staff')], default='FACULTY', max_length=100)),
                ('description', models.TextField(blank=True, help_text='Enter description only for HOD. For others this field can be skipped.')),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_accreditation',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('designation', models.TextField(blank=True)),
                ('member_type', models.CharField(choices=[('PAC', 'Program Assessment Committee (PAC)'), ('DAB', 'Department Advisory Board (DAB)')], default='DAB', max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_achievements',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('achievement_description', models.TextField()),
                ('achievement_type', models.CharField(choices=[('STUDENT', 'Student Achievement'), ('STAFF', 'Staff Achievement')], default='STAFF', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_activities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('activity_name', models.CharField(max_length=200)),
                ('activity_description', models.TextField()),
                ('activity_type', models.CharField(choices=[('RE', 'Forum Activity'), ('STC', 'Department Activity')], default='RE', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_alumni',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=500)),
                ('designation', models.CharField(max_length=500)),
                ('description', models.TextField()),
                ('image', models.ImageField(upload_to='department/alumni/CV/')),
                ('sno', models.IntegerField(default='1')),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_book_chapters',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sl_no', models.IntegerField()),
                ('name_of_book_chapter', models.CharField(max_length=500)),
                ('names_of_authors', models.CharField(max_length=500)),
                ('year_of_pub', models.IntegerField()),
                ('name_of_pub', models.CharField(max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_classroom',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('classroom', models.FileField(upload_to='department/CV/data/classroom/')),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_classroom_description',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_events',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('events', models.FileField(upload_to='department/CV/data/events/')),
                ('semester', models.CharField(max_length=10)),
                ('name', models.CharField(max_length=30)),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_forum',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField(help_text="Enter a short description about your department's forum.")),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_gallery',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('image', models.ImageField(upload_to='department/gallery/CV/')),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_grants_and_patents',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
                ('grant_or_patent', models.CharField(choices=[('GRANT', 'Grant'), ('PATENT', 'Patent')], default='GRANT', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_lab_facilities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('qty', models.IntegerField()),
                ('config_specs', models.TextField()),
                ('softwares', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_laboratory_facilities_gallary',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('image', models.ImageField(upload_to='department/gallery/CV/laboratory/')),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_learning_materials',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(3, 3), (4, 4), (5, 5), (6, 6), (7, 7), (8, 8)])),
                ('subject_code', models.CharField(max_length=100)),
                ('material', models.FileField(upload_to='department/CV/data/learning-materials')),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_library',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_major_equipments',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('equipment_description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_placement',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('company_name', models.CharField(max_length=500)),
                ('latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2020)),
                ('students_selected_for_latest_year', models.IntegerField()),
                ('second_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2019)),
                ('students_selected_for_2nd_latest_year', models.IntegerField()),
                ('third_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2018)),
                ('students_selected_for_3rd_latest_year', models.IntegerField()),
                ('fourth_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2017)),
                ('students_selected_for_4th_latest_year', models.IntegerField()),
                ('fifth_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2016)),
                ('students_selected_for_5th_latest_year', models.IntegerField()),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_publications',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name_of_faculty', models.CharField(max_length=100)),
                ('y15', models.IntegerField(blank=True, null=True)),
                ('y16', models.IntegerField(blank=True, null=True)),
                ('y17', models.IntegerField(blank=True, null=True)),
                ('y18', models.IntegerField(blank=True, null=True)),
                ('y19', models.IntegerField(blank=True, null=True)),
                ('national_or_inter', models.CharField(max_length=13)),
                ('indexing', models.CharField(blank=True, max_length=500, null=True)),
                ('citations', models.IntegerField(blank=True, null=True)),
                ('impact_factor', models.CharField(blank=True, max_length=80, null=True)),
                ('i10_index', models.IntegerField(blank=True, null=True)),
                ('h_index', models.IntegerField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_research_guide',
            fields=[
                ('sno', models.IntegerField(primary_key=True, serialize=False)),
                ('guide_name', models.CharField(max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_result_analysis',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(3, '3rd'), (4, '4th'), (5, '5th'), (6, '6th'), (7, '7th'), (8, '8th')])),
                ('result_analysis_pdf', models.FileField(upload_to='department/CV/result-analysis/')),
                ('result_analysis_image', models.ImageField(help_text='Upload image of result analysis bar graph or pie chart', upload_to='department/CV/result-analysis/', validators=[department.models.civil_dept_result_analysis.validate_image])),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_timetable',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('course', models.CharField(choices=[('BE', 'B.E.'), ('MT', 'M.Tech')], default='BE', max_length=100)),
                ('semester', models.IntegerField()),
                ('section', models.CharField(max_length=1)),
                ('timetable', models.FileField(upload_to='department/CV/data/timetable/')),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200)),
                ('designation', models.CharField(max_length=200)),
                ('image', models.ImageField(upload_to='department/CS/image/')),
                ('detail', models.FileField(blank='True', upload_to='department/CS/data/')),
                ('sno', models.IntegerField(default='1')),
                ('staff_type', models.CharField(choices=[('HOD', 'Head Of Department'), ('FACULTY', 'Faculty Member'), ('TECHNICAL', 'Technical Staff'), ('SUPPORTING', 'Supporting Staff')], default='FACULTY', max_length=100)),
                ('description', models.TextField(blank=True, help_text='Enter description only for HOD. For others this field can be skipped.')),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_accreditation',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('designation', models.TextField(blank=True)),
                ('member_type', models.CharField(choices=[('PAC', 'Program Assessment Committee (PAC)'), ('DAB', 'Department Advisory Board (DAB)')], default='DAB', max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_achievements',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('achievement_description', models.TextField()),
                ('achievement_type', models.CharField(choices=[('STUDENT', 'Student Achievement'), ('STAFF', 'Staff Achievement')], default='STAFF', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_activities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('activity_name', models.CharField(max_length=200)),
                ('activity_description', models.TextField()),
                ('activity_type', models.CharField(choices=[('RE', 'Forum Activity'), ('STC', 'Department Activity')], default='RE', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_alumni',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=500)),
                ('designation', models.CharField(max_length=500)),
                ('description', models.TextField()),
                ('image', models.ImageField(upload_to='department/alumni/CS/')),
                ('sno', models.IntegerField(default='1')),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_book_chapters',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sl_no', models.IntegerField()),
                ('name_of_book_chapter', models.CharField(max_length=500)),
                ('names_of_authors', models.CharField(max_length=500)),
                ('year_of_pub', models.IntegerField()),
                ('name_of_pub', models.CharField(max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_classroom',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('classroom', models.FileField(upload_to='department/CS/data/classroom/')),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_classroom_description',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_events',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('events', models.FileField(upload_to='department/CS/data/events/')),
                ('semester', models.CharField(max_length=10)),
                ('name', models.CharField(max_length=30)),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_forum',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField(help_text="Enter a short description about your department's forum.")),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_gallery',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('image', models.ImageField(upload_to='department/gallery/PhotoGallery/')),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_grants_and_patents',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
                ('grant_or_patent', models.CharField(choices=[('GRANT', 'Grant'), ('PATENT', 'Patent')], default='GRANT', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_lab_facilities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('qty', models.IntegerField()),
                ('config_specs', models.TextField()),
                ('softwares', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_laboratory_facilities_gallary',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('image', models.ImageField(upload_to='department/gallery/CS/laboratory/')),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_learning_materials',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(3, 3), (4, 4), (5, 5), (6, 6), (7, 7), (8, 8)])),
                ('subject_code', models.CharField(max_length=100)),
                ('material', models.FileField(upload_to='department/CS/data/learning-materials')),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_library',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_major_equipments',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('equipment_description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_placement',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('company_name', models.CharField(max_length=500)),
                ('latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2020)),
                ('students_selected_for_latest_year', models.IntegerField()),
                ('second_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2019)),
                ('students_selected_for_2nd_latest_year', models.IntegerField()),
                ('third_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2018)),
                ('students_selected_for_3rd_latest_year', models.IntegerField()),
                ('fourth_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2017)),
                ('students_selected_for_4th_latest_year', models.IntegerField()),
                ('fifth_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2016)),
                ('students_selected_for_5th_latest_year', models.IntegerField()),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_publications',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name_of_faculty', models.CharField(max_length=100)),
                ('y15', models.IntegerField(blank=True, null=True)),
                ('y16', models.IntegerField(blank=True, null=True)),
                ('y17', models.IntegerField(blank=True, null=True)),
                ('y18', models.IntegerField(blank=True, null=True)),
                ('y19', models.IntegerField(blank=True, null=True)),
                ('national_or_inter', models.CharField(max_length=13)),
                ('indexing', models.CharField(blank=True, max_length=500, null=True)),
                ('citations', models.IntegerField(blank=True, null=True)),
                ('impact_factor', models.CharField(blank=True, max_length=80, null=True)),
                ('i10_index', models.IntegerField(blank=True, null=True)),
                ('h_index', models.IntegerField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_research_guide',
            fields=[
                ('sno', models.IntegerField(primary_key=True, serialize=False)),
                ('guide_name', models.CharField(max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_result_analysis',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(3, '3rd'), (4, '4th'), (5, '5th'), (6, '6th'), (7, '7th'), (8, '8th')])),
                ('result_analysis_pdf', models.FileField(upload_to='department/CS/result-analysis/')),
                ('result_analysis_image', models.ImageField(help_text='Upload image of result analysis bar graph or pie chart', upload_to='department/CS/result-analysis/', validators=[department.models.computer_science_dept_result_analysis.validate_image])),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_timetable',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('course', models.CharField(choices=[('BE', 'B.E.'), ('MT', 'M.Tech')], default='BE', max_length=100)),
                ('semester', models.IntegerField()),
                ('section', models.CharField(max_length=1)),
                ('timetable', models.FileField(upload_to='department/CS/data/timetable/')),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200)),
                ('designation', models.CharField(max_length=200)),
                ('image', models.ImageField(upload_to='department/EE/image/')),
                ('detail', models.FileField(blank='True', upload_to='department/EE/data/')),
                ('sno', models.IntegerField(default='1')),
                ('staff_type', models.CharField(choices=[('HOD', 'Head Of Department'), ('FACULTY', 'Faculty Member'), ('TECHNICAL', 'Technical Staff'), ('SUPPORTING', 'Supporting Staff')], default='FACULTY', max_length=100)),
                ('description', models.TextField(blank=True, help_text='Enter description only for HOD. For others this field can be skipped.')),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_accreditation',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('designation', models.TextField(blank=True)),
                ('member_type', models.CharField(choices=[('PAC', 'Program Assessment Committee (PAC)'), ('DAB', 'Department Advisory Board (DAB)')], default='DAB', max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_achievements',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('achievement_description', models.TextField()),
                ('achievement_type', models.CharField(choices=[('STUDENT', 'Student Achievement'), ('STAFF', 'Staff Achievement')], default='STAFF', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_activities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('activity_name', models.CharField(max_length=200)),
                ('activity_description', models.TextField()),
                ('activity_type', models.CharField(choices=[('RE', 'Forum Activity'), ('STC', 'Department Activity')], default='RE', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_alumni',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=500)),
                ('designation', models.CharField(max_length=500)),
                ('description', models.TextField()),
                ('image', models.ImageField(upload_to='department/alumni/EE/')),
                ('sno', models.IntegerField(default='1')),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_book_chapters',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sl_no', models.IntegerField()),
                ('name_of_book_chapter', models.CharField(max_length=500)),
                ('names_of_authors', models.CharField(max_length=500)),
                ('year_of_pub', models.IntegerField()),
                ('name_of_pub', models.CharField(max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_classroom',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('classroom', models.FileField(upload_to='department/EE/data/classroom/')),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_classroom_description',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_events',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('events', models.FileField(upload_to='department/EE/data/events/')),
                ('semester', models.CharField(max_length=10)),
                ('name', models.CharField(max_length=30)),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_forum',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField(help_text="Enter a short description about your department's forum.")),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_gallery',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('image', models.ImageField(upload_to='department/gallery/EE/')),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_grants_and_patents',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
                ('grant_or_patent', models.CharField(choices=[('GRANT', 'Grant'), ('PATENT', 'Patent')], default='GRANT', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_lab_facilities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('qty', models.IntegerField()),
                ('config_specs', models.TextField()),
                ('softwares', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_laboratory_facilities_gallary',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('image', models.ImageField(upload_to='department/gallery/EE/laboratory/')),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_learning_materials',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(3, 3), (4, 4), (5, 5), (6, 6), (7, 7), (8, 8)])),
                ('subject_code', models.CharField(max_length=100)),
                ('material', models.FileField(upload_to='department/EE/data/learning-materials')),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_library',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_major_equipments',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('equipment_description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_placement',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('company_name', models.CharField(max_length=500)),
                ('latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2020)),
                ('students_selected_for_latest_year', models.IntegerField()),
                ('second_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2019)),
                ('students_selected_for_2nd_latest_year', models.IntegerField()),
                ('third_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2018)),
                ('students_selected_for_3rd_latest_year', models.IntegerField()),
                ('fourth_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2017)),
                ('students_selected_for_4th_latest_year', models.IntegerField()),
                ('fifth_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2016)),
                ('students_selected_for_5th_latest_year', models.IntegerField()),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_publications',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name_of_faculty', models.CharField(max_length=100)),
                ('y15', models.IntegerField(blank=True, null=True)),
                ('y16', models.IntegerField(blank=True, null=True)),
                ('y17', models.IntegerField(blank=True, null=True)),
                ('y18', models.IntegerField(blank=True, null=True)),
                ('y19', models.IntegerField(blank=True, null=True)),
                ('national_or_inter', models.CharField(max_length=13)),
                ('indexing', models.CharField(blank=True, max_length=500, null=True)),
                ('citations', models.IntegerField(blank=True, null=True)),
                ('impact_factor', models.CharField(blank=True, max_length=80, null=True)),
                ('i10_index', models.IntegerField(blank=True, null=True)),
                ('h_index', models.IntegerField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_research_guide',
            fields=[
                ('sno', models.IntegerField(primary_key=True, serialize=False)),
                ('guide_name', models.CharField(max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_result_analysis',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(3, '3rd'), (4, '4th'), (5, '5th'), (6, '6th'), (7, '7th'), (8, '8th')])),
                ('result_analysis_pdf', models.FileField(upload_to='department/EE/result-analysis/')),
                ('result_analysis_image', models.ImageField(help_text='Upload image of result analysis bar graph or pie chart', upload_to='department/EE/result-analysis/', validators=[department.models.electrical_and_electronics_dept_result_analysis.validate_image])),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_timetable',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('course', models.CharField(choices=[('BE', 'B.E.'), ('MT', 'M.Tech')], default='BE', max_length=100)),
                ('semester', models.IntegerField()),
                ('section', models.CharField(max_length=1)),
                ('timetable', models.FileField(upload_to='department/EE/data/timetable/')),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200)),
                ('designation', models.CharField(max_length=200)),
                ('image', models.ImageField(upload_to='department/EC/image/')),
                ('detail', models.FileField(blank='True', upload_to='department/EC/data/')),
                ('sno', models.IntegerField(default='1')),
                ('staff_type', models.CharField(choices=[('HOD', 'Head Of Department'), ('FACULTY', 'Faculty Member'), ('TECHNICAL', 'Technical Staff'), ('SUPPORTING', 'Supporting Staff')], default='FACULTY', max_length=100)),
                ('description', models.TextField(blank=True, help_text='Enter description only for HOD. For others this field can be skipped.')),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_accreditation',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('designation', models.TextField(blank=True)),
                ('member_type', models.CharField(choices=[('PAC', 'Program Assessment Committee (PAC)'), ('DAB', 'Department Advisory Board (DAB)')], default='DAB', max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_achievements',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('achievement_description', models.TextField()),
                ('achievement_type', models.CharField(choices=[('STUDENT', 'Student Achievement'), ('STAFF', 'Staff Achievement')], default='STAFF', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_activities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('activity_name', models.CharField(max_length=200)),
                ('activity_description', models.TextField()),
                ('activity_type', models.CharField(choices=[('RE', 'Forum Activity'), ('STC', 'Department Activity')], default='RE', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_alumni',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=500)),
                ('designation', models.CharField(max_length=500)),
                ('description', models.TextField()),
                ('image', models.ImageField(upload_to='department/alumni/EC/')),
                ('sno', models.IntegerField(default='1')),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_book_chapters',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sl_no', models.IntegerField()),
                ('name_of_book_chapter', models.CharField(max_length=500)),
                ('names_of_authors', models.CharField(max_length=500)),
                ('year_of_pub', models.IntegerField()),
                ('name_of_pub', models.CharField(max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_classroom',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('classroom', models.FileField(upload_to='department/EC/data/classroom/')),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_classroom_description',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_events',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('events', models.FileField(upload_to='department/EC/data/events/')),
                ('semester', models.CharField(max_length=10)),
                ('name', models.CharField(max_length=30)),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_forum',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField(help_text="Enter a short description about your department's forum.")),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_gallery',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('image', models.ImageField(upload_to='department/gallery/EC/')),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_grants_and_patents',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
                ('grant_or_patent', models.CharField(choices=[('GRANT', 'Grant'), ('PATENT', 'Patent')], default='GRANT', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_lab_facilities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('qty', models.IntegerField()),
                ('config_specs', models.TextField()),
                ('softwares', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_laboratory_facilities_gallary',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('image', models.ImageField(upload_to='department/gallery/EC/laboratory/')),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_learning_materials',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(3, 3), (4, 4), (5, 5), (6, 6), (7, 7), (8, 8)])),
                ('subject_code', models.CharField(max_length=100)),
                ('material', models.FileField(upload_to='department/EC/data/learning-materials')),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_library',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_major_equipments',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('equipment_description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_placement',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('company_name', models.CharField(max_length=500)),
                ('latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2020)),
                ('students_selected_for_latest_year', models.IntegerField()),
                ('second_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2019)),
                ('students_selected_for_2nd_latest_year', models.IntegerField()),
                ('third_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2018)),
                ('students_selected_for_3rd_latest_year', models.IntegerField()),
                ('fourth_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2017)),
                ('students_selected_for_4th_latest_year', models.IntegerField()),
                ('fifth_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2016)),
                ('students_selected_for_5th_latest_year', models.IntegerField()),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_publications',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name_of_faculty', models.CharField(max_length=100)),
                ('y15', models.IntegerField(blank=True, null=True)),
                ('y16', models.IntegerField(blank=True, null=True)),
                ('y17', models.IntegerField(blank=True, null=True)),
                ('y18', models.IntegerField(blank=True, null=True)),
                ('y19', models.IntegerField(blank=True, null=True)),
                ('national_or_inter', models.CharField(max_length=13)),
                ('indexing', models.CharField(blank=True, max_length=500, null=True)),
                ('citations', models.IntegerField(blank=True, null=True)),
                ('impact_factor', models.CharField(blank=True, max_length=80, null=True)),
                ('i10_index', models.IntegerField(blank=True, null=True)),
                ('h_index', models.IntegerField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_research_guide',
            fields=[
                ('sno', models.IntegerField(primary_key=True, serialize=False)),
                ('guide_name', models.CharField(max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_result_analysis',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(3, '3rd'), (4, '4th'), (5, '5th'), (6, '6th'), (7, '7th'), (8, '8th')])),
                ('result_analysis_pdf', models.FileField(upload_to='department/EC/result-analysis/')),
                ('result_analysis_image', models.ImageField(help_text='Upload image of result analysis bar graph or pie chart', upload_to='department/EC/result-analysis/', validators=[department.models.electronics_and_communication_dept_result_analysis.validate_image])),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_timetable',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('course', models.CharField(choices=[('BE', 'B.E.'), ('MT', 'M.Tech')], default='BE', max_length=100)),
                ('semester', models.IntegerField()),
                ('section', models.CharField(max_length=1)),
                ('timetable', models.FileField(upload_to='department/EC/data/timetable/')),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200)),
                ('designation', models.CharField(max_length=200)),
                ('image', models.ImageField(upload_to='department/EI/image/')),
                ('detail', models.FileField(blank='True', upload_to='department/EI/data/')),
                ('sno', models.IntegerField(default='1')),
                ('staff_type', models.CharField(choices=[('HOD', 'Head Of Department'), ('FACULTY', 'Faculty Member'), ('TECHNICAL', 'Technical Staff'), ('SUPPORTING', 'Supporting Staff')], default='FACULTY', max_length=100)),
                ('description', models.TextField(blank=True, help_text='Enter description only for HOD. For others this field can be skipped.')),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_accreditation',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('designation', models.TextField(blank=True)),
                ('member_type', models.CharField(choices=[('PAC', 'Program Assessment Committee (PAC)'), ('DAB', 'Department Advisory Board (DAB)')], default='DAB', max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_achievements',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('achievement_description', models.TextField()),
                ('achievement_type', models.CharField(choices=[('STUDENT', 'Student Achievement'), ('STAFF', 'Staff Achievement')], default='STAFF', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_activities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('activity_name', models.CharField(max_length=200)),
                ('activity_description', models.TextField()),
                ('activity_type', models.CharField(choices=[('RE', 'Forum Activity'), ('STC', 'Department Activity')], default='RE', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_alumni',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=500)),
                ('designation', models.CharField(max_length=500)),
                ('description', models.TextField()),
                ('image', models.ImageField(upload_to='department/alumni/EI/')),
                ('sno', models.IntegerField(default='1')),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_book_chapters',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sl_no', models.IntegerField()),
                ('name_of_book_chapter', models.CharField(max_length=500)),
                ('names_of_authors', models.CharField(max_length=500)),
                ('year_of_pub', models.IntegerField()),
                ('name_of_pub', models.CharField(max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_classroom',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('classroom', models.FileField(upload_to='department/EI/data/classroom/')),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_classroom_description',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_events',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('events', models.FileField(upload_to='department/EI/data/events/')),
                ('semester', models.CharField(max_length=10)),
                ('name', models.CharField(max_length=30)),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_forum',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField(help_text="Enter a short description about your department's forum.")),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_gallery',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('image', models.ImageField(upload_to='department/gallery/EI/')),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_grants_and_patents',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
                ('grant_or_patent', models.CharField(choices=[('GRANT', 'Grant'), ('PATENT', 'Patent')], default='GRANT', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_lab_facilities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('qty', models.IntegerField()),
                ('config_specs', models.TextField()),
                ('softwares', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_laboratory_facilities_gallary',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('image', models.ImageField(upload_to='department/gallery/EI/laboratory/')),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_learning_materials',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(3, 3), (4, 4), (5, 5), (6, 6), (7, 7), (8, 8)])),
                ('subject_code', models.CharField(max_length=100)),
                ('material', models.FileField(upload_to='department/EI/data/learning-materials')),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_library',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_major_equipments',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('equipment_description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_placement',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('company_name', models.CharField(max_length=500)),
                ('latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2020)),
                ('students_selected_for_latest_year', models.IntegerField()),
                ('second_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2019)),
                ('students_selected_for_2nd_latest_year', models.IntegerField()),
                ('third_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2018)),
                ('students_selected_for_3rd_latest_year', models.IntegerField()),
                ('fourth_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2017)),
                ('students_selected_for_4th_latest_year', models.IntegerField()),
                ('fifth_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2016)),
                ('students_selected_for_5th_latest_year', models.IntegerField()),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_publications',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name_of_faculty', models.CharField(max_length=100)),
                ('y15', models.IntegerField(blank=True, null=True)),
                ('y16', models.IntegerField(blank=True, null=True)),
                ('y17', models.IntegerField(blank=True, null=True)),
                ('y18', models.IntegerField(blank=True, null=True)),
                ('y19', models.IntegerField(blank=True, null=True)),
                ('national_or_inter', models.CharField(max_length=13)),
                ('indexing', models.CharField(blank=True, max_length=500, null=True)),
                ('citations', models.IntegerField(blank=True, null=True)),
                ('impact_factor', models.CharField(blank=True, max_length=80, null=True)),
                ('i10_index', models.IntegerField(blank=True, null=True)),
                ('h_index', models.IntegerField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_research_guide',
            fields=[
                ('sno', models.IntegerField(primary_key=True, serialize=False)),
                ('guide_name', models.CharField(max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_result_analysis',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(3, '3rd'), (4, '4th'), (5, '5th'), (6, '6th'), (7, '7th'), (8, '8th')])),
                ('result_analysis_pdf', models.FileField(upload_to='department/EI/result-analysis/')),
                ('result_analysis_image', models.ImageField(help_text='Upload image of result analysis bar graph or pie chart', upload_to='department/EI/result-analysis/', validators=[department.models.electronics_and_instrumentation_dept_result_analysis.validate_image])),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_timetable',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('course', models.CharField(choices=[('BE', 'B.E.'), ('MT', 'M.Tech')], default='BE', max_length=100)),
                ('semester', models.IntegerField()),
                ('section', models.CharField(max_length=1)),
                ('timetable', models.FileField(upload_to='department/EI/data/timetable/')),
            ],
        ),
        migrations.CreateModel(
            name='environmental_dept',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200)),
                ('designation', models.CharField(max_length=200)),
                ('image', models.ImageField(upload_to='department/ENV/image/')),
                ('detail', models.FileField(upload_to='department/ENV/data/')),
                ('sno', models.IntegerField()),
            ],
        ),
        migrations.CreateModel(
            name='environmental_dept_gallery',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('image', models.ImageField(upload_to='department/gallery/ENV/')),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200)),
                ('designation', models.CharField(max_length=200)),
                ('image', models.ImageField(upload_to='department/IS/image/')),
                ('detail', models.FileField(blank='True', upload_to='department/IS/data/')),
                ('sno', models.IntegerField(default='1')),
                ('staff_type', models.CharField(choices=[('HOD', 'Head Of Department'), ('FACULTY', 'Faculty Member'), ('TECHNICAL', 'Technical Staff'), ('SUPPORTING', 'Supporting Staff')], default='FACULTY', max_length=100)),
                ('description', models.TextField(blank=True, help_text='Enter description only for HOD. For others this field can be skipped.')),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_accreditation',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('designation', models.TextField(blank=True)),
                ('member_type', models.CharField(choices=[('PAC', 'Program Assessment Committee (PAC)'), ('DAB', 'Department Advisory Board (DAB)')], default='DAB', max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_achievements',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('achievement_description', models.TextField()),
                ('achievement_type', models.CharField(choices=[('STUDENT', 'Student Achievement'), ('STAFF', 'Staff Achievement')], default='STAFF', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_activities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('activity_name', models.CharField(max_length=200)),
                ('activity_description', models.TextField()),
                ('activity_type', models.CharField(choices=[('RE', 'Forum Activity'), ('STC', 'Department Activity')], default='RE', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_alumni',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=500)),
                ('designation', models.CharField(max_length=500)),
                ('description', models.TextField()),
                ('image', models.ImageField(upload_to='department/alumni/IS/')),
                ('sno', models.IntegerField(default='1')),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_book_chapters',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sl_no', models.IntegerField()),
                ('name_of_book_chapter', models.CharField(max_length=500)),
                ('names_of_authors', models.CharField(max_length=500)),
                ('year_of_pub', models.IntegerField()),
                ('name_of_pub', models.CharField(max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_classroom',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('classroom', models.FileField(upload_to='department/IS/data/classroom/')),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_classroom_description',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_events',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('events', models.FileField(upload_to='department/IS/data/events/')),
                ('semester', models.CharField(max_length=10)),
                ('name', models.CharField(max_length=30)),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_forum',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField(help_text="Enter a short description about your department's forum.")),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_gallery',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('image', models.ImageField(upload_to='department/gallery/IS/')),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_grants_and_patents',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
                ('grant_or_patent', models.CharField(choices=[('GRANT', 'Grant'), ('PATENT', 'Patent')], default='GRANT', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_lab_facilities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('qty', models.IntegerField()),
                ('config_specs', models.TextField()),
                ('softwares', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_laboratory_facilities_gallary',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('image', models.ImageField(upload_to='department/gallery/IS/laboratory/')),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_learning_materials',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(3, 3), (4, 4), (5, 5), (6, 6), (7, 7), (8, 8)])),
                ('subject_code', models.CharField(max_length=100)),
                ('material', models.FileField(upload_to='department/IS/data/learning-materials')),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_library',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_major_equipments',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('equipment_description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_placement',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('company_name', models.CharField(max_length=500)),
                ('latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2020)),
                ('students_selected_for_latest_year', models.IntegerField()),
                ('second_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2019)),
                ('students_selected_for_2nd_latest_year', models.IntegerField()),
                ('third_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2018)),
                ('students_selected_for_3rd_latest_year', models.IntegerField()),
                ('fourth_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2017)),
                ('students_selected_for_4th_latest_year', models.IntegerField()),
                ('fifth_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2016)),
                ('students_selected_for_5th_latest_year', models.IntegerField()),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_publications',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name_of_faculty', models.CharField(max_length=100)),
                ('y15', models.IntegerField(blank=True, null=True)),
                ('y16', models.IntegerField(blank=True, null=True)),
                ('y17', models.IntegerField(blank=True, null=True)),
                ('y18', models.IntegerField(blank=True, null=True)),
                ('y19', models.IntegerField(blank=True, null=True)),
                ('national_or_inter', models.CharField(max_length=13)),
                ('indexing', models.CharField(blank=True, max_length=500, null=True)),
                ('citations', models.IntegerField(blank=True, null=True)),
                ('impact_factor', models.CharField(blank=True, max_length=80, null=True)),
                ('i10_index', models.IntegerField(blank=True, null=True)),
                ('h_index', models.IntegerField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_research_guide',
            fields=[
                ('sno', models.IntegerField(primary_key=True, serialize=False)),
                ('guide_name', models.CharField(max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_result_analysis',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(3, '3rd'), (4, '4th'), (5, '5th'), (6, '6th'), (7, '7th'), (8, '8th')])),
                ('result_analysis_pdf', models.FileField(upload_to='department/IS/result-analysis/')),
                ('result_analysis_image', models.ImageField(help_text='Upload image of result analysis bar graph or pie chart', upload_to='department/IS/result-analysis/', validators=[department.models.information_science_dept_result_analysis.validate_image])),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_timetable',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('course', models.CharField(choices=[('BE', 'B.E.'), ('MT', 'M.Tech')], default='BE', max_length=100)),
                ('semester', models.IntegerField()),
                ('section', models.CharField(max_length=1)),
                ('timetable', models.FileField(upload_to='department/IS/data/timetable/')),
            ],
        ),
        migrations.CreateModel(
            name='mathematics_dept',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200)),
                ('designation', models.CharField(max_length=200)),
                ('image', models.ImageField(upload_to='department/MAT/image/')),
                ('detail', models.FileField(blank='True', upload_to='department/MAT/data/')),
                ('sno', models.IntegerField(default='1')),
                ('staff_type', models.CharField(choices=[('HOD', 'Head Of Department'), ('FACULTY', 'Faculty Member'), ('TECHNICAL', 'Technical Staff'), ('SUPPORTING', 'Supporting Staff')], default='FACULTY', max_length=100)),
                ('description', models.TextField(blank=True, help_text='Enter description only for HOD. For others this field can be skipped.')),
            ],
        ),
        migrations.CreateModel(
            name='mathematics_dept_accreditation',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('designation', models.TextField(blank=True)),
                ('member_type', models.CharField(choices=[('PAC', 'Program Assessment Committee (PAC)'), ('DAB', 'Department Advisory Board (DAB)')], default='DAB', max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='mathematics_dept_achievements',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('achievement_description', models.TextField()),
                ('achievement_type', models.CharField(choices=[('STUDENT', 'Student Achievement'), ('STAFF', 'Staff Achievement')], default='STAFF', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='mathematics_dept_activities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('activity_name', models.CharField(max_length=200)),
                ('activity_description', models.TextField()),
                ('activity_type', models.CharField(choices=[('STC', 'Department Activity')], default='STC', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='mathematics_dept_book_chapters',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sl_no', models.IntegerField()),
                ('name_of_book_chapter', models.CharField(max_length=500)),
                ('names_of_authors', models.CharField(max_length=500)),
                ('year_of_pub', models.IntegerField()),
                ('name_of_pub', models.CharField(max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='mathematics_dept_classroom',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('classroom', models.FileField(upload_to='department/MAT/data/classroom/')),
            ],
        ),
        migrations.CreateModel(
            name='mathematics_dept_classroom_description',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='mathematics_dept_events',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('events', models.FileField(upload_to='department/MAT/data/events/')),
                ('semester', models.CharField(max_length=10)),
                ('name', models.CharField(max_length=30)),
            ],
        ),
        migrations.CreateModel(
            name='mathematics_dept_forum',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField(help_text="Enter a short description about your department's forum.")),
            ],
        ),
        migrations.CreateModel(
            name='mathematics_dept_gallery',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('image', models.ImageField(upload_to='department/gallery/MAT/')),
            ],
        ),
        migrations.CreateModel(
            name='mathematics_dept_grants_and_patents',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
                ('grant_or_patent', models.CharField(choices=[('GRANT', 'Grant'), ('PATENT', 'Patent')], default='GRANT', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='mathematics_dept_lab_facilities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('qty', models.IntegerField()),
                ('config_specs', models.TextField()),
                ('softwares', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='mathematics_dept_laboratory_facilities_gallary',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('image', models.ImageField(upload_to='department/gallery/MAT/laboratory/')),
            ],
        ),
        migrations.CreateModel(
            name='mathematics_dept_learning_materials',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(1, 1), (2, 2), (3, 3), (4, 4)])),
                ('subject_code', models.CharField(max_length=100)),
                ('material', models.FileField(upload_to='department/MAT/data/learning-materials')),
            ],
        ),
        migrations.CreateModel(
            name='mathematics_dept_library',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='mathematics_dept_major_equipments',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('equipment_description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='mathematics_dept_publications',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name_of_faculty', models.CharField(max_length=100)),
                ('y15', models.IntegerField(blank=True, null=True)),
                ('y16', models.IntegerField(blank=True, null=True)),
                ('y17', models.IntegerField(blank=True, null=True)),
                ('y18', models.IntegerField(blank=True, null=True)),
                ('y19', models.IntegerField(blank=True, null=True)),
                ('national_or_inter', models.CharField(max_length=13)),
                ('indexing', models.CharField(blank=True, max_length=500, null=True)),
                ('citations', models.IntegerField(blank=True, null=True)),
                ('impact_factor', models.CharField(blank=True, max_length=80, null=True)),
                ('i10_index', models.IntegerField(blank=True, null=True)),
                ('h_index', models.IntegerField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='mathematics_dept_research_guide',
            fields=[
                ('sno', models.IntegerField(primary_key=True, serialize=False)),
                ('guide_name', models.CharField(max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='mathematics_dept_result_analysis',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(1, '1st'), (2, '2nd'), (3, '3rd'), (4, '4th')])),
                ('result_analysis_pdf', models.FileField(upload_to='department/MAT/result-analysis/')),
                ('result_analysis_image', models.ImageField(help_text='Upload image of result analysis bar graph or pie chart', upload_to='department/MAT/result-analysis/', validators=[department.models.mathematics_dept_result_analysis.validate_image])),
            ],
        ),
        migrations.CreateModel(
            name='mathematics_dept_timetable',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('course', models.CharField(choices=[('BE', 'B.E.'), ('MT', 'M.Tech')], default='BE', max_length=100)),
                ('semester', models.IntegerField()),
                ('section', models.CharField(max_length=1)),
                ('timetable', models.FileField(upload_to='department/MAT/data/timetable/')),
            ],
        ),
        migrations.CreateModel(
            name='mca_dept',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200)),
                ('designation', models.CharField(max_length=200)),
                ('image', models.ImageField(upload_to='department/MCA/image/')),
                ('detail', models.FileField(upload_to='department/MCA/data/')),
            ],
        ),
        migrations.CreateModel(
            name='mca_dept_gallery',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('image', models.ImageField(upload_to='department/gallery/MCA/')),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200)),
                ('designation', models.CharField(max_length=200)),
                ('image', models.ImageField(upload_to='department/ME/image/')),
                ('detail', models.FileField(blank='True', upload_to='department/ME/data/')),
                ('sno', models.IntegerField(default='1')),
                ('staff_type', models.CharField(choices=[('HOD', 'Head Of Department'), ('FACULTY', 'Faculty Member'), ('TECHNICAL', 'Technical Staff'), ('SUPPORTING', 'Supporting Staff')], default='FACULTY', max_length=100)),
                ('description', models.TextField(blank=True, help_text='Enter description only for HOD. For others this field can be skipped.')),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_accreditation',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('designation', models.TextField(blank=True)),
                ('member_type', models.CharField(choices=[('PAC', 'Program Assessment Committee (PAC)'), ('DAB', 'Department Advisory Board (DAB)')], default='DAB', max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_achievements',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('achievement_description', models.TextField()),
                ('achievement_type', models.CharField(choices=[('STUDENT', 'Student Achievement'), ('STAFF', 'Staff Achievement')], default='STAFF', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_activities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('activity_name', models.CharField(max_length=200)),
                ('activity_description', models.TextField()),
                ('activity_type', models.CharField(choices=[('RE', 'Forum Activity'), ('STC', 'Department Activity')], default='RE', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_alumni',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=500)),
                ('designation', models.CharField(max_length=500)),
                ('description', models.TextField()),
                ('image', models.ImageField(upload_to='department/alumni/ME/')),
                ('sno', models.IntegerField(default='1')),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_book_chapters',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sl_no', models.IntegerField()),
                ('name_of_book_chapter', models.CharField(max_length=500)),
                ('names_of_authors', models.CharField(max_length=500)),
                ('year_of_pub', models.IntegerField()),
                ('name_of_pub', models.CharField(max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_classroom',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('classroom', models.FileField(upload_to='department/ME/data/classroom/')),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_classroom_description',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_events',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('events', models.FileField(upload_to='department/ME/data/events/')),
                ('semester', models.CharField(max_length=10)),
                ('name', models.CharField(max_length=30)),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_forum',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField(help_text="Enter a short description about your department's forum.")),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_gallery',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('image', models.ImageField(upload_to='department/gallery/ME/')),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_grants_and_patents',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
                ('grant_or_patent', models.CharField(choices=[('GRANT', 'Grant'), ('PATENT', 'Patent')], default='GRANT', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_lab_facilities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('qty', models.IntegerField()),
                ('config_specs', models.TextField()),
                ('softwares', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_laboratory_facilities_gallary',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('image', models.ImageField(upload_to='department/gallery/ME/laboratory/')),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_learning_materials',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(3, 3), (4, 4), (5, 5), (6, 6), (7, 7), (8, 8)])),
                ('subject_code', models.CharField(max_length=100)),
                ('material', models.FileField(upload_to='department/ME/data/learning-materials')),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_library',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_major_equipments',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('equipment_description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_placement',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('company_name', models.CharField(max_length=500)),
                ('latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2020)),
                ('students_selected_for_latest_year', models.IntegerField()),
                ('second_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2019)),
                ('students_selected_for_2nd_latest_year', models.IntegerField()),
                ('third_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2018)),
                ('students_selected_for_3rd_latest_year', models.IntegerField()),
                ('fourth_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2017)),
                ('students_selected_for_4th_latest_year', models.IntegerField()),
                ('fifth_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2016)),
                ('students_selected_for_5th_latest_year', models.IntegerField()),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_publications',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name_of_faculty', models.CharField(max_length=100)),
                ('y15', models.IntegerField(blank=True, null=True)),
                ('y16', models.IntegerField(blank=True, null=True)),
                ('y17', models.IntegerField(blank=True, null=True)),
                ('y18', models.IntegerField(blank=True, null=True)),
                ('y19', models.IntegerField(blank=True, null=True)),
                ('national_or_inter', models.CharField(max_length=13)),
                ('indexing', models.CharField(blank=True, max_length=500, null=True)),
                ('citations', models.IntegerField(blank=True, null=True)),
                ('impact_factor', models.CharField(blank=True, max_length=80, null=True)),
                ('i10_index', models.IntegerField(blank=True, null=True)),
                ('h_index', models.IntegerField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_research_guide',
            fields=[
                ('sno', models.IntegerField(primary_key=True, serialize=False)),
                ('guide_name', models.CharField(max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_result_analysis',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(3, '3rd'), (4, '4th'), (5, '5th'), (6, '6th'), (7, '7th'), (8, '8th')])),
                ('result_analysis_pdf', models.FileField(upload_to='department/ME/result-analysis/')),
                ('result_analysis_image', models.ImageField(help_text='Upload image of result analysis bar graph or pie chart', upload_to='department/ME/result-analysis/', validators=[department.models.mechanical_dept_result_analysis.validate_image])),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_timetable',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('course', models.CharField(choices=[('BE', 'B.E.'), ('MT', 'M.Tech')], default='BE', max_length=100)),
                ('semester', models.IntegerField()),
                ('section', models.CharField(max_length=1)),
                ('timetable', models.FileField(upload_to='department/ME/data/timetable/')),
            ],
        ),
        migrations.CreateModel(
            name='physics_dept',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200)),
                ('designation', models.CharField(max_length=200)),
                ('image', models.ImageField(upload_to='department/PHY/image/')),
                ('detail', models.FileField(blank='True', upload_to='department/PHY/data/')),
                ('sno', models.IntegerField(default='1')),
                ('staff_type', models.CharField(choices=[('HOD', 'Head Of Department'), ('FACULTY', 'Faculty Member'), ('TECHNICAL', 'Technical Staff'), ('SUPPORTING', 'Supporting Staff')], default='FACULTY', max_length=100)),
                ('description', models.TextField(blank=True, help_text='Enter description only for HOD. For others this field can be skipped.')),
            ],
        ),
        migrations.CreateModel(
            name='physics_dept_accreditation',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('designation', models.TextField(blank=True)),
                ('member_type', models.CharField(choices=[('PAC', 'Program Assessment Committee (PAC)'), ('DAB', 'Department Advisory Board (DAB)')], default='DAB', max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='physics_dept_achievements',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('achievement_description', models.TextField()),
                ('achievement_type', models.CharField(choices=[('STUDENT', 'Student Achievement'), ('STAFF', 'Staff Achievement')], default='STAFF', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='physics_dept_activities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('activity_name', models.CharField(max_length=200)),
                ('activity_description', models.TextField()),
                ('activity_type', models.CharField(choices=[('STC', 'Department Activity')], default='STC', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='physics_dept_book_chapters',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sl_no', models.IntegerField()),
                ('name_of_book_chapter', models.CharField(max_length=500)),
                ('names_of_authors', models.CharField(max_length=500)),
                ('year_of_pub', models.IntegerField()),
                ('name_of_pub', models.CharField(max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='physics_dept_classroom',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('classroom', models.FileField(upload_to='department/PHY/data/classroom/')),
            ],
        ),
        migrations.CreateModel(
            name='physics_dept_classroom_description',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='physics_dept_events',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('events', models.FileField(upload_to='department/PHY/data/events/')),
                ('semester', models.CharField(max_length=10)),
                ('name', models.CharField(max_length=30)),
            ],
        ),
        migrations.CreateModel(
            name='physics_dept_forum',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField(help_text="Enter a short description about your department's forum.")),
            ],
        ),
        migrations.CreateModel(
            name='physics_dept_gallery',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('image', models.ImageField(upload_to='department/gallery/PHY/')),
            ],
        ),
        migrations.CreateModel(
            name='physics_dept_grants_and_patents',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
                ('grant_or_patent', models.CharField(choices=[('GRANT', 'Grant'), ('PATENT', 'Patent')], default='GRANT', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='physics_dept_lab_facilities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('qty', models.IntegerField()),
                ('config_specs', models.TextField()),
                ('softwares', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='physics_dept_laboratory_facilities_gallary',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('image', models.ImageField(upload_to='department/gallery/PHY/laboratory/')),
            ],
        ),
        migrations.CreateModel(
            name='physics_dept_learning_materials',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(1, 1), (2, 2)])),
                ('subject_code', models.CharField(max_length=100)),
                ('material', models.FileField(upload_to='department/PHY/data/learning-materials')),
            ],
        ),
        migrations.CreateModel(
            name='physics_dept_library',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='physics_dept_major_equipments',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('equipment_description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='physics_dept_publications',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name_of_faculty', models.CharField(max_length=100)),
                ('y15', models.IntegerField(blank=True, null=True)),
                ('y16', models.IntegerField(blank=True, null=True)),
                ('y17', models.IntegerField(blank=True, null=True)),
                ('y18', models.IntegerField(blank=True, null=True)),
                ('y19', models.IntegerField(blank=True, null=True)),
                ('national_or_inter', models.CharField(max_length=13)),
                ('indexing', models.CharField(blank=True, max_length=500, null=True)),
                ('citations', models.IntegerField(blank=True, null=True)),
                ('impact_factor', models.CharField(blank=True, max_length=80, null=True)),
                ('i10_index', models.IntegerField(blank=True, null=True)),
                ('h_index', models.IntegerField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='physics_dept_research_guide',
            fields=[
                ('sno', models.IntegerField(primary_key=True, serialize=False)),
                ('guide_name', models.CharField(max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='physics_dept_result_analysis',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(1, '1st'), (2, '2nd')])),
                ('result_analysis_pdf', models.FileField(upload_to='department/PHY/result-analysis/')),
                ('result_analysis_image', models.ImageField(help_text='Upload image of result analysis bar graph or pie chart', upload_to='department/PHY/result-analysis/', validators=[department.models.physics_dept_result_analysis.validate_image])),
            ],
        ),
        migrations.CreateModel(
            name='physics_dept_timetable',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('course', models.CharField(choices=[('BE', 'B.E.'), ('MT', 'M.Tech')], default='BE', max_length=100)),
                ('semester', models.IntegerField()),
                ('section', models.CharField(max_length=1)),
                ('timetable', models.FileField(upload_to='department/PHY/data/timetable/')),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200)),
                ('designation', models.CharField(max_length=200)),
                ('image', models.ImageField(upload_to='department/TX/image/')),
                ('detail', models.FileField(blank='True', upload_to='department/TX/data/')),
                ('sno', models.IntegerField(default='1')),
                ('staff_type', models.CharField(choices=[('HOD', 'Head Of Department'), ('FACULTY', 'Faculty Member'), ('TECHNICAL', 'Technical Staff'), ('SUPPORTING', 'Supporting Staff')], default='FACULTY', max_length=100)),
                ('description', models.TextField(blank=True, help_text='Enter description only for HOD. For others this field can be skipped.')),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_accreditation',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('designation', models.TextField(blank=True)),
                ('member_type', models.CharField(choices=[('PAC', 'Program Assessment Committee (PAC)'), ('DAB', 'Department Advisory Board (DAB)')], default='DAB', max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_achievements',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('achievement_description', models.TextField()),
                ('achievement_type', models.CharField(choices=[('STUDENT', 'Student Achievement'), ('STAFF', 'Staff Achievement')], default='STAFF', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_activities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('activity_name', models.CharField(max_length=200)),
                ('activity_description', models.TextField()),
                ('activity_type', models.CharField(choices=[('RE', 'Forum Activity'), ('STC', 'Department Activity')], default='RE', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_alumni',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=500)),
                ('designation', models.CharField(max_length=500)),
                ('description', models.TextField()),
                ('image', models.ImageField(upload_to='department/alumni/TX/')),
                ('sno', models.IntegerField(default='1')),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_book_chapters',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sl_no', models.IntegerField()),
                ('name_of_book_chapter', models.CharField(max_length=500)),
                ('names_of_authors', models.CharField(max_length=500)),
                ('year_of_pub', models.IntegerField()),
                ('name_of_pub', models.CharField(max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_classroom',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('classroom', models.FileField(upload_to='department/TX/data/classroom/')),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_classroom_description',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_events',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('events', models.FileField(upload_to='department/TX/data/events/')),
                ('semester', models.CharField(max_length=10)),
                ('name', models.CharField(max_length=30)),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_forum',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField(help_text="Enter a short description about your department's forum.")),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_gallery',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('image', models.ImageField(upload_to='department/gallery/TX/')),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_grants_and_patents',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
                ('grant_or_patent', models.CharField(choices=[('GRANT', 'Grant'), ('PATENT', 'Patent')], default='GRANT', max_length=500)),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_lab_facilities',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('name', models.CharField(max_length=200)),
                ('qty', models.IntegerField()),
                ('config_specs', models.TextField()),
                ('softwares', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_laboratory_facilities_gallary',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('room_no', models.CharField(default='A321', max_length=10)),
                ('image', models.ImageField(upload_to='department/gallery/TX/laboratory/')),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_learning_materials',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(3, 3), (4, 4), (5, 5), (6, 6), (7, 7), (8, 8)])),
                ('subject_code', models.CharField(max_length=100)),
                ('material', models.FileField(upload_to='department/TX/data/learning-materials')),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_library',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_major_equipments',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('equipment_description', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_placement',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sno', models.IntegerField()),
                ('company_name', models.CharField(max_length=500)),
                ('latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2020)),
                ('students_selected_for_latest_year', models.IntegerField()),
                ('second_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2019)),
                ('students_selected_for_2nd_latest_year', models.IntegerField()),
                ('third_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2018)),
                ('students_selected_for_3rd_latest_year', models.IntegerField()),
                ('fourth_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2017)),
                ('students_selected_for_4th_latest_year', models.IntegerField()),
                ('fifth_latest_year', models.IntegerField(choices=[(2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (2020, 2020)], default=2016)),
                ('students_selected_for_5th_latest_year', models.IntegerField()),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_publications',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name_of_faculty', models.CharField(max_length=100)),
                ('y15', models.IntegerField(blank=True, null=True)),
                ('y16', models.IntegerField(blank=True, null=True)),
                ('y17', models.IntegerField(blank=True, null=True)),
                ('y18', models.IntegerField(blank=True, null=True)),
                ('y19', models.IntegerField(blank=True, null=True)),
                ('national_or_inter', models.CharField(max_length=13)),
                ('indexing', models.CharField(blank=True, max_length=500, null=True)),
                ('citations', models.IntegerField(blank=True, null=True)),
                ('impact_factor', models.CharField(blank=True, max_length=80, null=True)),
                ('i10_index', models.IntegerField(blank=True, null=True)),
                ('h_index', models.IntegerField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_research_guide',
            fields=[
                ('sno', models.IntegerField(primary_key=True, serialize=False)),
                ('guide_name', models.CharField(max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_result_analysis',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('semester', models.IntegerField(choices=[(3, '3rd'), (4, '4th'), (5, '5th'), (6, '6th'), (7, '7th'), (8, '8th')])),
                ('result_analysis_pdf', models.FileField(upload_to='department/TX/result-analysis/')),
                ('result_analysis_image', models.ImageField(help_text='Upload image of result analysis bar graph or pie chart', upload_to='department/TX/result-analysis/', validators=[department.models.textile_technology_dept_result_analysis.validate_image])),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_timetable',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('course', models.CharField(choices=[('BE', 'B.E.'), ('MT', 'M.Tech')], default='BE', max_length=100)),
                ('semester', models.IntegerField()),
                ('section', models.CharField(max_length=1)),
                ('timetable', models.FileField(upload_to='department/TX/data/timetable/')),
            ],
        ),
        migrations.CreateModel(
            name='textile_technology_dept_research_scholars',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('research_scholar_name', models.CharField(max_length=100)),
                ('department', models.CharField(max_length=100)),
                ('year_of_regn', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('phD', models.CharField(choices=[('PHD', 'Ph.D.'), ('(PHD)', '(Ph.D.)')], default='(PHD)', max_length=10)),
                ('course_work_completed', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('pre_phD_viva_voce', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('submitted_final_thesis', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('phD_awarded_year', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('guide', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='department.textile_technology_dept_research_guide')),
            ],
        ),
        migrations.CreateModel(
            name='physics_dept_research_scholars',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('research_scholar_name', models.CharField(max_length=100)),
                ('department', models.CharField(max_length=100)),
                ('year_of_regn', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('phD', models.CharField(choices=[('PHD', 'Ph.D.'), ('(PHD)', '(Ph.D.)')], default='(PHD)', max_length=10)),
                ('course_work_completed', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('pre_phD_viva_voce', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('submitted_final_thesis', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('phD_awarded_year', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('guide', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='department.physics_dept_research_guide')),
            ],
        ),
        migrations.CreateModel(
            name='mechanical_dept_research_scholars',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('research_scholar_name', models.CharField(max_length=100)),
                ('department', models.CharField(max_length=100)),
                ('year_of_regn', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('phD', models.CharField(choices=[('PHD', 'Ph.D.'), ('(PHD)', '(Ph.D.)')], default='(PHD)', max_length=10)),
                ('course_work_completed', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('pre_phD_viva_voce', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('submitted_final_thesis', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('phD_awarded_year', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('guide', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='department.mechanical_dept_research_guide')),
            ],
        ),
        migrations.CreateModel(
            name='mathematics_dept_research_scholars',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('research_scholar_name', models.CharField(max_length=100)),
                ('department', models.CharField(max_length=100)),
                ('year_of_regn', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('phD', models.CharField(choices=[('PHD', 'Ph.D.'), ('(PHD)', '(Ph.D.)')], default='(PHD)', max_length=10)),
                ('course_work_completed', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('pre_phD_viva_voce', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('submitted_final_thesis', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('phD_awarded_year', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('guide', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='department.mathematics_dept_research_guide')),
            ],
        ),
        migrations.CreateModel(
            name='information_science_dept_research_scholars',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('research_scholar_name', models.CharField(max_length=100)),
                ('department', models.CharField(max_length=100)),
                ('year_of_regn', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('phD', models.CharField(choices=[('PHD', 'Ph.D.'), ('(PHD)', '(Ph.D.)')], default='(PHD)', max_length=10)),
                ('course_work_completed', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('pre_phD_viva_voce', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('submitted_final_thesis', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('phD_awarded_year', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('guide', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='department.information_science_dept_research_guide')),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_instrumentation_dept_research_scholars',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('research_scholar_name', models.CharField(max_length=100)),
                ('department', models.CharField(max_length=100)),
                ('year_of_regn', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('phD', models.CharField(choices=[('PHD', 'Ph.D.'), ('(PHD)', '(Ph.D.)')], default='(PHD)', max_length=10)),
                ('course_work_completed', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('pre_phD_viva_voce', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('submitted_final_thesis', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('phD_awarded_year', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('guide', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='department.electronics_and_instrumentation_dept_research_guide')),
            ],
        ),
        migrations.CreateModel(
            name='electronics_and_communication_dept_research_scholars',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('research_scholar_name', models.CharField(max_length=100)),
                ('department', models.CharField(max_length=100)),
                ('year_of_regn', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('phD', models.CharField(choices=[('PHD', 'Ph.D.'), ('(PHD)', '(Ph.D.)')], default='(PHD)', max_length=10)),
                ('course_work_completed', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('pre_phD_viva_voce', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('submitted_final_thesis', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('phD_awarded_year', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('guide', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='department.electronics_and_communication_dept_research_guide')),
            ],
        ),
        migrations.CreateModel(
            name='electrical_and_electronics_dept_research_scholars',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('research_scholar_name', models.CharField(max_length=100)),
                ('department', models.CharField(max_length=100)),
                ('year_of_regn', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('phD', models.CharField(choices=[('PHD', 'Ph.D.'), ('(PHD)', '(Ph.D.)')], default='(PHD)', max_length=10)),
                ('course_work_completed', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('pre_phD_viva_voce', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('submitted_final_thesis', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('phD_awarded_year', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('guide', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='department.electrical_and_electronics_dept_research_guide')),
            ],
        ),
        migrations.CreateModel(
            name='computer_science_dept_research_scholars',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('research_scholar_name', models.CharField(max_length=100)),
                ('department', models.CharField(max_length=100)),
                ('year_of_regn', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('phD', models.CharField(choices=[('PHD', 'Ph.D.'), ('(PHD)', '(Ph.D.)')], default='(PHD)', max_length=10)),
                ('course_work_completed', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('pre_phD_viva_voce', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('submitted_final_thesis', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('phD_awarded_year', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('guide', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='department.computer_science_dept_research_guide')),
            ],
        ),
        migrations.CreateModel(
            name='civil_dept_research_scholars',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('research_scholar_name', models.CharField(max_length=100)),
                ('department', models.CharField(max_length=100)),
                ('year_of_regn', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('phD', models.CharField(choices=[('PHD', 'Ph.D.'), ('(PHD)', '(Ph.D.)')], default='(PHD)', max_length=10)),
                ('course_work_completed', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('pre_phD_viva_voce', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('submitted_final_thesis', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('phD_awarded_year', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('guide', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='department.civil_dept_research_guide')),
            ],
        ),
        migrations.CreateModel(
            name='chemistry_dept_research_scholars',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('research_scholar_name', models.CharField(max_length=100)),
                ('department', models.CharField(max_length=100)),
                ('year_of_regn', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('phD', models.CharField(choices=[('PHD', 'Ph.D.'), ('(PHD)', '(Ph.D.)')], default='(PHD)', max_length=10)),
                ('course_work_completed', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('pre_phD_viva_voce', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('submitted_final_thesis', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('phD_awarded_year', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('guide', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='department.chemistry_dept_research_guide')),
            ],
        ),
        migrations.CreateModel(
            name='chemical_dept_research_scholars',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('research_scholar_name', models.CharField(max_length=100)),
                ('department', models.CharField(max_length=100)),
                ('year_of_regn', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('phD', models.CharField(choices=[('PHD', 'Ph.D.'), ('(PHD)', '(Ph.D.)')], default='(PHD)', max_length=10)),
                ('course_work_completed', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('pre_phD_viva_voce', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('submitted_final_thesis', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('phD_awarded_year', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('guide', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='department.chemical_dept_research_guide')),
            ],
        ),
        migrations.CreateModel(
            name='bio_technology_dept_research_scholars',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('research_scholar_name', models.CharField(max_length=100)),
                ('department', models.CharField(max_length=100)),
                ('year_of_regn', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('phD', models.CharField(choices=[('PHD', 'Ph.D.'), ('(PHD)', '(Ph.D.)')], default='(PHD)', max_length=10)),
                ('course_work_completed', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('pre_phD_viva_voce', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('submitted_final_thesis', models.CharField(choices=[('Y', 'Yes'), ('N', 'No')], default='Y', max_length=1)),
                ('phD_awarded_year', models.IntegerField(choices=[(1979, 1979), (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), (2017, 2017), (2018, 2018), (2019, 2019), (0, 'NA')], default=0)),
                ('guide', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='department.bio_technology_dept_research_guide')),
            ],
        ),
    ]
