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

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


class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='BGVCase',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('agency', models.CharField(blank=True, max_length=250, null=True)),
                ('checks', models.JSONField(blank=True, default=list)),
                ('status', models.CharField(choices=[('Initiated', 'Initiated'), ('In Progress', 'In Progress'), ('Verified', 'Verified'), ('Failed', 'Failed')], db_index=True, default='Initiated', max_length=12)),
                ('result', models.CharField(choices=[('Pending', 'Pending'), ('Clean', 'Clean'), ('Adverse', 'Adverse')], default='Pending', max_length=10)),
                ('result_note', models.TextField(blank=True, null=True)),
                ('report', models.FileField(blank=True, null=True, upload_to='candidate_documents/bgv_reports/')),
                ('completed_at', models.DateTimeField(blank=True, null=True)),
                ('candidate', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='bgv_case', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='bgv_cases', to='Company.company_details')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='CandidateApproval',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('status', models.CharField(choices=[('Pending', 'Pending'), ('Approved', 'Approved'), ('Rejected', 'Rejected')], db_index=True, default='Pending', max_length=10)),
                ('maker', models.CharField(blank=True, max_length=150, null=True)),
                ('checker', models.CharField(blank=True, max_length=150, null=True)),
                ('remarks', models.TextField(blank=True, null=True)),
                ('decided_at', models.DateTimeField(blank=True, null=True)),
                ('candidate', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='creation_approval', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='candidate_approvals', to='Company.company_details')),
            ],
            options={
                'ordering': ['-created_at'],
            },
        ),
        migrations.CreateModel(
            name='CandidatePortalLink',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('token', models.CharField(max_length=80, unique=True)),
                ('document_types', models.JSONField(blank=True, default=list)),
                ('expires_at', models.DateTimeField()),
                ('revoked', models.BooleanField(default=False)),
                ('sent_to', models.CharField(blank=True, max_length=254, null=True)),
                ('first_opened_at', models.DateTimeField(blank=True, null=True)),
                ('last_opened_at', models.DateTimeField(blank=True, null=True)),
                ('last_edit_at', models.DateTimeField(blank=True, null=True)),
                ('submitted_at', models.DateTimeField(blank=True, null=True)),
                ('submit_count', models.PositiveIntegerField(default=0)),
                ('candidate', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='portal_links', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='candidate_portal_links', to='Company.company_details')),
            ],
            options={
                'ordering': ['-created_at'],
            },
        ),
        migrations.CreateModel(
            name='CandidatePortalActivity',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('action', models.CharField(db_index=True, max_length=30)),
                ('detail', models.JSONField(blank=True, default=dict)),
                ('ip_address', models.CharField(blank=True, max_length=64, null=True)),
                ('candidate', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='portal_activity', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='candidate_portal_activity', to='Company.company_details')),
                ('link', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='activity', to='Recruitment.candidateportallink')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='CandidatePortalAccount',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('email', models.CharField(db_index=True, max_length=254)),
                ('password', models.CharField(max_length=128)),
                ('registered_at', models.DateTimeField(auto_now_add=True)),
                ('last_login_at', models.DateTimeField(blank=True, null=True)),
                ('failed_attempts', models.PositiveSmallIntegerField(default=0)),
                ('locked_until', models.DateTimeField(blank=True, null=True)),
                ('candidate', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='portal_account', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='candidate_portal_accounts', to='Company.company_details')),
                ('link', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='accounts', to='Recruitment.candidateportallink')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='DocumentReview',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('status', models.CharField(choices=[('Pending', 'Pending'), ('Verified', 'Verified'), ('Rejected', 'Rejected')], default='Pending', max_length=10)),
                ('remarks', models.TextField(blank=True, null=True)),
                ('reviewed_by', models.CharField(blank=True, max_length=150, null=True)),
                ('reviewed_at', models.DateTimeField(blank=True, null=True)),
                ('document', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='review', to='Employee.employeedocument')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='DocumentUploadLink',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('token', models.CharField(max_length=80, unique=True)),
                ('document_types', models.JSONField(blank=True, default=list)),
                ('expires_at', models.DateTimeField()),
                ('max_uses', models.PositiveIntegerField(default=20)),
                ('use_count', models.PositiveIntegerField(default=0)),
                ('revoked', models.BooleanField(default=False)),
                ('sent_to', models.CharField(blank=True, max_length=254, null=True)),
                ('last_used_at', models.DateTimeField(blank=True, null=True)),
                ('candidate', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='doc_upload_links', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='doc_upload_links', to='Company.company_details')),
            ],
            options={
                'ordering': ['-created_at'],
            },
        ),
        migrations.CreateModel(
            name='HiringChecklistItem',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('title', models.CharField(max_length=200)),
                ('category', models.CharField(choices=[('Todo', 'To-do'), ('Documentation', 'Documentation')], default='Todo', max_length=14)),
                ('doc_type', models.CharField(blank=True, max_length=30, null=True)),
                ('is_done', models.BooleanField(default=False)),
                ('done_by', models.CharField(blank=True, max_length=150, null=True)),
                ('done_at', models.DateTimeField(blank=True, null=True)),
                ('due_date', models.DateField(blank=True, null=True)),
                ('sort_order', models.PositiveIntegerField(default=0)),
                ('candidate', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='hiring_checklist', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='hiring_checklist', to='Company.company_details')),
            ],
            options={
                'ordering': ['sort_order', 'id'],
            },
        ),
        migrations.CreateModel(
            name='InterviewRound',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('interview_id', models.CharField(db_index=True, max_length=30)),
                ('round_name', models.CharField(max_length=100)),
                ('round_no', models.PositiveIntegerField(default=1)),
                ('scheduled_at', models.DateTimeField()),
                ('duration_minutes', models.PositiveIntegerField(default=60)),
                ('mode', models.CharField(blank=True, max_length=100, null=True)),
                ('meeting_link', models.CharField(blank=True, max_length=500, null=True)),
                ('status', models.CharField(choices=[('Scheduled', 'Scheduled'), ('Completed', 'Completed'), ('Cancelled', 'Cancelled'), ('No Show', 'No Show')], db_index=True, default='Scheduled', max_length=12)),
                ('feedback_status', models.CharField(choices=[('Pending', 'Pending'), ('Submitted', 'Submitted')], default='Pending', max_length=10)),
                ('notes', models.TextField(blank=True, null=True)),
                ('candidate', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='interview_rounds', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='interview_rounds', to='Company.company_details')),
                ('interviewer', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='interviews_taken', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['scheduled_at'],
                'unique_together': {('company', 'interview_id')},
            },
        ),
        migrations.CreateModel(
            name='InterviewFeedback',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('technical_skills', models.PositiveSmallIntegerField(default=0)),
                ('problem_solving', models.PositiveSmallIntegerField(default=0)),
                ('communication', models.PositiveSmallIntegerField(default=0)),
                ('culture_fit', models.PositiveSmallIntegerField(default=0)),
                ('domain_knowledge', models.PositiveSmallIntegerField(default=0)),
                ('leadership', models.PositiveSmallIntegerField(default=0)),
                ('recommendation', models.CharField(choices=[('Strong Hire', 'Strong Hire'), ('Hire', 'Hire'), ('Hold', 'Hold'), ('No Hire', 'No Hire'), ('Strong No Hire', 'Strong No Hire')], max_length=20)),
                ('strengths', models.TextField(blank=True, null=True)),
                ('concerns', models.TextField(blank=True, null=True)),
                ('comments', models.TextField(blank=True, null=True)),
                ('why_hire', models.TextField(blank=True, null=True)),
                ('why_not_hire', models.TextField(blank=True, null=True)),
                ('submitted_by_label', models.CharField(blank=True, max_length=150, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='interview_feedbacks', to='Company.company_details')),
                ('submitted_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='feedback_given', to='Employee.employeedt')),
                ('interview', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='feedback', to='Recruitment.interviewround')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='JobRequisition',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('requisition_id', models.CharField(db_index=True, max_length=30)),
                ('position_title', models.CharField(max_length=200)),
                ('department_name', models.CharField(blank=True, max_length=150, null=True)),
                ('work_mode', models.CharField(blank=True, max_length=50, null=True)),
                ('location', models.CharField(blank=True, max_length=150, null=True)),
                ('vacancies', models.PositiveIntegerField(default=1)),
                ('budget_min_lpa', models.DecimalField(blank=True, decimal_places=2, max_digits=8, null=True)),
                ('budget_max_lpa', models.DecimalField(blank=True, decimal_places=2, max_digits=8, null=True)),
                ('priority', models.CharField(choices=[('Low', 'Low'), ('Medium', 'Medium'), ('High', 'High'), ('Urgent', 'Urgent')], default='Medium', max_length=10)),
                ('approval_status', models.CharField(choices=[('Draft', 'Draft'), ('Submitted', 'Submitted'), ('Approved', 'Approved'), ('Rejected', 'Rejected'), ('Closed', 'Closed')], db_index=True, default='Draft', max_length=10)),
                ('approved_by', models.CharField(blank=True, max_length=150, null=True)),
                ('approved_at', models.DateTimeField(blank=True, null=True)),
                ('rejection_reason', models.TextField(blank=True, null=True)),
                ('closed_at', models.DateTimeField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='job_requisitions', to='Company.company_details')),
                ('department', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='requisitions', to='Employee.department')),
                ('hiring_manager', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='managed_requisitions', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['-created_at'],
                'unique_together': {('company', 'requisition_id')},
            },
        ),
        migrations.CreateModel(
            name='HiringQuestion',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('question', models.TextField()),
                ('category', models.CharField(blank=True, max_length=60, null=True)),
                ('answer', models.TextField(blank=True, null=True)),
                ('asked_by', models.CharField(blank=True, max_length=150, null=True)),
                ('sort_order', models.PositiveIntegerField(default=0)),
                ('candidate', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='hiring_questions', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='hiring_questions', to='Company.company_details')),
                ('requisition', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='hiring_questions', to='Recruitment.jobrequisition')),
            ],
            options={
                'ordering': ['sort_order', 'id'],
            },
        ),
        migrations.CreateModel(
            name='CandidateSelection',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('approved_ctc_lpa', models.DecimalField(blank=True, decimal_places=2, max_digits=8, null=True)),
                ('joining_date', models.DateField(blank=True, null=True)),
                ('status', models.CharField(choices=[('Selected', 'Selected'), ('Offer Generated', 'Offer Generated'), ('Rejected', 'Rejected')], default='Selected', max_length=20)),
                ('remarks', models.TextField(blank=True, null=True)),
                ('decided_by', models.CharField(blank=True, max_length=150, null=True)),
                ('decided_at', models.DateTimeField(blank=True, null=True)),
                ('candidate', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='selection', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='candidate_selections', to='Company.company_details')),
                ('reporting_manager', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='selected_reportees', to='Employee.employeedt')),
                ('requisition', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='selections', to='Recruitment.jobrequisition')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='CandidateProfile',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('current_company', models.CharField(blank=True, max_length=200, null=True)),
                ('total_experience_years', models.DecimalField(blank=True, decimal_places=1, max_digits=4, null=True)),
                ('notice_period_days', models.PositiveIntegerField(blank=True, null=True)),
                ('priority', models.CharField(choices=[('Low', 'Low'), ('Medium', 'Medium'), ('High', 'High'), ('Urgent', 'Urgent')], default='Medium', max_length=10)),
                ('rejection_reason', models.TextField(blank=True, null=True)),
                ('stage_changed_at', models.DateTimeField(default=django.utils.timezone.now)),
                ('candidate', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='recruitment_profile', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='candidate_profiles', to='Company.company_details')),
                ('recruiter', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='recruited_candidates', to='Employee.employeedt')),
                ('requisition', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='candidates', to='Recruitment.jobrequisition')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Offer',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('offer_id', models.CharField(db_index=True, max_length=30)),
                ('designation', models.CharField(blank=True, max_length=200, null=True)),
                ('offered_ctc_lpa', models.DecimalField(decimal_places=2, max_digits=8)),
                ('target_joining_date', models.DateField(blank=True, null=True)),
                ('valid_until', models.DateField(blank=True, null=True)),
                ('status', models.CharField(choices=[('Draft', 'Draft'), ('Sent', 'Sent'), ('Accepted', 'Accepted'), ('Declined', 'Declined'), ('Expired', 'Expired'), ('Withdrawn', 'Withdrawn')], db_index=True, default='Draft', max_length=10)),
                ('letter_text', models.TextField(blank=True, null=True)),
                ('sent_at', models.DateTimeField(blank=True, null=True)),
                ('responded_at', models.DateTimeField(blank=True, null=True)),
                ('decline_reason', models.TextField(blank=True, null=True)),
                ('candidate', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='offers', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='recruitment_offers', to='Company.company_details')),
            ],
            options={
                'ordering': ['-created_at'],
                'unique_together': {('company', 'offer_id')},
            },
        ),
        migrations.CreateModel(
            name='HikeApproval',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('last_ctc_lpa', models.DecimalField(decimal_places=2, max_digits=8)),
                ('offered_ctc_lpa', models.DecimalField(decimal_places=2, max_digits=8)),
                ('hike_percent', models.DecimalField(decimal_places=2, max_digits=7)),
                ('limit_percent', models.DecimalField(decimal_places=2, max_digits=5)),
                ('status', models.CharField(choices=[('Pending', 'Pending'), ('Approved', 'Approved'), ('Rejected', 'Rejected')], db_index=True, default='Pending', max_length=10)),
                ('requested_by', models.CharField(blank=True, max_length=150, null=True)),
                ('decided_by', models.CharField(blank=True, max_length=150, null=True)),
                ('decided_at', models.DateTimeField(blank=True, null=True)),
                ('remarks', models.TextField(blank=True, null=True)),
                ('candidate', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='hike_approvals', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='hike_approvals', to='Company.company_details')),
                ('offer', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='hike_approvals', to='Recruitment.offer')),
            ],
            options={
                'ordering': ['-created_at'],
            },
        ),
        migrations.CreateModel(
            name='RequisitionRoles',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='requisition_roles', to='Company.company_details')),
                ('hcm', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='Employee.employeedt')),
                ('performance_reviewer', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='Employee.employeedt')),
                ('reporting_manager', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='Employee.employeedt')),
                ('requisition', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='role_map', to='Recruitment.jobrequisition')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='StageHistory',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('from_stage', models.CharField(blank=True, max_length=30, null=True)),
                ('to_stage', models.CharField(max_length=30)),
                ('note', models.TextField(blank=True, null=True)),
                ('changed_by', models.CharField(blank=True, max_length=150, null=True)),
                ('changed_at', models.DateTimeField(auto_now_add=True)),
                ('candidate', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='stage_history', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='stage_history', to='Company.company_details')),
            ],
            options={
                'ordering': ['-changed_at'],
            },
        ),
        migrations.CreateModel(
            name='CandidatePortalDraft',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('step', models.CharField(max_length=40)),
                ('data', models.JSONField(blank=True, default=dict)),
                ('client_version', models.PositiveIntegerField(default=0)),
                ('candidate', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='portal_drafts', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='candidate_portal_drafts', to='Company.company_details')),
            ],
            options={
                'ordering': ['step'],
                'unique_together': {('candidate', 'step')},
            },
        ),
        migrations.CreateModel(
            name='IdentityVerification',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('id_type', models.CharField(choices=[('AADHAAR', 'Aadhaar'), ('PAN', 'PAN'), ('EDUCATION', 'Education Certificate'), ('EXPERIENCE', 'Experience')], db_index=True, max_length=12)),
                ('status', models.CharField(choices=[('Pending', 'Pending'), ('OTP Sent', 'OTP Sent'), ('Verified', 'Verified'), ('Mismatch', 'Mismatch'), ('Failed', 'Failed'), ('Not Applicable', 'Not Applicable')], db_index=True, default='Pending', max_length=15)),
                ('method', models.CharField(choices=[('None', 'None'), ('Checksum', 'Checksum'), ('OTP', 'Aadhaar OTP'), ('Manual', 'Manual / Document'), ('Provider', 'Provider API')], default='None', max_length=10)),
                ('id_last4', models.CharField(blank=True, max_length=4, null=True)),
                ('id_hash', models.CharField(blank=True, db_index=True, max_length=64, null=True)),
                ('provider', models.CharField(blank=True, max_length=40, null=True)),
                ('provider_ref', models.CharField(blank=True, max_length=120, null=True)),
                ('name_on_record', models.CharField(blank=True, max_length=200, null=True)),
                ('name_match', models.BooleanField(blank=True, null=True)),
                ('dob_match', models.BooleanField(blank=True, null=True)),
                ('remarks', models.TextField(blank=True, null=True)),
                ('verified_by', models.CharField(blank=True, max_length=150, null=True)),
                ('verified_at', models.DateTimeField(blank=True, null=True)),
                ('meta', models.JSONField(blank=True, default=dict)),
                ('candidate', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='identity_verifications', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='identity_verifications', to='Company.company_details')),
            ],
            options={
                'ordering': ['id'],
                'unique_together': {('candidate', 'id_type')},
            },
        ),
        migrations.CreateModel(
            name='InterviewerAssignment',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('round_name', models.CharField(blank=True, max_length=100, null=True)),
                ('is_confirmed', models.BooleanField(default=False)),
                ('candidate', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='interviewer_panel', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='interviewer_assignments', to='Company.company_details')),
                ('interviewer', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='panel_assignments', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['id'],
                'unique_together': {('candidate', 'interviewer', 'round_name')},
            },
        ),
        migrations.CreateModel(
            name='JobDescription',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('jd_code', models.CharField(db_index=True, max_length=30)),
                ('experience_min_years', models.DecimalField(blank=True, decimal_places=1, max_digits=4, null=True)),
                ('experience_max_years', models.DecimalField(blank=True, decimal_places=1, max_digits=4, null=True)),
                ('required_skills', models.JSONField(blank=True, default=list)),
                ('responsibilities', models.TextField(blank=True, null=True)),
                ('qualifications', models.TextField(blank=True, null=True)),
                ('is_published', models.BooleanField(default=False)),
                ('published_at', models.DateTimeField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='job_descriptions', to='Company.company_details')),
                ('requisition', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='job_description', to='Recruitment.jobrequisition')),
            ],
            options={
                'ordering': ['jd_code'],
                'unique_together': {('company', 'jd_code')},
            },
        ),
    ]
