class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='College',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=250)),
('slug', models.SlugField(max_length=250, unique_for_date='postdate')),
('postdate', models.DateTimeField(default=django.utils.timezone.now)),
('logo', models.FileField(blank=True, null=True, upload_to=college.models.college_logo_path)),
('scc_mail_id', models.EmailField(max_length=254)),
('description', models.TextField(blank=True, null=True)),
('website', models.TextField(blank=True, null=True)),
('address', models.TextField()),
('city', models.CharField(choices=[('GN', 'Gandhinagar'), ('ADI', 'Ahmedabad')], default='Gandhinagar', max_length=150)),
('author', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='college_posts', to=settings.AUTH_USER_MODEL)),
],
options={
'ordering': ('-postdate',),
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Assignment',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('subject', models.CharField(max_length=100)),
('message', models.TextField()),
('cr_date', models.DateTimeField(auto_now_add=True)),
('attachment1',
models.FileField(blank=True, null=True, upload_to='docs//')),
('sem',
models.IntegerField(choices=[(1, 1), (2, 2), (3, 3), (4, 4),
(5, 5), (6, 6), (7, 7), (8, 8)],
default=1)),
('duedate', models.DateTimeField()),
],
),
migrations.CreateModel(
name='Attendance',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('subject', models.CharField(max_length=100)),
('total_classes',
models.FloatField(
default=0,
validators=[django.core.validators.MinValueValidator(0)
])),
('attend',
models.FloatField(
default=0,
validators=[django.core.validators.MinValueValidator(0)
])),
('comment', models.TextField()),
],
),
migrations.CreateModel(
name='Branch',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100)),
('hod', models.CharField(max_length=100)),
],
),
migrations.CreateModel(
name='Notice',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('subject', models.CharField(max_length=100)),
('message', models.TextField()),
('cr_date', models.DateTimeField(auto_now_add=True)),
('attachment1',
models.FileField(blank=True, null=True, upload_to='docs//')),
('sem',
models.IntegerField(choices=[(1, 1), (2, 2), (3, 3), (4, 4),
(5, 5), (6, 6), (7, 7), (8, 8),
(0, 'All')],
default=0)),
('branch',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='college.Branch')),
],
),
migrations.CreateModel(
name='Result',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('subject', models.CharField(max_length=100)),
('marks',
models.FloatField(
default=0,
validators=[
django.core.validators.MinValueValidator(0),
django.core.validators.MaxValueValidator(100)
])),
('comment', models.TextField()),
],
),
migrations.CreateModel(
name='Student',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100)),
('sem',
models.IntegerField(choices=[(1, 1), (2, 2), (3, 3), (4, 4),
(5, 5), (6, 6), (7, 7), (8, 8)],
default=1)),
('rn',
models.IntegerField(
null=True,
validators=[django.core.validators.MinValueValidator(1)
])),
('phone_no',
models.CharField(max_length=20,
null=True,
validators=[
django.core.validators.RegexValidator(
'^0?[6-9]{1}\\d{9}$')
])),
('marks_10',
models.FloatField(
default=0,
validators=[
django.core.validators.MinValueValidator(0),
django.core.validators.MaxValueValidator(100)
])),
('marks_12',
models.FloatField(
default=0,
validators=[
django.core.validators.MinValueValidator(0),
django.core.validators.MaxValueValidator(100)
])),
('marks_aggr',
models.FloatField(
default=0,
validators=[
django.core.validators.MinValueValidator(0),
django.core.validators.MaxValueValidator(100)
])),
('email', models.EmailField(max_length=254, null=True)),
('skills', models.TextField(null=True)),
('myimg',
models.ImageField(null=True,
upload_to='images\\',
validators=[college.models.validate_img])),
('branch',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='college.Branch')),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.AddField(
model_name='result',
name='student',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='college.Student'),
),
migrations.AddField(
model_name='attendance',
name='student',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='college.Student'),
),
migrations.AddField(
model_name='assignment',
name='branch',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='college.Branch'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Course',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('coursename',
models.CharField(blank=True, max_length=100, null=True)),
('course_ka_photo',
models.ImageField(blank=True,
default='media/lol.jpg',
null=True,
upload_to='')),
],
),
migrations.CreateModel(
name='Follow',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('time', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='Student',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('username',
models.IntegerField(
blank=True,
null=True,
unique=True,
validators=[
django.core.validators.MinValueValidator(0),
django.core.validators.MaxValueValidator(12)
])),
('name', models.CharField(max_length=50)),
('email', models.EmailField(max_length=254)),
('avatar',
models.ImageField(
default='user_avatars/default-avatar.jpg',
upload_to=college.models.Student.get_upload_to)),
('course',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
to='college.Course')),
],
),
migrations.CreateModel(
name='Student_attendance',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('attendance',
models.IntegerField(
blank=True,
null=True,
validators=[
django.core.validators.MinValueValidator(0),
django.core.validators.MaxValueValidator(100)
])),
('student',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='college.Student')),
],
),
migrations.CreateModel(
name='Subject',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('subjectname',
models.CharField(blank=True, max_length=50, null=True)),
('course',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='college.Course')),
],
),
migrations.AddField(
model_name='follow',
name='followed',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='person_followed',
to='college.Student'),
),
migrations.AddField(
model_name='follow',
name='follower',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='person_following',
to='college.Student'),
),
]
class Migration(migrations.Migration):
replaces = [('college', '0001_initial'),
('college', '0002_auto_20200323_1231'),
('college', '0003_auto_20200706_0113'),
('college', '0004_auto_20200714_1254'),
('college', '0005_auto_20200803_0303'),
('college', '0006_auto_20200817_0303'),
('college', '0007_auto_20200823_0112'),
('college', '0008_teacher_user'),
('college', '0009_auto_20200921_0012'),
('college', '0010_auto_20201004_1604'),
('college', '0011_auto_20201004_1655'),
('college', '0012_auto_20201005_0204'),
('college', '0013_auto_20201005_2229'),
('college', '0014_auto_20201005_2305'),
('college', '0015_academicdatachange'),
('college', '0016_auto_20201006_0416'),
('college', '0017_auto_20201006_1423'),
('college', '0018_auto_20201008_1701'),
('college', '0019_auto_20201010_0437'),
('college', '0020_auto_20201010_0525'),
('college', '0021_auto_20201010_0611'),
('college', '0022_auto_20201010_1910'),
('college', '0023_auto_20201011_2248'),
('college', '0024_auto_20201012_0605'),
('college', '0025_auto_20201012_0915'),
('college', '0026_teacher_file_consent'),
('college', '0027_auto_20201018_2200'),
('college', '0028_auto_20201018_2344'),
('college', '0029_auto_20201019_0116'),
('college', '0030_auto_20201109_0332'),
('college', '0031_auto_20201117_0355'),
('college', '0032_auto_20201227_0018')]
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Building',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('external_id',
models.IntegerField(blank=True,
db_index=True,
null=True,
unique=True)),
('iid', models.CharField(blank=True, max_length=64,
null=True)),
('external_update', models.DateTimeField(blank=True,
null=True)),
('frozen', models.BooleanField(default=False)),
('disappeared', models.BooleanField(default=False)),
('external_data',
models.JSONField(blank=True, default=dict, null=True)),
('last_save', models.DateTimeField(auto_now=True)),
('name', models.CharField(max_length=32, unique=True)),
('abbreviation',
models.CharField(db_index=True,
max_length=16,
null=True,
unique=True)),
('map_tag', models.CharField(max_length=20, unique=True)),
('location',
django.contrib.gis.db.models.fields.PointField(geography=True,
null=True,
srid=4326)),
('picture',
models.ImageField(
blank=True,
null=True,
upload_to=college.models.building_pic_path)),
],
options={
'ordering': ['name'],
},
),
migrations.CreateModel(
name='Class',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('external_id',
models.IntegerField(blank=True,
db_index=True,
null=True,
unique=True)),
('iid', models.CharField(blank=True, max_length=64,
null=True)),
('external_update', models.DateTimeField(blank=True,
null=True)),
('frozen', models.BooleanField(default=False)),
('disappeared', models.BooleanField(default=False)),
('external_data',
models.JSONField(blank=True, default=dict, null=True)),
('last_save', models.DateTimeField(auto_now=True)),
('name', models.CharField(max_length=256)),
('abbreviation', models.CharField(default='---',
max_length=16)),
('description',
markdownx.models.MarkdownxField(blank=True, null=True)),
('credits', models.IntegerField(blank=True, null=True)),
('extinguished', models.BooleanField(default=False)),
('url', models.URLField(blank=True, max_length=256,
null=True)),
('avg_grade', models.FloatField(blank=True, null=True)),
],
options={
'verbose_name_plural': 'classes',
'ordering': ['name'],
},
),
migrations.CreateModel(
name='ClassFile',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('external_id',
models.IntegerField(blank=True,
db_index=True,
null=True,
unique=True)),
('iid', models.CharField(blank=True, max_length=64,
null=True)),
('external_update', models.DateTimeField(blank=True,
null=True)),
('frozen', models.BooleanField(default=False)),
('disappeared', models.BooleanField(default=False)),
('external_data',
models.JSONField(blank=True, default=dict, null=True)),
('name', models.CharField(blank=True,
max_length=256,
null=True)),
('category',
models.IntegerField(
choices=[(2, 'Slides'), (3, 'Problemas'), (
4, 'Protolos'), (5, 'Seminário'), (
6,
'Exame'), (7,
'Teste'), (8,
'Suporte'), (9,
'Outros')])),
('visibility',
models.IntegerField(choices=[(0, 'Todos'), (1, 'Estudantes'),
(2, 'Inscritos'),
(3, 'Ninguém')],
default=3)),
('official', models.BooleanField(default=False)),
('upload_datetime', models.DateTimeField(auto_now_add=True)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='ClassInstance',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('external_id',
models.IntegerField(blank=True,
db_index=True,
null=True,
unique=True)),
('iid', models.CharField(blank=True, max_length=64,
null=True)),
('external_update', models.DateTimeField(blank=True,
null=True)),
('frozen', models.BooleanField(default=False)),
('disappeared', models.BooleanField(default=False)),
('external_data',
models.JSONField(blank=True, default=dict, null=True)),
('last_save', models.DateTimeField(auto_now=True)),
('period',
models.IntegerField(choices=[(1, 'Anual'), (
2, '1º semestre'
), (3, '2º semestre'), (4, '1º trimestre'), (
5, '2º trimestre'), (6,
'3º trimestre'), (7,
'4º trimestre')])),
('year', models.IntegerField()),
('information',
models.JSONField(
encoder=django.core.serializers.json.DjangoJSONEncoder)),
('visibility',
models.IntegerField(choices=[(0, 'Todos'), (1, 'Estudantes'),
(2, 'Inscritos'),
(3, 'Ninguém')],
default=1)),
('avg_grade', models.FloatField(blank=True, null=True)),
],
),
migrations.CreateModel(
name='ClassInstanceAnnouncement',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('external_id',
models.IntegerField(blank=True,
db_index=True,
null=True,
unique=True)),
('iid', models.CharField(blank=True, max_length=64,
null=True)),
('external_update', models.DateTimeField(blank=True,
null=True)),
('frozen', models.BooleanField(default=False)),
('disappeared', models.BooleanField(default=False)),
('external_data',
models.JSONField(blank=True, default=dict, null=True)),
('title', models.CharField(max_length=256)),
('message', models.TextField()),
('datetime', models.DateTimeField()),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='ClassInstanceEvent',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('external_id',
models.IntegerField(blank=True,
db_index=True,
null=True,
unique=True)),
('iid', models.CharField(blank=True, max_length=64,
null=True)),
('external_update', models.DateTimeField(blank=True,
null=True)),
('frozen', models.BooleanField(default=False)),
('disappeared', models.BooleanField(default=False)),
('external_data',
models.JSONField(blank=True, default=dict, null=True)),
('date', models.DateField()),
('time', models.TimeField(blank=True, null=True)),
('duration', models.IntegerField(blank=True, null=True)),
('type',
models.IntegerField(choices=[(1, 'Teste'), (2, 'Exame'),
(3, 'Discussão'), (4, 'Viagem'),
(5, 'Enúnciação'),
(6, 'Entrega'), (7, 'Aula'),
(8, 'Apresentação'),
(9, 'Seminário'),
(10, 'Palestra')],
null=True)),
('season',
models.IntegerField(choices=[(1, 'Epoca normal'),
(2, 'Epoca de exame'),
(3, 'Epoca especial')],
null=True)),
('info', models.TextField(blank=True, null=True)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Course',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('external_id',
models.IntegerField(blank=True,
db_index=True,
null=True,
unique=True)),
('iid', models.CharField(blank=True, max_length=64,
null=True)),
('external_update', models.DateTimeField(blank=True,
null=True)),
('frozen', models.BooleanField(default=False)),
('disappeared', models.BooleanField(default=False)),
('external_data',
models.JSONField(blank=True, default=dict, null=True)),
('last_save', models.DateTimeField(auto_now=True)),
('name', models.CharField(max_length=256)),
('abbreviation',
models.CharField(blank=True, max_length=128, null=True)),
('description',
markdownx.models.MarkdownxField(blank=True, null=True)),
('degree',
models.IntegerField(
choices=[(1, 'Licenciatura'), (
2, 'Mestrado'), (3, 'Doutoramento'),
(4, 'Mestrado Integrado'), (5, 'Pos-Graduação'),
(6, 'Estudos Avançados'), (7,
'Pré-Graduação')])),
('active', models.BooleanField(default=False)),
('url', models.URLField(blank=True, max_length=256,
null=True)),
],
options={
'ordering': ['name'],
},
),
migrations.CreateModel(
name='Curriculum',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('period_type',
models.CharField(blank=True, max_length=1, null=True)),
('period', models.IntegerField(blank=True, null=True)),
('year', models.IntegerField()),
('required', models.BooleanField()),
],
options={
'ordering': ['year', 'period_type', 'period'],
},
),
migrations.CreateModel(
name='Department',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('external_id',
models.IntegerField(blank=True,
db_index=True,
null=True,
unique=True)),
('iid', models.CharField(blank=True, max_length=64,
null=True)),
('external_update', models.DateTimeField(blank=True,
null=True)),
('frozen', models.BooleanField(default=False)),
('disappeared', models.BooleanField(default=False)),
('external_data',
models.JSONField(blank=True, default=dict, null=True)),
('last_save', models.DateTimeField(auto_now=True)),
('name', models.CharField(max_length=128)),
('description',
markdownx.models.MarkdownxField(blank=True, null=True)),
('extinguished', models.BooleanField(default=True)),
('picture',
models.ImageField(
blank=True,
null=True,
upload_to=college.models.department_pic_path)),
('url', models.URLField(blank=True, max_length=256,
null=True)),
('phone', models.CharField(blank=True,
max_length=20,
null=True)),
('email',
models.EmailField(blank=True, max_length=254, null=True)),
],
options={
'ordering': ['name'],
},
),
migrations.CreateModel(
name='Enrollment',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('external_id',
models.IntegerField(blank=True,
db_index=True,
null=True,
unique=True)),
('iid', models.CharField(blank=True, max_length=64,
null=True)),
('external_update', models.DateTimeField(blank=True,
null=True)),
('frozen', models.BooleanField(default=False)),
('disappeared', models.BooleanField(default=False)),
('external_data',
models.JSONField(blank=True, default=dict, null=True)),
('attendance', models.BooleanField(null=True)),
('attendance_date', models.DateField(blank=True, null=True)),
('normal_grade', models.IntegerField(blank=True, null=True)),
('normal_grade_date', models.DateField(blank=True, null=True)),
('recourse_grade', models.IntegerField(blank=True, null=True)),
('recourse_grade_date', models.DateField(blank=True,
null=True)),
('special_grade', models.IntegerField(blank=True, null=True)),
('special_grade_date', models.DateField(blank=True,
null=True)),
('approved', models.BooleanField(blank=True, null=True)),
('grade', models.IntegerField(blank=True, null=True)),
],
),
migrations.CreateModel(
name='File',
fields=[
('external_id',
models.IntegerField(blank=True,
db_index=True,
null=True,
unique=True)),
('iid', models.CharField(blank=True, max_length=64,
null=True)),
('external_update', models.DateTimeField(blank=True,
null=True)),
('frozen', models.BooleanField(default=False)),
('disappeared', models.BooleanField(default=False)),
('external_data',
models.JSONField(blank=True, default=dict, null=True)),
('hash',
models.CharField(max_length=40,
primary_key=True,
serialize=False)),
('size', models.IntegerField()),
('mime', models.CharField(max_length=256, null=True)),
('name', models.CharField(max_length=256, null=True)),
('extension', models.CharField(max_length=16, null=True)),
('external', models.BooleanField(default=False)),
('license',
models.IntegerField(blank=True,
choices=[(0,
'Todos os direitos reservados'),
(1, 'Domínio Público'),
(2, 'GPLv3'), (3, 'MIT'),
(4, 'BSD'),
(5, 'Creative Commons BY'),
(6, 'Creative Commons BY-SA'),
(7, 'Creative Commons BY-NC'),
(8, 'Creative Commons BY-SA-NC'),
(100, 'Permissiva genérica')],
default=0,
null=True)),
('license_str',
models.CharField(blank=True,
default=None,
max_length=256,
null=True)),
('author_str',
models.CharField(blank=True, max_length=256, null=True)),
('doi', models.URLField(blank=True, null=True)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Place',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('last_save', models.DateTimeField(auto_now=True)),
('name', models.CharField(max_length=128)),
('floor', models.IntegerField(default=0)),
('unlocked', models.BooleanField(default=None, null=True)),
('location',
django.contrib.gis.db.models.fields.PointField(blank=True,
geography=True,
null=True,
srid=4326)),
('picture',
models.ImageField(blank=True,
null=True,
upload_to=college.models.place_pic_path)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='PlaceFeature',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100)),
('description', models.TextField()),
('icon',
models.FileField(upload_to=college.models.feature_pic_path)),
],
),
migrations.CreateModel(
name='Shift',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('external_id',
models.IntegerField(blank=True,
db_index=True,
null=True,
unique=True)),
('iid', models.CharField(blank=True, max_length=64,
null=True)),
('external_update', models.DateTimeField(blank=True,
null=True)),
('frozen', models.BooleanField(default=False)),
('disappeared', models.BooleanField(default=False)),
('external_data',
models.JSONField(blank=True, default=dict, null=True)),
('shift_type',
models.IntegerField(choices=[(1, 'Teórico'), (
2, 'Prático'), (3, 'Teórico-pratico'), (
4, 'Seminário'), (
5, 'Orientação tutorial'), (
6, 'Trabalho de campo'), (
7, 'Teórico Online'), (8,
'Prático Online'),
(9, 'Teórico-Pratico Online')])),
('number', models.IntegerField()),
('required', models.BooleanField(default=True)),
],
),
migrations.CreateModel(
name='ShiftInstance',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('external_id',
models.IntegerField(blank=True,
db_index=True,
null=True,
unique=True)),
('iid', models.CharField(blank=True, max_length=64,
null=True)),
('external_update', models.DateTimeField(blank=True,
null=True)),
('frozen', models.BooleanField(default=False)),
('disappeared', models.BooleanField(default=False)),
('external_data',
models.JSONField(blank=True, default=dict, null=True)),
('recurring', models.BooleanField(default=True)),
('weekday',
models.IntegerField(blank=True,
choices=[(0, 'Segunda-feira'),
(1, 'Terça-feira'),
(2, 'Quarta-feira'),
(3, 'Quinta-feira'),
(4, 'Sexta-feira'),
(5, 'Sábado'), (6, 'Domingo')],
null=True)),
('start', models.IntegerField(blank=True, null=True)),
('duration', models.IntegerField(blank=True, null=True)),
],
options={
'ordering': ['weekday', 'start'],
},
),
migrations.CreateModel(
name='ShiftStudents',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
],
options={
'verbose_name_plural': 'shift students',
},
),
migrations.CreateModel(
name='Student',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('external_id',
models.IntegerField(blank=True,
db_index=True,
null=True,
unique=True)),
('iid', models.CharField(blank=True, max_length=64,
null=True)),
('external_update', models.DateTimeField(blank=True,
null=True)),
('frozen', models.BooleanField(default=False)),
('disappeared', models.BooleanField(default=False)),
('external_data',
models.JSONField(blank=True, default=dict, null=True)),
('last_save', models.DateTimeField(auto_now=True)),
('name', models.TextField(max_length=200, null=True)),
('number',
models.IntegerField(blank=True,
db_index=True,
null=True,
unique=True)),
('abbreviation',
models.CharField(blank=True,
db_index=True,
max_length=64,
null=True)),
('graduation_grade',
models.IntegerField(blank=True, default=None, null=True)),
('year', models.IntegerField(blank=True, null=True)),
('first_year', models.IntegerField(blank=True, null=True)),
('last_year', models.IntegerField(blank=True, null=True)),
('credits', models.IntegerField(blank=True, null=True)),
('avg_grade', models.FloatField(blank=True, null=True)),
],
options={
'ordering': ['number'],
},
),
migrations.CreateModel(
name='TeacherRank',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=32)),
],
options={
'ordering': ['name'],
},
),
migrations.CreateModel(
name='Room',
fields=[
('place_ptr',
models.OneToOneField(
auto_created=True,
on_delete=django.db.models.deletion.CASCADE,
parent_link=True,
primary_key=True,
serialize=False,
to='college.place')),
('external_id',
models.IntegerField(blank=True,
db_index=True,
null=True,
unique=True)),
('iid', models.CharField(blank=True, max_length=64,
null=True)),
('external_update', models.DateTimeField(blank=True,
null=True)),
('frozen', models.BooleanField(default=False)),
('disappeared', models.BooleanField(default=False)),
('external_data',
models.JSONField(blank=True, default=dict, null=True)),
('capacity', models.IntegerField(blank=True, null=True)),
('door_number', models.IntegerField(blank=True, null=True)),
('type',
models.IntegerField(choices=[(1, 'Genérico'),
(2, 'Sala de aula'),
(3, 'Auditório'),
(4, 'Laboratório'),
(5, 'Sala de computadores'),
(6, 'Sala de reuniões'),
(7, 'Sala de mestrados'),
(8, 'Gabinete')],
default=0)),
('description', models.TextField(blank=True, null=True)),
('equipment', models.TextField(blank=True, null=True)),
('extinguished', models.BooleanField(default=False)),
],
options={
'ordering': ('floor', 'door_number', 'name'),
},
bases=('college.place', models.Model),
),
migrations.CreateModel(
name='Teacher',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('external_id',
models.IntegerField(blank=True,
db_index=True,
null=True,
unique=True)),
('iid', models.CharField(blank=True, max_length=64,
null=True)),
('external_update', models.DateTimeField(blank=True,
null=True)),
('frozen', models.BooleanField(default=False)),
('disappeared', models.BooleanField(default=False)),
('external_data',
models.JSONField(blank=True, default=dict, null=True)),
('last_save', models.DateTimeField(auto_now=True)),
('name', models.TextField(db_index=True, max_length=200)),
('first_year', models.IntegerField(blank=True, null=True)),
('last_year', models.IntegerField(blank=True, null=True)),
('abbreviation',
models.CharField(blank=True,
db_index=True,
max_length=64,
null=True)),
('url', models.URLField(blank=True, max_length=256,
null=True)),
('email',
models.EmailField(blank=True, max_length=256, null=True)),
('phone', models.CharField(blank=True,
max_length=20,
null=True)),
('picture',
models.ImageField(blank=True,
null=True,
upload_to=college.models.teacher_pic_path)),
('file_consent',
models.IntegerField(blank=True,
choices=[(0, 'Todos'), (1, 'Estudantes'),
(2, 'Inscritos'),
(3, 'Ninguém')],
default=None,
null=True)),
('departments',
models.ManyToManyField(related_name='teachers',
to='college.Department')),
('rank',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.PROTECT,
to='college.teacherrank')),
('same_as',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='college.teacher')),
],
options={
'abstract': False,
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Account',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('password', models.CharField(max_length=128, verbose_name='password')),
('email', models.EmailField(max_length=100, unique=True, verbose_name='email')),
('recovery_email', models.EmailField(default='*****@*****.**', max_length=255)),
('last_login', models.DateTimeField(auto_now=True)),
('enrollment_no', models.CharField(default='', max_length=20)),
('is_approved', models.BooleanField(default=False)),
('is_student', models.BooleanField(default=False)),
('is_HOD', models.BooleanField(default=False)),
('is_BOC', models.BooleanField(default=False)),
('is_teacher', models.BooleanField(default=False)),
('is_staff', models.BooleanField(default=False)),
('is_admin', models.BooleanField(default=False)),
('is_active', models.BooleanField(default=True)),
('is_superuser', models.BooleanField(default=False)),
],
options={
'abstract': False,
},
managers=[
('object', django.db.models.manager.Manager()),
],
),
migrations.CreateModel(
name='ExamData',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('exam', models.IntegerField()),
('total_question', models.IntegerField()),
('department', models.CharField(default='please enter department', max_length=255)),
('semester', models.IntegerField()),
('total_marks', models.IntegerField(default=0)),
('exam_date', models.DateTimeField(auto_now_add=True)),
],
),
migrations.CreateModel(
name='Staff',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('email', models.EmailField(max_length=100, unique=True, verbose_name='email')),
('first_name', models.CharField(max_length=100)),
('last_name', models.CharField(max_length=100)),
('joined_year', models.IntegerField()),
('address', models.CharField(max_length=255)),
('gender', models.CharField(max_length=10)),
('phone', models.CharField(max_length=15, verbose_name='phone')),
('image', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Staff.path_and_rename)),
('department', models.CharField(default='', max_length=255)),
('active', models.BooleanField(default=True)),
('last_login', models.DateTimeField(auto_now=True)),
('joined_date', models.DateTimeField(auto_now_add=True)),
('is_HOD', models.BooleanField(default=False)),
('is_BOC', models.BooleanField(default=False)),
('is_teacher', models.BooleanField(default=False)),
('is_staff', models.BooleanField(default=False)),
('staff_data', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
managers=[
('object', django.db.models.manager.Manager()),
],
),
migrations.CreateModel(
name='Subject',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('year', models.IntegerField()),
('semester', models.IntegerField(default='')),
('allow_test', models.BooleanField(default=False)),
('department', models.CharField(max_length=255)),
('name', models.CharField(max_length=255, verbose_name='Subject_name')),
('subject_code', models.CharField(default='', max_length=255, verbose_name='Subject_code')),
('allocated', models.BooleanField(default=False)),
('teacher', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='college.Staff')),
],
),
migrations.CreateModel(
name='Student',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('registration_no', models.CharField(max_length=20)),
('year', models.CharField(max_length=4)),
('semester', models.IntegerField(default=1)),
('university_roll', models.CharField(max_length=20)),
('enrollment_no', models.CharField(default='', max_length=255, unique=True)),
('qr_code', models.ImageField(blank=True, upload_to=college.models.Student.image_qr_code)),
('contact_no', models.CharField(max_length=10, verbose_name='phone')),
('email', models.EmailField(max_length=100, unique=True, verbose_name='email')),
('first_name', models.CharField(max_length=100)),
('last_name', models.CharField(max_length=100)),
('dob', models.CharField(blank=True, default='', max_length=255)),
('gender', models.CharField(max_length=10)),
('address', models.CharField(max_length=255)),
('city', models.CharField(blank=True, max_length=255)),
('state', models.CharField(blank=True, max_length=255)),
('country', models.CharField(blank=True, max_length=255)),
('fathers_name', models.CharField(default='', max_length=255)),
('mothers_name', models.CharField(default='', max_length=255)),
('blood_group', models.CharField(default='', max_length=255)),
('mothers_tongue', models.CharField(default='', max_length=255)),
('fathers_contact_no', models.CharField(default='', max_length=255)),
('fathers_email', models.EmailField(default='', max_length=100)),
('guardian_name', models.CharField(blank=True, default='', max_length=255)),
('guardian_contact_no', models.CharField(blank=True, default='', max_length=255)),
('relation_with_guardian', models.CharField(blank=True, default='', max_length=255)),
('nationality', models.CharField(blank=True, max_length=255)),
('cast', models.CharField(max_length=8)),
('religion', models.CharField(max_length=8)),
('physically_challenge', models.CharField(max_length=8)),
('department', models.CharField(max_length=255)),
('aadhar_card_no', models.CharField(max_length=255)),
('aadhar_card', models.ImageField(blank=True, upload_to=college.models.Student.image_aadhar_card)),
('cast_certificate', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Student.image_cast_certificate)),
('physically_certificate', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Student.image_physically_certificate)),
('photo', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Student.profile)),
('admission_cat', models.CharField(max_length=255)),
('conducted_by', models.CharField(max_length=255)),
('rank', models.CharField(max_length=255)),
('roll_no', models.CharField(max_length=255)),
('allotment', models.CharField(max_length=10)),
('rank_card', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Student.rank_card)),
('admit_card', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Student.admit_card)),
('school_name_10', models.CharField(blank=True, default='', max_length=255)),
('board_10', models.CharField(blank=True, default='', max_length=255)),
('medium_10', models.CharField(blank=True, default='', max_length=255)),
('address10', models.CharField(blank=True, default=0, max_length=255)),
('city10', models.CharField(blank=True, default=0, max_length=255)),
('state10', models.CharField(blank=True, default=0, max_length=255)),
('country10', models.CharField(blank=True, default=0, max_length=255)),
('passing_year_10', models.CharField(blank=True, default=0, max_length=255)),
('sub1', models.CharField(blank=True, default=0, max_length=255)),
('sub2', models.CharField(blank=True, default=0, max_length=255)),
('sub3', models.CharField(blank=True, default=0, max_length=255)),
('sub4', models.CharField(blank=True, default=0, max_length=255)),
('sub5', models.CharField(blank=True, default=0, max_length=255)),
('aggregate10', models.CharField(blank=True, default='', max_length=255)),
('admit10', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Student.image_admit_card_10)),
('mark10', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Student.image_marksheet_10)),
('certificate10', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Student.image_marksheet_10)),
('school_name_12', models.CharField(blank=True, default=' ', max_length=255)),
('board_12', models.CharField(blank=True, default='', max_length=255)),
('medium_12', models.CharField(blank=True, default='', max_length=255)),
('address12', models.CharField(blank=True, default=0, max_length=255)),
('city12', models.CharField(blank=True, default=0, max_length=255)),
('state12', models.CharField(blank=True, default=0, max_length=255)),
('country12', models.CharField(blank=True, default=0, max_length=255)),
('passing_year_12', models.CharField(blank=True, default=0, max_length=255)),
('english', models.CharField(blank=True, default=0, max_length=255)),
('chemistry', models.CharField(blank=True, default=0, max_length=255)),
('physics', models.CharField(blank=True, default=0, max_length=255)),
('math', models.CharField(blank=True, default=0, max_length=255)),
('optional', models.CharField(blank=True, default=0, max_length=255)),
('aggregate12', models.CharField(blank=True, default='', max_length=255)),
('mark12', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Student.image_marksheet_12)),
('admit12', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Student.image_admit_card_12)),
('certificate12', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Student.image_marksheet_12)),
('school_name_diploma', models.CharField(blank=True, default=' ', max_length=255)),
('board_diploma', models.CharField(blank=True, default='', max_length=255)),
('medium_diploma', models.CharField(blank=True, default='', max_length=255)),
('addressDiploma', models.CharField(blank=True, default=0, max_length=255)),
('cityDiploma', models.CharField(blank=True, default=0, max_length=255)),
('stateDiploma', models.CharField(blank=True, default=0, max_length=255)),
('countryDiploma', models.CharField(blank=True, default=0, max_length=255)),
('passing_year_Diploma', models.CharField(blank=True, default=0, max_length=255)),
('marksDiploma', models.CharField(blank=True, default='', max_length=255)),
('aggregateDiploma', models.CharField(blank=True, default='', max_length=255)),
('division', models.CharField(blank=True, default='', max_length=255)),
('markDiploma', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Student.image_marksheet_diploma)),
('certificateDiploma', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Student.image_certificateDiploma)),
('loan', models.CharField(blank=True, default='', max_length=255)),
('hostel', models.CharField(blank=True, default='', max_length=255)),
('gap', models.CharField(blank=True, default='', max_length=255)),
('reason', models.CharField(blank=True, default='', max_length=255)),
('last_login', models.DateTimeField(auto_now=True)),
('joined_date', models.DateTimeField(blank=True, null=True)),
('end_date', models.DateTimeField(blank=True, null=True)),
('student_data', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Result',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('exam', models.IntegerField()),
('department', models.CharField(default='please enter department', max_length=255)),
('semester', models.IntegerField()),
('marks', models.IntegerField(default=0)),
('exam_done', models.BooleanField(default=False)),
('exam_date', models.DateTimeField(auto_now_add=True)),
('student', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='college.Student')),
('subject', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='college.Subject')),
('total_marks', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='college.ExamData')),
],
),
migrations.CreateModel(
name='Question',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('question_no', models.IntegerField()),
('semester', models.IntegerField()),
('exam', models.IntegerField()),
('exam_start_time', models.DateTimeField(default=datetime.datetime(2021, 2, 23, 20, 8, 56, 680786))),
('exam_end_time', models.DateTimeField(default=datetime.datetime(2021, 2, 23, 20, 8, 56, 680786))),
('question_text', models.CharField(max_length=255)),
('choice_text1', models.CharField(max_length=255)),
('choice_text2', models.CharField(max_length=255)),
('choice_text3', models.CharField(max_length=255)),
('choice_text4', models.CharField(max_length=255)),
('correct', models.IntegerField()),
('pub_date', models.DateTimeField(auto_now_add=True)),
('subject', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='college.Subject')),
('teacher', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='college.Staff')),
],
),
migrations.AddField(
model_name='examdata',
name='subject',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='college.Subject'),
),
migrations.AddField(
model_name='examdata',
name='teacher',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='college.Staff'),
),
migrations.CreateModel(
name='Admission',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('enrollment_no', models.CharField(default='', max_length=255, unique=True)),
('qr_code', models.ImageField(blank=True, upload_to=college.models.Admission.image_qr_code)),
('year', models.CharField(max_length=4)),
('contact_no', models.CharField(max_length=10, verbose_name='phone')),
('email', models.EmailField(max_length=100, unique=True, verbose_name='email')),
('first_name', models.CharField(max_length=100)),
('last_name', models.CharField(max_length=100)),
('dob', models.CharField(blank=True, default='', max_length=255)),
('gender', models.CharField(max_length=10)),
('address', models.CharField(max_length=255)),
('city', models.CharField(blank=True, max_length=255)),
('state', models.CharField(blank=True, max_length=255)),
('country', models.CharField(blank=True, max_length=255)),
('fathers_name', models.CharField(default='', max_length=255)),
('mothers_name', models.CharField(default='', max_length=255)),
('blood_group', models.CharField(default='', max_length=255)),
('mothers_tongue', models.CharField(default='', max_length=255)),
('fathers_contact_no', models.CharField(default='', max_length=255)),
('fathers_email', models.EmailField(default='', max_length=100)),
('guardian_name', models.CharField(blank=True, default='', max_length=255)),
('guardian_contact_no', models.CharField(blank=True, default='', max_length=255)),
('relation_with_guardian', models.CharField(blank=True, default='', max_length=255)),
('nationality', models.CharField(blank=True, max_length=255)),
('cast', models.CharField(max_length=8)),
('religion', models.CharField(max_length=8)),
('physically_challenge', models.CharField(max_length=8)),
('department', models.CharField(max_length=255)),
('aadhar_card_no', models.CharField(max_length=255)),
('aadhar_card', models.ImageField(blank=True, upload_to=college.models.Admission.image_aadhar_card)),
('cast_certificate', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Admission.image_cast_certificate)),
('physically_certificate', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Admission.image_physically_certificate)),
('photo', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Admission.profile)),
('admission_cat', models.CharField(max_length=255)),
('conducted_by', models.CharField(max_length=255)),
('rank', models.CharField(max_length=255)),
('roll_no', models.CharField(max_length=255)),
('allotment', models.CharField(max_length=10)),
('rank_card', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Admission.rank_card)),
('admit_card', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Admission.admit_card)),
('school_name_10', models.CharField(blank=True, default='', max_length=255)),
('board_10', models.CharField(blank=True, default='', max_length=255)),
('medium_10', models.CharField(blank=True, default='', max_length=255)),
('address10', models.CharField(blank=True, default=0, max_length=255)),
('city10', models.CharField(blank=True, default=0, max_length=255)),
('state10', models.CharField(blank=True, default=0, max_length=255)),
('country10', models.CharField(blank=True, default=0, max_length=255)),
('passing_year_10', models.CharField(blank=True, default=0, max_length=255)),
('sub1', models.CharField(blank=True, default=0, max_length=255)),
('sub2', models.CharField(blank=True, default=0, max_length=255)),
('sub3', models.CharField(blank=True, default=0, max_length=255)),
('sub4', models.CharField(blank=True, default=0, max_length=255)),
('sub5', models.CharField(blank=True, default=0, max_length=255)),
('aggregate10', models.CharField(blank=True, default='', max_length=255)),
('admit10', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Admission.image_admit_card_10)),
('mark10', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Admission.image_marksheet_10)),
('certificate10', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Admission.image_marksheet_10)),
('school_name_12', models.CharField(blank=True, default=' ', max_length=255)),
('board_12', models.CharField(blank=True, default='', max_length=255)),
('medium_12', models.CharField(blank=True, default='', max_length=255)),
('address12', models.CharField(blank=True, default=0, max_length=255)),
('city12', models.CharField(blank=True, default=0, max_length=255)),
('state12', models.CharField(blank=True, default=0, max_length=255)),
('country12', models.CharField(blank=True, default=0, max_length=255)),
('passing_year_12', models.CharField(blank=True, default=0, max_length=255)),
('english', models.CharField(blank=True, default=0, max_length=255)),
('chemistry', models.CharField(blank=True, default=0, max_length=255)),
('physics', models.CharField(blank=True, default=0, max_length=255)),
('math', models.CharField(blank=True, default=0, max_length=255)),
('optional', models.CharField(blank=True, default=0, max_length=255)),
('aggregate12', models.CharField(blank=True, default='', max_length=255)),
('mark12', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Admission.image_marksheet_12)),
('admit12', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Admission.image_admit_card_12)),
('certificate12', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Admission.image_marksheet_12)),
('school_name_diploma', models.CharField(blank=True, default=' ', max_length=255)),
('board_diploma', models.CharField(blank=True, default='', max_length=255)),
('medium_diploma', models.CharField(blank=True, default='', max_length=255)),
('addressDiploma', models.CharField(blank=True, default=0, max_length=255)),
('cityDiploma', models.CharField(blank=True, default=0, max_length=255)),
('stateDiploma', models.CharField(blank=True, default=0, max_length=255)),
('countryDiploma', models.CharField(blank=True, default=0, max_length=255)),
('passing_year_Diploma', models.CharField(blank=True, default=0, max_length=255)),
('marksDiploma', models.CharField(blank=True, default='', max_length=255)),
('aggregateDiploma', models.CharField(blank=True, default='', max_length=255)),
('division', models.CharField(blank=True, default='', max_length=255)),
('markDiploma', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Admission.image_marksheet_diploma)),
('certificateDiploma', models.ImageField(blank=True, max_length=255, null=True, upload_to=college.models.Admission.image_certificateDiploma)),
('loan', models.CharField(blank=True, default='', max_length=255)),
('hostel', models.CharField(blank=True, default='', max_length=255)),
('gap', models.CharField(blank=True, default='', max_length=255)),
('reason', models.CharField(blank=True, default='', max_length=255)),
('last_login', models.DateTimeField(auto_now=True)),
('joined_date', models.DateTimeField(blank=True, null=True)),
('end_date', models.DateTimeField(blank=True, null=True)),
('student_data', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
]