class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0011_update_proxy_permissions'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('password', models.CharField(max_length=128, verbose_name='password')),
('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')),
('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')),
('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')),
('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')),
('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')),
('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')),
('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')),
('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')),
('email', models.EmailField(max_length=254, unique=True)),
('user_type', models.PositiveSmallIntegerField(choices=[(0, 'admin'), (1, 'client'), (2, 'fournisseur')])),
('tel', models.CharField(blank=True, max_length=10, null=True)),
('sexe', models.CharField(choices=[('M', 'Masculin'), ('F', 'Feminin')], max_length=1)),
('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')),
('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Categorie',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('nom', models.CharField(max_length=50)),
],
),
migrations.CreateModel(
name='Client',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Facture',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('date', models.DateField(default=django.utils.timezone.now)),
('client', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='factures', to='bill.Client')),
],
),
migrations.CreateModel(
name='Fournisseur',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Produit',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('designation', models.CharField(max_length=50)),
('prix', models.FloatField(default=0)),
('categorie', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='produits', to='bill.Categorie')),
('fournisseur', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='produits', to='bill.Fournisseur')),
],
),
migrations.CreateModel(
name='LigneFacture',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('qte', models.IntegerField(default=1)),
('facture', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='lignes', to='bill.Facture')),
('produit', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='lignes', to='bill.Produit')),
],
),
migrations.CreateModel(
name='Admin',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.AddConstraint(
model_name='lignefacture',
constraint=models.UniqueConstraint(fields=('produit', 'facture'), name='produit-facture'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0009_alter_user_last_name_max_length'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('username',
models.CharField(
error_messages={
'unique': 'A user with that username already exists.'
},
help_text=
'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
max_length=150,
unique=True,
validators=[
django.contrib.auth.validators.
UnicodeUsernameValidator()
],
verbose_name='username')),
('first_name',
models.CharField(blank=True,
max_length=30,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=150,
verbose_name='last name')),
('email',
models.EmailField(blank=True,
max_length=254,
verbose_name='email address')),
('is_staff',
models.BooleanField(
default=False,
help_text=
'Designates whether the user can log into this admin site.',
verbose_name='staff status')),
('is_active',
models.BooleanField(
default=True,
help_text=
'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
verbose_name='active')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('type',
models.CharField(choices=[('student', 'Student'),
('tutor', 'Tutor')],
max_length=20)),
('groups',
models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups')),
('user_permissions',
models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Location',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('city', models.CharField(max_length=255)),
('street_address', models.CharField(max_length=255)),
('zip_code', models.CharField(max_length=255)),
('latitude', models.FloatField()),
('longitude', models.FloatField()),
],
),
migrations.CreateModel(
name='Student',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date_of_birth', models.DateField(blank=True, null=True)),
('gender', models.CharField(blank=True, max_length=50)),
('locations',
models.ManyToManyField(related_name='_student_locations_+',
to='accounts.Location')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Tutor',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date_of_birth', models.DateField(blank=True, null=True)),
('gender', models.CharField(blank=True, max_length=50)),
('hourly_rate',
models.DecimalField(blank=True,
decimal_places=2,
max_digits=10,
null=True)),
('available', models.BooleanField(default=True)),
('locations',
models.ManyToManyField(related_name='_tutor_locations_+',
to='accounts.Location')),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name='tutor',
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
migrations.AddField(
model_name='student',
name='tutors',
field=models.ManyToManyField(related_name='students',
to='accounts.Tutor'),
),
migrations.AddField(
model_name='student',
name='user',
field=models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name='student',
to=settings.AUTH_USER_MODEL),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0009_alter_user_last_name_max_length'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('username',
models.CharField(
error_messages={
'unique': 'A user with that username already exists.'
},
help_text=
'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
max_length=150,
unique=True,
validators=[
django.contrib.auth.validators.
UnicodeUsernameValidator()
],
verbose_name='username')),
('first_name',
models.CharField(blank=True,
max_length=30,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=150,
verbose_name='last name')),
('is_staff',
models.BooleanField(
default=False,
help_text=
'Designates whether the user can log into this admin site.',
verbose_name='staff status')),
('is_active',
models.BooleanField(
default=True,
help_text=
'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
verbose_name='active')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('name', models.CharField(max_length=32, verbose_name='Name')),
('surname',
models.CharField(max_length=32, verbose_name='Surname')),
('email',
models.EmailField(max_length=254, verbose_name='Email')),
('tel',
models.CharField(max_length=15,
null=True,
verbose_name='Telephone number')),
('address',
models.CharField(max_length=120, verbose_name='Address')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Booking',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('book_date', models.DateField(verbose_name='Date')),
('status',
models.CharField(max_length=20, verbose_name='Status')),
],
),
migrations.CreateModel(
name='Car',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('vin', models.CharField(max_length=36)),
('car_number', models.CharField(max_length=36)),
],
),
migrations.CreateModel(
name='CarFuel',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=32)),
],
),
migrations.CreateModel(
name='CarList',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('model_specifiction', models.TextField()),
('power', models.FloatField()),
('mileage', models.FloatField()),
('year', models.IntegerField()),
('fuel',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='general.CarFuel')),
],
),
migrations.CreateModel(
name='CarMake',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=32)),
],
),
migrations.CreateModel(
name='CarModel',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=32)),
],
),
migrations.CreateModel(
name='CarTransmission',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=32)),
],
),
migrations.CreateModel(
name='Chat',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('message', models.TextField(verbose_name='Message')),
('finished',
models.BooleanField(default=False, verbose_name='Finished')),
],
),
migrations.CreateModel(
name='Request',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date', models.DateField()),
('answered', models.BooleanField(default=False)),
('answered_date', models.DateField(blank=True)),
('car',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='general.CarList')),
],
),
migrations.CreateModel(
name='ServiceHistory',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('end_date', models.DateField()),
('price', models.FloatField()),
('details', models.TextField()),
('finished', models.BooleanField(default=False)),
('review', models.IntegerField()),
('request',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='general.Request')),
],
),
migrations.CreateModel(
name='ServiceList',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=32)),
('price', models.FloatField()),
('active', models.BooleanField(default=False)),
('car_make',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='general.CarMake')),
],
),
migrations.CreateModel(
name='BusinessUser',
fields=[
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
primary_key=True,
serialize=False,
to=settings.AUTH_USER_MODEL,
verbose_name='User')),
('company_name',
models.CharField(max_length=32, verbose_name='Company Name')),
('reg', models.IntegerField(verbose_name='Reg')),
('vat', models.IntegerField(verbose_name='Vat')),
],
),
migrations.CreateModel(
name='Merchant',
fields=[
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
primary_key=True,
serialize=False,
to=settings.AUTH_USER_MODEL)),
('company_name',
models.CharField(max_length=120,
verbose_name='Company Name')),
('autoservice_name',
models.CharField(max_length=120,
verbose_name='Auto Service Name')),
('reg', models.IntegerField(verbose_name='Reg')),
('vat', models.IntegerField(verbose_name='Vat')),
('iban', models.CharField(max_length=120,
verbose_name='Iban')),
('description', models.TextField(verbose_name='Description')),
('photo_url',
models.ImageField(blank=True,
upload_to='',
verbose_name='Photo')),
('approved',
models.BooleanField(default=False, verbose_name='Approve')),
],
),
migrations.AddField(
model_name='request',
name='client',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='request',
name='service',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='general.ServiceList'),
),
migrations.AddField(
model_name='chat',
name='receiver',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='receivers',
to=settings.AUTH_USER_MODEL,
verbose_name='Receiver'),
),
migrations.AddField(
model_name='chat',
name='sender',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='senders',
to=settings.AUTH_USER_MODEL,
verbose_name='Sender'),
),
migrations.AddField(
model_name='carlist',
name='make',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='general.CarMake'),
),
migrations.AddField(
model_name='carlist',
name='model',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='general.CarModel'),
),
migrations.AddField(
model_name='carlist',
name='transmission',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='general.CarTransmission'),
),
migrations.AddField(
model_name='car',
name='car_type',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='general.CarList',
verbose_name='Car Type'),
),
migrations.AddField(
model_name='car',
name='owner',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='user',
name='groups',
field=models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups'),
),
migrations.AddField(
model_name='user',
name='user_permissions',
field=models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions'),
),
migrations.AddField(
model_name='servicelist',
name='merchant',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='general.Merchant'),
),
migrations.AddField(
model_name='booking',
name='merchant',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='general.Merchant',
verbose_name='Merchant'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0011_update_proxy_permissions'),
]
operations = [
migrations.CreateModel(
name='CustomUser',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('username',
models.CharField(
error_messages={
'unique': 'A user with that username already exists.'
},
help_text=
'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
max_length=150,
unique=True,
validators=[
django.contrib.auth.validators.
UnicodeUsernameValidator()
],
verbose_name='username')),
('first_name',
models.CharField(blank=True,
max_length=30,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=150,
verbose_name='last name')),
('email',
models.EmailField(blank=True,
max_length=254,
verbose_name='email address')),
('is_staff',
models.BooleanField(
default=False,
help_text=
'Designates whether the user can log into this admin site.',
verbose_name='staff status')),
('is_active',
models.BooleanField(
default=True,
help_text=
'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
verbose_name='active')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('user_type',
models.CharField(choices=[(1, 'HOD'), (2, 'Staff'),
(3, 'Student')],
default=1,
max_length=10)),
('groups',
models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups')),
('user_permissions',
models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Attendance',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('attendance_date', models.DateField()),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='Category',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=200)),
],
),
migrations.CreateModel(
name='Courses',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('course_name', models.CharField(max_length=255)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='FacultyMember',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(blank=True, max_length=50)),
('department', models.CharField(blank=True, max_length=50)),
('designation', models.CharField(blank=True, max_length=50)),
('qualification', models.CharField(blank=True,
max_length=500)),
('experience', models.CharField(blank=True, max_length=500)),
('awards', models.CharField(blank=True, max_length=500)),
],
),
migrations.CreateModel(
name='HeroCarousal',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('alt_text', models.CharField(max_length=200, null=True)),
('carousal_image',
models.ImageField(null=True, upload_to='banner/')),
('url_link', models.URLField(null=True)),
('status',
models.CharField(choices=[('Featured', 'Featured'),
('Not Featured', 'Not Featured')],
default='Not Featured',
max_length=15)),
('caption', models.CharField(max_length=100, null=True)),
],
),
migrations.CreateModel(
name='Notice',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=200, null=True)),
('description', models.TextField(max_length=1000, null=True)),
('created_on', models.DateTimeField(null=True)),
('is_featured',
models.CharField(choices=[('True', 'Yes'), ('False', 'No')],
default='False',
max_length=10,
null=True)),
],
),
migrations.CreateModel(
name='SessionYearModel',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('session_start_year', models.DateField()),
('session_end_year', models.DateField()),
],
),
migrations.CreateModel(
name='Subjects',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('subject_name', models.CharField(max_length=255)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('course_id',
models.ForeignKey(default=1,
on_delete=django.db.models.deletion.CASCADE,
to='student_management_app.Courses')),
('staff_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Students',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('gender', models.CharField(max_length=50)),
('profile_pic',
models.FileField(upload_to='profile/%Y/%m/%d')),
('address', models.TextField()),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('myconfirm_password',
models.CharField(max_length=200, null=True)),
('admin',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
('course_id',
models.ForeignKey(
default=1,
on_delete=django.db.models.deletion.DO_NOTHING,
to='student_management_app.Courses')),
('session_year_id',
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='student_management_app.SessionYearModel')),
],
),
migrations.CreateModel(
name='StudentResult',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('subject_exam_marks', models.FloatField(default=0)),
('subject_assignment_marks', models.FloatField(default=0)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('student_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='student_management_app.Students')),
('subject_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='student_management_app.Subjects')),
],
),
migrations.CreateModel(
name='Staffs',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('address', models.TextField()),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('admin',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='NotificationStudent',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('message', models.TextField()),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('student_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='student_management_app.Students')),
],
),
migrations.CreateModel(
name='NotificationStaffs',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('message', models.TextField()),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('stafff_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='student_management_app.Staffs')),
],
),
migrations.CreateModel(
name='LeaveReportStudent',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('leave_date', models.CharField(max_length=255)),
('leave_message', models.TextField()),
('leave_status', models.IntegerField(default=0)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('student_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='student_management_app.Students')),
],
),
migrations.CreateModel(
name='LeaveReportStaff',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('leave_date', models.CharField(max_length=255)),
('leave_message', models.TextField()),
('leave_status', models.IntegerField(default=0)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('staff_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='student_management_app.Staffs')),
],
),
migrations.CreateModel(
name='FeedBackStudent',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('feedback', models.TextField()),
('feedback_reply', models.TextField()),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('student_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='student_management_app.Students')),
],
),
migrations.CreateModel(
name='FeedBackStaffs',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('feedback', models.TextField()),
('feedback_reply', models.TextField()),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('staff_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='student_management_app.Staffs')),
],
),
migrations.CreateModel(
name='Events',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=200)),
('featured_image',
models.ImageField(null=True, upload_to='events/%Y/%m/%d')),
('content', models.TextField(max_length=1000, null=True)),
('created_at', models.DateTimeField(auto_now_add=True)),
('status',
models.CharField(choices=[('Draft', 'Draft'),
('Publish', 'Publish')],
default='Draft',
max_length=10)),
('category',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='student_management_app.Category')),
],
),
migrations.CreateModel(
name='AttendanceReport',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('status', models.BooleanField(default=False)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('attendance_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='student_management_app.Attendance')),
('student_id',
models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='student_management_app.Students')),
],
),
migrations.AddField(
model_name='attendance',
name='session_year_id',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='student_management_app.SessionYearModel'),
),
migrations.AddField(
model_name='attendance',
name='subject_id',
field=models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='student_management_app.Subjects'),
),
migrations.CreateModel(
name='AdminHOD',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('admin',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0012_alter_user_first_name_max_length'),
]
operations = [
migrations.CreateModel(
name='Collectdevice',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('cd_active', models.IntegerField(default=0)),
('cd_name', models.CharField(max_length=32, null=True)),
('cd_series_number', models.IntegerField()),
('cd_tunnel', models.CharField(max_length=32)),
('cd_status', models.CharField(max_length=20)),
('cd_data_status', models.CharField(max_length=20)),
('cd_last_contract_time', models.DateTimeField()),
('cd_register_time', models.DateTimeField()),
],
),
migrations.CreateModel(
name='Company',
fields=[
('id', models.BigAutoField(primary_key=True, serialize=False)),
('company_icon', models.ImageField(upload_to='cicons/%Y%m%d')),
('company_name', models.CharField(max_length=32, unique=True)),
('company_address', models.CharField(max_length=64,
unique=True)),
('active', models.IntegerField(default=0)),
('context', models.CharField(max_length=128, null=True)),
],
),
migrations.CreateModel(
name='Device',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('d_u_id', models.IntegerField(default=None, null=True)),
('d_active', models.IntegerField(default=0)),
('d_name', models.CharField(max_length=32)),
('d_series_number', models.IntegerField()),
('d_tunnel', models.CharField(max_length=32)),
('d_status', models.CharField(max_length=20)),
('d_data_status', models.CharField(max_length=20)),
('d_last_contract_time', models.DateTimeField()),
('d_register_time', models.DateTimeField()),
('d_c_id',
models.ForeignKey(db_column='d_c_id',
default=None,
on_delete=django.db.models.deletion.CASCADE,
to='One.collectdevice')),
],
),
migrations.CreateModel(
name='Knowledge',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('k_user_id', models.IntegerField()),
('k_title', models.CharField(max_length=32)),
('k_type', models.CharField(max_length=10)),
('k_date', models.DateTimeField()),
('k_content', models.CharField(max_length=20000)),
],
),
migrations.CreateModel(
name='KnowledgeMediaStore',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('m_k_id',
models.CharField(db_column='m_k_id', max_length=10,
null=True)),
('m_k_filepath', models.ImageField(upload_to='kmedia/%Y%m%d')),
('m_type', models.CharField(max_length=10)),
('m_date', models.DateTimeField()),
],
),
migrations.CreateModel(
name='Project',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('p_active', models.IntegerField(default=0, null=True)),
('p_name', models.CharField(max_length=32)),
('p_description', models.CharField(max_length=300, null=True)),
('p_type', models.CharField(max_length=20, null=True)),
('p_customer_type', models.CharField(max_length=20,
null=True)),
('p_party_a', models.CharField(max_length=30)),
('p_purchase_time', models.DateTimeField(null=True)),
('p_setup_time', models.DateTimeField(null=True)),
('p_built_time', models.DateTimeField(null=True)),
('p_contact_name', models.CharField(max_length=20, null=True)),
('p_contact_number', models.CharField(max_length=11,
null=True)),
('p_province', models.CharField(max_length=10, null=True)),
('p_city', models.CharField(max_length=10, null=True)),
('p_address', models.CharField(max_length=100, null=True)),
('p_longitude',
models.DecimalField(decimal_places=20,
max_digits=30,
null=True)),
('p_latitude',
models.DecimalField(decimal_places=20,
max_digits=30,
null=True)),
('p_c_id',
models.ForeignKey(db_column='p_c_id',
default=None,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='One.company')),
],
),
migrations.CreateModel(
name='Test',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('t', models.ImageField(upload_to='tmedia/%Y%m%d')),
],
),
migrations.CreateModel(
name='Worksheet',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('w_name', models.CharField(max_length=20)),
('w_type', models.CharField(max_length=20)),
('w_content', models.CharField(max_length=2000)),
('w_status', models.CharField(max_length=10)),
('w_time', models.DateTimeField()),
],
),
migrations.CreateModel(
name='LoginUser',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('username',
models.CharField(
error_messages={
'unique': 'A user with that username already exists.'
},
help_text=
'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
max_length=150,
unique=True,
validators=[
django.contrib.auth.validators.
UnicodeUsernameValidator()
],
verbose_name='username')),
('first_name',
models.CharField(blank=True,
max_length=150,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=150,
verbose_name='last name')),
('email',
models.EmailField(blank=True,
max_length=254,
verbose_name='email address')),
('is_staff',
models.BooleanField(
default=False,
help_text=
'Designates whether the user can log into this admin site.',
verbose_name='staff status')),
('is_active',
models.BooleanField(
default=True,
help_text=
'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
verbose_name='active')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('phone_numbers',
models.CharField(max_length=11,
unique=True,
verbose_name='手机号')),
('u_company_id', models.IntegerField(null=True)),
('u_icon',
models.ImageField(null=True, upload_to='uicons/%Y%m%d')),
('u_type', models.CharField(max_length=10, null=True)),
('tag', models.CharField(max_length=20, null=True)),
('groups',
models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups')),
('project', models.ManyToManyField(to='One.Project')),
('user_permissions',
models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Worksheetmedia',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('wm_w_image', models.ImageField(upload_to='wmedia/%Y%m%d')),
('wm_date', models.DateTimeField()),
('wm_w_id',
models.ForeignKey(db_column='wm_w_id',
default=None,
on_delete=django.db.models.deletion.CASCADE,
to='One.worksheet')),
],
),
migrations.AddField(
model_name='worksheet',
name='w_e_id',
field=models.ForeignKey(
db_column='w_e_id',
default=None,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL),
),
migrations.CreateModel(
name='Solution',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('s_title', models.CharField(max_length=32)),
('s_type', models.CharField(max_length=20)),
('s_date', models.DateTimeField()),
('s_content', models.CharField(max_length=20000)),
('s_k_id',
models.ForeignKey(db_column='s_k_id',
on_delete=django.db.models.deletion.CASCADE,
to='One.knowledge')),
('s_user_id',
models.ForeignKey(db_column='s_user_id',
default=None,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.AddField(
model_name='project',
name='p_u_id',
field=models.ForeignKey(
db_column='p_u_id',
default=None,
on_delete=django.db.models.deletion.CASCADE,
related_name='apply',
to=settings.AUTH_USER_MODEL,
verbose_name='申请人'),
),
migrations.CreateModel(
name='Message',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('message',
models.TextField(blank=True, null=True, verbose_name='内容')),
('unread',
models.BooleanField(db_index=True,
default=True,
verbose_name='是否未读')),
('created_at',
models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('recipient',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='receive_messages',
to=settings.AUTH_USER_MODEL,
verbose_name='接收者')),
('sender',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='sent_message',
to=settings.AUTH_USER_MODEL,
verbose_name='发送者')),
],
),
migrations.CreateModel(
name='Devicemaintainrecord',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('dmo_name', models.CharField(max_length=20, null=True)),
('dm_d_detail', models.CharField(max_length=2000)),
('dm_time', models.DateTimeField()),
('dm_d_id',
models.ForeignKey(db_column='dm_d_id',
default=None,
on_delete=django.db.models.deletion.CASCADE,
to='One.device')),
('dm_o_id',
models.ForeignKey(db_column='dm_o_id',
default=None,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Devicedata',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('ddd_name', models.CharField(max_length=32)),
('ddd_data', models.FloatField()),
('ddd_d_id',
models.ForeignKey(db_column='ddd_d_id',
default=None,
on_delete=django.db.models.deletion.CASCADE,
to='One.device')),
],
),
migrations.AddField(
model_name='device',
name='d_m_id',
field=models.ForeignKey(
db_column='d_mm_id',
default=None,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='device',
name='d_p_id',
field=models.ForeignKey(
db_column='d_p_id',
default=None,
on_delete=django.db.models.deletion.CASCADE,
to='One.project'),
),
migrations.CreateModel(
name='Data',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('d_name', models.CharField(max_length=20)),
('d_data', models.FloatField()),
('d_d_id',
models.ForeignKey(db_column='d_d_id',
default=None,
on_delete=django.db.models.deletion.CASCADE,
to='One.device')),
],
),
migrations.CreateModel(
name='Complainrecord',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('cr_detail', models.CharField(max_length=200)),
('cr_date', models.DateTimeField()),
('cr_type', models.CharField(max_length=10)),
('cr_e_id',
models.ForeignKey(
blank=True,
db_column='cr_e_id',
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='receiver',
to=settings.AUTH_USER_MODEL)),
('cr_u_id',
models.ForeignKey(
blank=True,
db_column='cr_u_id',
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='sender',
to=settings.AUTH_USER_MODEL)),
],
),
migrations.AddField(
model_name='company',
name='c_u_id',
field=models.OneToOneField(
db_column='c_u_id',
default=None,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL),
),
migrations.CreateModel(
name='Comment',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('cm_detail', models.CharField(max_length=200)),
('cm_date', models.DateTimeField()),
('cm_type', models.CharField(max_length=10)),
('cm_e_id',
models.ForeignKey(
blank=True,
db_column='cm_e_id',
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='service',
to=settings.AUTH_USER_MODEL)),
('cm_u_id',
models.ForeignKey(
blank=True,
db_column='cm_u_id',
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='customer',
to=settings.AUTH_USER_MODEL)),
],
),
migrations.AddField(
model_name='collectdevice',
name='cd_m_id',
field=models.ForeignKey(
db_column='cd_m_id',
default=None,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='collectdevice',
name='cd_p_id',
field=models.ForeignKey(
db_column='cd_p_id',
default=None,
on_delete=django.db.models.deletion.CASCADE,
to='One.project'),
),
migrations.CreateModel(
name='Cdevicedata',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('cdd_name', models.CharField(max_length=32)),
('cdd_data', models.CharField(max_length=32)),
('cdd_c_id',
models.ForeignKey(db_column='cd_p_id',
default=None,
on_delete=django.db.models.deletion.CASCADE,
to='One.collectdevice')),
],
),
migrations.CreateModel(
name='Alert',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('a_highest_line', models.FloatField(null=True)),
('a_highest_level', models.CharField(max_length=10,
null=True)),
('a_highest_tip', models.CharField(max_length=20, null=True)),
('a_high_line', models.FloatField(null=True)),
('a_high_level', models.CharField(max_length=10, null=True)),
('a_high_tip', models.CharField(max_length=20, null=True)),
('a_low_line', models.FloatField(null=True)),
('a_low_level', models.CharField(max_length=10, null=True)),
('a_low_tip', models.CharField(max_length=20, null=True)),
('a_lowest_line', models.FloatField(null=True)),
('a_lowest_level', models.CharField(max_length=10, null=True)),
('a_lowest_tip', models.CharField(max_length=20, null=True)),
('a_data_id',
models.ForeignKey(db_column='a_data_id',
default=None,
on_delete=django.db.models.deletion.CASCADE,
to='One.data')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0009_alter_user_last_name_max_length'),
]
operations = [
migrations.CreateModel(
name='Usuario',
fields=[
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('first_name',
models.CharField(blank=True,
max_length=30,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=150,
verbose_name='last name')),
('email',
models.EmailField(blank=True,
max_length=254,
verbose_name='email address')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('username',
models.CharField(max_length=150,
primary_key=True,
serialize=False,
verbose_name='username')),
('is_active',
models.BooleanField(default=True, verbose_name='is active')),
('is_staff',
models.BooleanField(default=True,
verbose_name='staff status')),
('is_superuser',
models.BooleanField(default=False,
verbose_name='superuser status')),
('groups',
models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups')),
('user_permissions',
models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions')),
],
options={
'verbose_name': 'User',
'verbose_name_plural': 'Users',
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Avaliador',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
],
),
migrations.CreateModel(
name='Coordenador',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
],
),
migrations.CreateModel(
name='CriterioAvaliacao',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('descricao',
models.CharField(max_length=200, verbose_name='Nome')),
('nota_minima', models.FloatField(verbose_name='Nota Mínima')),
('nota_maxima', models.FloatField(verbose_name='Nota Maxima')),
('ajuda_avaliador',
models.CharField(max_length=500, verbose_name='Nome')),
('incremento_nota',
models.PositiveIntegerField(
verbose_name='Incremento da Nota')),
],
),
migrations.CreateModel(
name='Cronograma',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('etapa', models.CharField(max_length=200,
verbose_name='Etapa')),
('marco', models.CharField(max_length=200,
verbose_name='Marco')),
('inicio', models.DateField(verbose_name='Data Inicial')),
('fim', models.DateField(verbose_name='Data Final')),
],
),
migrations.CreateModel(
name='Documento',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('nome', models.CharField(max_length=200,
verbose_name='Nome')),
],
),
migrations.CreateModel(
name='Edital',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('tipo',
models.CharField(help_text='Discente/Bolsista',
max_length=100,
verbose_name='Tipo')),
('programa',
models.CharField(max_length=100, verbose_name='Programa')),
('numero',
models.CharField(blank=True,
max_length=50,
null=True,
verbose_name='Número')),
('siglaUO',
models.CharField(help_text='Ex.: DG-EAD/IFRN',
max_length=100,
verbose_name='Unidade organizacional')),
('linkEdital',
models.URLField(help_text='Informe o LINK onde está o edital',
max_length=300,
verbose_name='URL')),
('grupo',
models.CharField(max_length=200,
null=True,
verbose_name='Grupo')),
('descricao',
models.CharField(max_length=300, verbose_name='Descrição')),
('ano',
models.PositiveIntegerField(help_text='Digite o ano',
verbose_name='Ano')),
('periodo',
models.PositiveIntegerField(choices=[(1, '1º Período'),
(2, '2º Período')],
verbose_name='Período letivo')),
('data_publicacao',
models.DateTimeField(verbose_name='Data de publicação')),
],
),
migrations.CreateModel(
name='EstrategiaClassificacao',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('descriaco',
models.CharField(help_text='Exemplo: Inscrição sem anexos',
max_length=200,
verbose_name='Descrição')),
],
),
migrations.CreateModel(
name='Fase',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('nome', models.CharField(max_length=200,
verbose_name='Nome')),
('tipo_classificacao',
models.PositiveIntegerField(
choices=[(1, 'Eliminatória'),
(2, 'Classificatória')],
verbose_name='Tipo de classificação')),
('aproveitamento_min',
models.PositiveIntegerField(
help_text='Nota necessária para passar',
verbose_name='Aproveitamento mínimo')),
('fator_habilitacao',
models.PositiveIntegerField(
help_text=
'Quantidade máxima de cadidatos que serão selecionados',
verbose_name='Fator habilitação')),
('edital',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='cadastro_edital.Edital')),
],
),
migrations.CreateModel(
name='MotivoNotaZero',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('descriaco',
models.CharField(help_text='Exemplo: Inscrição sem anexos',
max_length=200,
verbose_name='Descrição')),
('fase',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='cadastro_edital.Fase')),
],
),
migrations.CreateModel(
name='Pagamento',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('existe_taxa', models.BooleanField(default=False)),
('valor_taxa',
models.DecimalField(decimal_places=2, max_digits=7)),
('vencimento_boleto', models.DateField()),
('edital',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='cadastro_edital.Edital')),
],
),
migrations.CreateModel(
name='Vaga',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('curso', models.CharField(max_length=200,
verbose_name='Curso')),
('vaga', models.CharField(max_length=100,
verbose_name='Vaga')),
('numero_vagas',
models.PositiveIntegerField(verbose_name='Número de vagas')),
('edital',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='cadastro_edital.Edital')),
],
),
migrations.AddField(
model_name='estrategiaclassificacao',
name='fase',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='cadastro_edital.Fase'),
),
migrations.AddField(
model_name='documento',
name='fase',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='cadastro_edital.Fase'),
),
migrations.AddField(
model_name='cronograma',
name='fase',
field=models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='cadastro_edital.Fase'),
),
migrations.AddField(
model_name='criterioavaliacao',
name='fase',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='cadastro_edital.Fase'),
),
migrations.AddField(
model_name='coordenador',
name='edital',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='cadastro_edital.Edital'),
),
migrations.AddField(
model_name='coordenador',
name='usuario',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='avaliador',
name='fase',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='cadastro_edital.Fase'),
),
migrations.AddField(
model_name='avaliador',
name='usuario',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0012_alter_user_first_name_max_length'),
]
operations = [
migrations.CreateModel(
name='Employment_type',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(db_index=True,
max_length=30,
verbose_name='Name')),
],
options={
'verbose_name': 'Employment',
'verbose_name_plural': 'Employments',
'ordering': ['name'],
},
),
migrations.CreateModel(
name='Skill',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(db_index=True,
max_length=30,
verbose_name='Name')),
],
options={
'verbose_name': 'Skill',
'verbose_name_plural': 'Skills',
'ordering': ['name'],
},
),
migrations.CreateModel(
name='Subcategory',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(db_index=True,
max_length=30,
verbose_name='Name')),
('img',
models.FileField(blank=True,
null=True,
upload_to='img',
verbose_name='Subcategory_img')),
],
options={
'verbose_name': 'Subcategory',
'verbose_name_plural': 'Subcategories',
'ordering': ['name'],
},
),
migrations.CreateModel(
name='Сategory',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(db_index=True,
max_length=30,
verbose_name='Name')),
('img',
models.FileField(blank=True,
null=True,
upload_to='img',
verbose_name='Сategory_img')),
],
options={
'verbose_name': 'Сategory',
'verbose_name_plural': 'Categories',
'ordering': ['name'],
},
),
migrations.CreateModel(
name='Vacancie',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=50,
verbose_name='Title')),
('description',
models.TextField(blank=True,
null=True,
verbose_name='Description')),
('img',
models.ImageField(blank=True,
null=True,
upload_to='img',
verbose_name='Vacancy_img')),
('email', models.EmailField(max_length=50,
verbose_name='Email')),
('location',
models.TextField(blank=True,
null=True,
verbose_name='Location')),
('salary', models.FloatField(blank=True, null=True)),
('company',
models.CharField(blank=True,
max_length=70,
null=True,
verbose_name='Company')),
('url',
models.CharField(blank=True,
max_length=50,
null=True,
verbose_name='Url')),
('published',
models.DateTimeField(auto_now_add=True,
db_index=True,
verbose_name='Published')),
('requirements',
models.TextField(blank=True,
null=True,
verbose_name='requirements')),
('tasks',
models.TextField(blank=True, null=True,
verbose_name='Tasks')),
('terms',
models.TextField(blank=True, null=True,
verbose_name='Terms')),
('telegram',
models.CharField(blank=True,
max_length=50,
null=True,
verbose_name='Telegram')),
('category',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.PROTECT,
to='main.сategory',
verbose_name='Сategory')),
('employment',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.PROTECT,
to='main.employment_type',
verbose_name='Employmet type')),
('skill',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.PROTECT,
to='main.skill',
verbose_name='Skill')),
('subcategores',
models.ManyToManyField(to='main.Subcategory',
verbose_name='Subcategory')),
],
options={
'verbose_name': 'Vacancy',
'verbose_name_plural': 'Vacancies',
'ordering': ['-published'],
},
),
migrations.CreateModel(
name='AdvUser',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('username',
models.CharField(
error_messages={
'unique': 'A user with that username already exists.'
},
help_text=
'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
max_length=150,
unique=True,
validators=[
django.contrib.auth.validators.
UnicodeUsernameValidator()
],
verbose_name='username')),
('first_name',
models.CharField(blank=True,
max_length=150,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=150,
verbose_name='last name')),
('email',
models.EmailField(blank=True,
max_length=254,
verbose_name='email address')),
('is_staff',
models.BooleanField(
default=False,
help_text=
'Designates whether the user can log into this admin site.',
verbose_name='staff status')),
('is_active',
models.BooleanField(
default=True,
help_text=
'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
verbose_name='active')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('is_activated',
models.BooleanField(db_index=True,
default=True,
verbose_name='Is active?')),
('send_messages',
models.BooleanField(default=True,
verbose_name='Send alerts?')),
('groups',
models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups')),
('user_permissions',
models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0009_alter_user_last_name_max_length'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('username',
models.CharField(
error_messages={
'unique': 'A user with that username already exists.'
},
help_text=
'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
max_length=150,
unique=True,
validators=[
django.contrib.auth.validators.
UnicodeUsernameValidator()
],
verbose_name='username')),
('first_name',
models.CharField(blank=True,
max_length=30,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=150,
verbose_name='last name')),
('email',
models.EmailField(blank=True,
max_length=254,
verbose_name='email address')),
('is_staff',
models.BooleanField(
default=False,
help_text=
'Designates whether the user can log into this admin site.',
verbose_name='staff status')),
('is_active',
models.BooleanField(
default=True,
help_text=
'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
verbose_name='active')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('is_student', models.BooleanField(default=False)),
('is_teacher', models.BooleanField(default=False)),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Class',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=50)),
('location', models.CharField(max_length=50)),
('time_day',
models.CharField(choices=[('MON', 'Monday'),
('TUE', 'Tuesday'),
('WED', 'Wednesday'),
('THU', 'Thursday'),
('FRI', 'Friday'),
('SAT', 'Saturday'),
('SUN', 'Sunday')],
default='WED',
max_length=3)),
('time_start',
models.TimeField(default=datetime.time(15, 30))),
('time_end', models.TimeField(default=datetime.time(16, 30))),
],
),
migrations.CreateModel(
name='MemberLevel',
fields=[
('level_status',
models.CharField(choices=[('B', 'Bronze'), ('S', 'Silver'),
('G', 'Gold'), ('P', 'Platinum'),
('D', 'Diamond')],
default='B',
max_length=1,
primary_key=True,
serialize=False)),
('price', models.FloatField()),
],
),
migrations.CreateModel(
name='Member',
fields=[
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
primary_key=True,
serialize=False,
to=settings.AUTH_USER_MODEL)),
('funds', models.FloatField(default=0)),
('expired_date',
models.DateField(default=datetime.date(2019, 5, 29))),
('name', models.CharField(max_length=100)),
('email', models.EmailField(max_length=254)),
('phone_number',
models.CharField(
blank=True,
max_length=17,
validators=[
django.core.validators.RegexValidator(
message=
"Phone number must be entered in the format: '+999999999'. Up to 15 digits allowed.",
regex='^\\+?1?\\d{9,15}$')
])),
('classes', models.ManyToManyField(to='login.Class')),
('level',
models.ForeignKey(default='B',
on_delete=django.db.models.deletion.CASCADE,
to='login.MemberLevel')),
],
),
migrations.CreateModel(
name='Staff',
fields=[
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
primary_key=True,
serialize=False,
to=settings.AUTH_USER_MODEL)),
('name', models.CharField(max_length=100)),
],
),
migrations.AddField(
model_name='user',
name='groups',
field=models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups'),
),
migrations.AddField(
model_name='user',
name='user_permissions',
field=models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions'),
),
migrations.AddField(
model_name='class',
name='staff',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE, to='login.Staff'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0012_alter_user_first_name_max_length'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('password', models.CharField(max_length=128, verbose_name='password')),
('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')),
('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')),
('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')),
('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')),
('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')),
('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')),
('is_customer', models.BooleanField(default=False)),
('is_sp', models.BooleanField(default=False)),
('first_name', models.CharField(blank=True, max_length=50, null=True)),
('last_name', models.CharField(blank=True, max_length=100, null=True)),
('email', models.EmailField(max_length=254)),
('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')),
('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Order',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('date_of_order', models.DateField(auto_now_add=True, null=True)),
('no_of_orders', models.CharField(max_length=100, null=True)),
('last_date', models.DateField(null=True)),
],
),
migrations.CreateModel(
name='Customer',
fields=[
('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='account.user')),
('phone_number', models.CharField(max_length=10)),
('alt_phone_number', models.CharField(blank=True, max_length=10, null=True)),
('date_create', models.DateTimeField(default=django.utils.timezone.now)),
],
),
migrations.CreateModel(
name='PlaceAnOrder',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('status', models.CharField(choices=[('Pending', 'Pending'), ('out for Delivery', 'out for Delivery'), ('Delivered', 'Delivered'), ('Cancel', 'Cancel')], default='Pending', max_length=200, null=True)),
('new_date', models.DateField(auto_now_add=True, null=True)),
('time', models.TimeField(null=True)),
('order', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='account.order')),
],
),
migrations.CreateModel(
name='CustomerMenuItem',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('item_name', models.CharField(max_length=500)),
('price', models.CharField(max_length=20)),
('quantity', models.PositiveIntegerField()),
('order', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='account.placeanorder')),
],
),
migrations.CreateModel(
name='Address',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('state', models.CharField(max_length=150)),
('city', models.CharField(max_length=100)),
('pin_no', models.CharField(max_length=20)),
('Area_name', models.CharField(max_length=200)),
('land_mark', models.CharField(max_length=200)),
('building_name', models.CharField(max_length=200)),
('flate_number', models.CharField(max_length=100)),
('date_of_order', models.DateField(auto_now_add=True)),
('total_amount', models.FloatField(null=True)),
('placeanorder', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='account.placeanorder')),
],
),
migrations.CreateModel(
name='ServiceProvider',
fields=[
('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='account.user')),
('admin_name', models.CharField(max_length=100)),
('company_name', models.CharField(max_length=200)),
('phone_no', models.CharField(max_length=10)),
('alt_phone_no', models.CharField(max_length=10)),
('state', models.CharField(max_length=150)),
('city', models.CharField(max_length=100)),
('pin_no', models.CharField(max_length=20)),
('Area_name', models.CharField(max_length=200)),
('land_mark', models.CharField(max_length=200)),
('building_name', models.CharField(max_length=200)),
('flate_number', models.CharField(max_length=100)),
('customer', models.ManyToManyField(to='account.Customer')),
],
),
migrations.AddField(
model_name='order',
name='customer',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='account.customer'),
),
migrations.AddField(
model_name='order',
name='sp',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='account.serviceprovider'),
),
migrations.CreateModel(
name='Menu',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('item_name', models.CharField(max_length=500)),
('price', models.CharField(max_length=20)),
('category', models.CharField(max_length=200, null=True)),
('sp', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='account.serviceprovider')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0012_alter_user_first_name_max_length'),
]
operations = [
migrations.CreateModel(
name='Case',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('dateConfirmed', models.DateField()),
('caseType',
models.CharField(choices=[('Local', 'Local'),
('Imported', 'Imported')],
max_length=8)),
],
),
migrations.CreateModel(
name='Location',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100)),
('address', models.CharField(max_length=300)),
('x', models.FloatField(default=0.0)),
('y', models.FloatField(default=0.0)),
],
),
migrations.CreateModel(
name='Patient',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(default='', max_length=80)),
('idNumber', models.CharField(max_length=20)),
('dateOfBirth', models.DateField()),
],
),
migrations.CreateModel(
name='Virus',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=30)),
('commonName', models.CharField(max_length=50)),
('maxInfectiousPeriod', models.IntegerField(default=0)),
],
options={
'verbose_name_plural': 'Viruses',
},
),
migrations.CreateModel(
name='Visit',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('dateFrom', models.DateField()),
('dateTo', models.DateField()),
('category',
models.CharField(choices=[('Visit', 'Visit'),
('Residence', 'Residence'),
('Workplace', 'Workplace')],
max_length=20)),
('case',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='locations.case')),
('location',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='locations.location')),
],
),
migrations.AddField(
model_name='case',
name='patient',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='locations.patient'),
),
migrations.AddField(
model_name='case',
name='virus',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='locations.virus'),
),
migrations.CreateModel(
name='StaffUser',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('username',
models.CharField(
error_messages={
'unique': 'A user with that username already exists.'
},
help_text=
'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
max_length=150,
unique=True,
validators=[
django.contrib.auth.validators.
UnicodeUsernameValidator()
],
verbose_name='username')),
('first_name',
models.CharField(blank=True,
max_length=150,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=150,
verbose_name='last name')),
('email',
models.EmailField(blank=True,
max_length=254,
verbose_name='email address')),
('is_staff',
models.BooleanField(
default=False,
help_text=
'Designates whether the user can log into this admin site.',
verbose_name='staff status')),
('is_active',
models.BooleanField(
default=True,
help_text=
'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
verbose_name='active')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('chpStaffNumber',
models.CharField(max_length=7,
unique=True,
verbose_name='CHP Staff Number')),
('groups',
models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups')),
('user_permissions',
models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0008_alter_user_username_max_length'),
]
operations = [
migrations.CreateModel(
name='SpecialistMessageList',
fields=[
('id', models.IntegerField(primary_key=True, serialize=False)),
('photo', models.CharField(blank=True, max_length=240)),
('nick', models.CharField(blank=True, max_length=40)),
('date', models.DateField(blank=True)),
('title', models.CharField(blank=True, max_length=240)),
('total', models.IntegerField(blank=True)),
('client', models.IntegerField(blank=True)),
('specialist', models.IntegerField(blank=True)),
],
options={
'managed': False,
'db_table': 'specialist_message_list',
},
),
migrations.CreateModel(
name='User',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('password', models.CharField(max_length=128, verbose_name='password')),
('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')),
('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')),
('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')),
('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')),
('last_name', models.CharField(blank=True, max_length=30, verbose_name='last name')),
('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')),
('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')),
('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')),
('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')),
('nick', models.CharField(blank=True, max_length=45, null=True, verbose_name='nick')),
('email_exact', models.CharField(max_length=150, unique=True, verbose_name='email')),
('telephone', models.CharField(blank=True, max_length=14, null=True, verbose_name='phone')),
('cellphone', models.CharField(blank=True, max_length=14, null=True, verbose_name='cellphone')),
('photo', models.CharField(max_length=250, null=True, verbose_name='photo')),
('document_type', models.PositiveIntegerField(choices=[(1, 'DNI'), (2, 'Passport'), (3, 'Foreign Card')], verbose_name='type document')),
('document_number', models.CharField(max_length=45, verbose_name='document number')),
('img_document_number', models.CharField(max_length=250, null=True, verbose_name='upload document')),
('ruc', models.CharField(blank=True, max_length=40, null=True)),
('code', models.CharField(max_length=45, verbose_name='code')),
('anonymous', models.BooleanField(default=True, verbose_name='anonymous')),
('updated_at', models.DateTimeField(auto_now_add=True, verbose_name='updated at')),
('foreign_address', models.CharField(blank=True, max_length=200, null=True, verbose_name='foreign address')),
('key', models.CharField(blank=True, max_length=90, null=True)),
('status', models.PositiveIntegerField(choices=[(1, 'Pending'), (2, 'Activate'), (3, 'Reject'), (4, 'Deactivated')], default=1)),
],
options={
'verbose_name_plural': 'users',
'abstract': False,
'verbose_name': 'user',
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Address',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('street', models.CharField(blank=True, max_length=100)),
],
),
migrations.CreateModel(
name='Bank',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=200, verbose_name='Bank')),
('code', models.CharField(max_length=10)),
],
),
migrations.CreateModel(
name='Category',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=45, unique=True)),
('image', models.CharField(max_length=169)),
('description', models.CharField(max_length=255)),
('fixed_commission', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
('variable_commission', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
],
),
migrations.CreateModel(
name='Ciiu',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('code', models.CharField(max_length=4, unique=True)),
('description', models.CharField(max_length=255)),
],
),
migrations.CreateModel(
name='Clasification',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=45)),
('created_at', models.DateTimeField(auto_now_add=True)),
],
),
migrations.CreateModel(
name='Contract',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('url_file', models.CharField(max_length=255)),
('created_at', models.DateField(auto_now_add=True)),
('active', models.BooleanField(default=False)),
('validity_months', models.PositiveIntegerField()),
('expiration_date', models.DateField()),
],
),
migrations.CreateModel(
name='ContractType',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=50)),
('descripcion', models.CharField(max_length=200)),
],
),
migrations.CreateModel(
name='Countries',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=90, unique=True)),
('code_phone', models.CharField(max_length=4)),
('iso_code', models.CharField(max_length=4, unique=True)),
],
),
migrations.CreateModel(
name='Department',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=55)),
],
),
migrations.CreateModel(
name='District',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=55)),
],
),
migrations.CreateModel(
name='EconomicSector',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=45)),
],
),
migrations.CreateModel(
name='FeeMonthSeller',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('start_month', models.DateField()),
('fee_plans', models.PositiveIntegerField()),
('fee_contacts', models.PositiveIntegerField()),
('complete_fee_products', models.PositiveIntegerField()),
('created_at', models.DateTimeField(auto_now_add=True)),
],
),
migrations.CreateModel(
name='GroupMessage',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('status', models.PositiveIntegerField()),
],
),
migrations.CreateModel(
name='LevelInstruction',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=45)),
],
),
migrations.CreateModel(
name='LogPaymentsCreditCard',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('created_at', models.DateTimeField(auto_now_add=True)),
('successful', models.BooleanField()),
('description', models.CharField(max_length=50)),
('code_api', models.CharField(max_length=100)),
],
),
migrations.CreateModel(
name='Match',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('price', models.DecimalField(decimal_places=2, max_digits=10)),
],
),
migrations.CreateModel(
name='MatchAcquired',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('price', models.DecimalField(decimal_places=2, max_digits=10)),
('cause', models.TextField()),
('status', models.PositiveIntegerField(choices=[(1, 'Requested'), (2, 'Accepted'), (3, 'Declined')])),
('paid_by_client', models.BooleanField(default=True)),
('paid_by_specialist', models.BooleanField(default=False)),
],
),
migrations.CreateModel(
name='MatchAcquiredFiles',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('file_url', models.CharField(max_length=100)),
('type_file', models.PositiveIntegerField(choices=[(2, 'Image'), (3, 'Voice'), (4, 'Document')])),
('match_acquired', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.MatchAcquired')),
],
),
migrations.CreateModel(
name='MatchAcquiredLog',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('changed_on', models.DateTimeField(auto_now_add=True)),
('action', models.CharField(max_length=50)),
('status', models.PositiveIntegerField(choices=[(1, 'Requested'), (2, 'Accepted'), (3, 'Declined')])),
('declined', models.NullBooleanField()),
('declined_motive', models.CharField(max_length=255, null=True)),
('match_acquired', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.MatchAcquired')),
],
),
migrations.CreateModel(
name='Message',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('message', models.TextField(blank=True)),
('msg_type', models.CharField(blank=True, choices=[('q', 'query'), ('r', 'requery'), ('a', 'answer')], max_length=1)),
('created_at', models.DateTimeField(auto_now_add=True)),
('content_type', models.PositiveIntegerField(choices=[(1, 'Text'), (2, 'Image'), (3, 'Video'), (4, 'Voice'), (5, 'Document')])),
('viewed', models.BooleanField(default=False)),
('file_url', models.CharField(blank=True, max_length=100)),
('code', models.CharField(max_length=45, verbose_name='code')),
('room', models.CharField(max_length=200)),
('group', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.GroupMessage')),
('message_reference', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, related_name='ref', to='api.Message')),
],
),
migrations.CreateModel(
name='MonthlyFee',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('fee_amount', models.DecimalField(decimal_places=2, max_digits=10)),
('fee_order_number', models.PositiveIntegerField()),
('fee_quantity', models.PositiveIntegerField()),
('reference_number', models.CharField(max_length=20)),
('pay_before', models.DateField()),
('status', models.PositiveIntegerField(choices=[(1, 'Pending'), (2, 'Paid')])),
],
),
migrations.CreateModel(
name='NotificationsBack',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('message', models.CharField(max_length=255, verbose_name='message')),
('viewed', models.BooleanField(default=False, verbose_name='viewed')),
('created_at', models.DateTimeField(auto_now_add=True)),
('code', models.CharField(max_length=200)),
],
),
migrations.CreateModel(
name='Objection',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=65)),
],
),
migrations.CreateModel(
name='Parameter',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('parameter', models.CharField(max_length=45)),
('value', models.CharField(max_length=50)),
],
),
migrations.CreateModel(
name='Payment',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('amount', models.FloatField()),
('operation_number', models.CharField(max_length=12)),
('agency_code', models.CharField(max_length=10)),
('account_number_drawer', models.CharField(max_length=50)),
('check_number', models.CharField(max_length=50)),
('credit_cart_number', models.CharField(max_length=30)),
('credit_card_cvc', models.CharField(max_length=3)),
('credit_card_exp_date', models.DateField()),
('authorization_date', models.DateTimeField()),
('created_at', models.DateTimeField(auto_now_add=True)),
('status', models.PositiveIntegerField(choices=[(1, 'Pending'), (2, 'Accepted'), (3, 'Declined')])),
('observations', models.CharField(max_length=255)),
],
),
migrations.CreateModel(
name='PaymentType',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=45)),
('description', models.CharField(max_length=200, null=True)),
('status', models.BooleanField(default=True)),
],
),
migrations.CreateModel(
name='Permmission',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=150)),
('description', models.CharField(max_length=220)),
('code', models.CharField(max_length=12)),
],
),
migrations.CreateModel(
name='ProductType',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=50)),
('description', models.CharField(max_length=200)),
('created_at', models.DateTimeField(auto_now_add=True)),
],
),
migrations.CreateModel(
name='Province',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=55)),
('department', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Department')),
],
),
migrations.CreateModel(
name='Query',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=100)),
('status', models.PositiveIntegerField(choices=[(1, 'Requested'), (2, 'Accepted'), (3, 'Answered'), (4, 'To score'), (5, 'Absolved')])),
('created_at', models.DateTimeField(auto_now_add=True)),
('last_modified', models.DateTimeField(auto_now=True)),
('calification', models.PositiveSmallIntegerField(null=True)),
('changed_on', models.DateTimeField(auto_now=True, null=True)),
],
),
migrations.CreateModel(
name='QueryLogs',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('action', models.CharField(max_length=10)),
('description', models.CharField(max_length=200, null=True)),
('changed_on', models.DateTimeField()),
('status_log', models.PositiveIntegerField(choices=[(1, 'Requested'), (2, 'Accepted'), (3, 'Answered'), (4, 'To score'), (5, 'Absolved')])),
('derived', models.NullBooleanField()),
('declined', models.NullBooleanField()),
('declined_motive', models.TextField(null=True)),
('query', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Query')),
],
),
migrations.CreateModel(
name='QueryPlans',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=50)),
('query_quantity', models.IntegerField()),
('validity_months', models.PositiveIntegerField()),
('maximum_response_time', models.PositiveIntegerField()),
('price', models.DecimalField(decimal_places=4, max_digits=10)),
('created_at', models.DateTimeField(auto_now_add=True)),
('is_active', models.BooleanField(default=True)),
('clasification', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Clasification')),
('product_type', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.ProductType')),
],
),
migrations.CreateModel(
name='QueryPlansAcquired',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('expiration_date', models.DateField(null=True)),
('validity_months', models.PositiveIntegerField()),
('available_queries', models.PositiveIntegerField()),
('query_quantity', models.PositiveIntegerField()),
('activation_date', models.DateField(null=True)),
('is_active', models.BooleanField(default=False)),
('is_chosen', models.BooleanField(default=False)),
('available_requeries', models.PositiveIntegerField()),
('maximum_response_time', models.PositiveIntegerField()),
('acquired_at', models.DateTimeField(auto_now_add=True)),
('plan_name', models.CharField(max_length=50)),
('query_plans', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.QueryPlans')),
],
),
migrations.CreateModel(
name='RecoveryPassword',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('created_at', models.DateTimeField(auto_now_add=True)),
('is_active', models.BooleanField(default=False)),
('code', models.CharField(max_length=6)),
],
),
migrations.CreateModel(
name='Role',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=50, unique=True)),
('created_at', models.DateTimeField(auto_now_add=True)),
('permissions', models.ManyToManyField(db_table='role_permission', to='api.Permmission')),
],
),
migrations.CreateModel(
name='Sale',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('created_at', models.DateTimeField(auto_now_add=True)),
('place', models.CharField(max_length=100)),
('total_amount', models.DecimalField(decimal_places=2, max_digits=10)),
('reference_number', models.CharField(max_length=20)),
('description', models.TextField()),
('is_fee', models.BooleanField(default=False)),
],
),
migrations.CreateModel(
name='SaleDetail',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('price', models.DecimalField(decimal_places=2, max_digits=10)),
('description', models.TextField()),
('discount', models.DecimalField(decimal_places=2, max_digits=10)),
('pin_code', models.CharField(max_length=50)),
('is_billable', models.BooleanField(default=True)),
('contract', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Contract')),
('product_type', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.ProductType')),
('sale', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Sale')),
],
),
migrations.CreateModel(
name='SellerContactNoEfective',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('first_name', models.CharField(max_length=45, null=True)),
('last_name', models.CharField(max_length=55, null=True)),
('type_contact', models.CharField(choices=[('n', 'Natural'), ('b', 'Business')], max_length=1)),
('document_type', models.PositiveIntegerField(choices=[(1, 'DNI'), (2, 'Passport'), (3, 'Foreign Card')])),
('document_number', models.CharField(max_length=45)),
('email', models.CharField(max_length=150, null=True)),
('civil_state', models.CharField(choices=[('c', 'cohabiting'), ('e', 'separated'), ('m', 'married'), ('w', 'widower'), ('d', 'divorced'), ('s', 'single')], max_length=1, null=True)),
('birthdate', models.DateField(null=True)),
('institute', models.CharField(blank=True, max_length=100, null=True)),
('activity_description', models.CharField(blank=True, max_length=255, null=True)),
('photo', models.CharField(max_length=250, null=True)),
('about', models.CharField(blank=True, max_length=255, null=True)),
('cellphone', models.CharField(blank=True, max_length=14, null=True)),
('telephone', models.CharField(blank=True, max_length=14, null=True)),
('ocupation', models.PositiveIntegerField(choices=[(1, 'Employer'), (2, 'Independent worker'), (3, 'Employee'), (4, 'Worker'), (5, 'Worker in a family business'), (6, 'Home worker'), (7, 'Other')], default=7, null=True)),
('profession', models.CharField(max_length=45, null=True)),
('business_name', models.CharField(max_length=45, null=True)),
('commercial_reason', models.CharField(max_length=45, null=True)),
('agent_firstname', models.CharField(max_length=45, null=True)),
('agent_lastname', models.CharField(max_length=45, null=True)),
('sex', models.CharField(blank=True, choices=[('m', 'Male'), ('f', 'Female')], max_length=1)),
('latitude', models.CharField(blank=True, max_length=45)),
('longitude', models.CharField(blank=True, max_length=45)),
('created_at', models.DateTimeField(auto_now_add=True)),
('position', models.CharField(max_length=45, null=True)),
('ruc', models.CharField(blank=True, max_length=40, null=True)),
('address', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Address')),
('ciiu', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='api.Ciiu')),
('economic_sector', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.EconomicSector')),
('level_instruction', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.LevelInstruction')),
('nationality', models.ForeignKey(default=1, on_delete=django.db.models.deletion.PROTECT, to='api.Countries')),
('objection', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Objection')),
],
),
migrations.CreateModel(
name='SellerNonBillablePlans',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('quantity', models.PositiveIntegerField()),
('number_month', models.PositiveIntegerField()),
('created_at', models.DateTimeField(auto_now_add=True)),
('query_plans', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.QueryPlans')),
],
),
migrations.CreateModel(
name='Zone',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=45)),
('districts', models.ManyToManyField(db_table='zones_districts', to='api.District')),
],
),
migrations.CreateModel(
name='Client',
fields=[
('user_ptr', models.OneToOneField(auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to=settings.AUTH_USER_MODEL)),
('type_client', models.CharField(choices=[('n', 'Natural'), ('b', 'Business')], max_length=1)),
('sex', models.CharField(blank=True, choices=[('m', 'Male'), ('f', 'Female')], max_length=1)),
('commercial_reason', models.CharField(max_length=45, null=True)),
('civil_state', models.CharField(choices=[('c', 'cohabiting'), ('e', 'separated'), ('m', 'married'), ('w', 'widower'), ('d', 'divorced'), ('s', 'single')], max_length=1, null=True)),
('birthdate', models.DateField(null=True)),
('activity_description', models.CharField(blank=True, max_length=255, null=True)),
('institute', models.CharField(blank=True, max_length=100, null=True)),
('ocupation', models.PositiveIntegerField(choices=[(1, 'Employer'), (2, 'Independent worker'), (3, 'Employee'), (4, 'Worker'), (5, 'Worker in a family business'), (6, 'Home worker'), (7, 'Other')], null=True)),
('about', models.CharField(blank=True, max_length=255, null=True)),
('business_name', models.CharField(max_length=45, null=True)),
('agent_firstname', models.CharField(max_length=45, null=True)),
('agent_lastname', models.CharField(max_length=45, null=True)),
('position', models.CharField(max_length=45, null=True)),
('profession', models.CharField(max_length=45, null=True)),
('ciiu', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='api.Ciiu')),
('economic_sector', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.EconomicSector')),
('level_instruction', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.LevelInstruction')),
],
options={
'verbose_name_plural': 'Clients',
'verbose_name': 'Client',
},
bases=('api.user',),
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Seller',
fields=[
('user_ptr', models.OneToOneField(auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to=settings.AUTH_USER_MODEL)),
('cv', models.CharField(blank=True, max_length=100, null=True)),
('ciiu', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='api.Ciiu')),
('zone', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Zone')),
],
options={
'verbose_name_plural': 'Sellers',
'verbose_name': 'Seller',
},
bases=('api.user',),
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Specialist',
fields=[
('user_ptr', models.OneToOneField(auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to=settings.AUTH_USER_MODEL)),
('business_name', models.CharField(max_length=55)),
('type_specialist', models.CharField(choices=[('m', 'Main'), ('a', 'Associate')], max_length=1)),
('star_rating', models.IntegerField(null=True)),
('cv', models.CharField(max_length=150, null=True)),
('payment_per_answer', models.DecimalField(decimal_places=2, max_digits=10)),
],
options={
'verbose_name_plural': 'Specialists',
'verbose_name': 'Specialist',
},
bases=('api.user',),
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.AddField(
model_name='recoverypassword',
name='user',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='queryplansacquired',
name='sale_detail',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.SaleDetail'),
),
migrations.AddField(
model_name='query',
name='acquired_plan',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.QueryPlansAcquired'),
),
migrations.AddField(
model_name='query',
name='category',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Category'),
),
migrations.AddField(
model_name='payment',
name='authorized_by',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='payment',
name='bank',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Bank'),
),
migrations.AddField(
model_name='payment',
name='payment_type',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.PaymentType'),
),
migrations.AddField(
model_name='notificationsback',
name='user',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='monthlyfee',
name='payment',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='api.Payment'),
),
migrations.AddField(
model_name='monthlyfee',
name='sale_detail',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.SaleDetail'),
),
migrations.AddField(
model_name='message',
name='query',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Query'),
),
migrations.AddField(
model_name='matchacquired',
name='sale_detail',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.SaleDetail'),
),
migrations.AddField(
model_name='match',
name='product_type',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.ProductType'),
),
migrations.AddField(
model_name='match',
name='speciality',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Category'),
),
migrations.AddField(
model_name='district',
name='province',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Province'),
),
migrations.AddField(
model_name='contract',
name='type_contract',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.ContractType'),
),
migrations.AddField(
model_name='category',
name='contract',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Contract'),
),
migrations.AddField(
model_name='address',
name='department',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Department'),
),
migrations.AddField(
model_name='address',
name='district',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.District'),
),
migrations.AddField(
model_name='address',
name='province',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Province'),
),
migrations.AddField(
model_name='user',
name='address',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Address', verbose_name='address'),
),
migrations.AddField(
model_name='user',
name='code_cellphone',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, related_name='prefix_cellphone', to='api.Countries'),
),
migrations.AddField(
model_name='user',
name='code_telephone',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, related_name='prefix_telephone', to='api.Countries'),
),
migrations.AddField(
model_name='user',
name='groups',
field=models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups'),
),
migrations.AddField(
model_name='user',
name='nationality',
field=models.ForeignKey(default=1, on_delete=django.db.models.deletion.PROTECT, to='api.Countries', verbose_name='nationality'),
),
migrations.AddField(
model_name='user',
name='residence_country',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, related_name='residence', to='api.Countries', verbose_name='residence country'),
),
migrations.AddField(
model_name='user',
name='role',
field=models.ForeignKey(default=1, on_delete=django.db.models.deletion.PROTECT, to='api.Role', verbose_name='role'),
),
migrations.AddField(
model_name='user',
name='user_permissions',
field=models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions'),
),
migrations.AddField(
model_name='specialist',
name='category',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Category'),
),
migrations.AddField(
model_name='sellernonbillableplans',
name='seller',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Seller'),
),
migrations.AddField(
model_name='sellercontactnoefective',
name='seller',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Seller'),
),
migrations.AddField(
model_name='sale',
name='client',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Client'),
),
migrations.AddField(
model_name='sale',
name='seller',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Seller'),
),
migrations.AddField(
model_name='queryplansacquired',
name='client',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Client'),
),
migrations.AddField(
model_name='queryplans',
name='non_billable',
field=models.ManyToManyField(through='api.SellerNonBillablePlans', to='api.Seller'),
),
migrations.AddField(
model_name='querylogs',
name='from_specialist',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, related_name='al_especialista', to='api.Specialist'),
),
migrations.AddField(
model_name='querylogs',
name='to_specialist',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, related_name='del_especialista', to='api.Specialist'),
),
migrations.AddField(
model_name='query',
name='client',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Client'),
),
migrations.AddField(
model_name='query',
name='specialist',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Specialist'),
),
migrations.AddField(
model_name='message',
name='specialist',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Specialist'),
),
migrations.AddField(
model_name='matchacquired',
name='client',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Client'),
),
migrations.AddField(
model_name='matchacquired',
name='specialist',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Specialist'),
),
migrations.AddField(
model_name='feemonthseller',
name='seller',
field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Seller'),
),
migrations.AddField(
model_name='client',
name='seller_asigned',
field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Seller'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Cart',
fields=[
('cid', models.AutoField(primary_key=True, serialize=False)),
('c_food_num', models.IntegerField()),
('c_is_select', models.IntegerField()),
],
options={
'db_table': 'cart',
'managed': False,
},
),
migrations.CreateModel(
name='Foods',
fields=[
('fid', models.AutoField(primary_key=True, serialize=False)),
('food_name', models.CharField(max_length=255)),
('food_price', models.FloatField()),
('food_describe', models.CharField(max_length=255)),
('sell_num', models.IntegerField(default=0)),
('food_img', models.CharField(max_length=255)),
],
options={
'db_table': 'foods',
'ordering': ['fid'],
'managed': False,
},
),
migrations.CreateModel(
name='Order',
fields=[
('oid', models.AutoField(primary_key=True, serialize=False)),
('o_price', models.FloatField()),
('o_time', models.DateTimeField(auto_now=True)),
('o_status', models.IntegerField()),
],
options={
'db_table': 'order',
'ordering': ['-o_time'],
'managed': False,
},
),
migrations.CreateModel(
name='Orderfoods',
fields=[
('ofid', models.AutoField(primary_key=True, serialize=False)),
('of_food_num', models.IntegerField()),
],
options={
'db_table': 'orderfoods',
'managed': False,
},
),
migrations.CreateModel(
name='Type',
fields=[
('tid', models.AutoField(primary_key=True, serialize=False)),
('type_name', models.CharField(max_length=32)),
],
options={
'db_table': 'type',
'managed': False,
},
),
migrations.CreateModel(
name='User',
fields=[
('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')),
('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')),
('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')),
('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')),
('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')),
('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')),
('uid', models.AutoField(primary_key=True, serialize=False)),
('username', models.CharField(max_length=20, unique=True)),
('password', models.CharField(max_length=200)),
('email', models.EmailField(max_length=200, unique=True)),
('phone', models.IntegerField(blank=True, null=True)),
('sex', models.IntegerField(blank=True, null=True)),
('is_active', models.IntegerField(default=0)),
('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')),
('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')),
],
options={
'db_table': 'user',
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0011_update_proxy_permissions'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('username',
models.CharField(
error_messages={
'unique': 'A user with that username already exists.'
},
help_text=
'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
max_length=150,
unique=True,
validators=[
django.contrib.auth.validators.
UnicodeUsernameValidator()
],
verbose_name='username')),
('first_name',
models.CharField(blank=True,
max_length=30,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=150,
verbose_name='last name')),
('is_staff',
models.BooleanField(
default=False,
help_text=
'Designates whether the user can log into this admin site.',
verbose_name='staff status')),
('is_active',
models.BooleanField(
default=True,
help_text=
'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
verbose_name='active')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('email',
models.EmailField(error_messages={
'unique': 'El email que ingreso ya existe'
},
max_length=254,
unique=True,
verbose_name='email addres')),
('groups',
models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups')),
('user_permissions',
models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Asignacion',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('descripcion',
models.CharField(blank=True, max_length=250, null=True)),
('portada',
models.ImageField(blank=True, null=True,
upload_to='Portada')),
('activo', models.BooleanField(default=True)),
('creado', models.DateTimeField(auto_now_add=True)),
('modificado', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='Ciclo',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('anio',
models.PositiveIntegerField(validators=[
django.core.validators.MinValueValidator(1990)
])),
('activo', models.BooleanField(default=True)),
('creado', models.DateTimeField(auto_now_add=True)),
('modificado', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='Curso',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('nombre', models.CharField(max_length=100)),
('descripcion',
models.CharField(blank=True, max_length=250, null=True)),
('activo', models.BooleanField(default=True)),
('creado', models.DateTimeField(auto_now_add=True)),
('modificado', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='Estudiante',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('telefono_contacto',
models.CharField(blank=True, max_length=15, null=True)),
('direccion_contacto',
models.CharField(blank=True, max_length=250, null=True)),
('activo', models.BooleanField(default=True)),
('creado', models.DateTimeField(auto_now_add=True)),
('modificado', models.DateTimeField(auto_now=True)),
('asignacion_estudiante',
models.ManyToManyField(related_name='estudiante_asignaciones',
to='api.Asignacion')),
],
),
migrations.CreateModel(
name='Nivel',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('nombre', models.CharField(max_length=100)),
('descripcion',
models.CharField(blank=True, max_length=250, null=True)),
('activo', models.BooleanField(default=True)),
('creado', models.DateTimeField(auto_now_add=True)),
('modificado', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='Profesion',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('nombre', models.CharField(max_length=100)),
('descripcion',
models.CharField(blank=True, max_length=250, null=True)),
('activo', models.BooleanField(default=True)),
('creado', models.DateTimeField(auto_now_add=True)),
('modificado', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='Rol',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('nombre', models.CharField(max_length=100)),
('descripcion',
models.CharField(blank=True, max_length=250, null=True)),
('activo', models.BooleanField(default=True)),
('creado', models.DateTimeField(auto_now_add=True)),
('modificado', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='Seccion',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('nombre', models.CharField(max_length=100)),
('activo', models.BooleanField(default=True)),
('creado', models.DateTimeField(auto_now_add=True)),
('modificado', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='Tarea',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('titulo', models.CharField(max_length=100)),
('descripcion',
models.CharField(blank=True, max_length=250, null=True)),
('fecha_entrega', models.DateField()),
('hora_entrega', models.TimeField()),
('nota', models.FloatField(default=0)),
('archivo',
models.FileField(blank=True,
null=True,
upload_to='tarea_maestros')),
('permitir_archivo', models.BooleanField(default=True)),
('activo', models.BooleanField(default=True)),
('creado', models.DateTimeField(auto_now_add=True)),
('modificado', models.DateTimeField(auto_now=True)),
('asignacion',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='asignaciones',
to='api.Asignacion')),
],
),
migrations.CreateModel(
name='Tarea_Estudiante',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('texto',
models.CharField(blank=True, max_length=250, null=True)),
('archivo',
models.FileField(blank=True,
null=True,
upload_to='tarea_alumnos')),
('punteo', models.FloatField(default=0)),
('activo', models.BooleanField(default=True)),
('creado', models.DateTimeField(auto_now_add=True)),
('modificado', models.DateTimeField(auto_now=True)),
('estudiante',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='estudiantes',
to='api.Estudiante')),
('tarea',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='tareas',
to='api.Tarea')),
],
),
migrations.CreateModel(
name='Profile',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('phone', models.CharField(blank=True,
max_length=15,
null=True)),
('address',
models.CharField(blank=True, max_length=250, null=True)),
('avatar',
models.ImageField(blank=True, null=True, upload_to='Avatar')),
('is_first_login',
models.BooleanField(
default=True,
help_text=
'Verifica si es la primera vez que se logueo en la aplicaion',
verbose_name='first_login')),
('activo', models.BooleanField(default=True)),
('creado', models.DateTimeField(auto_now_add=True)),
('modificado', models.DateTimeField(auto_now=True)),
('rol',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='roles',
to='api.Rol')),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name='profiles',
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Material',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('titulo', models.CharField(max_length=100)),
('descripcion',
models.CharField(blank=True, max_length=250, null=True)),
('archivo', models.FileField(upload_to='material_apoyo')),
('activo', models.BooleanField(default=True)),
('creado', models.DateTimeField(auto_now_add=True)),
('modificado', models.DateTimeField(auto_now=True)),
('asignacion',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='material_asignaciones',
to='api.Asignacion')),
],
),
migrations.CreateModel(
name='Maestro',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('activo', models.BooleanField(default=True)),
('creado', models.DateTimeField(auto_now_add=True)),
('modificado', models.DateTimeField(auto_now=True)),
('maestro_profile',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name='maestros_profiles',
to='api.Profile')),
('profesion',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='profesiones',
to='api.Profesion')),
],
),
migrations.CreateModel(
name='Grado',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('nombre', models.CharField(max_length=100)),
('descripcion',
models.CharField(blank=True, max_length=250, null=True)),
('activo', models.BooleanField(default=True)),
('creado', models.DateTimeField(auto_now_add=True)),
('modificado', models.DateTimeField(auto_now=True)),
('nivel',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='niveles',
to='api.Nivel')),
],
),
migrations.CreateModel(
name='Evento',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('titulo', models.CharField(max_length=100)),
('descripcion',
models.CharField(blank=True, max_length=250, null=True)),
('fecha', models.DateField()),
('hora', models.TimeField()),
('activo', models.BooleanField(default=True)),
('creado', models.DateTimeField(auto_now_add=True)),
('modificado', models.DateTimeField(auto_now=True)),
('ciclo_escolar',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='ciclos',
to='api.Ciclo')),
],
),
migrations.AddField(
model_name='estudiante',
name='estudiante_profile',
field=models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name='profiles',
to='api.Profile'),
),
migrations.AddField(
model_name='asignacion',
name='asignacion_ciclo',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='asignacion_ciclos',
to='api.Ciclo'),
),
migrations.AddField(
model_name='asignacion',
name='curso',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='asignacion_cursos',
to='api.Curso'),
),
migrations.AddField(
model_name='asignacion',
name='grado',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='asignacion_grados',
to='api.Grado'),
),
migrations.AddField(
model_name='asignacion',
name='maestro',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='asignacion_maestros',
to='api.Maestro'),
),
migrations.AddField(
model_name='asignacion',
name='seccion',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='asignacion_secciones',
to='api.Seccion'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0009_alter_user_last_name_max_length'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('username',
models.CharField(
error_messages={
'unique': 'A user with that username already exists.'
},
help_text=
'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
max_length=150,
unique=True,
validators=[
django.contrib.auth.validators.
UnicodeUsernameValidator()
],
verbose_name='username')),
('first_name',
models.CharField(blank=True,
max_length=30,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=150,
verbose_name='last name')),
('is_staff',
models.BooleanField(
default=False,
help_text=
'Designates whether the user can log into this admin site.',
verbose_name='staff status')),
('is_active',
models.BooleanField(
default=True,
help_text=
'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
verbose_name='active')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('created',
models.DateTimeField(
auto_now_add=True,
help_text='Date time on which the object was created.',
verbose_name='created_at')),
('modified',
models.DateTimeField(
auto_now=True,
help_text=
'Date time on which the object was last modified.',
verbose_name='modified_at')),
('email',
models.EmailField(error_messages={
'unique':
'A user with that email already exists.'
},
max_length=254,
unique=True,
verbose_name='email address')),
('phone_number',
models.CharField(
blank=True,
max_length=17,
validators=[
django.core.validators.RegexValidator(
message=
'Phone number must be entered in the format: +999999999. Up to 15 digits allowed.',
regex='\\+?1?\\d{9,15}$')
])),
('is_client',
models.BooleanField(
default=True,
help_text=
'Help easily distinguish users and perform queries. Clients are the main type of user.',
verbose_name='client')),
('is_verified',
models.BooleanField(
default=True,
help_text=
'Set to true when the user have verified its email address.',
verbose_name='verified')),
('groups',
models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups')),
('user_permissions',
models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions')),
],
options={
'ordering': ['-created', '-modified'],
'get_latest_by': 'created',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Profile',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created',
models.DateTimeField(
auto_now_add=True,
help_text='Date time on which the object was created.',
verbose_name='created_at')),
('modified',
models.DateTimeField(
auto_now=True,
help_text=
'Date time on which the object was last modified.',
verbose_name='modified_at')),
('picture',
models.ImageField(blank=True,
null=True,
upload_to='users/pictures/',
verbose_name='profile picture')),
('biography', models.TextField(blank=True, max_length=500)),
('rides_taken', models.PositiveIntegerField(default=0)),
('rides_offered', models.PositiveIntegerField(default=0)),
('reputation',
models.FloatField(
default=5.0,
help_text=
"User's reputaton based on the rides taken and offered.")
),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'ordering': ['-created', '-modified'],
'get_latest_by': 'created',
'abstract': False,
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0008_alter_user_username_max_length'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('username',
models.CharField(
error_messages={
'unique': 'A user with that username already exists.'
},
help_text=
'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
max_length=150,
unique=True,
validators=[
django.contrib.auth.validators.
UnicodeUsernameValidator()
],
verbose_name='username')),
('first_name',
models.CharField(blank=True,
max_length=30,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=30,
verbose_name='last name')),
('email',
models.EmailField(blank=True,
max_length=254,
verbose_name='email address')),
('is_staff',
models.BooleanField(
default=False,
help_text=
'Designates whether the user can log into this admin site.',
verbose_name='staff status')),
('is_active',
models.BooleanField(
default=True,
help_text=
'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
verbose_name='active')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('nickname',
models.CharField(blank=True,
max_length=32,
null=True,
verbose_name='昵称')),
('telphone',
models.IntegerField(max_length=11, verbose_name='手机号码')),
('address',
models.CharField(max_length=128, verbose_name='邮寄地址')),
('groups',
models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups')),
('user_permissions',
models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Order',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('telphone', models.IntegerField(max_length=11)),
('create_time', models.DateTimeField(auto_now=True)),
('total_price', models.FloatField(default=0)),
('address', models.CharField(max_length=128)),
('status',
models.CharField(choices=[('wait', '待付款'), ('overdue', '已过期'),
('complete', '已完成'),
('refund', '已退款')],
default='wait',
max_length=9)),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='orders',
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='OrderProduct',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('price', models.FloatField(default=0.0)),
('count', models.IntegerField(default=0)),
('total_price', models.FloatField(default=0.0)),
('order',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='orders',
to='shop.Order')),
],
),
migrations.CreateModel(
name='Product',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('pic', models.ImageField(upload_to='product_pic')),
('describe', models.TextField()),
('price', models.FloatField(default=0.0)),
('count', models.IntegerField(default=0)),
],
),
migrations.CreateModel(
name='ShopCar',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('count', models.IntegerField(default=0)),
('product',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='shopcars',
to='shop.Product')),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='shopcar',
to=settings.AUTH_USER_MODEL)),
],
),
migrations.AddField(
model_name='orderproduct',
name='product',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='orderproducts',
to='shop.Product'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0008_alter_user_username_max_length'),
]
operations = [
migrations.CreateModel(
name='UserProfile',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('username',
models.CharField(
error_messages={
'unique': 'A user with that username already exists.'
},
help_text=
'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
max_length=150,
unique=True,
validators=[
django.contrib.auth.validators.
UnicodeUsernameValidator()
],
verbose_name='username')),
('first_name',
models.CharField(blank=True,
max_length=30,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=30,
verbose_name='last name')),
('email',
models.EmailField(blank=True,
max_length=254,
verbose_name='email address')),
('is_staff',
models.BooleanField(
default=False,
help_text=
'Designates whether the user can log into this admin site.',
verbose_name='staff status')),
('is_active',
models.BooleanField(
default=True,
help_text=
'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
verbose_name='active')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('name',
models.CharField(blank=True,
max_length=30,
null=True,
verbose_name='姓名')),
('birthday',
models.DateField(blank=True, null=True, verbose_name='出生年月')),
('gender',
models.CharField(choices=[('male', '男'), ('female', '女')],
default='female',
max_length=6,
verbose_name='性别')),
('mobile',
models.CharField(blank=True,
max_length=11,
null=True,
verbose_name='电话')),
('qq_number',
models.CharField(blank=True,
max_length=15,
null=True,
verbose_name='QQ号码')),
('balance',
models.FloatField(default=0, null=True, verbose_name='余额')),
('groups',
models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups')),
('user_permissions',
models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions')),
],
options={
'verbose_name': '用户',
'verbose_name_plural': '用户',
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='RechargeOrder',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('money', models.FloatField(verbose_name='充值金额')),
('arrival_money',
models.FloatField(default=0, verbose_name='到账金额')),
('order_number',
models.CharField(blank=True,
max_length=300,
null=True,
verbose_name='充值单号')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
('state',
models.BooleanField(default=False, verbose_name='处理状态')),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL,
verbose_name='充值用户')),
],
options={
'verbose_name': '充值订单',
'verbose_name_plural': '充值订单',
},
),
migrations.CreateModel(
name='Store',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('store_ww',
models.CharField(default='',
max_length=100,
verbose_name='店铺旺旺')),
('store_name',
models.CharField(default='',
max_length=100,
verbose_name='店铺名称')),
('store_category',
models.CharField(default='',
max_length=100,
verbose_name='店铺类目')),
('store_url',
models.URLField(max_length=500, verbose_name='店铺链接')),
('sender_name',
models.CharField(default='',
max_length=100,
verbose_name='发件人')),
('mobile',
models.CharField(default='', max_length=11,
verbose_name='电话')),
('province',
models.CharField(default='',
max_length=100,
verbose_name='省份')),
('city',
models.CharField(default='',
max_length=100,
verbose_name='城市')),
('district',
models.CharField(default='',
max_length=100,
verbose_name='区域')),
('address',
models.CharField(default='',
max_length=100,
verbose_name='详细地址')),
('postal_code',
models.CharField(default='', max_length=6,
verbose_name='邮编')),
('image',
models.ImageField(upload_to='store_image',
verbose_name='卖家中心图片')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
('state',
models.BooleanField(default=False, verbose_name='审核状态')),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL,
verbose_name='用户')),
],
options={
'verbose_name': '我的店铺',
'verbose_name_plural': '我的店铺',
},
),
migrations.CreateModel(
name='VerifyCode',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('code', models.CharField(max_length=10, verbose_name='邀请码')),
('mobile', models.CharField(max_length=11, verbose_name='电话')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
],
options={
'verbose_name': '邀请码',
'verbose_name_plural': '邀请码',
},
),
migrations.CreateModel(
name='WithdrawOrder',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('money', models.FloatField(verbose_name='提现金额')),
('Bank_number',
models.CharField(blank=True,
max_length=50,
null=True,
verbose_name='提现银行卡号')),
('arrival_money',
models.FloatField(default=0, verbose_name='到账金额')),
('add_time',
models.DateTimeField(default=datetime.datetime.now,
verbose_name='添加时间')),
('state',
models.BooleanField(default=False, verbose_name='处理状态')),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL,
verbose_name='提现用户')),
],
options={
'verbose_name': '提现订单',
'verbose_name_plural': '提现订单',
},
),
]
class Migration(migrations.Migration):
dependencies = [
('auth', '0012_alter_user_first_name_max_length'),
('movie_app', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('username',
models.CharField(
error_messages={
'unique': 'A user with that username already exists.'
},
help_text=
'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
max_length=150,
unique=True,
validators=[
django.contrib.auth.validators.
UnicodeUsernameValidator()
],
verbose_name='username')),
('first_name',
models.CharField(blank=True,
max_length=150,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=150,
verbose_name='last name')),
('email',
models.EmailField(blank=True,
max_length=254,
verbose_name='email address')),
('is_staff',
models.BooleanField(
default=False,
help_text=
'Designates whether the user can log into this admin site.',
verbose_name='staff status')),
('is_active',
models.BooleanField(
default=True,
help_text=
'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
verbose_name='active')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('access_level',
models.IntegerField(choices=[(1, 'Admin'), (2, 'User')],
default=2)),
('groups',
models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups')),
('user_permissions',
models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Genre',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=100, unique=True)),
],
),
migrations.CreateModel(
name='Movie',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=100, unique=True)),
('rating',
models.FloatField(validators=[
django.core.validators.MinValueValidator(0),
django.core.validators.MaxValueValidator(10)
])),
('popularity',
models.FloatField(validators=[
django.core.validators.MinValueValidator(0),
django.core.validators.MaxValueValidator(100)
])),
('director',
models.CharField(blank=True, max_length=100, null=True)),
('genre', models.ManyToManyField(to='movie_app.Genre')),
],
),
migrations.DeleteModel(name='Movies', ),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0012_alter_user_first_name_max_length'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('username',
models.CharField(
error_messages={
'unique': 'A user with that username already exists.'
},
help_text=
'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
max_length=150,
unique=True,
validators=[
django.contrib.auth.validators.
UnicodeUsernameValidator()
],
verbose_name='username')),
('first_name',
models.CharField(blank=True,
max_length=150,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=150,
verbose_name='last name')),
('is_staff',
models.BooleanField(
default=False,
help_text=
'Designates whether the user can log into this admin site.',
verbose_name='staff status')),
('is_active',
models.BooleanField(
default=True,
help_text=
'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
verbose_name='active')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('email', models.EmailField(max_length=254, unique=True)),
('email_confirmed', models.BooleanField(default=False)),
('groups',
models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups')),
('user_permissions',
models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Food',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=45)),
('description',
models.CharField(blank=True, max_length=200, null=True)),
('counter', models.PositiveIntegerField()),
('vegetarian', models.BooleanField()),
('vegan', models.BooleanField()),
('halal', models.BooleanField()),
('lactose_free', models.BooleanField()),
('gluten_free', models.BooleanField()),
('bio', models.BooleanField()),
('expiration_date',
models.DateField(
validators=[fridge.validators.expiration_date_validator])
),
],
),
migrations.CreateModel(
name='Fridge',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=45)),
('address', models.CharField(max_length=45)),
('city', models.CharField(max_length=45)),
('zip_code',
models.CharField(max_length=45,
validators=[
django.core.validators.RegexValidator(
'^\\d{4}$', 'This NPA is not valid')
])),
('phone_number',
models.CharField(max_length=12,
validators=[
django.core.validators.RegexValidator(
'^(\\+41|0)\\d{9}$',
'This phone number is not valid.')
])),
('latitude', models.FloatField()),
('longitude', models.FloatField()),
('image', models.ImageField(upload_to='images/')),
('is_active', models.BooleanField(default=False)),
('user',
models.OneToOneField(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Sponsor',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=45)),
('logo', models.ImageField(upload_to='images/')),
('website', models.URLField(blank=True, null=True)),
],
),
migrations.CreateModel(
name='TemperatureControl',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date', models.DateField()),
('temperature', models.FloatField()),
('visa', models.CharField(max_length=45)),
('fridge',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='fridge.fridge')),
],
),
migrations.CreateModel(
name='SpecialDay',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('description', models.CharField(max_length=200)),
('is_open', models.BooleanField(default=False)),
('from_date', models.DateField()),
('to_date', models.DateField(blank=True, null=True)),
('from_hour', models.TimeField(blank=True, null=True)),
('to_hour', models.TimeField(blank=True, null=True)),
('fridge',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='fridge.fridge')),
],
),
migrations.CreateModel(
name='Reservation',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('quantity', models.PositiveIntegerField()),
('food',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='fridge.food')),
('user',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='ReportContent',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('food',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='fridge.food')),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='OpeningHour',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('weekday',
models.PositiveSmallIntegerField(choices=[(0, 'Monday'),
(1, 'Tuesday'),
(2, 'Wednesday'),
(3, 'Thursday'),
(4, 'Friday'),
(5, 'Saturday'),
(6, 'Sunday')],
default=0)),
('from_hour', models.TimeField()),
('to_hour', models.TimeField()),
('fridge',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='fridge.fridge')),
],
),
migrations.CreateModel(
name='Inventory',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date', models.DateField()),
('product_name', models.CharField(max_length=45)),
('product_number', models.IntegerField()),
('temperature', models.FloatField()),
('visa', models.CharField(max_length=45)),
('fridge',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='fridge.fridge')),
],
),
migrations.CreateModel(
name='FridgeFollowing',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('fridge',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='fridge.fridge')),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.AddField(
model_name='food',
name='fridge',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='fridge.fridge'),
),
migrations.AddField(
model_name='food',
name='user',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('address', '0002_auto_20160213_1726'),
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('auth', '0011_update_proxy_permissions'),
]
operations = [
migrations.CreateModel(
name='CriticalDateType',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=50)),
('season_flag', models.BooleanField()),
('comment',
models.CharField(blank=True, max_length=200, null=True)),
('created_date',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date published')),
('created_by',
models.ForeignKey(default=django.contrib.auth.models.User,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Crop',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100, null=True)),
('dwu_formaula',
models.CharField(blank=True, max_length=100, null=True)),
('created_date',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date published')),
('created_by',
models.ForeignKey(default=django.contrib.auth.models.User,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Diviner',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('diviner_number', models.CharField(max_length=50)),
('comment',
models.CharField(blank=True, max_length=100, null=True)),
('created_date',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date published')),
('created_by',
models.ForeignKey(default=django.contrib.auth.models.User,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Document',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('description', models.CharField(blank=True, max_length=255)),
('document', models.FileField(upload_to='documents/')),
],
),
migrations.CreateModel(
name='Farm',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100)),
('owner', models.CharField(default='TEST', max_length=100)),
('comment',
models.CharField(blank=True, max_length=200, null=True)),
('landline',
models.CharField(blank=True, max_length=40, null=True)),
('mobile',
models.CharField(blank=True, max_length=40, null=True)),
('email',
models.EmailField(blank=True, max_length=254, null=True)),
('folder',
models.CharField(blank=True, max_length=100, null=True)),
('created_date',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date published')),
('address',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
to='address.Address')),
('created_by',
models.ForeignKey(default=django.contrib.auth.models.User,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Probe',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('serial_number',
models.CharField(default='Manual', max_length=100)),
('comment',
models.CharField(blank=True, max_length=200, null=True)),
('created_date',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date published')),
('created_by',
models.ForeignKey(default=django.contrib.auth.models.User,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='ReadingType',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100)),
('comment',
models.CharField(blank=True, max_length=200, null=True)),
('formula',
models.CharField(blank=True, max_length=200, null=True)),
('created_date',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date published')),
('created_by',
models.ForeignKey(default=django.contrib.auth.models.User,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Report',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100)),
('created_date',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date published')),
('created_by',
models.ForeignKey(default=django.contrib.auth.models.User,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Season',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=20)),
('current_flag',
models.BooleanField(
default=None,
help_text=
'Is this the current season, only one season can be the current season',
null=True)),
('created_date',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date published')),
('created_by',
models.ForeignKey(default=django.contrib.auth.models.User,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='UserFullName',
fields=[],
options={
'proxy': True,
'indexes': [],
'constraints': [],
},
bases=('auth.user', ),
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='SeasonStartEnd',
fields=[
('season',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
primary_key=True,
serialize=False,
to='skeleton.Season')),
('season_name', models.CharField(max_length=20)),
('site_name', models.CharField(max_length=100)),
('period_from', models.DateTimeField()),
('period_to', models.DateTimeField()),
],
options={
'db_table': 'skeleton_season_start_end',
'managed': False,
},
),
migrations.CreateModel(
name='WeatherStation',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100, null=True)),
('code', models.CharField(max_length=4, null=True)),
('region',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='address.State')),
],
),
migrations.CreateModel(
name='Variety',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100, null=True)),
('comment', models.TextField(blank=True, null=True)),
('created_date',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date published')),
('created_by',
models.ForeignKey(default=django.contrib.auth.models.User,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='StrategyType',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=50)),
('comment', models.TextField(blank=True, null=True)),
('created_date',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date published')),
('created_by',
models.ForeignKey(default=django.contrib.auth.models.User,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Strategy',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('days',
models.IntegerField(
help_text=
'A positive or negative number indicated the amount of days away from that critical date.'
)),
('percentage',
models.FloatField(
help_text=
'A number beween 1 and 0 indicating the variation from the limit associated with the strategy.'
)),
('comment', models.TextField(blank=True, null=True)),
('created_date',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date published')),
('created_by',
models.ForeignKey(default=django.contrib.auth.models.User,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
('critical_date_type',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='skeleton.CriticalDateType')),
('type',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='skeleton.StrategyType')),
],
),
migrations.CreateModel(
name='Site',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('site_number', models.CharField(max_length=20, unique=True)),
('selected', models.BooleanField(null=True)),
('name', models.CharField(max_length=100, null=True)),
('irrigation_method',
models.IntegerField(
choices=[(0, 'Non-Drip (Overhead)'), (1, 'Drip')],
default=1,
help_text=
'Are you sure you want to change this to Overhead?')),
('irrigation_area', models.FloatField(blank=True, null=True)),
('irrigation_time', models.FloatField(blank=True, null=True)),
('irrigation_delivered_volume',
models.FloatField(blank=True, null=True)),
('irrigation_position',
models.FloatField(
blank=True,
null=True,
verbose_name='Inline Water Meter Position in Trees')),
('irrigation_yield', models.FloatField(blank=True, null=True)),
('irrigation_allocation_volume',
models.FloatField(blank=True, null=True)),
('rz1_top', models.IntegerField(blank=True, null=True)),
('rz1_bottom', models.IntegerField(blank=True, null=True)),
('rz2_top', models.IntegerField(blank=True, null=True)),
('rz2_bottom', models.IntegerField(blank=True, null=True)),
('rz3_top', models.IntegerField(blank=True, null=True)),
('rz3_bottom', models.IntegerField(blank=True, null=True)),
('depth1', models.IntegerField(blank=True, null=True)),
('depth2', models.IntegerField(blank=True, null=True)),
('depth3', models.IntegerField(blank=True, null=True)),
('depth4', models.IntegerField(blank=True, null=True)),
('depth5', models.IntegerField(blank=True, null=True)),
('depth6', models.IntegerField(blank=True, null=True)),
('depth7', models.IntegerField(blank=True, null=True)),
('depth8', models.IntegerField(blank=True, null=True)),
('depth9', models.IntegerField(blank=True, null=True)),
('depth10', models.IntegerField(blank=True, null=True)),
('depth_he1', models.IntegerField(blank=True, null=True)),
('depth_he2', models.IntegerField(blank=True, null=True)),
('depth_he3', models.IntegerField(blank=True, null=True)),
('depth_he4', models.IntegerField(blank=True, null=True)),
('depth_he5', models.IntegerField(blank=True, null=True)),
('depth_he6', models.IntegerField(blank=True, null=True)),
('depth_he7', models.IntegerField(blank=True, null=True)),
('depth_he8', models.IntegerField(blank=True, null=True)),
('depth_he9', models.IntegerField(blank=True, null=True)),
('depth_he10', models.IntegerField(blank=True, null=True)),
('emitter_rate', models.FloatField(blank=True, null=True)),
('row_spacing',
models.IntegerField(blank=True,
null=True,
verbose_name='Row Spacing (cm)')),
('emitter_spacing',
models.IntegerField(blank=True,
null=True,
verbose_name='Emitter Spacing (cm)')),
('plant_spacing',
models.IntegerField(blank=True,
null=True,
verbose_name='Plant Spacing (cm)')),
('wetted_width',
models.IntegerField(blank=True,
null=True,
verbose_name='Wetted Width (cm)')),
('delivery_time',
models.IntegerField(blank=True,
null=True,
verbose_name='Deliver Time in Minutes')),
('area',
models.FloatField(blank=True,
null=True,
verbose_name='Area (Ha)')),
('comment', models.TextField(blank=True, null=True)),
('created_date',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date published')),
('created_by',
models.ForeignKey(default=django.contrib.auth.models.User,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
('crop',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='skeleton.Crop')),
('farm',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='skeleton.Farm')),
('lower_limit',
models.ForeignKey(blank=True,
help_text='Target Lower line for Graph',
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='lower_limit_type',
to='skeleton.ReadingType')),
('lower_strategy',
models.ForeignKey(
blank=True,
help_text=
'Strategy dictating deviance of Lower line for Graph',
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='lower_strategy_type',
to='skeleton.StrategyType')),
('report',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='skeleton.Report')),
('technician',
models.ForeignKey(default=1,
on_delete=django.db.models.deletion.CASCADE,
related_name='technician_id',
to=settings.AUTH_USER_MODEL)),
('upper_limit',
models.ForeignKey(blank=True,
help_text='Target Upper line for Graph',
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='upper_limit_type',
to='skeleton.ReadingType')),
('upper_strategy',
models.ForeignKey(
blank=True,
help_text=
'Strategy dictating deviance of Upper line for Graph',
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='upper_strategy_type',
to='skeleton.StrategyType')),
],
),
migrations.CreateModel(
name='ProbeDiviner',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created_date',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date published')),
('created_by',
models.ForeignKey(default=django.contrib.auth.models.User,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
('diviner',
models.ForeignKey(blank=True,
on_delete=django.db.models.deletion.CASCADE,
to='skeleton.Diviner')),
('probe',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='skeleton.Probe')),
],
),
migrations.CreateModel(
name='KCReading',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('period_from',
models.DateField(default=django.utils.timezone.now)),
('period_to',
models.DateField(default=django.utils.timezone.now)),
('kc', models.FloatField(blank=True, null=True)),
('created_date',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date published')),
('created_by',
models.ForeignKey(default=django.contrib.auth.models.User,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
('crop',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='skeleton.Crop')),
],
),
migrations.AddField(
model_name='farm',
name='report',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='skeleton.Report'),
),
migrations.AddField(
model_name='farm',
name='weatherstation',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='skeleton.WeatherStation'),
),
migrations.CreateModel(
name='ETReading',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date', models.DateField(default=django.utils.timezone.now)),
('weekly', models.FloatField(blank=True, null=True)),
('daily', models.FloatField(blank=True, null=True)),
('created_date',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date published')),
('created_by',
models.ForeignKey(default=django.contrib.auth.models.User,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
('state',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='address.State')),
],
),
migrations.AddField(
model_name='diviner',
name='site',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='skeleton.Site'),
),
migrations.AddField(
model_name='crop',
name='report',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='skeleton.Report'),
),
migrations.AddField(
model_name='crop',
name='variety',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='skeleton.Variety'),
),
migrations.CreateModel(
name='Calibration',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('soil_type', models.IntegerField(blank=True, null=True)),
('period_from',
models.DateField(default=django.utils.timezone.now)),
('period_to', models.DateField(blank=True, null=True)),
('slope', models.FloatField(blank=True, null=True)),
('intercept', models.FloatField(blank=True, null=True)),
('created_date',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date published')),
('created_by',
models.ForeignKey(default=django.contrib.auth.models.User,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
('serial_number',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='skeleton.Probe')),
],
),
migrations.CreateModel(
name='SiteDescription',
fields=[],
options={
'proxy': True,
'indexes': [],
'constraints': [],
},
bases=('skeleton.site', ),
),
migrations.CreateModel(
name='Reading',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date', models.DateField(default=django.utils.timezone.now)),
('depth1',
models.FloatField(blank=True,
null=True,
verbose_name='Depth1 VSW/Normal')),
('depth2',
models.FloatField(blank=True,
null=True,
verbose_name='Depth1 VSW/Normal')),
('depth3',
models.FloatField(blank=True,
null=True,
verbose_name='Depth3 VSW/Normal')),
('depth4',
models.FloatField(blank=True,
null=True,
verbose_name='Depth4 VSW/Normal')),
('depth5',
models.FloatField(blank=True,
null=True,
verbose_name='Depth5 VSW/Normal')),
('depth6',
models.FloatField(blank=True,
null=True,
verbose_name='Depth6 VSW/Normal')),
('depth7',
models.FloatField(blank=True,
null=True,
verbose_name='Depth7 VSW/Normal')),
('depth8',
models.FloatField(blank=True,
null=True,
verbose_name='Depth8 VSW/Normal')),
('depth9',
models.FloatField(blank=True,
null=True,
verbose_name='Depth9 VSW/Normal')),
('depth10',
models.FloatField(blank=True,
null=True,
verbose_name='Depth10 VSW/Normal')),
('depth1_count', models.FloatField(blank=True, null=True)),
('depth2_count', models.FloatField(blank=True, null=True)),
('depth3_count', models.FloatField(blank=True, null=True)),
('depth4_count', models.FloatField(blank=True, null=True)),
('depth5_count', models.FloatField(blank=True, null=True)),
('depth6_count', models.FloatField(blank=True, null=True)),
('depth7_count', models.FloatField(blank=True, null=True)),
('depth8_count', models.FloatField(blank=True, null=True)),
('depth9_count', models.FloatField(blank=True, null=True)),
('depth10_count', models.FloatField(blank=True, null=True)),
('rz1',
models.FloatField(blank=True,
null=True,
verbose_name='Root Zone 1')),
('rz2',
models.FloatField(blank=True,
null=True,
verbose_name='Root Zone 2')),
('rz3',
models.FloatField(blank=True,
null=True,
verbose_name='Root Zone 3')),
('deficit',
models.FloatField(
blank=True,
help_text=
'Deficit is the difference between the full point reading and root zone 1',
null=True)),
('probe_dwu',
models.FloatField(
blank=True,
help_text=
'PDWU is the rate of change of the water content of root zone 1, expressed in mm/day',
null=True,
verbose_name='Probe Daily Water Use')),
('estimated_dwu',
models.FloatField(
blank=True,
help_text=
'EDWU is KC Reading for crop multiplied by ET reading for region',
null=True,
verbose_name='Estimated Daily Water Use')),
('rain',
models.FloatField(blank=True,
help_text='Rainfall reding',
null=True)),
('meter',
models.FloatField(
blank=True,
help_text='Meter reading',
null=True,
verbose_name='Inline Water Meter in Litres')),
('irrigation_litres',
models.FloatField(
blank=True,
help_text=
'Difference in Meter readings multipled by the Irrigation Postion',
null=True,
verbose_name='Irrigation in Litres')),
('irrigation_mms',
models.FloatField(
blank=True,
help_text=
'Irrigation in Litres divided by Schedule Rowspace and Schedule Plantspace divided by 10000',
null=True,
verbose_name='Irrigation in Millimetres')),
('effective_rain_1',
models.FloatField(blank=True,
help_text='keydata 5 - Well Complicated',
null=True)),
('effective_rainfall',
models.FloatField(blank=True,
help_text='keydata 6',
null=True)),
('efflrr1',
models.FloatField(blank=True,
help_text='keydata 7',
null=True)),
('efflrr2',
models.FloatField(blank=True,
help_text='keydata 8',
null=True)),
('effective_irrigation',
models.FloatField(blank=True,
help_text='keydata 9',
null=True)),
('comment', models.TextField(blank=True, null=True)),
('created_date',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date published')),
('created_by',
models.ForeignKey(default=django.contrib.auth.models.User,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
('serial_number',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='skeleton.Probe')),
('site',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='readings',
to='skeleton.Site')),
('type',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='skeleton.ReadingType')),
],
options={
'unique_together': {('date', 'site', 'type')},
},
),
migrations.AlterUniqueTogether(
name='crop',
unique_together={('name', 'variety')},
),
migrations.CreateModel(
name='CriticalDate',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date', models.DateField(default=django.utils.timezone.now)),
('comment',
models.CharField(blank=True, max_length=200, null=True)),
('created_date',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date published')),
('created_by',
models.ForeignKey(default=django.contrib.auth.models.User,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
('season',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='seasons',
to='skeleton.Season')),
('site',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='sites',
to='skeleton.Site')),
('type',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='critical_date_types',
to='skeleton.CriticalDateType')),
],
options={
'unique_together': {('site', 'season', 'type')},
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0011_update_proxy_permissions'),
]
operations = [
migrations.CreateModel(
name='Users',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('username',
models.CharField(
error_messages={
'unique': 'A user with that username already exists.'
},
help_text=
'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
max_length=150,
unique=True,
validators=[
django.contrib.auth.validators.
UnicodeUsernameValidator()
],
verbose_name='username')),
('first_name',
models.CharField(blank=True,
max_length=30,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=150,
verbose_name='last name')),
('email',
models.EmailField(blank=True,
max_length=254,
verbose_name='email address')),
('is_staff',
models.BooleanField(
default=False,
help_text=
'Designates whether the user can log into this admin site.',
verbose_name='staff status')),
('is_active',
models.BooleanField(
default=True,
help_text=
'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
verbose_name='active')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('groups',
models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='College',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=255)),
],
),
migrations.CreateModel(
name='Faculties',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=255)),
('college',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='public.College')),
],
),
migrations.CreateModel(
name='Major',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=63)),
('faculty',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='public.Faculties')),
],
),
migrations.CreateModel(
name='Role',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('role',
models.CharField(choices=[('Student', 'Role1'),
('Teacher', 'Role2'),
('DepartmentHead', 'Role3'),
('FacultyTrainingStaff', 'Role4'),
('UniversityTrainingStaff',
'Role5'),
('InternshipHead', 'Role6')],
max_length=31)),
],
),
migrations.CreateModel(
name='Student',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('credits', models.IntegerField()),
('average', models.FloatField()),
('studentNumber', models.CharField(max_length=9)),
('phone', models.CharField(max_length=11)),
('nationalCode', models.CharField(max_length=10)),
('major',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='public.Major')),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Department',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=255)),
('faculty',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='public.Faculties')),
],
),
migrations.AddField(
model_name='users',
name='role',
field=models.ManyToManyField(to='public.Role'),
),
migrations.AddField(
model_name='users',
name='user_permissions',
field=models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0011_update_proxy_permissions'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('first_name',
models.CharField(blank=True,
max_length=30,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=150,
verbose_name='last name')),
('is_staff',
models.BooleanField(
default=False,
help_text=
'Designates whether the user can log into this admin site.',
verbose_name='staff status')),
('is_active',
models.BooleanField(
default=True,
help_text=
'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
verbose_name='active')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('registration_number',
models.CharField(max_length=25,
unique=True,
verbose_name='registration number')),
('email',
models.EmailField(max_length=254,
unique=True,
verbose_name='email address')),
('is_teacher',
models.BooleanField(default=False,
verbose_name='is teacher')),
('is_student',
models.BooleanField(default=False,
verbose_name='is student')),
('groups',
models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups')),
('user_permissions',
models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions')),
],
options={
'db_table': 'users',
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Activity',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=250)),
('description', models.CharField(max_length=250)),
('create_at', models.DateTimeField(auto_now_add=True)),
('update_at', models.DateTimeField(auto_now=True)),
],
options={
'db_table': 'activity',
},
),
migrations.CreateModel(
name='Class',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=200)),
('description', models.TextField(blank=True, null=True)),
('created_at',
models.DateTimeField(auto_now_add=True,
verbose_name='created_at')),
('modified_at',
models.DateTimeField(auto_now=True,
verbose_name='modified_at')),
],
options={
'db_table': 'class',
},
),
migrations.CreateModel(
name='Institution',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=250,
verbose_name='name')),
('description',
models.TextField(blank=True,
null=True,
verbose_name='description')),
('created_at',
models.DateTimeField(auto_now_add=True,
verbose_name='created_at')),
('modified_at',
models.DateTimeField(auto_now=True,
verbose_name='modified_at')),
],
options={
'db_table': 'institution',
},
),
migrations.CreateModel(
name='Location',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=250)),
('description', models.TextField(blank=True, null=True)),
('latitude', models.FloatField()),
('longitude', models.FloatField()),
('create_at', models.DateTimeField(auto_now_add=True)),
('update_at', models.DateTimeField(auto_now=True)),
],
options={
'db_table': 'location',
},
),
migrations.CreateModel(
name='Teacher',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('cpf',
models.CharField(max_length=100,
unique=True,
verbose_name='cpf')),
('full_name',
models.CharField(blank=True,
max_length=250,
null=True,
verbose_name='full name')),
('description',
models.TextField(blank=True,
null=True,
verbose_name='description')),
('created_at',
models.DateTimeField(auto_now_add=True,
verbose_name='created at')),
('modified_at',
models.DateTimeField(auto_now=True,
verbose_name='modified at')),
('institution',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='teachers',
to='accounts.Institution')),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name='teacher',
to=settings.AUTH_USER_MODEL)),
],
options={
'db_table': 'teacher',
},
),
migrations.CreateModel(
name='Student',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('cpf',
models.CharField(max_length=100,
unique=True,
verbose_name='cpf')),
('full_name',
models.CharField(blank=True,
max_length=250,
null=True,
verbose_name='full name')),
('description',
models.TextField(blank=True,
null=True,
verbose_name='description')),
('created_at',
models.DateTimeField(auto_now_add=True,
verbose_name='created at')),
('modified_at',
models.DateTimeField(auto_now=True,
verbose_name='modified at')),
('class_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='students',
to='accounts.Class')),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
related_name='student',
to=settings.AUTH_USER_MODEL)),
],
options={
'db_table': 'student',
},
),
migrations.CreateModel(
name='Program',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=200,
verbose_name='name')),
('description',
models.TextField(blank=True,
null=True,
verbose_name='description')),
('created_at',
models.DateTimeField(auto_now_add=True,
verbose_name='created_at')),
('modified_at',
models.DateTimeField(auto_now=True,
verbose_name='modified_at')),
('institution',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='accounts.Institution')),
],
options={
'db_table': 'program',
},
),
migrations.CreateModel(
name='Course',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=200,
verbose_name='name')),
('description',
models.TextField(blank=True,
null=True,
verbose_name='description')),
('created_at',
models.DateTimeField(auto_now_add=True,
verbose_name='created_at')),
('modified_at',
models.DateTimeField(auto_now=True,
verbose_name='modified_at')),
('class_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='courses',
to='accounts.Class')),
('program',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='courses',
to='accounts.Program')),
('teacher',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='courses',
to='accounts.Teacher')),
],
options={
'db_table': 'course',
},
),
migrations.CreateModel(
name='Content',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=250)),
('description', models.CharField(max_length=250)),
('create_at', models.DateTimeField(auto_now_add=True)),
('update_at', models.DateTimeField(auto_now=True)),
('course',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='contents',
to='accounts.Course')),
('teacher',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='contents',
to='accounts.Teacher')),
],
options={
'db_table': 'content',
},
),
migrations.AddField(
model_name='class',
name='program',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='classes',
to='accounts.Program'),
),
migrations.CreateModel(
name='Address',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('state', models.CharField(max_length=2,
verbose_name='state')),
('city', models.CharField(max_length=100,
verbose_name='city')),
('street',
models.CharField(max_length=250, verbose_name='street')),
('neighborhood',
models.CharField(max_length=100,
verbose_name='neighborhood')),
('number', models.IntegerField(verbose_name='number')),
('postal_code',
models.CharField(max_length=250, verbose_name='postal_code')),
('complement',
models.CharField(blank=True,
max_length=250,
null=True,
verbose_name='complement')),
('created_at',
models.DateTimeField(auto_now_add=True,
verbose_name='created_at')),
('modified_at',
models.DateTimeField(auto_now=True,
verbose_name='modified_at')),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='addresses',
to=settings.AUTH_USER_MODEL)),
],
options={
'db_table': 'address',
},
),
migrations.CreateModel(
name='ActivityAnswer',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('google_drive_file_key', models.CharField(max_length=200)),
('activity',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='answers',
to='accounts.Activity')),
('student',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='answers',
to='accounts.Student')),
],
options={
'db_table': 'activity_answer',
},
),
migrations.AddField(
model_name='activity',
name='content',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='activities',
to='accounts.Content'),
),
migrations.AddField(
model_name='activity',
name='location',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='activities',
to='accounts.Teacher'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0009_alter_user_last_name_max_length'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('username',
models.CharField(
error_messages={
'unique': 'A user with that username already exists.'
},
help_text=
'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.',
max_length=150,
unique=True,
validators=[
django.contrib.auth.validators.
UnicodeUsernameValidator()
],
verbose_name='username')),
('first_name',
models.CharField(blank=True,
max_length=30,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=150,
verbose_name='last name')),
('email',
models.EmailField(blank=True,
max_length=254,
verbose_name='email address')),
('is_staff',
models.BooleanField(
default=False,
help_text=
'Designates whether the user can log into this admin site.',
verbose_name='staff status')),
('is_active',
models.BooleanField(
default=True,
help_text=
'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
verbose_name='active')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('upload', models.ImageField(upload_to='uploads/%Y/%m/%d/')),
('groups',
models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups')),
('user_permissions',
models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Account',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('update_time', models.DateField()),
('currency', models.CharField(max_length=3)),
('balance', models.FloatField()),
],
),
migrations.CreateModel(
name='Client',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('full_name', models.CharField(max_length=30)),
('login', models.CharField(max_length=20)),
('birthday', models.DateField()),
('contract_number', models.CharField(max_length=10)),
('date_conclusion', models.DateField()),
('tel', models.CharField(max_length=12)),
('address', models.CharField(max_length=100)),
],
),
migrations.CreateModel(
name='History_of_changes',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('old_balance', models.FloatField()),
('new_balance', models.FloatField()),
('reason', models.CharField(max_length=30)),
('update_time', models.DateField()),
('acc_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='bs.Account')),
],
),
migrations.CreateModel(
name='Rate',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('source_currency', models.CharField(max_length=3)),
('final_currency', models.CharField(max_length=3)),
('cost', models.FloatField()),
('update', models.DateField()),
],
),
migrations.CreateModel(
name='Transfer',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('tr_date', models.DateField()),
('source_currency', models.CharField(max_length=3)),
('source_sum', models.FloatField()),
('final_currency', models.CharField(max_length=3)),
('final_sum', models.FloatField()),
('final_his_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='final_his_id',
to='bs.History_of_changes')),
('source_his_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='source_his_id',
to='bs.History_of_changes')),
],
),
migrations.AddField(
model_name='account',
name='cl_id',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE, to='bs.Client'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0011_update_proxy_permissions'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('password', models.CharField(max_length=128, verbose_name='password')),
('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')),
('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')),
('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')),
('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')),
('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')),
('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')),
('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')),
('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')),
('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')),
('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')),
('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='AuctionListings',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=64)),
('description', models.CharField(max_length=64)),
('initialBid', models.FloatField(max_length=6)),
('image', models.ImageField(default='/static/auctions/default_image.jpg', null=True, upload_to='auctions/static/auctions')),
('category', models.CharField(max_length=64)),
('auctioner', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Watchlist',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('lotList', models.ManyToManyField(blank=True, to='auctions.AuctionListings')),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Comments',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('comments', models.TextField(max_length=64)),
('listing', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='listingComment', to='auctions.AuctionListings')),
('userComment', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='usercomment', to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Bids',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('bid', models.FloatField(max_length=6)),
('holder', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='bidHolder', to=settings.AUTH_USER_MODEL)),
('lot', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='bidLot', to='auctions.AuctionListings')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('contenttypes', '0002_remove_content_type_name'),
('auth', '0008_alter_user_username_max_length'),
]
operations = [
migrations.CreateModel(
name='UserInfo',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')),
('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')),
('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')),
('last_name', models.CharField(blank=True, max_length=30, verbose_name='last name')),
('username', models.CharField(max_length=64, unique=True, verbose_name='\u7528\u6237\u540d')),
('email', models.EmailField(blank=True, max_length=255, null=True, unique=True, verbose_name='email address')),
('uid', models.CharField(max_length=64, unique=True)),
('mobile', models.BigIntegerField(help_text='\u7528\u4e8e\u624b\u673a\u9a8c\u8bc1\u7801\u767b\u5f55', null=True, unique=True, verbose_name='\u624b\u673a')),
('qq', models.CharField(blank=True, db_index=True, max_length=64, null=True, verbose_name='QQ')),
('weixin', models.CharField(blank=True, db_index=True, max_length=128, null=True, verbose_name='\u5fae\u4fe1')),
('signature', models.CharField(blank=True, max_length=255, null=True, verbose_name='\u4e2a\u4eba\u7b7e\u540d')),
('brief', models.TextField(blank=True, null=True, verbose_name='\u4e2a\u4eba\u4ecb\u7ecd')),
('openid', models.CharField(blank=True, max_length=128, null=True)),
('alipay_card', models.CharField(blank=True, max_length=128, null=True, verbose_name='\u652f\u4ed8\u5b9d\u8d26\u6237')),
('gender', models.SmallIntegerField(choices=[(0, '\u4fdd\u5bc6'), (1, '\u7537'), (2, '\u5973')], default=0, verbose_name='\u6027\u522b')),
('id_card', models.CharField(blank=True, max_length=32, null=True, verbose_name='\u8eab\u4efd\u8bc1\u53f7\u6216\u62a4\u7167\u53f7')),
('password', models.CharField(help_text="<a class='btn-link' href='password'>\u91cd\u7f6e\u5bc6\u7801</a>", max_length=128, verbose_name='password')),
('is_active', models.BooleanField(default=True, verbose_name='\u8d26\u6237\u72b6\u6001')),
('is_staff', models.BooleanField(default=False, help_text='\u51b3\u5b9a\u7740\u7528\u6237\u662f\u5426\u53ef\u767b\u5f55\u7ba1\u7406\u540e\u53f0', verbose_name='staff status')),
('name', models.CharField(default='', max_length=32, verbose_name='\u771f\u5b9e\u59d3\u540d')),
('head_img', models.CharField(default='/static/frontend/head_portrait/[email protected]', max_length=256, verbose_name='\u4e2a\u4eba\u5934\u50cf')),
('role', models.SmallIntegerField(choices=[(0, '\u5b66\u5458'), (1, '\u5bfc\u5e08'), (2, '\u8bb2\u5e08'), (3, '\u7ba1\u7406\u5458'), (4, '\u73ed\u4e3b\u4efb'), (5, '\u7ebf\u4e0b\u73ed\u4e3b\u4efb')], default=0, verbose_name='\u89d2\u8272')),
('memo', models.TextField(blank=True, default=None, help_text='json\u683c\u5f0f\u5b58\u50a8', null=True, verbose_name='\u5907\u6ce8')),
('date_joined', models.DateTimeField(auto_now_add=True, verbose_name='\u6ce8\u518c\u65f6\u95f4')),
('beli', models.IntegerField(default=1000)),
('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')),
('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')),
],
options={
'verbose_name': '\u7528\u6237\u4fe1\u606f',
'verbose_name_plural': '\u7528\u6237\u4fe1\u606f',
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Coupon',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=64, verbose_name='\u6d3b\u52a8\u540d\u79f0')),
('brief', models.TextField(blank=True, null=True, verbose_name='\u4f18\u60e0\u5238\u4ecb\u7ecd')),
('coupon_type', models.SmallIntegerField(choices=[(0, '\u7acb\u51cf\u5238'), (1, '\u6ee1\u51cf\u5238'), (2, '\u6298\u6263\u5238')], default=0, verbose_name='\u5238\u7c7b\u578b')),
('money_equivalent_value', models.FloatField(blank=True, null=True, verbose_name='\u7b49\u503c\u8d27\u5e01')),
('off_percent', models.PositiveSmallIntegerField(blank=True, help_text='\u53ea\u9488\u5bf9\u6298\u6263\u5238\uff0c\u4f8b7.9\u6298\uff0c\u519979', null=True, verbose_name='\u6298\u6263\u767e\u5206\u6bd4')),
('minimum_consume', models.PositiveIntegerField(default=0, help_text='\u4ec5\u5728\u6ee1\u51cf\u5238\u65f6\u586b\u5199\u6b64\u5b57\u6bb5', verbose_name='\u6700\u4f4e\u6d88\u8d39')),
('object_id', models.PositiveIntegerField(blank=True, help_text='\u53ef\u4ee5\u628a\u4f18\u60e0\u5238\u8ddf\u8bfe\u7a0b\u7ed1\u5b9a', null=True, verbose_name='\u7ed1\u5b9a\u8bfe\u7a0b')),
('quantity', models.PositiveIntegerField(default=1, verbose_name='\u6570\u91cf(\u5f20)')),
('open_date', models.DateField(verbose_name='\u4f18\u60e0\u5238\u9886\u53d6\u5f00\u59cb\u65f6\u95f4')),
('close_date', models.DateField(verbose_name='\u4f18\u60e0\u5238\u9886\u53d6\u7ed3\u675f\u65f6\u95f4')),
('valid_begin_date', models.DateField(blank=True, null=True, verbose_name='\u6709\u6548\u671f\u5f00\u59cb\u65f6\u95f4')),
('valid_end_date', models.DateField(blank=True, null=True, verbose_name='\u6709\u6548\u7ed3\u675f\u65f6\u95f4')),
('coupon_valid_days', models.PositiveIntegerField(blank=True, help_text='\u81ea\u5238\u88ab\u9886\u65f6\u5f00\u59cb\u7b97\u8d77', null=True, verbose_name='\u4f18\u60e0\u5238\u6709\u6548\u671f\uff08\u5929\uff09')),
('status', models.SmallIntegerField(choices=[(0, '\u4e0a\u7ebf'), (1, '\u4e0b\u7ebf')], default=0)),
('date', models.DateTimeField(auto_now_add=True)),
('content_type', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='contenttypes.ContentType')),
],
),
migrations.CreateModel(
name='CouponRecord',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('status', models.SmallIntegerField(choices=[(0, '\u672a\u4f7f\u7528'), (1, '\u5df2\u4f7f\u7528'), (2, '\u5df2\u8fc7\u671f'), (3, '\u672a\u9886\u53d6')], default=0)),
('get_time', models.DateTimeField(blank=True, help_text='\u7528\u6237\u9886\u53d6\u65f6\u95f4', null=True, verbose_name='\u9886\u53d6\u65f6\u95f4')),
('used_time', models.DateTimeField(blank=True, null=True, verbose_name='\u4f7f\u7528\u65f6\u95f4')),
('date', models.DateTimeField(auto_now_add=True, verbose_name='\u751f\u6210\u65f6\u95f4')),
('account', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL, verbose_name='\u4f7f\u7528\u8005')),
('coupon', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.Coupon')),
],
),
migrations.CreateModel(
name='Course',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=128, unique=True, verbose_name='\u6a21\u5757')),
('course_img', models.CharField(max_length=255)),
('course_type', models.SmallIntegerField(choices=[(0, '\u4ed8\u8d39'), (1, 'VIP\u4e13\u4eab'), (2, '\u5b66\u4f4d\u8bfe\u7a0b')])),
('brief', models.TextField(max_length=2048, verbose_name='\u8bfe\u7a0b\u6982\u8ff0')),
('level', models.SmallIntegerField(choices=[(0, '\u521d\u7ea7'), (1, '\u4e2d\u7ea7'), (2, '\u9ad8\u7ea7')], default=1)),
('pub_date', models.DateField(blank=True, null=True, verbose_name='\u53d1\u5e03\u65e5\u671f')),
('period', models.PositiveIntegerField(default=7, verbose_name='\u5efa\u8bae\u5b66\u4e60\u5468\u671f(days)')),
('order', models.IntegerField(help_text='\u4ece\u4e0a\u4e00\u4e2a\u8bfe\u7a0b\u6570\u5b57\u5f80\u540e\u6392', verbose_name='\u8bfe\u7a0b\u987a\u5e8f')),
('attachment_path', models.CharField(blank=True, max_length=128, null=True, verbose_name='\u8bfe\u4ef6\u8def\u5f84')),
('status', models.SmallIntegerField(choices=[(0, '\u4e0a\u7ebf'), (1, '\u4e0b\u7ebf'), (2, '\u9884\u4e0a\u7ebf')], default=0)),
],
),
migrations.CreateModel(
name='CourseChapter',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('chapter', models.SmallIntegerField(default=1, verbose_name='\u7b2c\u51e0\u7ae0')),
('name', models.CharField(max_length=128)),
('summary', models.TextField(blank=True, null=True, verbose_name='\u7ae0\u8282\u4ecb\u7ecd')),
('is_create', models.BooleanField(default=True, verbose_name='\u662f\u5426\u521b\u5efa\u9898\u5e93\u8fdb\u5ea6')),
('pub_date', models.DateTimeField(auto_now_add=True, verbose_name='\u53d1\u5e03\u65e5\u671f')),
('course', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='coursechapters', to='api.Course')),
],
),
migrations.CreateModel(
name='CourseDetail',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('hours', models.IntegerField(verbose_name='\u8bfe\u65f6')),
('course_slogan', models.CharField(blank=True, max_length=125, null=True)),
('video_brief_link', models.CharField(blank=True, max_length=255, null=True)),
('why_study', models.TextField(verbose_name='\u4e3a\u4ec0\u4e48\u5b66\u4e60\u8fd9\u95e8\u8bfe\u7a0b')),
('what_to_study_brief', models.TextField(verbose_name='\u6211\u5c06\u5b66\u5230\u54ea\u4e9b\u5185\u5bb9')),
('career_improvement', models.TextField(verbose_name='\u6b64\u9879\u76ee\u5982\u4f55\u6709\u52a9\u4e8e\u6211\u7684\u804c\u4e1a\u751f\u6daf')),
('prerequisite', models.TextField(max_length=1024, verbose_name='\u8bfe\u7a0b\u5148\u4fee\u8981\u6c42')),
('course', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to='api.Course')),
('recommend_courses', models.ManyToManyField(blank=True, related_name='recommend_by', to='api.Course')),
],
),
migrations.CreateModel(
name='CourseSection',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=128)),
('order', models.PositiveSmallIntegerField(help_text='\u5efa\u8bae\u6bcf\u4e2a\u8bfe\u65f6\u4e4b\u95f4\u7a7a1\u81f32\u4e2a\u503c\uff0c\u4ee5\u5907\u540e\u7eed\u63d2\u5165\u8bfe\u65f6', verbose_name='\u8bfe\u65f6\u6392\u5e8f')),
('section_type', models.SmallIntegerField(choices=[(0, '\u6587\u6863'), (1, '\u7ec3\u4e60'), (2, '\u89c6\u9891')], default=2)),
('section_link', models.CharField(blank=True, help_text='\u82e5\u662fvideo\uff0c\u586bvid,\u82e5\u662f\u6587\u6863\uff0c\u586blink', max_length=255, null=True)),
('video_time', models.CharField(blank=True, max_length=32, null=True, verbose_name='\u89c6\u9891\u65f6\u957f')),
('pub_date', models.DateTimeField(auto_now_add=True, verbose_name='\u53d1\u5e03\u65f6\u95f4')),
('free_trail', models.BooleanField(default=False, verbose_name='\u662f\u5426\u53ef\u8bd5\u770b')),
('is_flash', models.BooleanField(default=False, verbose_name='\u662f\u5426\u4f7f\u7528FLASH\u64ad\u653e')),
('player', models.SmallIntegerField(choices=[(0, 'CC'), (1, 'POLYV'), (2, 'ALI')], default=1, help_text='\u89c6\u9891\u64ad\u653e\u5668\u9009\u62e9')),
('chapter', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='coursesection', to='api.CourseChapter')),
],
),
migrations.CreateModel(
name='OftenAskedQuestion',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('object_id', models.PositiveIntegerField()),
('question', models.CharField(max_length=255)),
('answer', models.TextField(max_length=1024)),
('content_type', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='contenttypes.ContentType')),
],
options={
'verbose_name_plural': '\u5e38\u89c1\u95ee\u9898',
},
),
migrations.CreateModel(
name='Order',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('payment_type', models.SmallIntegerField(choices=[(0, '\u5fae\u4fe1'), (1, '\u652f\u4ed8\u5b9d'), (2, '\u4f18\u60e0\u7801'), (3, '\u8d1d\u91cc'), (4, '\u94f6\u8054')])),
('payment_number', models.CharField(blank=True, max_length=128, null=True, verbose_name='\u652f\u4ed8\u7b2c3\u65b9\u8ba2\u5355\u53f7')),
('order_number', models.CharField(max_length=128, unique=True, verbose_name='\u8ba2\u5355\u53f7')),
('actual_amount', models.FloatField(verbose_name='\u5b9e\u4ed8\u91d1\u989d')),
('status', models.SmallIntegerField(choices=[(0, '\u4ea4\u6613\u6210\u529f'), (1, '\u5f85\u652f\u4ed8'), (2, '\u9000\u8d39\u7533\u8bf7\u4e2d'), (3, '\u5df2\u9000\u8d39'), (4, '\u4e3b\u52a8\u53d6\u6d88'), (5, '\u8d85\u65f6\u53d6\u6d88')], verbose_name='\u72b6\u6001')),
('order_type', models.SmallIntegerField(choices=[(0, '\u7528\u6237\u4e0b\u5355'), (1, '\u7ebf\u4e0b\u73ed\u521b\u5efa')], default=0, verbose_name='\u8ba2\u5355\u7c7b\u578b')),
('date', models.DateTimeField(auto_now_add=True, verbose_name='\u8ba2\u5355\u751f\u6210\u65f6\u95f4')),
('pay_time', models.DateTimeField(blank=True, null=True, verbose_name='\u4ed8\u6b3e\u65f6\u95f4')),
('cancel_time', models.DateTimeField(blank=True, null=True, verbose_name='\u8ba2\u5355\u53d6\u6d88\u65f6\u95f4')),
('account', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='OrderDetail',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('object_id', models.PositiveIntegerField()),
('original_price', models.FloatField(verbose_name='\u8bfe\u7a0b\u539f\u4ef7')),
('price', models.FloatField(verbose_name='\u6298\u540e\u4ef7\u683c')),
('content', models.CharField(blank=True, max_length=255, null=True)),
('valid_period_display', models.CharField(max_length=32, verbose_name='\u6709\u6548\u671f\u663e\u793a')),
('valid_period', models.PositiveIntegerField(verbose_name='\u6709\u6548\u671f(days)')),
('memo', models.CharField(blank=True, max_length=255, null=True)),
('content_type', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='contenttypes.ContentType')),
('order', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.Order')),
],
),
migrations.CreateModel(
name='PricePolicy',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('object_id', models.PositiveIntegerField()),
('valid_period', models.SmallIntegerField(choices=[(1, '1\u5929'), (3, '3\u5929'), (7, '1\u5468'), (14, '2\u5468'), (30, '1\u4e2a\u6708'), (60, '2\u4e2a\u6708'), (90, '3\u4e2a\u6708'), (120, '4\u4e2a\u6708'), (180, '6\u4e2a\u6708'), (210, '12\u4e2a\u6708'), (540, '18\u4e2a\u6708'), (720, '24\u4e2a\u6708'), (722, '24\u4e2a\u6708'), (723, '24\u4e2a\u6708')])),
('price', models.FloatField()),
('content_type', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='contenttypes.ContentType')),
],
),
migrations.CreateModel(
name='Teacher',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=32)),
('role', models.SmallIntegerField(choices=[(0, '\u8bb2\u5e08'), (1, '\u5bfc\u5e08')], default=0)),
('title', models.CharField(max_length=64, verbose_name='\u804c\u4f4d\u3001\u804c\u79f0')),
('signature', models.CharField(blank=True, help_text='\u5bfc\u5e08\u7b7e\u540d', max_length=255, null=True)),
('image', models.CharField(max_length=128)),
('brief', models.TextField(max_length=1024)),
],
),
migrations.CreateModel(
name='Token',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('key', models.CharField(max_length=40)),
('created', models.DateTimeField(auto_now_add=True, verbose_name='\u521b\u5efa\u65f6\u95f4')),
('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='auth_token', to=settings.AUTH_USER_MODEL, verbose_name='\u5173\u8054\u7528\u6237')),
],
),
migrations.AddField(
model_name='coursedetail',
name='teachers',
field=models.ManyToManyField(to='api.Teacher', verbose_name='\u8bfe\u7a0b\u8bb2\u5e08'),
),
migrations.AddField(
model_name='couponrecord',
name='order',
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='api.Order', verbose_name='\u5173\u8054\u8ba2\u5355'),
),
migrations.AlterUniqueTogether(
name='pricepolicy',
unique_together=set([('content_type', 'object_id', 'valid_period')]),
),
migrations.AlterUniqueTogether(
name='orderdetail',
unique_together=set([('order', 'content_type', 'object_id')]),
),
migrations.AlterUniqueTogether(
name='oftenaskedquestion',
unique_together=set([('content_type', 'object_id', 'question')]),
),
migrations.AlterUniqueTogether(
name='coursesection',
unique_together=set([('chapter', 'section_link')]),
),
migrations.AlterUniqueTogether(
name='coursechapter',
unique_together=set([('course', 'chapter')]),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('auth', '0009_alter_user_last_name_max_length'),
]
operations = [
migrations.CreateModel(
name='FoodDispenserAction',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('time', models.DateTimeField()),
('cups', models.FloatField(default=0)),
('command', models.PositiveIntegerField(default=2)),
],
),
migrations.CreateModel(
name='Pet',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('chip_id', models.BigIntegerField()),
('pet_type',
models.CharField(blank=True, default='', max_length=30)),
('pet_breed',
models.CharField(blank=True, default='', max_length=30)),
('name', models.CharField(blank=True,
default='',
max_length=30)),
('birthday', models.DateField(blank=True, default=None)),
],
),
migrations.CreateModel(
name='PetConsumptionAction',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('time', models.DateTimeField()),
('mass', models.PositiveIntegerField(default=0)),
],
),
migrations.CreateModel(
name='PetFeeder',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('serial_id', models.CharField(max_length=36, unique=True)),
('setting_cup', models.PositiveIntegerField(default=0)),
('setting_interval', models.PositiveIntegerField(default=0)),
('setting_closure', models.BooleanField(default=False)),
],
),
migrations.CreateModel(
name='PetFood',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=50)),
('calories_serving', models.PositiveIntegerField(default=0)),
('cups_serving', models.FloatField(default=0)),
('density', models.FloatField(default=0)),
],
),
migrations.CreateModel(
name='Profile',
fields=[
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
primary_key=True,
serialize=False,
to=settings.AUTH_USER_MODEL)),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
bases=('auth.user', ),
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='UserRequestAction',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('start_time', models.DateTimeField()),
('end_time', models.DateTimeField(blank=True, default=None)),
('request_type', models.IntegerField()),
('status', models.IntegerField()),
('feeder',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='petfeeder.PetFeeder')),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.AddField(
model_name='petfood',
name='user',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='petfeeder',
name='food',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='petfeeder.PetFood'),
),
migrations.AddField(
model_name='petfeeder',
name='pet',
field=models.OneToOneField(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='petfeeder.Pet'),
),
migrations.AddField(
model_name='petfeeder',
name='user',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='petconsumptionaction',
name='food',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='petfeeder.PetFood'),
),
migrations.AddField(
model_name='petconsumptionaction',
name='pet',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='petfeeder.Pet'),
),
migrations.AddField(
model_name='pet',
name='user',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='fooddispenseraction',
name='feeder',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='petfeeder.PetFeeder'),
),
migrations.AddField(
model_name='fooddispenseraction',
name='food',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='petfeeder.PetFood'),
),
]
class Migration(migrations.Migration):
dependencies = [
('auth', '0009_alter_user_last_name_max_length'),
('IMSAdmin', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Customer',
fields=[
('user_ptr',
models.OneToOneField(
auto_created=True,
on_delete=django.db.models.deletion.CASCADE,
parent_link=True,
primary_key=True,
serialize=False,
to=settings.AUTH_USER_MODEL)),
('mobile', models.CharField(max_length=50)),
('city', models.CharField(max_length=50)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
bases=('auth.user', ),
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='CustomerPolicyComprehensive',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('deleted_at', models.DateTimeField(blank=True, null=True)),
('effectiveFrom', models.DateField()),
('effectiveTill', models.DateField()),
('year', models.IntegerField()),
('value', models.FloatField()),
('totalAmount', models.FloatField()),
('commission', models.FloatField()),
('policyType', models.BooleanField()),
('name', models.CharField(max_length=50)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('repairType', models.BooleanField()),
('premium', models.FloatField()),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='CustomerPolicyTP',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('deleted_at', models.DateTimeField(blank=True, null=True)),
('effectiveFrom', models.DateField()),
('effectiveTill', models.DateField()),
('year', models.IntegerField()),
('value', models.FloatField()),
('totalAmount', models.FloatField()),
('commission', models.FloatField()),
('policyType', models.BooleanField()),
('name', models.CharField(max_length=50)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('fixedValue', models.FloatField()),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='InsuranceCompany',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('deleted_at', models.DateTimeField(blank=True, null=True)),
('name', models.CharField(max_length=50)),
('logo', models.ImageField(upload_to='')),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='PolicyComprehensive',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('deleted_at', models.DateTimeField(blank=True, null=True)),
('repairType', models.BooleanField()),
('minVehicle', models.FloatField()),
('maxVehicle', models.FloatField()),
('premium', models.FloatField()),
('minAmount', models.FloatField()),
('commission', models.FloatField()),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('insuranceCompany',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='IMSAdmin.InsuranceCompany')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='PolicyTP',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('deleted_at', models.DateTimeField(blank=True, null=True)),
('fixedValue', models.FloatField()),
('minVehicle', models.FloatField()),
('maxVehicle', models.FloatField()),
('commission', models.FloatField()),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('insuranceCompany',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='IMSAdmin.InsuranceCompany')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='VehicleMake',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('deleted_at', models.DateTimeField(blank=True, null=True)),
('name', models.CharField(max_length=50)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='VehicleModel',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('deleted_at', models.DateTimeField(blank=True, null=True)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('name', models.CharField(max_length=50)),
('make',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='IMSAdmin.VehicleMake')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='VehicleValue',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('deleted_at', models.DateTimeField(blank=True, null=True)),
('value', models.FloatField()),
('year', models.IntegerField()),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('make',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='IMSAdmin.VehicleModel')),
],
options={
'abstract': False,
},
),
migrations.DeleteModel(name='AdminProfile', ),
migrations.AddField(
model_name='customerpolicytp',
name='insuranceCompany',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='IMSAdmin.InsuranceCompany'),
),
migrations.AddField(
model_name='customerpolicytp',
name='model',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='IMSAdmin.VehicleModel'),
),
migrations.AddField(
model_name='customerpolicycomprehensive',
name='insuranceCompany',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='IMSAdmin.InsuranceCompany'),
),
migrations.AddField(
model_name='customerpolicycomprehensive',
name='model',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='IMSAdmin.VehicleModel'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0011_update_proxy_permissions'),
]
operations = [
migrations.CreateModel(
name='TiposCartao',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('designacao', models.CharField(blank=True, db_column='Designacao', max_length=200, null=True)),
('codcontafinanceira', models.CharField(blank=True, db_column='CodContaFinanceira', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
],
options={
'db_table': 'TiposCartao',
'managed': False,
},
),
migrations.CreateModel(
name='Bairros',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('nome', models.CharField(blank=True, db_column='Nome', max_length=100, null=True)),
('cod_bairro', models.CharField(blank=True, db_column='CodBairro', max_length=50, null=True)),
('data_criacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('data_atualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
],
options={
'db_table': 'Bairros',
},
),
migrations.CreateModel(
name='Banco',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('nome', models.CharField(blank=True, db_column='Nome', max_length=200, null=True)),
('sigla', models.CharField(blank=True, db_column='Sigla', max_length=5, null=True)),
('numeroregisto', models.CharField(blank=True, db_column='NumeroRegisto', max_length=50, null=True)),
('swiftcode', models.CharField(blank=True, db_column='SwiftCode', max_length=10, null=True)),
('codbanco', models.CharField(blank=True, db_column='CodBanco', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
],
options={
'db_table': 'Banco',
},
),
migrations.CreateModel(
name='CartaConducao',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('numlicenca', models.CharField(blank=True, db_column='NumLicenca', max_length=50, null=True)),
('dataemissao', models.DateField(blank=True, db_column='DataEmissao', null=True)),
('dataprimeiraemissao', models.DateField(blank=True, db_column='DataPrimeiraEmissao', null=True)),
('datavalidade', models.DateField(blank=True, db_column='DataValidade', null=True)),
('caminhoficheiro', models.CharField(blank=True, db_column='CaminhoFicheiro', max_length=256, null=True)),
('codcartaconducao', models.CharField(blank=True, db_column='CodCartaConducao', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
],
options={
'db_table': 'CartaConducao',
},
),
migrations.CreateModel(
name='Cidades',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('nome', models.CharField(blank=True, db_column='Nome', max_length=100, null=True)),
('codcidade', models.CharField(blank=True, db_column='CodCidade', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
],
options={
'db_table': 'Cidades',
},
),
migrations.CreateModel(
name='Enderecos',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('codendereco', models.CharField(blank=True, db_column='CodEndereco', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
],
options={
'db_table': 'Enderecos',
},
),
migrations.CreateModel(
name='EntidadeEmissora',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('designacao', models.CharField(blank=True, db_column='Designacao', max_length=200, null=True)),
('codentidadeemissora', models.CharField(blank=True, db_column='CodEntidadeEmissora', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
],
options={
'db_table': 'EntidadeEmissora',
},
),
migrations.CreateModel(
name='EstadoCivil',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('designacao', models.CharField(blank=True, db_column='Designacao', max_length=100, null=True)),
('codestadocivil', models.CharField(blank=True, db_column='CodEstadoCivil', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
],
options={
'db_table': 'EstadoCivil',
},
),
migrations.CreateModel(
name='Generos',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('designacao', models.CharField(blank=True, db_column='Designacao', max_length=100, null=True)),
('codGenero', models.CharField(blank=True, db_column='CodGenero', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
],
options={
'db_table': 'Generos',
},
),
migrations.CreateModel(
name='Paises',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('nome', models.CharField(blank=True, db_column='Nome', max_length=100, null=True)),
('codigopais', models.CharField(blank=True, db_column='CodigoPais', max_length=5, null=True)),
('ddd', models.CharField(blank=True, db_column='DDI', max_length=5, null=True)),
('codpais', models.CharField(blank=True, db_column='CodPais', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
],
options={
'db_table': 'Paises',
},
),
migrations.CreateModel(
name='RestricoesCategorias',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('designacao', models.CharField(blank=True, db_column='Designacao', max_length=100, null=True)),
('codigo', models.CharField(blank=True, db_column='Codigo', max_length=5, null=True)),
('codrestricoescategorias', models.CharField(blank=True, db_column='CodRestricoesCategorias', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
],
options={
'db_table': 'RestricoesCategorias',
},
),
migrations.CreateModel(
name='RestricoesPessoais',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('designacao', models.CharField(blank=True, db_column='Designacao', max_length=100, null=True)),
('codigo', models.CharField(blank=True, db_column='Codigo', max_length=5, null=True)),
('codrestricoespessoais', models.CharField(blank=True, db_column='CodRestricoesPessoais', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
],
options={
'db_table': 'RestricoesPessoais',
},
),
migrations.CreateModel(
name='RestricoesViaturas',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('designacao', models.CharField(blank=True, db_column='Designacao', max_length=100, null=True)),
('codigo', models.CharField(blank=True, db_column='Codigo', max_length=5, null=True)),
('codrestricoesviaturas', models.CharField(blank=True, db_column='CodRestricoesViaturas', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
],
options={
'db_table': 'RestricoesViaturas',
},
),
migrations.CreateModel(
name='TipoContactos',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('designacao', models.CharField(blank=True, db_column='Designacao', max_length=100, null=True)),
('codtipocontacto', models.CharField(blank=True, db_column='CodTipoContacto', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
],
options={
'db_table': 'TipoContactos',
},
),
migrations.CreateModel(
name='TiposCartaConducao',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('designacao', models.CharField(blank=True, db_column='Designacao', max_length=200, null=True)),
('categoria', models.CharField(blank=True, db_column='Categoria', max_length=200, null=True)),
('codigo', models.CharField(blank=True, db_column='Codigo', max_length=5, null=True)),
('codtiposcartaconducao', models.CharField(blank=True, db_column='CodTiposCartaConducao', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
],
options={
'db_table': 'TiposCartaConducao',
},
),
migrations.CreateModel(
name='TiposConta',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('designacao', models.CharField(blank=True, db_column='Designacao', max_length=100, null=True)),
('codtipoconta', models.CharField(blank=True, db_column='CodTipoConta', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
],
options={
'db_table': 'TiposConta',
},
),
migrations.CreateModel(
name='TiposEndereco',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('tipoendereco', models.CharField(blank=True, db_column='TipoEndereco', max_length=100, null=True)),
('codtipoEndereco', models.CharField(blank=True, db_column='CodTipoEndereco', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
],
options={
'db_table': 'TiposEndereco',
},
),
migrations.CreateModel(
name='TiposSanguineos',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('tiposanguineo', models.CharField(blank=True, db_column='TipoSanguineo', max_length=5, null=True)),
('codtiposanguineo', models.CharField(blank=True, db_column='CodTipoSanguineo', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='dataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='ataAtualizacao', null=True)),
],
options={
'db_table': 'TiposSanguineos',
},
),
migrations.CreateModel(
name='Titulos',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('titulo', models.CharField(blank=True, db_column='Titulo', max_length=100, null=True)),
('abreviacao', models.CharField(blank=True, db_column='Abreviacao', max_length=50, null=True)),
('codtitulo', models.CharField(blank=True, db_column='CodTitulo', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
],
options={
'db_table': 'Titulos',
},
),
migrations.CreateModel(
name='User_permissions',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('permission', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='auth.Permission')),
],
),
migrations.CreateModel(
name='User',
fields=[
('password', models.CharField(max_length=128, verbose_name='password')),
('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')),
('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')),
('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')),
('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')),
('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')),
('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')),
('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')),
('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')),
('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')),
('id', models.UUIDField(editable=False, primary_key=True, serialize=False)),
('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')),
('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', through='Api.User_permissions', to='auth.Permission')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.AddField(
model_name='user_permissions',
name='user',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='user_permis', to=settings.AUTH_USER_MODEL),
),
migrations.CreateModel(
name='Ruas',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('nome', models.CharField(blank=True, db_column='Nome', max_length=100, null=True)),
('codrua', models.CharField(blank=True, db_column='CodRua', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
('bairroid', models.ForeignKey(blank=True, db_column='BairroId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Bairros')),
],
options={
'db_table': 'Ruas',
},
),
migrations.CreateModel(
name='RestricoesViaturaCartaConducao',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('codrestricoesviaturacartaconducao', models.CharField(blank=True, db_column='CodRestricoesViaturaCartaConducao', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
('cartaconducaoid', models.ForeignKey(blank=True, db_column='CartaConducaoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.CartaConducao')),
('restricoesviaturaid', models.ForeignKey(blank=True, db_column='RestricoesViaturaId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.RestricoesViaturas')),
],
options={
'db_table': 'RestricoesViaturaCartaConducao',
},
),
migrations.CreateModel(
name='RestricoesPessoaisCartaConducao',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('codrestricoespessoaiscartaconducao', models.CharField(blank=True, db_column='CodRestricoesPessoaisCartaConducao', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
('cartaconducaoid', models.ForeignKey(blank=True, db_column='CartaConducaoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.CartaConducao')),
('restricoespessoaisid', models.ForeignKey(blank=True, db_column='RestricoesPessoaisId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.RestricoesPessoais')),
],
options={
'db_table': 'RestricoesPessoaisCartaConducao',
},
),
migrations.CreateModel(
name='RestricoesCategoriasCartaConducao',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('codrestricoescategoriascartaconducao', models.CharField(blank=True, db_column='CodRestricoesCategoriasCartaConducao', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
('cartaconducaoid', models.ForeignKey(blank=True, db_column='CartaConducaoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.CartaConducao')),
('restricoescategoriasid', models.ForeignKey(blank=True, db_column='RestricoesCategoriasId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.RestricoesCategorias')),
],
options={
'db_table': 'RestricoesCategoriasCartaConducao',
},
),
migrations.CreateModel(
name='Provincias',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('nome', models.CharField(blank=True, db_column='Nome', max_length=100, null=True)),
('codprovincia', models.CharField(blank=True, db_column='CodProvincia', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
('paisid', models.ForeignKey(blank=True, db_column='PaisId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Paises')),
],
options={
'db_table': 'Provincias',
},
),
migrations.CreateModel(
name='Pessoa',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('primeironome', models.CharField(blank=True, db_column='PrimeiroNome', max_length=100, null=True)),
('nomedomeio', models.CharField(blank=True, db_column='NomeDoMeio', max_length=100, null=True)),
('ultimonome', models.CharField(blank=True, db_column='UltimoNome', max_length=100, null=True)),
('nomecompleto', models.CharField(blank=True, db_column='NomeCompleto', max_length=200, null=True)),
('nomecurto', models.CharField(blank=True, db_column='NomeCurto', max_length=100, null=True)),
('pseudonimo', models.CharField(blank=True, db_column='Pseudonimo', max_length=100, null=True)),
('datanascimento', models.DateField(blank=True, db_column='DataNascimento', null=True)),
('nif', models.CharField(blank=True, db_column='NIF', max_length=50, null=True, unique=True)),
('numsegurancasocial', models.CharField(blank=True, db_column='NumSegurancaSocial', max_length=50, null=True)),
('codpessoa', models.CharField(blank=True, db_column='CodPessoa', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
('estadocivilid', models.ForeignKey(blank=True, db_column='EstadoCivilId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.EstadoCivil')),
('generoid', models.ForeignKey(blank=True, db_column='GeneroId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Generos')),
('tiposanguineoid', models.ForeignKey(blank=True, db_column='TipoSanguineoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.TiposSanguineos')),
('tituloid', models.ForeignKey(blank=True, db_column='TituloId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Titulos')),
],
options={
'db_table': 'Pessoa',
},
),
migrations.CreateModel(
name='Municipios',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('nome', models.CharField(blank=True, db_column='Nome', max_length=100, null=True)),
('codmunicipio', models.CharField(blank=True, db_column='CodMunicipio', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
('provinciaid', models.ForeignKey(blank=True, db_column='ProvinciaId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Provincias')),
],
options={
'db_table': 'Municipios',
},
),
migrations.CreateModel(
name='Motorista',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('codmotorista', models.CharField(blank=True, db_column='CodMotorista', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
('pessoaid', models.ForeignKey(blank=True, db_column='PessoaId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Pessoa')),
],
options={
'db_table': 'Motorista',
},
),
migrations.CreateModel(
name='Moradas',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('numeroporta', models.IntegerField(blank=True, db_column='NumeroPorta', null=True)),
('numerocasa', models.IntegerField(blank=True, db_column='NumeroCasa', null=True)),
('caixapostal', models.IntegerField(blank=True, db_column='CaixaPostal', null=True)),
('numeroandar', models.IntegerField(blank=True, db_column='NumeroAndar', null=True)),
('latitude', models.FloatField(blank=True, db_column='Latitude', null=True)),
('longitude', models.FloatField(blank=True, db_column='Longitude', null=True)),
('pontoreferencia', models.CharField(blank=True, db_column='PontoReferencia', max_length=100, null=True)),
('codmunicipio', models.CharField(blank=True, db_column='CodMunicipio', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
('cidadeid', models.ForeignKey(blank=True, db_column='CidadeId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Cidades')),
('enderecoid', models.ForeignKey(blank=True, db_column='EnderecoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Enderecos')),
],
options={
'db_table': 'Moradas',
},
),
migrations.AddField(
model_name='enderecos',
name='ruaid',
field=models.ForeignKey(blank=True, db_column='RuaId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Ruas'),
),
migrations.AddField(
model_name='enderecos',
name='tipoenderecoId',
field=models.ForeignKey(blank=True, db_column='TipoEnderecoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.TiposEndereco'),
),
migrations.CreateModel(
name='Distritos',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('nome', models.CharField(blank=True, db_column='Nome', max_length=100, null=True)),
('coddistrito', models.CharField(blank=True, db_column='CodDistrito', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
('municipioid', models.ForeignKey(blank=True, db_column='municipioid', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Municipios')),
],
options={
'db_table': 'Distritos',
},
),
migrations.CreateModel(
name='ContaFinanceira',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('refcontafinanceira', models.CharField(blank=True, db_column='RefContaFinanceira', max_length=50, null=True)),
('numeroconta', models.IntegerField(blank=True, db_column='NumeroConta', null=True)),
('nomeconta', models.CharField(blank=True, db_column='NomeConta', max_length=200, null=True)),
('descricao', models.TextField(blank=True, db_column='Descricao', null=True)),
('iban', models.CharField(blank=True, db_column='IBAN', max_length=100, null=True)),
('nib', models.CharField(blank=True, db_column='NIB', max_length=100, null=True)),
('limiteconta', models.FloatField(blank=True, db_column='LimiteConta', null=True)),
('dataencerramento', models.DateField(blank=True, db_column='DataEncerramento', null=True)),
('codcontafinanceira', models.CharField(blank=True, db_column='CodContaFinanceira', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
('bancoid', models.ForeignKey(blank=True, db_column='BancoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Banco')),
('tipocontaid', models.ForeignKey(blank=True, db_column='TipoContaId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.TiposConta')),
('titulardacontaid', models.ForeignKey(blank=True, db_column='TitularDaContaId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Pessoa')),
],
options={
'db_table': 'ContaFinanceira',
},
),
migrations.CreateModel(
name='Contactos',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('telemovel', models.IntegerField(blank=True, db_column='Telemovel', null=True)),
('telefone', models.IntegerField(blank=True, db_column='Telefone', null=True)),
('email', models.CharField(blank=True, db_column='Email', max_length=256, null=True)),
('fax', models.IntegerField(blank=True, db_column='Fax', null=True)),
('website', models.CharField(blank=True, db_column='WebSite', max_length=256, null=True)),
('ddi', models.CharField(blank=True, db_column='DDI', max_length=5, null=True)),
('codcontacto', models.CharField(blank=True, db_column='CodContacto', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
('pessoaid', models.ForeignKey(blank=True, db_column='PessoaId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Pessoa')),
('tipocontactoid', models.ForeignKey(blank=True, db_column='TipoContactoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.TipoContactos')),
],
options={
'db_table': 'Contactos',
},
),
migrations.AddField(
model_name='cidades',
name='bairroid',
field=models.ForeignKey(blank=True, db_column='BairroId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Provincias'),
),
migrations.CreateModel(
name='Cartoes',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('nome', models.CharField(blank=True, db_column='Nome', max_length=100, null=True)),
('numero', models.IntegerField(blank=True, db_column='Numero', null=True)),
('dataexpiracao', models.DateField(blank=True, db_column='DataExpiracao', null=True)),
('codcontafinanceira', models.CharField(blank=True, db_column='CodContaFinanceira', max_length=50, null=True)),
('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)),
('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)),
('contafinanceiraid', models.ForeignKey(blank=True, db_column='ContaFinanceiraId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.ContaFinanceira')),
('tipocartaoid', models.ForeignKey(blank=True, db_column='TipoCartaoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.TiposCartao')),
],
options={
'db_table': 'Cartoes',
},
),
migrations.AddField(
model_name='cartaconducao',
name='entidadeemissoraid',
field=models.ForeignKey(blank=True, db_column='EntidadeEmissoraId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.EntidadeEmissora'),
),
migrations.AddField(
model_name='cartaconducao',
name='motoristaid',
field=models.ForeignKey(blank=True, db_column='MotoristaId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Motorista'),
),
migrations.AddField(
model_name='cartaconducao',
name='tipocartaconducaoid',
field=models.ForeignKey(blank=True, db_column='TipoCartaConducaoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.TiposCartaConducao'),
),
migrations.AddField(
model_name='bairros',
name='distrito_id',
field=models.ForeignKey(blank=True, db_column='DistritoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Distritos'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0011_update_proxy_permissions'),
]
operations = [
migrations.CreateModel(
name='Fee',
fields=[
('uuid',
models.UUIDField(default=uuid.uuid4,
editable=False,
primary_key=True,
serialize=False)),
('amount', models.FloatField(default=0.0)),
],
),
migrations.CreateModel(
name='Project',
fields=[
('uuid',
models.UUIDField(default=uuid.uuid4,
editable=False,
primary_key=True,
serialize=False)),
('title', models.CharField(max_length=200, unique=True)),
('unit',
models.IntegerField(choices=[(0, 'hectareas'), (1, 'árboles'),
(2, 'toneladas'), (3, 'euros')],
default=3)),
('description', models.TextField()),
('visible', models.BooleanField(default=True)),
('got', models.IntegerField()),
('goal', models.IntegerField()),
('created_on', models.DateTimeField(auto_now_add=True)),
],
options={
'verbose_name': 'Proyecto',
},
),
migrations.CreateModel(
name='FeeDistribution',
fields=[
('uuid',
models.UUIDField(default=uuid.uuid4,
editable=False,
primary_key=True,
serialize=False)),
('percentage', models.FloatField(default=0.0)),
('fee',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='api.Fee')),
('project',
models.ForeignKey(
on_delete=django.db.models.deletion.DO_NOTHING,
to='api.Project')),
],
options={
'verbose_name': 'DistribucionCuota',
},
),
migrations.CreateModel(
name='Socio',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('first_name',
models.CharField(blank=True,
max_length=30,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=150,
verbose_name='last name')),
('is_staff',
models.BooleanField(
default=False,
help_text=
'Designates whether the user can log into this admin site.',
verbose_name='staff status')),
('is_active',
models.BooleanField(
default=True,
help_text=
'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.',
verbose_name='active')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('type',
models.IntegerField(choices=[(0, 'Admin'), (1, 'Socio'),
(2, 'Trabajador'),
(3, 'Voluntario')],
default=3)),
('email',
models.EmailField(max_length=254,
unique=True,
verbose_name='email address')),
('username',
models.CharField(blank=True, max_length=150, unique=True)),
('created_on', models.DateTimeField(auto_now_add=True)),
('updated_on', models.DateTimeField(auto_now=True)),
('fee',
models.OneToOneField(
on_delete=django.db.models.deletion.DO_NOTHING,
to='api.Fee')),
('groups',
models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups')),
('user_permissions',
models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions')),
],
options={
'verbose_name': 'Socio',
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0011_update_proxy_permissions'),
]
operations = [
migrations.CreateModel(
name='CustomUser',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('date_joined',
models.DateTimeField(default=django.utils.timezone.now,
verbose_name='date joined')),
('email',
models.EmailField(blank=True,
max_length=255,
null=True,
unique=True)),
('telephone',
models.IntegerField(blank=True, default=0, null=True)),
('first_name',
models.CharField(blank=True, max_length=30, null=True)),
('last_name',
models.CharField(blank=True, max_length=255, null=True)),
('username',
models.CharField(blank=True,
max_length=30,
null=True,
unique=True)),
('application_fee',
models.IntegerField(blank=True, default=10000, null=True)),
('Role',
models.CharField(choices=[('Admin', 'Admin'),
('Ordinary', 'Ordinary')],
max_length=250)),
('is_active', models.BooleanField(default=True)),
('is_staff', models.BooleanField(default=False)),
('is_superuser', models.BooleanField(default=False)),
('groups',
models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups')),
('user_permissions',
models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Attendance',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('full_name',
models.CharField(blank=True, max_length=123, null=True)),
('date', models.DateField(blank=True, null=True)),
('status', models.BooleanField(blank=True, default=False)),
('social_fund',
models.IntegerField(blank=True, default=0, null=True)),
('attendance_year',
models.CharField(blank=True,
default=2020,
max_length=255,
null=True)),
('attendance_month',
models.CharField(blank=True, max_length=255, null=True)),
],
),
migrations.CreateModel(
name='Cycle',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('cycle_name',
models.CharField(blank=True,
max_length=220,
null=True,
unique=True)),
('rate', models.IntegerField(blank=True, default=15,
null=True)),
('cycle_period_start',
models.DateField(max_length=255, unique=True)),
('cycle_period_end',
models.DateField(max_length=255, unique=True)),
('is_active', models.BooleanField(default=True)),
],
),
migrations.CreateModel(
name='LookUp',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=220, unique=True)),
],
),
migrations.CreateModel(
name='PayingLoan',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('loan_id',
models.CharField(blank=True, max_length=100, null=True)),
('date', models.DateField(blank=True,
max_length=100,
null=True)),
('name', models.CharField(blank=True,
max_length=100,
null=True)),
('amount', models.IntegerField(blank=True,
default=0,
null=True)),
],
),
migrations.CreateModel(
name='Stock',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('ticker', models.CharField(max_length=10)),
('openn', models.FloatField()),
('close', models.FloatField()),
('volume', models.IntegerField()),
],
),
migrations.CreateModel(
name='Saving',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date', models.DateField(blank=True,
max_length=100,
null=True)),
('amount', models.IntegerField(default=0)),
('cycle',
models.ForeignKey(
blank=True,
max_length=100,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='savingsapp.Cycle')),
('name',
models.ForeignKey(
blank=True,
max_length=100,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='LookupDetail',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('Details', models.CharField(max_length=220)),
('Lookup_Name',
models.ForeignKey(max_length=220,
on_delete=django.db.models.deletion.CASCADE,
to='savingsapp.LookUp')),
],
),
migrations.CreateModel(
name='Loan',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('cycle',
models.CharField(blank=True, max_length=100, null=True)),
('date', models.DateField(blank=True,
max_length=100,
null=True)),
('amount', models.IntegerField(default=0)),
('interest_rate', models.IntegerField(default=0)),
('loan_period', models.IntegerField(default=0)),
('loan_status',
models.CharField(blank=True,
choices=[('RUNNING', 'RUNNING'),
('SETTLED', 'SETTLED')],
default='RUNNING',
max_length=100,
null=True)),
('recorded_by',
models.CharField(blank=True, max_length=220, null=True)),
('name',
models.ForeignKey(
blank=True,
max_length=100,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0012_alter_user_first_name_max_length'),
]
operations = [
migrations.CreateModel(
name='User',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('password', models.CharField(max_length=128, verbose_name='password')),
('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')),
('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')),
('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')),
('first_name', models.CharField(blank=True, max_length=150, verbose_name='first name')),
('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')),
('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')),
('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')),
('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')),
('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')),
('is_professor', models.BooleanField(default=False)),
('is_aluno', models.BooleanField(default=False)),
('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')),
('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.CreateModel(
name='Disciplina',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('nome', models.CharField(max_length=32)),
('descricao', models.TextField(default='Uma descrição')),
],
),
migrations.CreateModel(
name='Horario',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('diaSemana', models.IntegerField(choices=[(2, 'Segunda'), (3, 'Terça'), (4, 'Quarta'), (5, 'Quinta'), (6, 'Sexta'), (7, 'Sábado')])),
('horarioInicio', models.TimeField()),
('horarioFim', models.TimeField()),
],
),
migrations.CreateModel(
name='Inscricao',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('disciplina', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.disciplina')),
],
),
migrations.CreateModel(
name='Laboratorio',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('localizacao', models.CharField(max_length=10, unique=True)),
('capacidade', models.PositiveIntegerField()),
],
),
migrations.CreateModel(
name='Sala',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('localizacao', models.CharField(max_length=10, unique=True)),
('capacidade', models.PositiveIntegerField()),
],
),
migrations.CreateModel(
name='Semestre',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('ano', models.PositiveIntegerField()),
('periodo', models.PositiveIntegerField()),
],
),
migrations.CreateModel(
name='Aluno',
fields=[
('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='core.user')),
('matricula', models.CharField(max_length=12, unique=True)),
('nome', models.CharField(max_length=32)),
],
),
migrations.CreateModel(
name='Professor',
fields=[
('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='core.user')),
('matricula', models.CharField(max_length=12, unique=True)),
('nome', models.CharField(max_length=32)),
],
),
migrations.CreateModel(
name='Turma',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('disciplina', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.disciplina')),
('horarioLaboratorio', models.ManyToManyField(related_name='horarios_laboratorio', to='core.Horario')),
('horarioSala', models.ManyToManyField(related_name='horarios_sala', to='core.Horario')),
('laboratorio', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='laboratorios_turmas', to='core.laboratorio')),
('sala', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='salas_turmas', to='core.sala')),
('semestre', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.semestre')),
('professor', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.professor')),
],
),
migrations.CreateModel(
name='Prazo',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('prazo', models.DateField()),
('disciplina', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.disciplina')),
('semestre', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.semestre')),
],
),
migrations.CreateModel(
name='Nota',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('nota', models.FloatField()),
('inscricao', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.inscricao')),
],
),
migrations.AddField(
model_name='inscricao',
name='semestre',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.semestre'),
),
migrations.AddField(
model_name='inscricao',
name='turma',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.turma'),
),
migrations.AddField(
model_name='inscricao',
name='aluno',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.aluno'),
),
]
