text: # -*- coding: utf-8 -*-
  # Generated by Django 1.10.5 on 2017-01-26 17:29
  from __future__ import unicode_literals
  
  from django.db import migrations, models
  import django.db.models.deletion
  
  
  class Migration(migrations.Migration):
  
      initial = True
  
      dependencies = [
          ('utils', '0001_initial'),
      ]
  
      operations = [
          migrations.CreateModel(
              name='BankAccount',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('name_on_account', models.CharField(blank=True, max_length=100, null=True)),
                  ('bank_name', models.CharField(blank=True, max_length=100, null=True)),
                  ('branch_name', models.CharField(blank=True, max_length=200, null=True)),
                  ('account_number', models.CharField(blank=True, max_length=30, null=True)),
                  ('ifsc', models.CharField(blank=True, max_length=20, null=True)),
                  ('created_on', models.DateTimeField(auto_now_add=True)),
                  ('updated_on', models.DateTimeField(auto_now=True)),
              ],
          ),
          migrations.CreateModel(
              name='CertificationCourse',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('course_name', models.CharField(blank=True, max_length=200, null=True)),
                  ('obtained_from', models.CharField(blank=True, max_length=200, null=True)),
                  ('validity', models.DateField(blank=True, null=True)),
                  ('quality', models.CharField(blank=True, max_length=20, null=True)),
                  ('created_on', models.DateTimeField(auto_now_add=True)),
                  ('updated_on', models.DateTimeField(auto_now=True)),
              ],
          ),
          migrations.CreateModel(
              name='CurrentAddress',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('name', models.CharField(blank=True, max_length=35, null=True)),
                  ('address_line_1', models.CharField(blank=True, max_length=200, null=True)),
                  ('address_line_2', models.CharField(blank=True, max_length=200, null=True)),
                  ('address_line_3', models.CharField(blank=True, max_length=200, null=True)),
                  ('city', models.CharField(blank=True, max_length=35, null=True)),
                  ('state', models.CharField(blank=True, max_length=35, null=True)),
                  ('pin', models.CharField(blank=True, max_length=8, null=True)),
                  ('phone', models.CharField(blank=True, max_length=15, null=True)),
                  ('created_on', models.DateTimeField(auto_now_add=True)),
                  ('updated_on', models.DateTimeField(auto_now=True)),
              ],
          ),
          migrations.CreateModel(
              name='CurrentEmployeeDetails',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('current_job_responsibilities', models.TextField(blank=True, null=True, verbose_name='Outline briefly current job responsibilities')),
                  ('present_salary', models.TextField(blank=True, null=True)),
                  ('role', models.CharField(blank=True, max_length=100, null=True)),
                  ('e_shops', models.CharField(blank=True, max_length=50, null=True)),
                  ('date_of_acquisition', models.CharField(blank=True, max_length=15, null=True)),
                  ('date_of_vesting', models.CharField(blank=True, max_length=15, null=True)),
                  ('date_of_selling', models.CharField(blank=True, max_length=15, null=True)),
                  ('pan', models.CharField(blank=True, max_length=15, null=True)),
                  ('id_type', models.CharField(blank=True, max_length=70, null=True)),
                  ('id_number', models.CharField(blank=True, max_length=25, null=True)),
                  ('pf_account', models.CharField(blank=True, max_length=35, null=True)),
                  ('created_on', models.DateTimeField(auto_now_add=True)),
                  ('updated_on', models.DateTimeField(auto_now=True)),
              ],
          ),
          migrations.CreateModel(
              name='EducationalDegree',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('course_name', models.CharField(blank=True, max_length=50, null=True)),
                  ('college_name', models.CharField(blank=True, max_length=200, null=True)),
                  ('university_name', models.CharField(blank=True, max_length=200, null=True)),
                  ('specialization', models.CharField(blank=True, max_length=200, null=True)),
                  ('marks_obtained', models.CharField(blank=True, max_length=20, null=True)),
                  ('max_marks', models.CharField(blank=True, max_length=10, null=True)),
                  ('passing_year', models.DateField(blank=True, null=True)),
                  ('created_on', models.DateTimeField(auto_now_add=True)),
                  ('updated_on', models.DateTimeField(auto_now=True)),
              ],
          ),
          migrations.CreateModel(
              name='EducationalQualification',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('created_on', models.DateTimeField(auto_now_add=True)),
                  ('updated_on', models.DateTimeField(auto_now=True)),
                  ('degree', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='employee.EducationalDegree')),
              ],
          ),
          migrations.CreateModel(
              name='Employee',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('employee_id', models.CharField(max_length=35, unique=True)),
                  ('designation', models.CharField(blank=True, max_length=35, null=True)),
                  ('reporting_person', models.CharField(blank=True, max_length=35, null=True)),
                  ('name', models.CharField(max_length=35)),
                  ('father_name', models.CharField(blank=True, max_length=35, null=True)),
                  ('mother_name', models.CharField(blank=True, max_length=35, null=True)),
                  ('phone', models.CharField(blank=True, max_length=15, null=True)),
                  ('alternate_phone', models.CharField(blank=True, max_length=15, null=True)),
                  ('email', models.EmailField(blank=True, max_length=70, null=True)),
                  ('date_of_birth', models.DateField()),
                  ('created_on', models.DateTimeField(auto_now_add=True)),
                  ('updated_on', models.DateTimeField(auto_now=True)),
                  ('office', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='utils.AahoOffice')),
              ],
          ),
          migrations.CreateModel(
              name='EmploymentAgency',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('name', models.CharField(blank=True, max_length=70, null=True)),
                  ('contact_name', models.CharField(blank=True, max_length=35, null=True)),
                  ('phone', models.CharField(blank=True, max_length=15, null=True)),
                  ('email', models.EmailField(blank=True, max_length=50, null=True)),
                  ('created_on', models.DateTimeField(auto_now_add=True)),
                  ('updated_on', models.DateTimeField(auto_now=True)),
                  ('employee', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='employment_agency', to='employee.Employee')),
              ],
          ),
          migrations.CreateModel(
              name='Family',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('family_member_name', models.CharField(blank=True, max_length=35, null=True)),
                  ('relationship_with_employee', models.CharField(blank=True, max_length=35, null=True)),
                  ('date_of_birth', models.CharField(blank=True, max_length=15, null=True)),
                  ('dependent', models.CharField(choices=[('YES', 'YES'), ('NO', 'NO'), ('Not Specified', 'Not Specified')], default='Not Specified', max_length=10)),
                  ('is_same_company', models.CharField(choices=[('YES', 'YES'), ('NO', 'NO'), ('Not Specified', 'Not Specified')], default='Not Specified', max_length=10)),
                  ('employment_status', models.CharField(blank='Not Specified', choices=[('Government Job', 'Government Job'), ('Private Job', 'Private Job'), ('Businessman', 'Businessman'), ('Farmer', 'Farmer'), ('Unemployed', 'Unemployed'), ('Not Specified', 'Not Specified')], max_length=20)),
                  ('created_on', models.DateTimeField(auto_now_add=True)),
                  ('updated_on', models.DateTimeField(auto_now=True)),
                  ('employee', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='family', to='employee.Employee')),
              ],
          ),
          migrations.CreateModel(
              name='JoiningDetails',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('recruiter_name', models.CharField(blank=True, max_length=35, null=True)),
                  ('date_of_appointment', models.DateField(blank=True, null=True)),
                  ('joining_dept', models.CharField(blank=True, max_length=35, null=True)),
                  ('date_of_joining', models.DateField(blank=True, null=True)),
                  ('initial_designation', models.CharField(blank=True, max_length=35, null=True)),
                  ('mode_of_recruitment', models.CharField(blank=True, max_length=35, null=True)),
                  ('employee_type', models.CharField(blank=True, max_length=35, null=True)),
                  ('initial_salary', models.CharField(blank=True, max_length=20, null=True)),
                  ('created_on', models.DateTimeField(auto_now_add=True)),
                  ('updated_on', models.DateTimeField(auto_now=True)),
                  ('employee', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='joining_details', to='employee.Employee')),
              ],
          ),
          migrations.CreateModel(
              name='LeaveRecord',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('leave_approval_status', models.CharField(choices=[('Approved', 'Approved'), ('Cancelled', 'Cancelled'), ('Pending', 'Pending')], default='Pending', max_length=10)),
                  ('leave_category', models.CharField(choices=[('Paid Leave', 'Paid Leave'), ('Casual Leave', 'Casual Leave'), ('Medical Leave', 'Medical Leave')], max_length=20)),
                  ('from_date', models.DateField(blank=True, null=True)),
                  ('to_date', models.DateField(blank=True, null=True)),
                  ('reason_for_leave', models.TextField(blank=True, null=True)),
                  ('leave_balance', models.CharField(blank=True, max_length=70, null=True)),
                  ('remarks', models.TextField(blank=True, null=True)),
                  ('created_on', models.DateTimeField(auto_now_add=True)),
                  ('updated_on', models.DateTimeField(auto_now=True)),
                  ('employee', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='leave_record', to='employee.Employee')),
                  ('sanctioning_person', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='sanction_leave_emp', to='employee.Employee')),
              ],
          ),
          migrations.CreateModel(
              name='Nominee',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('name_of_nominee', models.CharField(blank=True, max_length=35, null=True)),
                  ('relationship_with_employee', models.CharField(blank=True, max_length=35, null=True)),
                  ('type_of_nomination', models.CharField(blank=True, max_length=35, null=True)),
                  ('nominee_age', models.CharField(blank=True, max_length=10, null=True)),
                  ('percentage_share', models.CharField(blank=True, max_length=10, null=True)),
                  ('address_line_1', models.CharField(blank=True, max_length=200, null=True)),
                  ('address_line_2', models.CharField(blank=True, max_length=200, null=True)),
                  ('address_line_3', models.CharField(blank=True, max_length=200, null=True)),
                  ('city', models.CharField(blank=True, max_length=35, null=True)),
                  ('state', models.CharField(blank=True, max_length=35, null=True)),
                  ('pin', models.CharField(blank=True, max_length=8, null=True)),
                  ('phone', models.CharField(blank=True, max_length=15, null=True)),
                  ('created_on', models.DateTimeField(auto_now_add=True)),
                  ('updated_on', models.DateTimeField(auto_now=True)),
                  ('employee', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='nominee', to='employee.Employee')),
              ],
          ),
          migrations.CreateModel(
              name='PastEmployee',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('period', models.CharField(blank=True, max_length=50, null=True)),
                  ('organisation', models.CharField(blank=True, max_length=100, null=True)),
                  ('designation', models.CharField(blank=True, max_length=100, null=True)),
                  ('reporting_manager', models.CharField(blank=True, max_length=100, null=True)),
                  ('gross_compensation', models.CharField(blank=True, max_length=20, null=True)),
                  ('reason_for_change', models.TextField(blank=True, null=True)),
                  ('total_year_of_experience', models.CharField(blank=True, max_length=3, null=True)),
                  ('total_month_of_experience', models.CharField(blank=True, max_length=3, null=True)),
                  ('relevant_year_of_experience', models.CharField(blank=True, max_length=3, null=True)),
                  ('relevant_month_of_experience', models.CharField(blank=True, max_length=3, null=True)),
                  ('created_on', models.DateTimeField(auto_now_add=True)),
                  ('updated_on', models.DateTimeField(auto_now=True)),
                  ('employee', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='past_emp_details', to='employee.Employee')),
              ],
          ),
          migrations.CreateModel(
              name='PermanentAddress',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('name', models.CharField(blank=True, max_length=35, null=True)),
                  ('address_line_1', models.CharField(blank=True, max_length=200, null=True)),
                  ('address_line_2', models.CharField(blank=True, max_length=200, null=True)),
                  ('address_line_3', models.CharField(blank=True, max_length=200, null=True)),
                  ('city', models.CharField(blank=True, max_length=35, null=True)),
                  ('state', models.CharField(blank=True, max_length=35, null=True)),
                  ('pin', models.CharField(blank=True, max_length=8, null=True)),
                  ('phone', models.CharField(blank=True, max_length=15, null=True)),
                  ('created_on', models.DateTimeField(auto_now_add=True)),
                  ('updated_on', models.DateTimeField(auto_now=True)),
                  ('employee', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='permanent_address', to='employee.Employee')),
              ],
          ),
          migrations.CreateModel(
              name='PersonalDetail',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('height', models.CharField(blank=True, max_length=35, null=True)),
                  ('blood_group', models.CharField(blank=True, max_length=10, null=True)),
                  ('medical_fitness', models.TextField(blank=True, null=True)),
                  ('emergency_contact_person', models.CharField(blank=True, max_length=35, null=True)),
                  ('emergency_contact_person_phone', models.CharField(blank=True, max_length=15, null=True)),
                  ('emergency_contact_person_email', models.EmailField(blank=True, max_length=35, null=True)),
                  ('created_on', models.DateTimeField(auto_now_add=True)),
                  ('updated_on', models.DateTimeField(auto_now=True)),
                  ('employee', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='personal_details', to='employee.Employee')),
              ],
          ),
          migrations.CreateModel(
              name='Referral',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('name', models.CharField(blank=True, max_length=100, null=True)),
                  ('organisation', models.CharField(blank=True, max_length=100, null=True)),
                  ('designation', models.CharField(blank=True, max_length=100, null=True)),
                  ('phone', models.CharField(blank=True, max_length=15, null=True)),
                  ('address', models.TextField(blank=True, null=True)),
                  ('email', models.EmailField(blank=True, max_length=35, null=True)),
                  ('nature_of_assisstance', models.TextField(blank=True, null=True)),
                  ('number_of_year', models.CharField(blank=True, max_length=5, null=True)),
                  ('created_on', models.DateTimeField(auto_now_add=True)),
                  ('updated_on', models.DateTimeField(auto_now=True)),
                  ('employee', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='referral', to='employee.Employee')),
              ],
          ),
          migrations.CreateModel(
              name='Salary',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('pan_number', models.CharField(blank=True, max_length=13, null=True)),
                  ('total_salary', models.IntegerField(blank=True, default=0, null=True, verbose_name='A. Total Salary')),
                  ('advance_payment', models.IntegerField(blank=True, default=0, null=True, verbose_name='B. Advance')),
                  ('travel_allowance', models.IntegerField(blank=True, default=0, null=True, verbose_name='C. Travel Allowance')),
                  ('food_allowance', models.IntegerField(blank=True, default=True, null=True, verbose_name='D. Food Allowance')),
                  ('mobile_allowance', models.IntegerField(blank=True, default=0, null=True, verbose_name='E. Mobile Allowance')),
                  ('tax_deduction', models.IntegerField(blank=True, default=0, null=True, verbose_name='F. Mobile Allowance')),
                  ('bill_submission', models.IntegerField(blank=True, default=0, null=True, verbose_name='G. Bill submission (apart from C, D, E)')),
                  ('net_payable', models.IntegerField(blank=True, default=0, null=True, verbose_name='H. Net Payable (A-B+C+D+E-F+G)')),
                  ('created_on', models.DateTimeField(auto_now_add=True)),
                  ('updated_on', models.DateTimeField(auto_now=True)),
                  ('employee', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='salary', to='employee.Employee')),
              ],
          ),
          migrations.CreateModel(
              name='SkillSet',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('technical_skill', models.TextField(blank=True, null=True)),
                  ('professional_skill', models.TextField(blank=True, null=True)),
                  ('others', models.TextField(blank=True, null=True)),
                  ('created_on', models.DateTimeField(auto_now_add=True)),
                  ('updated_on', models.DateTimeField(auto_now=True)),
                  ('employee', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='skill_set', to='employee.Employee')),
              ],
          ),
          migrations.CreateModel(
              name='Task',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('name', models.CharField(max_length=70, unique=True)),
                  ('created_on', models.DateTimeField(auto_now_add=True)),
                  ('updated_on', models.DateTimeField(auto_now=True)),
              ],
          ),
          migrations.CreateModel(
              name='TaskEmail',
              fields=[
                  ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                  ('created_on', models.DateTimeField(auto_now_add=True)),
                  ('updated_on', models.DateTimeField(auto_now=True)),
                  ('employee', models.ManyToManyField(to='employee.Employee')),
                  ('office', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='task_eamil_office', to='utils.AahoOffice')),
                  ('task', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='task_email_work', to='employee.Task')),
              ],
          ),
          migrations.AddField(
              model_name='educationalqualification',
              name='employee',
              field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='educational', to='employee.Employee'),
          ),
          migrations.AddField(
              model_name='currentemployeedetails',
              name='employee',
              field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='current_emp_details', to='employee.Employee'),
          ),
          migrations.AddField(
              model_name='currentaddress',
              name='employee',
              field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='current_address', to='employee.Employee'),
          ),
          migrations.AddField(
              model_name='certificationcourse',
              name='employee',
              field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='certificates', to='employee.Employee'),
          ),
          migrations.AddField(
              model_name='bankaccount',
              name='employee',
              field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='bank_account', to='employee.Employee'),
          ),
          migrations.AlterUniqueTogether(
              name='taskemail',
              unique_together=set([('office', 'task')]),
          ),
      ]
  