# Generated by Django 5.0.6 on 2026-11-02 07:03

import django.db.models.deletion
from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('Company', '0001_initial'),
        ('Employee', '0001_initial'),
        ('People', '0001_initial'),
    ]

    operations = [
        migrations.AddField(
            model_name='perfappraisal',
            name='promotion_request',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='People.promotionrequest'),
        ),
        migrations.AddField(
            model_name='perfgoal',
            name='company',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='perf_goals', to='Company.company_details'),
        ),
        migrations.AddField(
            model_name='perfgoal',
            name='employee',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='perf_goals', to='Employee.employeedt'),
        ),
        migrations.AddField(
            model_name='perfgoal',
            name='parent',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='children', to='Employee.perfgoal'),
        ),
        migrations.AddField(
            model_name='perfimprovementplan',
            name='appraisal',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='improvement_plans', to='Employee.perfappraisal'),
        ),
        migrations.AddField(
            model_name='perfimprovementplan',
            name='company',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='perf_improvement_plans', to='Company.company_details'),
        ),
        migrations.AddField(
            model_name='perfimprovementplan',
            name='employee',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='perf_improvement_plans', to='Employee.employeedt'),
        ),
        migrations.AddField(
            model_name='perfmanagerfeedback',
            name='company',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='perf_manager_feedback', to='Company.company_details'),
        ),
        migrations.AddField(
            model_name='perfmanagerfeedback',
            name='employee',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='perf_feedback_received', to='Employee.employeedt'),
        ),
        migrations.AddField(
            model_name='perfmanagerfeedback',
            name='manager',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='perf_feedback_given', to='Employee.employeedt'),
        ),
        migrations.AddField(
            model_name='perfratinghistory',
            name='appraisal',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='rating_history', to='Employee.perfappraisal'),
        ),
        migrations.AddField(
            model_name='perfratinghistory',
            name='company',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='perf_rating_history', to='Company.company_details'),
        ),
        migrations.AddField(
            model_name='perfratinghistory',
            name='employee',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='perf_rating_history', to='Employee.employeedt'),
        ),
        migrations.AddField(
            model_name='perfreviewcycle',
            name='company',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='perf_review_cycles', to='Company.company_details'),
        ),
        migrations.AddField(
            model_name='perfratinghistory',
            name='cycle',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='rating_history', to='Employee.perfreviewcycle'),
        ),
        migrations.AddField(
            model_name='perfmanagerfeedback',
            name='cycle',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='manager_feedback', to='Employee.perfreviewcycle'),
        ),
        migrations.AddField(
            model_name='perfgoal',
            name='cycle',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='goals', to='Employee.perfreviewcycle'),
        ),
        migrations.AddField(
            model_name='perfappraisal',
            name='cycle',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='appraisals', to='Employee.perfreviewcycle'),
        ),
        migrations.AddField(
            model_name='perfselfreview',
            name='appraisal',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='self_reviews', to='Employee.perfappraisal'),
        ),
        migrations.AddField(
            model_name='perfselfreview',
            name='company',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='perf_self_reviews', to='Company.company_details'),
        ),
        migrations.AddField(
            model_name='perfselfreview',
            name='cycle',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='self_reviews', to='Employee.perfreviewcycle'),
        ),
        migrations.AddField(
            model_name='perfselfreview',
            name='employee',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='perf_self_reviews', to='Employee.employeedt'),
        ),
        migrations.AddField(
            model_name='reportinghierarchy',
            name='company',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='reporting_hierarchy', to='Company.company_details'),
        ),
        migrations.AddField(
            model_name='target',
            name='company',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='targets', to='Company.company_details'),
        ),
        migrations.AddField(
            model_name='target',
            name='employee',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='targets', to='Employee.employeedt'),
        ),
        migrations.AddField(
            model_name='perfgoal',
            name='legacy_target',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='perf_goals', to='Employee.target'),
        ),
        migrations.AddField(
            model_name='wfhpolicy',
            name='company',
            field=models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='wfh_policy', to='Company.company_details'),
        ),
        migrations.AddField(
            model_name='wfhrequest',
            name='company',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='wfh_requests', to='Company.company_details'),
        ),
        migrations.AddIndex(
            model_name='approvalaction',
            index=models.Index(fields=['company', 'request_type', 'request_id'], name='Employee_ap_company_4dfb8e_idx'),
        ),
        migrations.AddIndex(
            model_name='approvalaction',
            index=models.Index(fields=['company', 'status', 'approver_code'], name='Employee_ap_company_9ab497_idx'),
        ),
        migrations.AddConstraint(
            model_name='approvalworkflowstep',
            constraint=models.UniqueConstraint(fields=('company', 'request_type', 'step_order'), name='unique_company_workflow_step_order'),
        ),
        migrations.AddIndex(
            model_name='department',
            index=models.Index(fields=['company', 'is_active'], name='Employee_de_company_54f280_idx'),
        ),
        migrations.AddConstraint(
            model_name='department',
            constraint=models.UniqueConstraint(fields=('company', 'name'), name='unique_company_department_name'),
        ),
        migrations.AddIndex(
            model_name='attendanceemp',
            index=models.Index(fields=['company', 'date'], name='Employee_at_company_54bbae_idx'),
        ),
        migrations.AddIndex(
            model_name='attendanceemp',
            index=models.Index(fields=['company', 'Employee_ID'], name='Employee_at_company_199083_idx'),
        ),
        migrations.AddIndex(
            model_name='employeedocument',
            index=models.Index(fields=['company', 'employee'], name='Employee_em_company_f5d71f_idx'),
        ),
        migrations.AddIndex(
            model_name='employeedocument',
            index=models.Index(fields=['company', 'document_type'], name='Employee_em_company_1d9fdb_idx'),
        ),
        migrations.AddIndex(
            model_name='employeedocument',
            index=models.Index(fields=['employee', 'document_type'], name='Employee_em_employe_e69355_idx'),
        ),
        migrations.AddIndex(
            model_name='candidateexperience',
            index=models.Index(fields=['employee'], name='Employee_ca_employe_8f069f_idx'),
        ),
        migrations.AddIndex(
            model_name='candidateexperience',
            index=models.Index(fields=['company_name'], name='Employee_ca_company_5961cc_idx'),
        ),
        migrations.AddIndex(
            model_name='candidateeducation',
            index=models.Index(fields=['employee'], name='Employee_ca_employe_50c8b6_idx'),
        ),
        migrations.AddIndex(
            model_name='bankaccount',
            index=models.Index(fields=['employee'], name='Employee_ba_employe_7eaed3_idx'),
        ),
        migrations.AddConstraint(
            model_name='bankaccount',
            constraint=models.UniqueConstraint(fields=('employee', 'account_number', 'ifsc_code'), name='uniq_employee_account'),
        ),
        migrations.AddIndex(
            model_name='employeerole',
            index=models.Index(fields=['company', 'is_active'], name='Employee_em_company_8fa003_idx'),
        ),
        migrations.AddConstraint(
            model_name='employeerole',
            constraint=models.UniqueConstraint(fields=('company', 'role_code'), name='unique_company_role_code'),
        ),
        migrations.AddIndex(
            model_name='employeedt',
            index=models.Index(fields=['company', 'is_active'], name='Employee_em_company_e12408_idx'),
        ),
        migrations.AddIndex(
            model_name='employeedt',
            index=models.Index(fields=['company', 'employee_code'], name='Employee_em_company_fa6645_idx'),
        ),
        migrations.AddIndex(
            model_name='employeedt',
            index=models.Index(fields=['company', 'email'], name='Employee_em_company_0ea461_idx'),
        ),
        migrations.AddIndex(
            model_name='leavebalance',
            index=models.Index(fields=['company', 'financial_year'], name='Employee_le_company_6cd279_idx'),
        ),
        migrations.AddConstraint(
            model_name='leavebalance',
            constraint=models.UniqueConstraint(fields=('company', 'Employee_ID', 'leave_type', 'financial_year'), name='unique_leave_balance_row'),
        ),
        migrations.AddConstraint(
            model_name='leavepolicy',
            constraint=models.UniqueConstraint(fields=('company', 'leave_type'), name='unique_company_leave_policy_type'),
        ),
        migrations.AddIndex(
            model_name='leaverequest',
            index=models.Index(fields=['company', 'status'], name='Employee_le_company_ee27f8_idx'),
        ),
        migrations.AddIndex(
            model_name='leaverequest',
            index=models.Index(fields=['company', 'from_date'], name='Employee_le_company_f8dfb4_idx'),
        ),
        migrations.AlterUniqueTogether(
            name='payroll',
            unique_together={('Employee_ID', 'month', 'year')},
        ),
        migrations.AddConstraint(
            model_name='perfreviewcycle',
            constraint=models.UniqueConstraint(fields=('company', 'name'), name='unique_company_perf_cycle_name'),
        ),
        migrations.AddIndex(
            model_name='perfratinghistory',
            index=models.Index(fields=['company', 'financial_year'], name='Employee_pe_company_98802e_idx'),
        ),
        migrations.AddConstraint(
            model_name='perfratinghistory',
            constraint=models.UniqueConstraint(condition=models.Q(('cycle__isnull', False)), fields=('company', 'employee', 'cycle'), name='unique_company_employee_cycle_rating_history'),
        ),
        migrations.AddIndex(
            model_name='perfmanagerfeedback',
            index=models.Index(fields=['company', 'employee'], name='Employee_pe_company_88cd5b_idx'),
        ),
        migrations.AddIndex(
            model_name='perfappraisal',
            index=models.Index(fields=['company', 'status'], name='Employee_pe_company_86ad2b_idx'),
        ),
        migrations.AddConstraint(
            model_name='perfappraisal',
            constraint=models.UniqueConstraint(fields=('company', 'employee', 'cycle'), name='unique_company_employee_cycle_appraisal'),
        ),
        migrations.AddConstraint(
            model_name='perfselfreview',
            constraint=models.UniqueConstraint(fields=('company', 'employee', 'cycle'), name='unique_company_employee_cycle_self_review'),
        ),
        migrations.AddConstraint(
            model_name='reportinghierarchy',
            constraint=models.UniqueConstraint(fields=('company', 'Employee_ID'), name='unique_company_reporting_hierarchy'),
        ),
        migrations.AddIndex(
            model_name='perfgoal',
            index=models.Index(fields=['company', 'employee'], name='Employee_pe_company_67404c_idx'),
        ),
        migrations.AddIndex(
            model_name='perfgoal',
            index=models.Index(fields=['company', 'status'], name='Employee_pe_company_13faff_idx'),
        ),
        migrations.AddIndex(
            model_name='wfhrequest',
            index=models.Index(fields=['company', 'status'], name='Employee_wf_company_13b694_idx'),
        ),
        migrations.AddIndex(
            model_name='wfhrequest',
            index=models.Index(fields=['company', 'wfh_date'], name='Employee_wf_company_2cce10_idx'),
        ),
    ]
