Fakultas Ilmu Komputer UI

0001_initial.py 13.1 KB
Newer Older
1
# -*- coding: utf-8 -*-
Muhammad Fauzan Fikri's avatar
Muhammad Fauzan Fikri committed
2
# Generated by Django 1.11.17 on 2019-12-03 03:38
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
from __future__ import unicode_literals

import core.lib.validators
import core.models.accounts
from django.conf import settings
import django.core.validators
from django.db import migrations, models
import django.db.models.deletion


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name='Application',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('cover_letter', models.TextField(blank=True, null=True)),
                ('status', models.IntegerField(default=0)),
            ],
        ),
        migrations.CreateModel(
            name='Company',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created', models.DateTimeField(auto_now_add=True)),
                ('updated', models.DateTimeField(auto_now=True)),
                ('description', models.TextField()),
Muhammad Fauzan Fikri's avatar
Muhammad Fauzan Fikri committed
37
                ('status', models.IntegerField(default=0, validators=[django.core.validators.MaxValueValidator(2), django.core.validators.MinValueValidator(0)])),
38
39
                ('logo', models.FileField(blank=True, null=True, upload_to=core.models.accounts.get_company_logo_file_path, validators=[core.lib.validators.validate_image_file_extension])),
                ('address', models.CharField(blank=True, max_length=1000, null=True)),
Muhammad Fauzan Fikri's avatar
Muhammad Fauzan Fikri committed
40
                ('category', models.CharField(default='Belum ada kategori perusahaan', max_length=140)),
Hadlina Rahmadinni's avatar
Hadlina Rahmadinni committed
41
                ('size', models.CharField(blank=True, default=0, max_length=10, null=True)),
Muhammad Fauzan Fikri's avatar
Muhammad Fauzan Fikri committed
42
                ('website', models.CharField(default='Belum ada link website', max_length=100)),
43
                ('linkedin_url', models.URLField(blank=True, null=True)),
44
45
46
47
48
49
50
51
52
53
54
                ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'ordering': ['-updated'],
            },
        ),
        migrations.CreateModel(
            name='Feedback',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created', models.DateTimeField(auto_now_add=True)),
Muhammad Fauzan Fikri's avatar
Muhammad Fauzan Fikri committed
55
                ('title', models.CharField(blank=True, default='', max_length=100)),
56
                ('content', models.TextField()),
Hadlina Rahmadinni's avatar
Hadlina Rahmadinni committed
57
                ('companyId', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='core.Company')),
58
59
60
61
62
            ],
            options={
                'ordering': ['created'],
            },
        ),
63
64
65
66
        migrations.CreateModel(
            name='Recommendation',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
Muhammad Fauzan Fikri's avatar
Muhammad Fauzan Fikri committed
67
                ('content', models.TextField(blank=True)),
68
69
70
71
72
73
74
                ('created', models.DateTimeField(auto_now_add=True)),
                ('updated', models.DateTimeField(auto_now=True)),
            ],
            options={
                'ordering': ['-updated'],
            },
        ),
