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 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')),
('name',
models.CharField(help_text='Company name',
max_length=100,
unique=True)),
('description',
models.CharField(help_text='Description of the company',
max_length=500)),
('website',
models.URLField(blank=True, help_text='Company website URL')),
('address',
models.CharField(blank=True,
help_text='Company address',
max_length=200)),
('phone',
models.CharField(blank=True,
help_text='Contact phone number',
max_length=50)),
('email',
models.EmailField(blank=True,
help_text='Contact email address',
max_length=254)),
('contact',
models.CharField(blank=True,
help_text='Point of contact',
max_length=100)),
('URL',
models.URLField(
blank=True,
help_text='Link to external company information')),
('image',
models.ImageField(
blank=True,
max_length=255,
null=True,
upload_to=company.models.rename_company_image)),
('notes', models.TextField(blank=True)),
('is_customer',
models.BooleanField(
default=False,
help_text='Do you sell items to this company?')),
('is_supplier',
models.BooleanField(
default=True,
help_text='Do you purchase items from this company?')),
],
),
migrations.CreateModel(
name='Contact',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100)),
('phone', models.CharField(blank=True, max_length=100)),
('email', models.EmailField(blank=True, max_length=254)),
('role', models.CharField(blank=True, max_length=100)),
],
),
migrations.CreateModel(
name='SupplierPart',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('SKU',
models.CharField(help_text='Supplier stock keeping unit',
max_length=100)),
('manufacturer',
models.CharField(blank=True,
help_text='Manufacturer',
max_length=100)),
('MPN',
models.CharField(blank=True,
help_text='Manufacturer part number',
max_length=100)),
('URL',
models.URLField(
blank=True,
help_text='URL for external supplier part link')),
('description',
models.CharField(blank=True,
help_text='Supplier part description',
max_length=250)),
('note',
models.CharField(blank=True,
help_text='Notes',
max_length=100)),
('base_cost',
models.DecimalField(
decimal_places=3,
default=0,
help_text='Minimum charge (e.g. stocking fee)',
max_digits=10,
validators=[django.core.validators.MinValueValidator(0)
])),
('packaging',
models.CharField(blank=True,
help_text='Part packaging',
max_length=50)),
('multiple',
models.PositiveIntegerField(
default=1,
help_text='Order multiple',
validators=[django.core.validators.MinValueValidator(1)
])),
('minimum',
models.PositiveIntegerField(
default=1,
help_text='Minimum order quantity (MOQ)',
validators=[django.core.validators.MinValueValidator(1)
])),
('lead_time', models.DurationField(blank=True, null=True)),
],
options={
'db_table': 'part_supplierpart',
},
),
migrations.CreateModel(
name='SupplierPriceBreak',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('quantity',
models.PositiveIntegerField(
default=1,
validators=[django.core.validators.MinValueValidator(1)
])),
('cost',
models.DecimalField(
decimal_places=5,
max_digits=10,
validators=[django.core.validators.MinValueValidator(0)
])),
('part',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='pricebreaks',
to='company.SupplierPart')),
],
options={
'db_table': 'part_supplierpricebreak',
},
),
]
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):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Department',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('dept_name', models.CharField(max_length=150, verbose_name='Department')),
('start_date', models.DateField(default=datetime.date.today, verbose_name='Start Date')),
('end_date', models.DateField(blank=True, null=True, verbose_name='End Date')),
('creation_date', models.DateField(auto_now=True)),
('last_update_date', models.DateField(auto_now_add=True)),
('attribute1', models.CharField(max_length=255)),
('attribute2', models.CharField(max_length=255)),
('attribute3', models.CharField(max_length=255)),
('attribute4', models.CharField(max_length=255)),
('attribute5', models.CharField(max_length=255)),
('attribute6', models.CharField(max_length=255)),
('attribute7', models.CharField(max_length=255)),
('attribute8', models.CharField(max_length=255)),
('attribute9', models.CharField(max_length=255)),
('attribute10', models.CharField(max_length=255)),
('attribute11', models.CharField(max_length=255)),
('attribute12', models.CharField(max_length=255)),
('attribute13', models.CharField(max_length=255)),
('attribute14', models.CharField(max_length=255)),
('attribute15', models.CharField(max_length=255)),
('lft', models.PositiveIntegerField(editable=False)),
('rght', models.PositiveIntegerField(editable=False)),
('tree_id', models.PositiveIntegerField(db_index=True, editable=False)),
('level', models.PositiveIntegerField(editable=False)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Enterprise',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=255, verbose_name='Company Name')),
('reg_tax_num', models.CharField(max_length=150, verbose_name='Reg Tax Num')),
('commercail_record', models.CharField(max_length=150, verbose_name='Commercial Record')),
('address1', models.CharField(blank=True, max_length=255, null=True, verbose_name='Address1')),
('phone', models.CharField(blank=True, max_length=255, null=True, verbose_name='Phone')),
('mobile', models.CharField(blank=True, max_length=255, null=True, verbose_name='Mobile')),
('fax', models.CharField(blank=True, max_length=255, null=True, verbose_name='Fax')),
('email', models.EmailField(blank=True, max_length=254, null=True, verbose_name='Email')),
('slug', models.SlugField(blank=True, null=True)),
('start_date', models.DateField(default=datetime.date.today, verbose_name='Start Date')),
('end_date', models.DateField(blank=True, null=True, verbose_name='End Date')),
('creation_date', models.DateField(auto_now=True)),
('last_update_date', models.DateField(auto_now_add=True)),
('attribute1', models.CharField(max_length=255)),
('attribute2', models.CharField(max_length=255)),
('attribute3', models.CharField(max_length=255)),
('attribute4', models.CharField(max_length=255)),
('attribute5', models.CharField(max_length=255)),
('attribute6', models.CharField(max_length=255)),
('attribute7', models.CharField(max_length=255)),
('attribute8', models.CharField(max_length=255)),
('attribute9', models.CharField(max_length=255)),
('attribute10', models.CharField(max_length=255)),
('attribute11', models.CharField(max_length=255)),
('attribute12', models.CharField(max_length=255)),
('attribute13', models.CharField(max_length=255)),
('attribute14', models.CharField(max_length=255)),
('attribute15', models.CharField(max_length=255)),
],
),
migrations.CreateModel(
name='Enterprise_Policies',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('policy_description', models.CharField(blank=True, max_length=255, null=True, verbose_name='Policy Description')),
('attachment', models.ImageField(blank=True, null=True, upload_to=company.models.path_and_rename, verbose_name='Attachment')),
('start_date', models.DateField(default=datetime.date.today, verbose_name='Start Date')),
('end_date', models.DateField(blank=True, null=True, verbose_name='End Date')),
('creation_date', models.DateField(auto_now=True)),
('last_update_date', models.DateField(auto_now_add=True)),
('attribute1', models.CharField(max_length=255)),
('attribute2', models.CharField(max_length=255)),
('attribute3', models.CharField(max_length=255)),
('attribute4', models.CharField(max_length=255)),
('attribute5', models.CharField(max_length=255)),
('attribute6', models.CharField(max_length=255)),
('attribute7', models.CharField(max_length=255)),
('attribute8', models.CharField(max_length=255)),
('attribute9', models.CharField(max_length=255)),
('attribute10', models.CharField(max_length=255)),
('attribute11', models.CharField(max_length=255)),
('attribute12', models.CharField(max_length=255)),
('attribute13', models.CharField(max_length=255)),
('attribute14', models.CharField(max_length=255)),
('attribute15', models.CharField(max_length=255)),
],
),
migrations.CreateModel(
name='Grade',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('grade_name', models.CharField(max_length=100, verbose_name='Grade Name')),
('grade_description', models.CharField(blank=True, max_length=255, null=True, verbose_name='Grade Description')),
('start_date', models.DateField(default=datetime.date.today, verbose_name='Start Date')),
('end_date', models.DateField(blank=True, null=True, verbose_name='End Date')),
('creation_date', models.DateField(auto_now=True)),
('last_update_date', models.DateField(auto_now_add=True)),
('attribute1', models.CharField(max_length=255)),
('attribute2', models.CharField(max_length=255)),
('attribute3', models.CharField(max_length=255)),
('attribute4', models.CharField(max_length=255)),
('attribute5', models.CharField(max_length=255)),
('attribute6', models.CharField(max_length=255)),
('attribute7', models.CharField(max_length=255)),
('attribute8', models.CharField(max_length=255)),
('attribute9', models.CharField(max_length=255)),
('attribute10', models.CharField(max_length=255)),
('attribute11', models.CharField(max_length=255)),
('attribute12', models.CharField(max_length=255)),
('attribute13', models.CharField(max_length=255)),
('attribute14', models.CharField(max_length=255)),
('attribute15', models.CharField(max_length=255)),
],
),
migrations.CreateModel(
name='Job',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('job_name', models.CharField(max_length=100, verbose_name='Job Name')),
('job_description', models.CharField(blank=True, max_length=255, null=True, verbose_name='Job Description')),
('start_date', models.DateField(default=datetime.date.today, verbose_name='Start Date')),
('end_date', models.DateField(blank=True, null=True, verbose_name='End Date')),
('creation_date', models.DateField(auto_now=True)),
('last_update_date', models.DateField(auto_now_add=True)),
('attribute1', models.CharField(max_length=255)),
('attribute2', models.CharField(max_length=255)),
('attribute3', models.CharField(max_length=255)),
('attribute4', models.CharField(max_length=255)),
('attribute5', models.CharField(max_length=255)),
('attribute6', models.CharField(max_length=255)),
('attribute7', models.CharField(max_length=255)),
('attribute8', models.CharField(max_length=255)),
('attribute9', models.CharField(max_length=255)),
('attribute10', models.CharField(max_length=255)),
('attribute11', models.CharField(max_length=255)),
('attribute12', models.CharField(max_length=255)),
('attribute13', models.CharField(max_length=255)),
('attribute14', models.CharField(max_length=255)),
('attribute15', models.CharField(max_length=255)),
],
),
migrations.CreateModel(
name='Position',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('position_name', models.CharField(max_length=100, verbose_name='Position Name')),
('position_description', models.CharField(blank=True, max_length=255, null=True, verbose_name='Position Description')),
('start_date', models.DateField(default=datetime.date.today, verbose_name='Start Date')),
('end_date', models.DateField(blank=True, null=True, verbose_name='End Date')),
('creation_date', models.DateField(auto_now=True)),
('last_update_date', models.DateField(auto_now_add=True)),
('attribute1', models.CharField(max_length=255)),
('attribute2', models.CharField(max_length=255)),
('attribute3', models.CharField(max_length=255)),
('attribute4', models.CharField(max_length=255)),
('attribute5', models.CharField(max_length=255)),
('attribute6', models.CharField(max_length=255)),
('attribute7', models.CharField(max_length=255)),
('attribute8', models.CharField(max_length=255)),
('attribute9', models.CharField(max_length=255)),
('attribute10', models.CharField(max_length=255)),
('attribute11', models.CharField(max_length=255)),
('attribute12', models.CharField(max_length=255)),
('attribute13', models.CharField(max_length=255)),
('attribute14', models.CharField(max_length=255)),
('attribute15', models.CharField(max_length=255)),
],
),
migrations.CreateModel(
name='Working_Days_Policy',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('number_of_daily_working_hrs', models.DecimalField(decimal_places=2, default=8, max_digits=3)),
('week_end_days', multiselectfield.db.fields.MultiSelectField(blank=True, choices=[(5, 'Saturday'), (6, 'Sunday'), (0, 'Monday'), (1, 'Tuesday'), (2, 'Wednesday'), (3, 'Thursday'), (4, 'Friday')], max_length=100, null=True)),
('normal_over_time_hourly_rate', models.DecimalField(decimal_places=2, max_digits=3)),
('exceptional_over_time_hourly_rate', models.DecimalField(decimal_places=2, max_digits=3)),
('hrs_start_from', models.TimeField(blank=True, null=True, verbose_name='Working Hours From')),
('hrs_end_at', models.TimeField(blank=True, null=True, verbose_name='Working Hours To')),
('delay_allowed', models.TimeField(blank=True, null=True, verbose_name='Delay allowed')),
('delay_starts_from', models.TimeField(blank=True, null=True, verbose_name='Delay calculation starts from')),
('absence_starts_from', models.TimeField(blank=True, null=True, verbose_name='Absence calculation starts from')),
('start_date', models.DateField(default=datetime.date.today, verbose_name='Start Date')),
('end_date', models.DateField(blank=True, null=True, verbose_name='End Date')),
('creation_date', models.DateField(auto_now=True)),
('last_update_date', models.DateField(auto_now_add=True)),
],
),
migrations.CreateModel(
name='Working_Hours_Deductions_Policy',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('day_number', models.IntegerField()),
('delay_rate', models.DecimalField(decimal_places=2, default=0.0, max_digits=3)),
('notify', models.BooleanField(default=False)),
('susbend', models.BooleanField(default=False)),
('start_date', models.DateField(default=datetime.date.today, verbose_name='Start Date')),
('end_date', models.DateField(blank=True, null=True, verbose_name='End Date')),
('creation_date', models.DateField(auto_now=True)),
('last_update_date', models.DateField(auto_now_add=True)),
],
),
migrations.CreateModel(
name='Year',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('year', models.IntegerField()),
('creation_date', models.DateField(auto_now_add=True)),
('last_update_date', models.DateField(auto_now=True)),
],
),
migrations.CreateModel(
name='YearlyHoliday',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=255)),
('start_date', models.DateField(verbose_name='Start Date')),
('end_date', models.DateField(verbose_name='End Date')),
('number_of_days_off', models.IntegerField(blank=True, null=True)),
('creation_date', models.DateField(auto_now=True)),
('last_update_date', models.DateField(auto_now_add=True)),
],
),
]
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')),
],
),
]