class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Company',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(max_length=40,
verbose_name='Nombre de la empresa')),
('address',
models.CharField(blank=True,
max_length=200,
null=True,
verbose_name='Dirección')),
('phone',
models.CharField(blank=True,
max_length=15,
null=True,
verbose_name='Teléfono')),
('city', models.CharField(max_length=20,
verbose_name='Ciudad')),
('email',
models.EmailField(blank=True,
max_length=254,
null=True,
verbose_name='Email')),
('logo',
models.ImageField(
blank=True,
upload_to=company.models.custom_company_upload_to)),
('created',
models.DateTimeField(auto_now_add=True,
verbose_name='Fecha de creación')),
('updated',
models.DateTimeField(auto_now=True,
verbose_name='Fecha de edición')),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'verbose_name': 'Compañia',
'verbose_name_plural': 'Compañias',
'ordering': ['-created'],
},
),
]
class DummyFlowTrans(models.Model):
id = models.AutoField(unique=True,
primary_key=True,
null=False,
blank=False)
date = models.DateTimeField(auto_now_add=True)
class Meta:
db_table = 'dummy_transactions'
verbose_name_plural = 'Тестирование / Бункеры транзацкции'
def __unicode__(self):
return u'[%s] %s' % (self.id, self.date)
class DummyCompanies(models.Model):
name = models.CharField(max_length=255, blank=False, null=False)
description = models.CharField(max_length=255, blank=True, null=True)
www = models.CharField(max_length=255, blank=True)
org_type = models.ForeignKey('company.CompanyOrgTypes',
null=False,
blank=False,
related_name="org_type")
rel_type = models.ForeignKey('company.CompanyRelTypes',
null=False,
blank=False)
status = models.ForeignKey('company.CompanyStatus',
null=False,
blank=False)
date_add = models.DateTimeField(auto_now_add=True)
date_update = models.DateTimeField(auto_now=True)
class Meta:
db_table = 'dummy_companies'
verbose_name_plural = 'Тестирование / Компании'
def __unicode__(self):
return u'[%s] %s' % (self.id, self.name)
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Attachment',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('file',
models.FileField(upload_to=company.models.company_file_path)),
('created_at',
models.DateTimeField(auto_now_add=True,
verbose_name='date created')),
('updated_at',
models.DateTimeField(auto_now=True,
verbose_name='date updated')),
],
),
migrations.CreateModel(
name='Branch',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(choices=[
('CO', 'Computer Engineering'),
('ME', 'Mechanical Engineering'),
('CE', 'Civil Engineering'),
('EE', 'Electrical Engineering'),
('CH', 'Chemical Engineering'),
('EC', 'Electronics and Communication Engineering'),
('PHY', 'Physics'), ('CHEM', 'Chemistry'),
('MATH', 'Mathematics'), ('ALL', 'All Branches')
],
max_length=4)),
('degree',
models.CharField(choices=[('BTECH', 'BTech'),
('MTECH', 'MTech'), ('MSC', 'MSc')],
default='BTECH',
max_length=5)),
],
),
migrations.CreateModel(
name='Company',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=255, unique=True)),
('slug', models.SlugField()),
('website',
models.URLField(blank=True, max_length=255, null=True)),
('about',
models.TextField(blank=True, max_length=5000, null=True)),
('perks',
models.TextField(blank=True, max_length=5000, null=True)),
('infra_req',
models.TextField(blank=True, max_length=5000, null=True)),
('other',
models.TextField(blank=True, max_length=5000, null=True)),
('created_at',
models.DateTimeField(auto_now_add=True,
verbose_name='date created')),
('updated_at',
models.DateTimeField(auto_now=True,
verbose_name='date updated')),
],
),
migrations.CreateModel(
name='CRPDate',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('datatype',
models.CharField(choices=[('MON', 'Month'),
('WOM', 'Week of Month'),
('DAT', 'Date')],
max_length=3)),
('month', models.IntegerField(blank=True, null=True)),
('date', models.DateField(blank=True, null=True)),
('week_number',
models.CharField(blank=True,
choices=[('F', 'First'), ('S', 'Second'),
('T', 'Third'), ('L', 'Last')],
max_length=1,
null=True)),
('created_at',
models.DateTimeField(auto_now_add=True,
verbose_name='date created')),
('updated_at',
models.DateTimeField(auto_now=True,
verbose_name='date updated')),
],
),
migrations.CreateModel(
name='Job',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('designation', models.CharField(max_length=255, unique=True)),
('description',
models.TextField(blank=True, max_length=5000, null=True)),
('requirements',
models.TextField(blank=True, max_length=5000, null=True)),
('eligibility_criteria',
models.TextField(blank=True, max_length=5000, null=True)),
('ctc',
models.DecimalField(blank=True,
decimal_places=2,
max_digits=4)),
('ctc_details',
models.TextField(blank=True, max_length=5000, null=True)),
('bond_details',
models.CharField(blank=True,
max_length=255,
null=True,
unique=True)),
('number_of_selections',
models.IntegerField(blank=True, null=True)),
('other',
models.TextField(blank=True, max_length=5000, null=True)),
('created_at',
models.DateTimeField(auto_now_add=True,
verbose_name='date created')),
('updated_at',
models.DateTimeField(auto_now=True,
verbose_name='date updated')),
],
),
migrations.CreateModel(
name='JobLocation',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('location', models.CharField(max_length=255)),
('job',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='job_location',
to='company.Job')),
],
),
migrations.CreateModel(
name='JobType',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('job_domain',
models.CharField(choices=[('C', 'Core'), ('N', 'Non-Core')],
max_length=1)),
('job_type', models.CharField(max_length=255)),
],
),
migrations.CreateModel(
name='PlacementCategory',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=255, unique=True)),
('ctc_range', models.CharField(max_length=255, unique=True)),
],
),
migrations.CreateModel(
name='SelectionProcedure',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('procedure', models.CharField(max_length=255)),
],
),
migrations.AlterUniqueTogether(
name='jobtype',
unique_together=set([('job_domain', 'job_type')]),
),
migrations.AddField(
model_name='job',
name='category',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='job',
to='company.PlacementCategory'),
),
migrations.AddField(
model_name='job',
name='company',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='job',
to='company.Company'),
),
migrations.AddField(
model_name='job',
name='eligible_branches',
field=models.ManyToManyField(to='company.Branch'),
),
migrations.AddField(
model_name='job',
name='job_type',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='job',
to='company.JobType'),
),
migrations.AddField(
model_name='job',
name='selection_procedure',
field=models.ManyToManyField(to='company.SelectionProcedure'),
),
migrations.AddField(
model_name='crpdate',
name='job',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='crpdate',
to='company.Job'),
),
migrations.AlterUniqueTogether(
name='branch',
unique_together=set([('name', 'degree')]),
),
migrations.AddField(
model_name='attachment',
name='job',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='attachment',
to='company.Job'),
),
migrations.AlterUniqueTogether(
name='joblocation',
unique_together=set([('job', 'location')]),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Send_Email',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('username',
models.CharField(blank=True, max_length=50, null=True)),
('email',
models.EmailField(blank=True, max_length=50, null=True)),
('content',
models.CharField(blank=True, max_length=350, null=True)),
],
),
migrations.CreateModel(
name='Notification',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('verb', models.CharField(max_length=100)),
('description', models.TextField()),
('read', models.BooleanField(default=False)),
('post', models.IntegerField()),
('applicant', models.IntegerField()),
('receiver',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Match_Results',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('resume',
models.CharField(blank=True,
max_length=100,
null=True,
verbose_name='resume')),
('app_email',
models.CharField(blank=True,
max_length=50,
verbose_name='email')),
('job_id',
models.IntegerField(blank=True,
null=True,
verbose_name='the job')),
('skills_rslt',
models.CharField(blank=True,
max_length=1000,
null=True,
verbose_name='match result')),
('status',
models.CharField(blank=True,
max_length=100,
null=True,
verbose_name='status')),
('content',
models.CharField(blank=True, max_length=300, null=True)),
('aplcnt',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='CreatePost',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('jobtitle', models.CharField(blank=True, max_length=50)),
('job_description', models.CharField(blank=True,
max_length=500)),
('joblocation', models.CharField(blank=True, max_length=50)),
('city', models.CharField(blank=True, max_length=50)),
('Area', models.CharField(blank=True, max_length=50)),
('careerlevel', models.CharField(blank=True, max_length=50)),
('year_of_experience',
models.CharField(blank=True, max_length=50)),
('salary_range1', models.CharField(blank=True, max_length=50)),
('salary_range2', models.CharField(blank=True, max_length=50)),
('num_vacancies', models.TextField(blank=True, max_length=50)),
('jobtype', models.CharField(blank=True, max_length=50)),
('image',
models.ImageField(blank=True,
upload_to=company.models.upload_location)),
('skills', models.CharField(blank=True, max_length=500)),
('deadline', models.DateField(blank=True)),
('status', models.CharField(default='Publishing',
max_length=10)),
('date_published',
models.DateTimeField(auto_now_add=True,
verbose_name='date published')),
('date_updated',
models.DateTimeField(auto_now=True,
verbose_name='date updated')),
('slug', models.SlugField(blank=True)),
('author',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
dependencies = [
('company', '0005_merge_20170927_1238'),
]
operations = [
migrations.CreateModel(
name='TblCoupons',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(blank=True,
max_length=250,
null=True)),
('coupon_id',
models.CharField(blank=True, max_length=250, null=True)),
('display_name',
models.CharField(blank=True, max_length=250, null=True)),
('discount',
models.CharField(blank=True, max_length=250, null=True)),
('applicable_on',
models.CharField(blank=True, max_length=250, null=True)),
('valid_for',
models.CharField(blank=True, max_length=250, null=True)),
('valid_on_days',
models.CharField(blank=True, max_length=250, null=True)),
('start_date',
models.CharField(blank=True, max_length=250, null=True)),
('end_date',
models.CharField(blank=True, max_length=250, null=True)),
('actual_price',
models.CharField(blank=True, max_length=250, null=True)),
('offer_price',
models.CharField(blank=True, max_length=250, null=True)),
('terms_conditions',
models.CharField(blank=True, max_length=250, null=True)),
('special_offer_menus',
models.FileField(
blank=True,
null=True,
upload_to=company.models.get_special_offer_menu_path)),
('date_created', models.DateTimeField(blank=True, null=True)),
('date_updated', models.DateTimeField(blank=True, null=True)),
],
),
migrations.CreateModel(
name='TblHappyHours',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(blank=True,
max_length=250,
null=True)),
('happy_hour_id',
models.CharField(blank=True, max_length=250, null=True)),
('display_name',
models.CharField(blank=True, max_length=250, null=True)),
('start_time',
models.CharField(blank=True, max_length=250, null=True)),
('end_time',
models.CharField(blank=True, max_length=250, null=True)),
('discount',
models.CharField(blank=True, max_length=250, null=True)),
('applicable_on',
models.CharField(blank=True, max_length=250, null=True)),
('valid_for',
models.CharField(blank=True, max_length=250, null=True)),
('valid_on_days',
models.CharField(blank=True, max_length=250, null=True)),
('terms_conditions',
models.CharField(blank=True, max_length=250, null=True)),
('date_created', models.DateTimeField(blank=True, null=True)),
('date_updated', models.DateTimeField(blank=True, null=True)),
],
),
migrations.CreateModel(
name='TblRepetetionDate',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('day', models.CharField(blank=True, max_length=250,
null=True)),
('start_time',
models.CharField(blank=True, max_length=250, null=True)),
('end_time',
models.CharField(blank=True, max_length=250, null=True)),
('date_created', models.DateTimeField(blank=True, null=True)),
('date_updated', models.DateTimeField(blank=True, null=True)),
('happy_hour',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='company.TblHappyHours')),
],
),
migrations.AlterField(
model_name='tblvendor',
name='cover_photo',
field=models.FileField(
blank=True,
null=True,
upload_to=company.models.get_vendor_image_path),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Employee',
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')),
('name', models.CharField(max_length=50, verbose_name='имя')),
('salary', models.FloatField(verbose_name='salary')),
('address',
models.CharField(blank=True,
max_length=200,
null=True,
verbose_name='address')),
('phone',
models.CharField(max_length=100,
unique=True,
verbose_name='phone')),
('is_staff',
models.BooleanField(default=False, verbose_name='is staff')),
('is_superuser',
models.BooleanField(default=False,
verbose_name='is superuser')),
('role',
models.CharField(choices=[('director', 'director'),
('manager', 'manager'),
('technologist', 'technologist'),
('accountant', 'accountant'),
('hr', 'hr')],
max_length=30,
null=True)),
],
options={
'verbose_name': 'employee',
'verbose_name_plural': 'employees',
'db_table': 'employee',
},
managers=[
('objects', company.models.UserManager()),
],
),
migrations.CreateModel(
name='Budget',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('summ', models.FloatField(verbose_name='sum')),
],
options={
'verbose_name': 'budget',
'verbose_name_plural': 'budget',
'db_table': 'budget',
},
),
migrations.CreateModel(
name='Credit',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('bank', models.CharField(max_length=50, verbose_name='bank')),
('date_of_issue', models.DateField()),
('fine', models.FloatField()),
('percent', models.FloatField()),
('sum', models.FloatField()),
('year', models.FloatField()),
('redeemed', models.FloatField()),
],
options={
'db_table': 'credit',
},
),
migrations.CreateModel(
name='Ingredient',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('quantity', models.FloatField(verbose_name='quantity')),
],
options={
'verbose_name': 'ingredient',
'verbose_name_plural': 'ingredients',
'db_table': 'ingredient',
},
),
migrations.CreateModel(
name='Material',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(max_length=50,
unique=True,
verbose_name='имя')),
('summ', models.FloatField(verbose_name='sum')),
('quantity', models.FloatField(verbose_name='quantity')),
],
options={
'verbose_name': 'material',
'verbose_name_plural': 'materials',
'db_table': 'material',
},
),
migrations.CreateModel(
name='Payroll',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('year', models.IntegerField(verbose_name='year')),
('month', models.IntegerField(verbose_name='month')),
('date', models.DateField(verbose_name='date')),
('salary', models.FloatField(verbose_name='salary')),
('prize', models.FloatField(verbose_name='prize')),
('employee',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to=settings.AUTH_USER_MODEL)),
],
options={
'verbose_name': 'payroll',
'verbose_name_plural': 'payroll',
'db_table': 'payroll',
},
),
migrations.CreateModel(
name='Position',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100, verbose_name='имя')),
],
options={
'verbose_name': 'position',
'verbose_name_plural': 'positions',
'db_table': 'position',
},
),
migrations.CreateModel(
name='Product',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(max_length=50,
unique=True,
verbose_name='имя')),
('summ', models.FloatField(verbose_name='sum')),
('quantity', models.FloatField(verbose_name='quantity')),
],
options={
'verbose_name': 'product',
'verbose_name_plural': 'products',
'db_table': 'product',
},
),
migrations.CreateModel(
name='Production',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('quantity', models.FloatField(verbose_name='quantity')),
('time', models.DateTimeField(verbose_name='time')),
('employee',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to=settings.AUTH_USER_MODEL)),
('product',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to='company.Product')),
],
options={
'verbose_name': 'production',
'verbose_name_plural': 'production',
'db_table': 'production',
},
),
migrations.CreateModel(
name='Purchase',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('quantity', models.FloatField(verbose_name='quantity')),
('summ', models.FloatField(verbose_name='sum')),
('time', models.DateTimeField(verbose_name='time')),
('employee',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to=settings.AUTH_USER_MODEL)),
('material',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to='company.Material')),
],
options={
'verbose_name': 'purchase',
'verbose_name_plural': 'purchases',
'db_table': 'purchase',
},
),
migrations.CreateModel(
name='Repayment',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('payment_date', models.DateField(verbose_name='date')),
('sum_all', models.FloatField(blank=True, null=True)),
('payment_sum',
models.FloatField(blank=True, null=True, verbose_name='sum')),
('percents', models.FloatField(blank=True, null=True)),
('fine', models.FloatField(blank=True, null=True)),
('bank',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='repayments',
to='company.Credit')),
],
options={
'db_table': 'repayment',
},
),
migrations.CreateModel(
name='Sale',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('quantity', models.FloatField(verbose_name='quantity')),
('summ', models.FloatField(verbose_name='sum')),
('time', models.DateTimeField(verbose_name='time')),
('employee',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to=settings.AUTH_USER_MODEL)),
('product',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to='company.Product')),
],
options={
'verbose_name': 'sale',
'verbose_name_plural': 'sale',
'db_table': 'sale',
},
),
migrations.CreateModel(
name='Unit',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(max_length=50,
unique=True,
verbose_name='имя')),
],
options={
'verbose_name': 'unit',
'verbose_name_plural': 'units',
'db_table': 'unit',
},
),
migrations.AddField(
model_name='product',
name='unit',
field=models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
to='company.Unit',
verbose_name='unit'),
),
migrations.AddField(
model_name='material',
name='unit',
field=models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
to='company.Unit',
verbose_name='unit'),
),
migrations.AddField(
model_name='ingredient',
name='material',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='company.Material'),
),
migrations.AddField(
model_name='ingredient',
name='product',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='company.Product'),
),
migrations.AddField(
model_name='employee',
name='position',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.PROTECT,
to='company.Position'),
),
]
class Migration(migrations.Migration):
dependencies = [
('company', '0003_companyreview_highlight'),
]
operations = [
migrations.CreateModel(
name='Company',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(max_length=15, verbose_name='Company Name')),
('tag',
models.CharField(max_length=255, verbose_name='Company Tag')),
('founded',
models.DateTimeField(verbose_name='Company Founded')),
('active',
models.BooleanField(default=True,
verbose_name='Company State')),
('website',
models.URLField(max_length=50,
verbose_name='Company Website')),
],
),
migrations.CreateModel(
name='CompanyTelephoneHelpline',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('helpline',
models.CharField(max_length=20,
verbose_name='Helpline Type')),
('telephone',
models.CharField(max_length=15, verbose_name='Telephone')),
('company',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='company.company')),
],
),
migrations.CreateModel(
name='CompanyFounder',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=50, verbose_name='Name')),
('designation',
models.CharField(max_length=30, verbose_name='Designation')),
('profile_pic',
models.ImageField(
upload_to=company.models.profilepic_directory_path,
verbose_name='Profile Pic')),
('bio', models.TextField(verbose_name='About Founder')),
('company',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='company.company')),
],
),
migrations.CreateModel(
name='CompanyEmailHelpline',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('helpline',
models.CharField(max_length=20,
verbose_name='Helpline Type')),
('email',
models.EmailField(max_length=254, verbose_name='Email')),
('company',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='company.company')),
],
),
migrations.CreateModel(
name='CompanyAddress',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('street', models.TextField(verbose_name='Street Address')),
('city', models.CharField(max_length=40, verbose_name='City')),
('pin', models.CharField(max_length=6, verbose_name='PIN')),
('district',
models.CharField(max_length=30, verbose_name='District')),
('state', models.CharField(max_length=30,
verbose_name='State')),
('country',
models.CharField(max_length=30, verbose_name='Country')),
('company',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='company.company')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Company',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('company_index',
models.IntegerField(db_column='company_index',
default=12,
verbose_name='单位编号')),
('company_name',
models.CharField(db_column='company_name',
max_length=50,
unique=True,
verbose_name='单位名称')),
('company_address',
models.CharField(db_column='company_address',
max_length=50,
verbose_name='单位地址')),
],
options={
'verbose_name': '单位名称',
'verbose_name_plural': '单位名称',
'db_table': 'company',
'ordering': ['company_index'],
},
),
migrations.CreateModel(
name='Department',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('department_index',
models.IntegerField(db_column='department_index',
default=12,
verbose_name='部门编号')),
('department_name',
models.CharField(db_column='department_name',
max_length=50,
verbose_name='部门名称')),
('department_position',
models.CharField(db_column='department_position',
max_length=50,
verbose_name='部门位置')),
('belong_company',
models.ForeignKey(db_column='belong_company',
on_delete=django.db.models.deletion.CASCADE,
to='company.Company',
verbose_name='单位名称')),
],
options={
'verbose_name': '部门名称',
'verbose_name_plural': '部门名称',
'db_table': 'department',
'ordering': ['department_index'],
},
),
migrations.CreateModel(
name='Employee',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('employee_index',
models.CharField(db_column='employee_index',
max_length=20,
unique=True,
verbose_name='员工编号')),
('employee_name',
models.CharField(db_column='employee_name',
max_length=10,
verbose_name='员工姓名')),
('employee_gender',
models.CharField(choices=[('M', '男'), ('F', '女'),
('U', '不详')],
db_column='employee_gender',
max_length=10,
verbose_name='员工姓别')),
('employee_telephone',
models.CharField(db_column='employee_telephone',
max_length=20,
verbose_name='联系电话')),
('belong_department',
models.ForeignKey(blank=True,
db_column='belong_department',
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='company.Company',
verbose_name='所属部门')),
],
options={
'verbose_name': '员工信息',
'verbose_name_plural': '员工信息',
'db_table': 'employee',
'ordering': ['employee_index'],
},
),
migrations.CreateModel(
name='EmployeeDetail',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('employee_img',
models.ImageField(
blank=True,
db_column='employee_img',
null=True,
upload_to=company.models.user_directory_path,
verbose_name='头像')),
('employee_hire_date',
models.DateTimeField(auto_now_add=True,
db_column='employee_hire_date',
verbose_name='入职时间')),
('is_delete',
models.BooleanField(db_column='is_delete',
default=False,
verbose_name='是否离职')),
],
options={
'verbose_name': '员工详细信息',
'verbose_name_plural': '员工详细信息',
'db_table': 'employee_detail',
'ordering': ['employee_index'],
},
),
migrations.CreateModel(
name='LeadershipPosition',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('leadership_positon_name',
models.CharField(db_column='pro_title_name',
max_length=50,
verbose_name='领导职务')),
],
options={
'verbose_name': '领导职务',
'verbose_name_plural': '领导职务',
'db_table': 'leadershipposition',
},
),
migrations.CreateModel(
name='Professional',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('professional_name',
models.CharField(db_column='pro_name',
max_length=50,
verbose_name='专业名称')),
],
options={
'verbose_name': '专业名称',
'verbose_name_plural': '专业名称',
'db_table': 'professional',
},
),
migrations.CreateModel(
name='ProfessionalTitle',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('professional_title_name',
models.CharField(db_column='pro_title_name',
max_length=50,
verbose_name='专业职称')),
],
options={
'verbose_name': '专业职称',
'verbose_name_plural': '专业职称',
'db_table': 'professionaltitle',
},
),
migrations.AddField(
model_name='employeedetail',
name='belong_leadership_position',
field=models.ForeignKey(
blank=True,
db_column='belong_leadership_position',
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='company.LeadershipPosition',
verbose_name='领导职务'),
),
migrations.AddField(
model_name='employeedetail',
name='belong_professional',
field=models.OneToOneField(
db_column='belong_professional',
on_delete=django.db.models.deletion.CASCADE,
to='company.Professional',
verbose_name='专业名称'),
),
migrations.AddField(
model_name='employeedetail',
name='belong_professional_title',
field=models.OneToOneField(
db_column='belong_professional_title',
on_delete=django.db.models.deletion.CASCADE,
to='company.ProfessionalTitle',
verbose_name='专业职称'),
),
migrations.AddField(
model_name='employeedetail',
name='employee_index',
field=models.OneToOneField(
db_column='employee_index',
on_delete=django.db.models.deletion.CASCADE,
to='company.Employee',
verbose_name='员工编号'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='TblVendor',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user', models.CharField(blank=True,
max_length=250,
null=True)),
('password',
models.CharField(blank=True, max_length=250, null=True)),
('name', models.CharField(blank=True,
max_length=250,
null=True)),
('address',
models.CharField(blank=True, max_length=250, null=True)),
('phone',
models.CharField(blank=True, max_length=250, null=True)),
('email', models.CharField(max_length=250, unique=True)),
('web_url',
models.CharField(blank=True, max_length=250, null=True)),
('latitude', models.FloatField(blank=True, null=True)),
('longitude', models.FloatField(blank=True, null=True)),
('description', models.TextField(blank=True, null=True)),
('cover_photo',
models.FileField(
blank=True,
null=True,
upload_to=company.models.get_vendor_image_path)),
('mon_op_timings',
models.CharField(blank=True, max_length=250, null=True)),
('mon_close_timings',
models.CharField(blank=True, max_length=250, null=True)),
('tues_op_timings',
models.CharField(blank=True, max_length=250, null=True)),
('tues_close_timings',
models.CharField(blank=True, max_length=250, null=True)),
('wed_op_timings',
models.CharField(blank=True, max_length=250, null=True)),
('wed_close_timings',
models.CharField(blank=True, max_length=250, null=True)),
('thurs_op_timings',
models.CharField(blank=True, max_length=250, null=True)),
('thurs_close_timings',
models.CharField(blank=True, max_length=250, null=True)),
('fri_op_timings',
models.CharField(blank=True, max_length=250, null=True)),
('fri_close_timings',
models.CharField(blank=True, max_length=250, null=True)),
('sat_op_timings',
models.CharField(blank=True, max_length=250, null=True)),
('sat_close_timings',
models.CharField(blank=True, max_length=250, null=True)),
('sun_op_timings',
models.CharField(blank=True, max_length=250, null=True)),
('sun_close_timings',
models.CharField(blank=True, max_length=250, null=True)),
('food_menu',
models.FileField(
blank=True,
null=True,
upload_to=company.models.get_food_menu_path)),
('drinks_menu',
models.FileField(
blank=True,
null=True,
upload_to=company.models.get_drinks_menu_path)),
('dessert_menu',
models.FileField(
blank=True,
null=True,
upload_to=company.models.get_dessert_menu_path)),
('cafe_menu',
models.FileField(
blank=True,
null=True,
upload_to=company.models.get_cafe_menu_path)),
('category',
models.CharField(blank=True, max_length=250, null=True)),
('cuisines',
models.CharField(blank=True, max_length=250, null=True)),
('ambience',
models.CharField(blank=True, max_length=250, null=True)),
('special_offerings',
models.CharField(blank=True, max_length=250, null=True)),
('ordering_options', models.IntegerField(blank=True,
null=True)),
('cost_for_two',
models.CharField(blank=True, max_length=250, null=True)),
('payment_modes',
models.CharField(blank=True, max_length=250, null=True)),
('facilities',
models.CharField(blank=True, max_length=250, null=True)),
('contact_person',
models.CharField(blank=True, max_length=250, null=True)),
('phone_contact_person',
models.CharField(blank=True, max_length=250, null=True)),
('date_created', models.DateTimeField(blank=True, null=True)),
('date_updated', models.DateTimeField(blank=True, null=True)),
('is_anonymous', models.IntegerField(default=False)),
('is_active', models.IntegerField(default=1)),
('is_authenticated', models.IntegerField(default=False)),
('last_login', models.DateTimeField(default='1970-01-01')),
],
),
migrations.CreateModel(
name='TblData',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('cat_type',
models.CharField(blank=True, max_length=250, null=True)),
('cat_name',
models.CharField(blank=True, max_length=250, null=True)),
('display_name',
models.CharField(blank=True, max_length=250, null=True)),
('image',
models.FileField(blank=True,
null=True,
upload_to=company.models.get_catagory_path)),
],
),
migrations.CreateModel(
name='TblVendorImages',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.FileField(
blank=True,
null=True,
upload_to=company.models.get_vendor_image_path)),
('vendor',
models.ForeignKey(blank=True,
max_length=250,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
]