75
76
77
78
79
80
81
        migrations.CreateModel(
            name='Student',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created', models.DateTimeField(auto_now_add=True)),
                ('updated', models.DateTimeField(auto_now=True)),
                ('npm', models.IntegerField(unique=True, validators=[core.lib.validators.validate_npm])),
Muhammad Fauzan Fikri's avatar
Muhammad Fauzan Fikri committed
82
                ('resume', models.FileField(blank=True, null=True, upload_to=core.models.accounts.get_student_resume_file_path, validators=[django.core.validators.FileExtensionValidator(['pdf'])])),
83
                ('sertifikat', models.FileField(blank=True, null=True, upload_to=core.models.accounts.get_student_sertifikat_file_path, validators=[core.lib.validators.validate_document_file_extension])),
Muhammad Fauzan Fikri's avatar
Muhammad Fauzan Fikri committed
84
                ('phone_number', models.CharField(blank=True, db_index=True, max_length=100, null=True, validators=[django.core.validators.RegexValidator('^0\\d{1,11}$')])),
85
86
87
88
89
90
                ('gender', models.CharField(blank=True, max_length=30, null=True)),
                ('birth_place', models.CharField(blank=True, max_length=30, null=True)),
                ('birth_date', models.DateField(blank=True, null=True)),
                ('major', models.CharField(blank=True, max_length=30, null=True)),
                ('batch', models.CharField(blank=True, max_length=4, null=True)),
                ('show_transcript', models.BooleanField(default=False)),
Muhammad Fauzan Fikri's avatar
Muhammad Fauzan Fikri committed
91
                ('photo', models.FileField(blank=True, null=True, upload_to=core.models.accounts.get_student_photo_file_path, validators=[django.core.validators.FileExtensionValidator(['jpg', 'jpeg', 'png'])])),
92
93
94
95
96
97
98
99
100
101
102
103
104
                ('self_description', models.CharField(blank=True, db_index=True, max_length=500, null=True)),
                ('portfolio_link', models.URLField(blank=True, null=True)),
                ('linkedin_url', models.URLField(blank=True, null=True)),
                ('hackerrank_url', models.URLField(blank=True, null=True)),
                ('website_url', models.URLField(blank=True, null=True)),
                ('work_experience', models.CharField(blank=True, max_length=500, null=True)),
                ('region', models.CharField(blank=True, max_length=30, null=True)),
                ('alamat', models.CharField(blank=True, max_length=50, null=True)),
                ('skills', models.CharField(blank=True, max_length=50, null=True)),
                ('ui_ux_portofolio', models.FileField(blank=True, null=True, upload_to=core.models.accounts.get_student_ui_ux_portofolio_file_path, validators=[core.lib.validators.validate_document_file_extension])),
                ('latest_work', models.CharField(blank=True, max_length=100, null=True)),
                ('latest_work_desc', models.TextField(blank=True, null=True)),
                ('github_url', models.URLField(blank=True, null=True)),
RANI LASMA ULI's avatar
RANI LASMA ULI committed
105
                ('gitlab_url', models.URLField(blank=True, null=True)),
106
                ('intro', models.CharField(blank=True, max_length=50, null=True)),
Muhammad Fauzan Fikri's avatar
Muhammad Fauzan Fikri committed
107
                ('expected_salary', models.CharField(blank=True, max_length=10, null=True, validators=[django.core.validators.RegexValidator('^\\d{0,10}$')])),
108
                ('job_seeking_status', models.CharField(blank=True, max_length=30, null=True)),
Muhammad Fauzan Fikri's avatar
Muhammad Fauzan Fikri committed
109
110
                ('student_gpa', models.FloatField(blank=True, db_column='student_gpa', default=1.0, null=True, validators=[core.lib.validators.validate_student_gpa])),
                ('student_toefl', models.CharField(blank=True, max_length=3, null=True)),
111
112
113
114
115
116
117
                ('volunteer', models.CharField(blank=True, max_length=100, null=True)),
                ('awards', models.CharField(blank=True, max_length=100, null=True)),
                ('projects', models.CharField(blank=True, max_length=100, null=True)),
                ('certification', models.CharField(blank=True, max_length=100, null=True)),
                ('languages', models.CharField(blank=True, max_length=100, null=True)),
                ('seminar', models.CharField(blank=True, max_length=100, null=True)),
                ('interests', models.CharField(blank=True, max_length=100, null=True)),
Muhammad Fauzan Fikri's avatar
Muhammad Fauzan Fikri committed
118
                ('dependants', models.IntegerField(blank=True, db_column='dependants', default=0, null=True)),
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
            ],
            options={
                'ordering': ['-updated'],
            },
        ),
        migrations.CreateModel(
            name='Supervisor',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created', models.DateTimeField(auto_now_add=True)),
                ('updated', models.DateTimeField(auto_now=True)),
                ('nip', models.IntegerField(unique=True, validators=[django.core.validators.MinValueValidator(100000000), django.core.validators.MaxValueValidator(9999999999)])),
                ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'ordering': ['-updated'],
            },
        ),
        migrations.CreateModel(
            name='Vacancy',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('verified', models.BooleanField(default=False)),
                ('open_time', models.DateTimeField()),
                ('description', models.TextField(blank=True)),
                ('requirements', models.TextField(blank=True)),
                ('responsibilities', models.TextField(blank=True)),
                ('close_time', models.DateTimeField()),
                ('created', models.DateTimeField(auto_now_add=True)),
                ('updated', models.DateTimeField(auto_now=True)),
                ('name', models.CharField(max_length=100)),
                ('amount', models.IntegerField(null=True)),
                ('max_accepted_applicants', models.IntegerField(default=0)),
                ('benefits', models.TextField(blank=True)),
                ('working_period', models.CharField(max_length=100, null=True)),
                ('tag', models.TextField(blank=True)),
                ('salary', models.IntegerField(default=0)),
                ('recruiter_activity', models.CharField(blank=True, max_length=10, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='vacancies', to='core.Company')),
            ],
            options={
                'ordering': ['-updated'],
            },
        ),
        migrations.CreateModel(
            name='VacancyMilestone',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=100)),
                ('detail', models.TextField()),
                ('expected_start', models.DateField()),
                ('expected_finish', models.DateField()),
                ('vacancy', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='milestones', to='core.Vacancy')),
            ],
        ),
        migrations.CreateModel(
            name='ReasonRejected',
            fields=[
                ('application', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='core.Application')),
Muhammad Fauzan Fikri's avatar
Muhammad Fauzan Fikri committed
178
                ('reason', models.TextField(default='Tidak memenuhi kualifikasi perusahaan.')),
179
180
181
182
183
184
185
186
187
188
189
190
            ],
        ),
        migrations.AddField(
            model_name='student',
            name='applied_vacancies',
            field=models.ManyToManyField(blank=True, related_name='applied_vacancies', through='core.Application', to='core.Vacancy'),
        ),
        migrations.AddField(
            model_name='student',
            name='bookmarked_vacancies',
            field=models.ManyToManyField(blank=True, related_name='bookmarked_vacancies', to='core.Vacancy'),
        ),
