# Generated by Django 5.1.4 on 2025-01-03 10:56 import django.db.models.deletion import django.utils.timezone from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ('system_administration', '0001_initial'), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name='MyMessage', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('message_title', models.CharField(blank=True, default='', max_length=100)), ('message_body', models.CharField(blank=True, default='', max_length=500)), ('created_on', models.DateTimeField(auto_now_add=True)), ], ), migrations.CreateModel( name='MyNotification', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('notification_title', models.CharField(blank=True, default='', max_length=100)), ('notification_body', models.CharField(blank=True, default='', max_length=500)), ('created_on', models.DateTimeField(auto_now_add=True)), ], ), migrations.CreateModel( name='Bonus', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('bonus_title', models.CharField(default='', max_length=100)), ('bonus_description', models.CharField(blank=True, default='', max_length=500)), ('bonus_type', models.CharField(choices=[('performance_bonus', 'Performance Bonus'), ('annual_bonus', 'Annual Bonus'), ('retention_bonus', 'Retention Bonus'), ('sales_commision', 'Sales Commision'), ('attendance_bonus', 'Attendance Bonus'), ('other', 'Other'), ('not_selected', 'Not Selected')], default='not_selected', max_length=20)), ('bonus_amount', models.CharField(default='0.00', max_length=12)), ('date_effective_from', models.DateField(blank=True, null=True)), ('date_effective_to', models.DateField(blank=True, null=True)), ('recycle_bin', models.BooleanField(default=False)), ('created_on', models.DateTimeField(auto_now_add=True)), ('last_updated_on', models.DateTimeField(auto_now=True)), ('company_profile', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='company_bonuses', to='system_administration.companyprofile')), ], options={ 'verbose_name': 'Bonus', 'verbose_name_plural': 'Bonuses', }, ), migrations.CreateModel( name='BonusInstance', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('bonus_instance_value', models.CharField(default='0.00', max_length=12)), ('recycle_bin', models.BooleanField(default=False)), ('created_on', models.DateTimeField(auto_now_add=True)), ('last_updated_on', models.DateTimeField(auto_now=True)), ('bonus', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='bonus_items', to='human_resource.bonus')), ], ), migrations.CreateModel( name='Deduction', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('deduction_title', models.CharField(default='', max_length=100)), ('deduction_description', models.CharField(blank=True, default='', max_length=500)), ('deduction_type', models.CharField(choices=[('tax', 'Tax'), ('insurance', 'Insurance'), ('pension', 'Pension'), ('loan_repayment', 'Loan Repayment'), ('other', 'Other'), ('not_selected', 'Not Selected')], default='not_selected', max_length=20)), ('deduction_module', models.CharField(choices=[('percentage', 'Percentage'), ('fixed', 'Fixed'), ('other', 'Other'), ('not_selected', 'Not Selected')], default='not_selected', max_length=20)), ('deduction_value', models.CharField(default='0.00', max_length=20)), ('date_effective_from', models.DateField(blank=True, null=True)), ('date_effective_to', models.DateField(blank=True, null=True)), ('recycle_bin', models.BooleanField(default=False)), ('created_on', models.DateTimeField(auto_now_add=True)), ('last_updated_on', models.DateTimeField(auto_now=True)), ('company_profile', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='company_deductions', to='system_administration.companyprofile')), ], ), migrations.CreateModel( name='DeductionInstance', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('deduction_instance_value', models.CharField(default='0.00', max_length=12)), ('recycle_bin', models.BooleanField(default=False)), ('created_on', models.DateTimeField(auto_now_add=True)), ('last_updated_on', models.DateTimeField(auto_now=True)), ('deduction', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='deduction_items', to='human_resource.deduction')), ], ), migrations.CreateModel( name='PayrollSheet', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('payroll_sheet_title', models.CharField(default='', max_length=100)), ('payroll_sheet_number', models.CharField(default='', max_length=50, unique=True)), ('payroll_sheet_description', models.CharField(blank=True, default='', max_length=500)), ('payroll_sheet_for_the_month_of', models.CharField(choices=[('january', 'January'), ('february', 'February'), ('march', 'March'), ('april', 'April'), ('may', 'May'), ('june', 'June'), ('july', 'July'), ('august', 'August'), ('september', 'September'), ('october', 'October'), ('november', 'November'), ('december', 'December'), ('not_selected', 'Not Selected')], default='not_selected', max_length=100)), ('payroll_sheet_for_the_year', models.CharField(default='2024', max_length=15)), ('payroll_sheet_value', models.CharField(default='0.00', max_length=15)), ('payroll_sheet_total_net_pay_value', models.CharField(default='0.00', max_length=15)), ('payroll_sheet_total_bonus_value', models.CharField(default='0.00', max_length=15)), ('payroll_sheet_total_deduction_value', models.CharField(default='0.00', max_length=15)), ('payroll_sheet_total_commission_value', models.CharField(default='0.00', max_length=15)), ('payroll_sheet_approved_by_finance', models.BooleanField(default=False)), ('payroll_sheet_approved_by_system_administrator', models.BooleanField(default=False)), ('is_terminal_dues', models.BooleanField(default=False)), ('payroll_sheet_payment_settled', models.BooleanField(default=False)), ('recycle_bin', models.BooleanField(default=False)), ('created_on', models.DateTimeField(auto_now_add=True)), ('last_updated_on', models.DateTimeField(auto_now=True)), ('timestamp', models.DateTimeField(default=django.utils.timezone.now)), ('company_branch', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='branch_payroll_sheets', to='system_administration.companybranch')), ], ), migrations.CreateModel( name='staffPosition', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('position_title', models.CharField(default='', max_length=100)), ('position_description', models.CharField(blank=True, default='', max_length=500)), ('salary', models.CharField(blank=True, default='0.00', max_length=12)), ('recycle_bin', models.BooleanField(default=False)), ('created_on', models.DateTimeField(auto_now_add=True)), ('last_updated_on', models.DateTimeField(auto_now=True)), ('company_profile', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='company_staff_positions', to='system_administration.companyprofile')), ], options={ 'verbose_name': 'Staff Position', 'verbose_name_plural': 'Staff Positions', }, ), migrations.CreateModel( name='StaffProfile', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('staff_number', models.CharField(default='', max_length=30, unique=True)), ('first_name', models.CharField(default='', max_length=50)), ('last_name', models.CharField(default='', max_length=50)), ('email_address', models.EmailField(default='', max_length=50)), ('date_of_birth', models.DateField(blank=True, null=True)), ('country_name', models.CharField(default='Kenya (KE) [+254]', max_length=20)), ('identification_number', models.CharField(default='', max_length=20)), ('phone_number', models.CharField(default='', max_length=25)), ('kra_pin', models.CharField(default='', max_length=50)), ('staff_title', models.CharField(choices=[('mr', 'Mr.'), ('mrs', 'Mrs.'), ('miss', 'Miss'), ('other', 'Other'), ('not_selected', 'Not Selected')], default='not_selected', max_length=20)), ('type_of_employment', models.CharField(choices=[('not_selected', 'Not Selected'), ('contract', 'Contract'), ('permanent', 'Permanent')], default='not_selected', max_length=20)), ('employment_start_date', models.DateField(blank=True, null=True)), ('employment_end_date', models.DateField(blank=True, null=True)), ('emergency_contact_phone', models.CharField(blank=True, default='', max_length=25)), ('banking_institution_name', models.CharField(blank=True, default='', max_length=100)), ('bank_account_name', models.CharField(blank=True, default='', max_length=100)), ('bank_account_number', models.CharField(blank=True, default='', max_length=100)), ('bank_branch_name', models.CharField(blank=True, default='', max_length=100)), ('bank_branch_code', models.CharField(blank=True, default='', max_length=100)), ('bank_swift_code', models.CharField(blank=True, default='', max_length=100)), ('nhif_number', models.CharField(blank=True, default='', max_length=30)), ('nhif_additional_info', models.CharField(blank=True, default='', max_length=500)), ('nssf_number', models.CharField(blank=True, default='', max_length=30)), ('nssf_additional_info', models.CharField(blank=True, default='', max_length=500)), ('staff_additional_info', models.CharField(blank=True, default='', max_length=500)), ('basic_salary', models.CharField(blank=True, default='0.00', max_length=12)), ('is_profile_set', models.BooleanField(default=False)), ('is_head_of_department', models.BooleanField(default=False)), ('has_read_write_priviledges', models.BooleanField(default=False)), ('is_super_admin', models.BooleanField(default=False)), ('is_on_leave', models.BooleanField(default=False)), ('recycle_bin', models.BooleanField(default=False)), ('is_profile_active', models.BooleanField(default=True)), ('created_on', models.DateTimeField(auto_now_add=True)), ('last_updated_on', models.DateTimeField(auto_now=True)), ('personal_email', models.EmailField(blank=True, default='', max_length=100)), ('timestamp', models.DateTimeField(default=django.utils.timezone.now)), ('company_branch', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='company_branch_staffs', to='system_administration.companybranch')), ('company_department', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='company_department_staffs', to='system_administration.companydepartment')), ('staff_position', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='human_resource.staffposition')), ('user', models.OneToOneField(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='user_staff_profile', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'Staff Profile', 'verbose_name_plural': 'Staff Profiles', }, ), migrations.CreateModel( name='StaffPayrollInstance', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('gross_salary', models.CharField(default='0.00', max_length=12)), ('commissions_total', models.CharField(default='0.00', max_length=12)), ('net_salary', models.CharField(default='0.00', max_length=12)), ('recycle_bin', models.BooleanField(default=False)), ('created_on', models.DateTimeField(auto_now_add=True)), ('last_updated_on', models.DateTimeField(auto_now=True)), ('is_prorated', models.BooleanField(default=False)), ('pro_rate_factor', models.CharField(default='1.00', max_length=12)), ('bonus_instance', models.ManyToManyField(blank=True, related_name='staff_bonuses', to='human_resource.bonusinstance')), ('deduction_instance', models.ManyToManyField(blank=True, related_name='staff_deductions', to='human_resource.deductioninstance')), ('payroll_sheet', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='staff_payroll_items', to='human_resource.payrollsheet')), ('created_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='payroll_instances_created_by', to='human_resource.staffprofile')), ('last_updated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='payroll_instances_last_updated_by', to='human_resource.staffprofile')), ('staff_profile', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='human_resource.staffprofile')), ], ), migrations.CreateModel( name='StaffLeave', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('leave_type', models.CharField(choices=[('sick_leave', 'Sick Leave'), ('annual_leave', 'Annual Leave'), ('vacation_leave', 'Vacation Leave'), ('maternity_leave', 'Maternity Leave'), ('paternity_leave', 'Paternity Leave'), ('medical_leave', 'Medical Leave'), ('bereavement_leave', 'Bereavement Leave'), ('other', 'Other'), ('not_selected', 'Not Selected')], default='not_selected', max_length=20)), ('leave_description', models.CharField(blank=True, default='', max_length=500)), ('leave_start_date', models.DateField()), ('leave_end_date', models.DateField()), ('number_of_leave_days', models.CharField(default='1', max_length=5)), ('leave_department_approval', models.CharField(choices=[('pending', 'Pending'), ('denied', 'Denied'), ('approved', 'Approved')], default='pending', max_length=20)), ('leave_hr_approval', models.CharField(choices=[('pending', 'Pending'), ('denied', 'Denied'), ('approved', 'Approved')], default='pending', max_length=20)), ('leave_status', models.CharField(choices=[('active', 'Active'), ('pending', 'Pending'), ('cancelled', 'Cancelled'), ('expired', 'Expired'), ('denied', 'Denied'), ('completed', 'Completed')], default='pending', max_length=20)), ('recycle_bin', models.BooleanField(default=False)), ('created_on', models.DateTimeField(auto_now_add=True)), ('last_updated_on', models.DateTimeField(auto_now=True)), ('created_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='staff_leaves_created_by', to='human_resource.staffprofile')), ('last_updated_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='staff_leaves_last_updated_by', to='human_resource.staffprofile')), ('staff_profile', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='staff_leave_instances', to='human_resource.staffprofile')), ('staff_reliever', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='staff_leaves_relieved', to='human_resource.staffprofile')), ], ), migrations.CreateModel( name='StaffDeductionScheme', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('deduction', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='deduction_schemes', to='human_resource.deduction')), ('staff_profile', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='staff_deduction_schemes', to='human_resource.staffprofile')), ], ), migrations.CreateModel( name='StaffBonusScheme', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('bonus', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='bonus_schemes', to='human_resource.bonus')), ('staff_profile', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='staff_bonus_schemes', to='human_resource.staffprofile')), ], ), migrations.AddField( model_name='payrollsheet', name='created_by', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='payroll_sheets_created_by', to='human_resource.staffprofile'), ), migrations.AddField( model_name='payrollsheet', name='last_updated_by', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='payroll_sheets_last_updated_by', to='human_resource.staffprofile'), ), migrations.CreateModel( name='NotificationStaffReadStatus', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('notification_read', models.BooleanField(default=False)), ('notification', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='human_resource.mynotification')), ('staff', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='human_resource.staffprofile')), ], ), migrations.CreateModel( name='MessageStaffReadStatus', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('message_read', models.BooleanField(default=False)), ('message', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='human_resource.mymessage')), ('staff', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='human_resource.staffprofile')), ], ), migrations.CreateModel( name='Engagement', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('engagement_title', models.CharField(default='', max_length=100)), ('engagement_description', models.CharField(default='', max_length=500)), ('engagement_effective_from', models.DateTimeField(blank=True, null=True)), ('engagement_effective_to', models.DateTimeField(blank=True, null=True)), ('created_on', models.DateTimeField(auto_now_add=True)), ('last_updated_on', models.DateTimeField(auto_now=True)), ('company_profile', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='company_engagements', to='system_administration.companyprofile')), ('staff', models.ManyToManyField(blank=True, related_name='staff_engagements', to='human_resource.staffprofile')), ], ), migrations.CreateModel( name='Educational_Qualification', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('qualification_title', models.CharField(default='', max_length=100)), ('accredition_category', models.CharField(choices=[('not_selected', 'Not Selected'), ('phd', 'PhD'), ('masters', 'Masters'), ('bachelors', 'Bachelors'), ('diploma', 'Diploma'), ('certificate', 'Certificate'), ('other', 'Other')], default='not_selected', max_length=20)), ('accrediting_institution', models.CharField(default='', max_length=100)), ('year_of_accredition', models.CharField(default='', max_length=10)), ('created_on', models.DateTimeField(auto_now_add=True)), ('last_updated_on', models.DateTimeField(auto_now=True)), ('staff', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='staff_education_qualifications', to='human_resource.staffprofile')), ], ), migrations.CreateModel( name='Disciplinary_Record', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('disciplinary_incidence_title', models.CharField(blank=True, default='', max_length=100)), ('disciplinary_incidence_description', models.CharField(blank=True, default='', max_length=500)), ('disciplinary_verdict', models.CharField(blank=True, default='', max_length=100)), ('disciplinary_verdict_description', models.CharField(blank=True, default='', max_length=500)), ('created_on', models.DateTimeField(auto_now_add=True)), ('last_updated_on', models.DateTimeField(auto_now=True)), ('staff', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='staff_disciplinary_records', to='human_resource.staffprofile')), ], ), migrations.AddField( model_name='deductioninstance', name='created_by', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='deductions_instances_created_by', to='human_resource.staffprofile'), ), migrations.AddField( model_name='deductioninstance', name='last_updated_by', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='deductions_instances_last_updated_by', to='human_resource.staffprofile'), ), migrations.AddField( model_name='deduction', name='created_by', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='deductions_created_by', to='human_resource.staffprofile'), ), migrations.AddField( model_name='deduction', name='last_updated_by', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='deductions_last_updated_by', to='human_resource.staffprofile'), ), migrations.AddField( model_name='bonusinstance', name='created_by', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='bonus_instances_created_by', to='human_resource.staffprofile'), ), migrations.AddField( model_name='bonusinstance', name='last_updated_by', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='bonus_instances_last_updated_by', to='human_resource.staffprofile'), ), migrations.AddField( model_name='bonus', name='created_by', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='bonuses_created_by', to='human_resource.staffprofile'), ), migrations.AddField( model_name='bonus', name='last_updated_by', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='bonuses_last_updated_by', to='human_resource.staffprofile'), ), migrations.CreateModel( name='Task', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('task_title', models.CharField(default='', max_length=100)), ('task_description', models.CharField(default='', max_length=500)), ('task_effective_from', models.DateTimeField(blank=True, null=True)), ('task_effective_to', models.DateTimeField(blank=True, null=True)), ('created_on', models.DateTimeField(auto_now_add=True)), ('last_updated_on', models.DateTimeField(auto_now=True)), ('company_profile', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='company_tasks', to='system_administration.companyprofile')), ('staff', models.ManyToManyField(blank=True, related_name='staff_tasks', to='human_resource.staffprofile')), ], ), migrations.CreateModel( name='TimeSheet', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('check_in_time', models.DateTimeField()), ('check_out_time', models.DateTimeField(blank=True, null=True)), ('recycle_bin', models.BooleanField(default=False)), ('created_on', models.DateTimeField(auto_now_add=True)), ('last_updated_on', models.DateTimeField(auto_now=True)), ('staff_profile', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='staff_time_sheets', to='human_resource.staffprofile')), ], ), migrations.CreateModel( name='Training_Record', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('training_title', models.CharField(blank=True, default='', max_length=100)), ('training_description', models.CharField(blank=True, default='', max_length=500)), ('training_effective_from', models.DateTimeField(blank=True, null=True)), ('training_effective_to', models.DateTimeField(blank=True, null=True)), ('created_on', models.DateTimeField(auto_now_add=True)), ('last_updated_on', models.DateTimeField(auto_now=True)), ('staff', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='staff_training_records', to='human_resource.staffprofile')), ], ), migrations.CreateModel( name='VacancyRecord', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('vacancy_title', models.CharField(default='', max_length=100)), ('vacancy_description', models.CharField(default='', max_length=500)), ('vacancy_count', models.CharField(default='1', max_length=10)), ('vacancy_deadline', models.DateTimeField(blank=True, null=True)), ('created_on', models.DateTimeField(auto_now_add=True)), ('last_updated_on', models.DateTimeField(auto_now=True)), ('vacant_position', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='position_vacancies', to='human_resource.staffposition')), ], ), migrations.CreateModel( name='JobApplication', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created_on', models.DateTimeField(auto_now_add=True)), ('last_updated_on', models.DateTimeField(auto_now=True)), ('vacancy_record', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='vacancy_applications', to='human_resource.vacancyrecord')), ], ), migrations.CreateModel( name='VacantPositionRequirement', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('requirement_title', models.CharField(default='', max_length=100)), ('requirement_description', models.CharField(default='', max_length=500)), ('vacancy_record', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='vacancy_requirements', to='human_resource.vacancyrecord')), ], ), migrations.CreateModel( name='WorkShift', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('shift_name', models.CharField(default='', max_length=50)), ('shift_hours_start', models.TimeField(blank=True, null=True)), ('shift_hours_end', models.TimeField(blank=True, null=True)), ('shift_description', models.CharField(blank=True, default='', max_length=500)), ('recycle_bin', models.BooleanField(default=False)), ('created_on', models.DateTimeField(auto_now_add=True)), ('last_updated_on', models.DateTimeField(auto_now=True)), ('company_profile', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='company_work_shifts', to='system_administration.companyprofile')), ], ), migrations.CreateModel( name='WorkingDays', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('day_of_week_identifier', models.CharField(default='0', max_length=1)), ('recycle_bin', models.BooleanField(default=False)), ('created_on', models.DateTimeField(auto_now_add=True)), ('last_updated_on', models.DateTimeField(auto_now=True)), ('work_shift', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='workday_shifts', to='human_resource.workshift')), ], ), ]