191
192
193
194
195
        migrations.AddField(
            model_name='student',
            name='recommendations',
            field=models.ManyToManyField(blank=True, related_name='recommendations', to='core.Recommendation'),
        ),
196
197
198
199
200
        migrations.AddField(
            model_name='student',
            name='user',
            field=models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
        ),
201
202
203
        migrations.AddField(
            model_name='recommendation',
            name='recommendation_giver',
Muhammad Fauzan Fikri's avatar
Muhammad Fauzan Fikri committed
204
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='giver', to='core.Student'),
205
206
207
208
        ),
        migrations.AddField(
            model_name='recommendation',
            name='recommendation_receiver',
Muhammad Fauzan Fikri's avatar
Muhammad Fauzan Fikri committed
209
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='receiver', to='core.Student'),
210
        ),
Hadlina Rahmadinni's avatar
Hadlina Rahmadinni committed
211
212
213
214
215
        migrations.AddField(
            model_name='feedback',
            name='studentId',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='core.Student'),
        ),
216
217
218
219
220
221
222
223
224
225
        migrations.AddField(
            model_name='application',
            name='student',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Student'),
        ),
        migrations.AddField(
            model_name='application',
            name='vacancy',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Vacancy'),
        ),
226
227
228
229
        migrations.AlterUniqueTogether(
            name='recommendation',
            unique_together=set([('recommendation_giver', 'recommendation_receiver')]),
        ),
230
231
232
233
234
        migrations.AlterUniqueTogether(
            name='application',
            unique_together=set([('student', 'vacancy')]),
        ),
    ]