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

import People.org_chart_models
import datetime
import django.db.models.deletion
import django.utils.timezone
from decimal import Decimal
from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='Announcement',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('audience_type', models.CharField(choices=[('ALL', 'All Organization'), ('DEPARTMENT', 'Department'), ('BRANCH', 'Branch')], db_index=True, default='ALL', max_length=10)),
                ('audience_ids', models.JSONField(blank=True, default=list)),
                ('title', models.CharField(max_length=200)),
                ('body', models.TextField()),
                ('category', models.CharField(choices=[('COMPANY_UPDATES', 'Company Updates'), ('POLICY_BENEFITS', 'Policy & Benefits'), ('CULTURE_INNOVATION', 'Cultural & Innovation'), ('HR_NOTICE', 'HR Notice'), ('ACHIEVEMENT', 'Achievements'), ('OTHER', 'Other')], db_index=True, default='COMPANY_UPDATES', max_length=24)),
                ('priority', models.CharField(choices=[('NORMAL', 'Normal'), ('HIGH', 'High Priority'), ('URGENT', 'Urgent')], default='NORMAL', max_length=8)),
                ('status', models.CharField(choices=[('DRAFT', 'Draft'), ('SCHEDULED', 'Scheduled'), ('PUBLISHED', 'Published'), ('ARCHIVED', 'Archived')], db_index=True, default='DRAFT', max_length=10)),
                ('publish_at', models.DateTimeField(blank=True, null=True)),
                ('published_at', models.DateTimeField(blank=True, null=True)),
                ('expires_at', models.DateTimeField(blank=True, null=True)),
                ('is_pinned', models.BooleanField(default=False)),
                ('allow_comments', models.BooleanField(default=True)),
                ('banner_image', models.ImageField(blank=True, null=True, upload_to='engagement/announcements/')),
                ('author_name', models.CharField(blank=True, max_length=150, null=True)),
                ('author_title', models.CharField(blank=True, max_length=150, null=True)),
                ('author', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='eng_announcements', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='eng_announcements', to='Company.company_details')),
            ],
            options={
                'ordering': ['-is_pinned', '-id'],
            },
        ),
        migrations.CreateModel(
            name='AnnouncementComment',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('author_name', models.CharField(blank=True, max_length=150, null=True)),
                ('body', models.TextField()),
                ('announcement', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='comments', to='People.announcement')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='eng_comments', to='Company.company_details')),
                ('employee', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='eng_comments', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['created_at', 'id'],
            },
        ),
        migrations.CreateModel(
            name='AssetAllocation',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('allocated_on', models.DateField(default=django.utils.timezone.localdate)),
                ('expected_return', models.DateField(blank=True, null=True)),
                ('returned_on', models.DateField(blank=True, null=True)),
                ('condition_out', models.CharField(blank=True, max_length=100, null=True)),
                ('condition_in', models.CharField(blank=True, max_length=100, null=True)),
                ('status', models.CharField(choices=[('Allocated', 'Allocated'), ('Returned', 'Returned')], db_index=True, default='Allocated', max_length=10)),
                ('notes', models.TextField(blank=True, null=True)),
                ('return_pending', models.BooleanField(db_index=True, default=False)),
                ('return_requested_on', models.DateField(blank=True, null=True)),
                ('return_due_date', models.DateField(blank=True, null=True)),
                ('return_reason', models.CharField(blank=True, max_length=250, null=True)),
                ('acknowledged_on', models.DateTimeField(blank=True, null=True)),
                ('acknowledged_note', models.CharField(blank=True, max_length=250, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_allocations', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='asset_allocations', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['-allocated_on', '-id'],
            },
        ),
        migrations.CreateModel(
            name='AssetMaster',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('asset_tag', models.CharField(max_length=40)),
                ('device_name', models.CharField(max_length=200)),
                ('category', models.CharField(choices=[('Hardware', 'Hardware'), ('Software', 'Software'), ('Security', 'Security'), ('Access', 'Access Card / Keys'), ('Furniture', 'Furniture'), ('Other', 'Other'), ('Laptop', 'Laptop'), ('Monitor', 'Monitor'), ('Mobile', 'Mobile'), ('Peripheral', 'Peripheral')], db_index=True, default='Hardware', max_length=12)),
                ('serial_number', models.CharField(blank=True, max_length=100, null=True)),
                ('purchase_date', models.DateField(blank=True, null=True)),
                ('purchase_cost', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)),
                ('status', models.CharField(choices=[('Available', 'Available'), ('Allocated', 'Allocated'), ('Under Repair', 'Under Repair'), ('Retired', 'Retired'), ('Lost', 'Lost'), ('Reserved', 'Reserved')], db_index=True, default='Available', max_length=14)),
                ('notes', models.TextField(blank=True, null=True)),
                ('vendor', models.CharField(blank=True, max_length=150, null=True)),
                ('warranty_until', models.DateField(blank=True, null=True)),
                ('reserved_on', models.DateField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_assets', to='Company.company_details')),
                ('reserved_for', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='reserved_assets', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['asset_tag'],
                'unique_together': {('company', 'asset_tag')},
            },
        ),
        migrations.CreateModel(
            name='AssetMaintenance',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('event_type', models.CharField(choices=[('Repair', 'Repair'), ('Battery Replacement', 'Battery Replacement'), ('Warranty Claim', 'Warranty Claim'), ('Warranty Extension', 'Warranty Extension'), ('Service', 'Service'), ('Upgrade', 'Upgrade'), ('Inspection', 'Inspection'), ('Other', 'Other')], db_index=True, default='Service', max_length=20)),
                ('event_date', models.DateField(db_index=True, default=django.utils.timezone.localdate)),
                ('vendor', models.CharField(blank=True, max_length=150, null=True)),
                ('cost', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)),
                ('description', models.TextField(blank=True, null=True)),
                ('warranty_until', models.DateField(blank=True, null=True)),
                ('next_service_due', models.DateField(blank=True, null=True)),
                ('status', models.CharField(choices=[('Scheduled', 'Scheduled'), ('In Progress', 'In Progress'), ('Completed', 'Completed')], db_index=True, default='Completed', max_length=12)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_asset_maintenance', to='Company.company_details')),
                ('asset', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='maintenance_logs', to='People.assetmaster')),
            ],
            options={
                'ordering': ['-event_date', '-id'],
            },
        ),
        migrations.CreateModel(
            name='AssetAudit',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('audited_on', models.DateField(default=django.utils.timezone.localdate)),
                ('audited_by', models.CharField(blank=True, max_length=150, null=True)),
                ('condition', models.CharField(blank=True, max_length=100, null=True)),
                ('is_ok', models.BooleanField(default=True)),
                ('notes', models.TextField(blank=True, null=True)),
                ('allocation', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='audits', to='People.assetallocation')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_asset_audits', to='Company.company_details')),
                ('asset', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='audits', to='People.assetmaster')),
            ],
            options={
                'ordering': ['-audited_on', '-id'],
            },
        ),
        migrations.AddField(
            model_name='assetallocation',
            name='asset',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='allocations', to='People.assetmaster'),
        ),
        migrations.CreateModel(
            name='AttendanceGeofence',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('name', models.CharField(max_length=150)),
                ('latitude', models.FloatField()),
                ('longitude', models.FloatField()),
                ('radius_m', models.PositiveIntegerField(default=200)),
                ('ip_ranges', models.JSONField(blank=True, default=list)),
                ('is_primary', models.BooleanField(default=False)),
                ('notes', models.TextField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_geofences', to='Company.company_details')),
            ],
            options={
                'ordering': ['-is_primary', 'name'],
            },
        ),
        migrations.CreateModel(
            name='AttendancePolicy',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('shift_start', models.TimeField(default=datetime.time(9, 0))),
                ('shift_end', models.TimeField(default=datetime.time(18, 0))),
                ('grace_minutes', models.PositiveSmallIntegerField(default=15)),
                ('early_leave_grace_minutes', models.PositiveSmallIntegerField(default=15)),
                ('perimeter_enforced', models.BooleanField(default=True)),
                ('allow_web_punch', models.BooleanField(default=True)),
                ('allow_mobile_punch', models.BooleanField(default=True)),
                ('wfh_redirect_enabled', models.BooleanField(default=True)),
                ('field_ping_interval_minutes', models.PositiveSmallIntegerField(default=30)),
                ('device_online_minutes', models.PositiveSmallIntegerField(default=10)),
                ('ingestion_mode', models.CharField(default='Direct TCP/IP Polling (Zero Buffer Loss)', max_length=80)),
                ('reconcile_interval_seconds', models.PositiveIntegerField(default=60)),
                ('company', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='people_attendance_policy', to='Company.company_details')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='AttendanceRegularization',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('request_id', models.CharField(max_length=30)),
                ('attendance_date', models.DateField(db_index=True)),
                ('punch_in_time', models.TimeField()),
                ('punch_out_time', models.TimeField(blank=True, null=True)),
                ('reason', models.TextField()),
                ('status', models.CharField(choices=[('Pending Approval', 'Pending Approval'), ('Approved', 'Approved'), ('Rejected', 'Rejected'), ('Cancelled', 'Cancelled')], db_index=True, default='Pending Approval', max_length=16)),
                ('requested_by', models.CharField(default='HR', max_length=10)),
                ('reviewed_by', models.CharField(blank=True, max_length=150, null=True)),
                ('reviewed_at', models.DateTimeField(blank=True, null=True)),
                ('review_comment', models.TextField(blank=True, null=True)),
                ('applied_checkin', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='Employee.emp_check_in_check_out')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_regularizations', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='regularizations', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['-attendance_date', '-id'],
            },
        ),
        migrations.CreateModel(
            name='BiometricDevice',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('device_code', models.CharField(max_length=30)),
                ('name', models.CharField(max_length=150)),
                ('vendor', models.CharField(choices=[('eSSL', 'eSSL'), ('ZKTeco', 'ZKTeco'), ('Matrix', 'Matrix'), ('Suprema', 'Suprema'), ('Other', 'Other')], default='Other', max_length=10)),
                ('location_label', models.CharField(blank=True, max_length=200, null=True)),
                ('ip_address', models.GenericIPAddressField(blank=True, null=True)),
                ('port', models.PositiveIntegerField(blank=True, null=True)),
                ('sync_protocol', models.CharField(choices=[('Push API / TCP-IP', 'Push API / TCP-IP'), ('SQL Mirror / WebSocket', 'SQL Mirror / WebSocket'), ('REST API Endpoint', 'REST API Endpoint'), ('Direct TCP Socket', 'Direct TCP Socket')], default='Push API / TCP-IP', max_length=24)),
                ('firmware', models.CharField(blank=True, max_length=60, null=True)),
                ('status', models.CharField(choices=[('Enabled', 'Enabled'), ('Disabled', 'Disabled'), ('Maintenance', 'Maintenance')], db_index=True, default='Enabled', max_length=12)),
                ('api_key_hash', models.CharField(blank=True, db_index=True, max_length=64, null=True)),
                ('api_key_hint', models.CharField(blank=True, max_length=12, null=True)),
                ('last_seen_at', models.DateTimeField(blank=True, null=True)),
                ('last_sync_at', models.DateTimeField(blank=True, null=True)),
                ('last_ping_ok', models.BooleanField(blank=True, null=True)),
                ('last_ping_ms', models.PositiveIntegerField(blank=True, null=True)),
                ('last_ping_message', models.CharField(blank=True, max_length=300, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_bio_devices', to='Company.company_details')),
            ],
            options={
                'ordering': ['device_code'],
            },
        ),
        migrations.CreateModel(
            name='AttendancePunchMeta',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('source', models.CharField(choices=[('Biometric Device', 'Biometric Device'), ('GPS Mobile Punch', 'GPS Mobile Punch'), ('Web Portal Punch', 'Web Portal Punch'), ('Field Tracker', 'Field Tracker'), ('Regularization', 'Regularization'), ('Manual', 'Manual')], max_length=20)),
                ('perimeter_status', models.CharField(choices=[('In-Perimeter Verified', 'In-Perimeter Verified'), ('Authorized WFH', 'Authorized WFH'), ('Field Force', 'Field Force'), ('Device Verified', 'Device Verified'), ('Regularized', 'Regularized'), ('Manual Entry', 'Manual Entry'), ('Unverified', 'Unverified')], default='Unverified', max_length=24)),
                ('distance_m', models.DecimalField(blank=True, decimal_places=1, max_digits=10, null=True)),
                ('ip_address', models.GenericIPAddressField(blank=True, null=True)),
                ('checkout_source', models.CharField(blank=True, max_length=20, null=True)),
                ('regularization_id', models.PositiveIntegerField(blank=True, null=True)),
                ('checkin', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='punch_meta', to='Employee.emp_check_in_check_out')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_punch_meta', to='Company.company_details')),
                ('geofence', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='People.attendancegeofence')),
                ('device', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='People.biometricdevice')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='BiometricDeviceLink',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('zk_port', models.PositiveIntegerField(default=4370)),
                ('comm_key_enc', models.TextField(blank=True, null=True)),
                ('pull_enabled', models.BooleanField(default=True)),
                ('direction_mode', models.CharField(choices=[('auto', 'Auto (first scan IN, next OUT)'), ('device', 'Use IN/OUT flag sent by the device')], default='auto', max_length=8)),
                ('min_gap_minutes', models.PositiveSmallIntegerField(default=2)),
                ('auto_enroll', models.BooleanField(default=False)),
                ('pull_since', models.DateField(blank=True, null=True)),
                ('cursor_time', models.DateTimeField(blank=True, null=True)),
                ('serial_number', models.CharField(blank=True, max_length=60, null=True)),
                ('device_name', models.CharField(blank=True, max_length=80, null=True)),
                ('last_status', models.CharField(choices=[('Idle', 'Idle'), ('Running', 'Running'), ('Success', 'Success'), ('Error', 'Error')], default='Idle', max_length=8)),
                ('running_since', models.DateTimeField(blank=True, null=True)),
                ('last_pull_at', models.DateTimeField(blank=True, null=True)),
                ('last_error', models.TextField(blank=True, null=True)),
                ('total_pulled', models.PositiveBigIntegerField(default=0)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_device_links', to='Company.company_details')),
                ('device', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='link', to='People.biometricdevice')),
            ],
            options={
                'ordering': ['device__device_code'],
            },
        ),
        migrations.CreateModel(
            name='BiometricEnrollment',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('biometric_id', models.CharField(max_length=60)),
                ('verification_mode', models.CharField(choices=[('Fingerprint', 'Fingerprint'), ('Face Recognition', 'Face Recognition'), ('Smart Card + PIN', 'Smart Card + PIN'), ('Iris', 'Iris'), ('Other', 'Other')], default='Fingerprint', max_length=20)),
                ('notes', models.TextField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_bio_enrollments', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='bio_enrollments', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['biometric_id'],
            },
        ),
        migrations.CreateModel(
            name='BiometricPunch',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('device_code', models.CharField(blank=True, max_length=30, null=True)),
                ('biometric_id', models.CharField(max_length=60)),
                ('punch_time', models.DateTimeField(db_index=True)),
                ('direction', models.CharField(choices=[('IN', 'IN'), ('OUT', 'OUT')], default='IN', max_length=3)),
                ('verification_mode', models.CharField(blank=True, max_length=40, null=True)),
                ('match_score', models.DecimalField(blank=True, decimal_places=2, max_digits=5, null=True)),
                ('sync_status', models.CharField(choices=[('Reconciled', 'Reconciled'), ('Pending', 'Pending'), ('Unmatched', 'Unmatched'), ('Duplicate', 'Duplicate'), ('Failed', 'Failed')], db_index=True, default='Pending', max_length=10)),
                ('sync_message', models.CharField(blank=True, max_length=300, null=True)),
                ('raw_payload', models.JSONField(blank=True, default=dict)),
                ('source', models.CharField(default='device', max_length=10)),
                ('checkin', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='bio_punches', to='Employee.emp_check_in_check_out')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_bio_punches', to='Company.company_details')),
                ('device', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='punches', to='People.biometricdevice')),
                ('employee', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='bio_punches', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['-punch_time', '-id'],
            },
        ),
        migrations.CreateModel(
            name='Branch',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('name', models.CharField(max_length=150)),
                ('code', models.CharField(blank=True, max_length=30, null=True)),
                ('city', models.CharField(blank=True, max_length=100, null=True)),
                ('address', models.TextField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_branches', to='Company.company_details')),
            ],
            options={
                'ordering': ['name'],
            },
        ),
        migrations.AddField(
            model_name='biometricdevice',
            name='branch',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='bio_devices', to='People.branch'),
        ),
        migrations.AddField(
            model_name='attendancegeofence',
            name='branch',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='geofences', to='People.branch'),
        ),
        migrations.CreateModel(
            name='CompanyEmailConfig',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=80)),
                ('name_key', models.CharField(editable=False, max_length=80)),
                ('audience', models.CharField(choices=[('ALL', 'Employees & Candidates'), ('EMPLOYEE', 'Employees only'), ('CANDIDATE', 'Candidates only')], db_index=True, default='ALL', max_length=10)),
                ('host', models.CharField(max_length=255)),
                ('port', models.PositiveIntegerField(default=465)),
                ('security', models.CharField(choices=[('SSL', 'SSL/TLS (usually port 465)'), ('STARTTLS', 'STARTTLS (usually port 587)'), ('NONE', 'No encryption (not recommended)')], default='SSL', max_length=10)),
                ('username', models.CharField(blank=True, default='', max_length=254)),
                ('password_enc', models.TextField(blank=True, default='')),
                ('from_email', models.EmailField(max_length=254)),
                ('from_name', models.CharField(blank=True, default='', max_length=100)),
                ('reply_to', models.EmailField(blank=True, default='', max_length=254)),
                ('timeout_seconds', models.PositiveSmallIntegerField(default=20)),
                ('daily_limit', models.PositiveIntegerField(default=500)),
                ('is_default', models.BooleanField(default=False)),
                ('enabled', models.BooleanField(default=True)),
                ('mailbox_key', models.CharField(db_index=True, editable=False, max_length=320)),
                ('last_test_at', models.DateTimeField(blank=True, null=True)),
                ('last_test_ok', models.BooleanField(blank=True, null=True)),
                ('last_test_message', models.CharField(blank=True, default='', max_length=300)),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=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='email_configs', to='Company.company_details')),
            ],
            options={
                'ordering': ['company_id', 'audience', '-is_default', 'id'],
            },
        ),
        migrations.CreateModel(
            name='CompanyEmailLog',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('config_name', models.CharField(blank=True, default='', max_length=80)),
                ('from_email', models.CharField(blank=True, default='', max_length=254)),
                ('recipient_type', models.CharField(default='EMPLOYEE', max_length=10)),
                ('to_email', models.CharField(db_index=True, max_length=254)),
                ('subject', models.CharField(blank=True, default='', max_length=250)),
                ('kind', models.CharField(blank=True, default='general', max_length=40)),
                ('status', models.CharField(db_index=True, default='SENT', max_length=10)),
                ('via', models.CharField(default='COMPANY_SMTP', max_length=20)),
                ('error', models.CharField(blank=True, default='', max_length=500)),
                ('sent_by', models.CharField(blank=True, default='', max_length=150)),
                ('batch_id', models.CharField(blank=True, default='', max_length=36)),
                ('created_at', models.DateTimeField(auto_now_add=True, db_index=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='email_logs', to='Company.company_details')),
                ('config', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='logs', to='People.companyemailconfig')),
                ('employee', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='received_email_logs', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='CompanyEvent',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('audience_type', models.CharField(choices=[('ALL', 'All Organization'), ('DEPARTMENT', 'Department'), ('BRANCH', 'Branch')], db_index=True, default='ALL', max_length=10)),
                ('audience_ids', models.JSONField(blank=True, default=list)),
                ('title', models.CharField(max_length=200)),
                ('event_type', models.CharField(choices=[('TOWN_HALL', 'Town Hall'), ('CELEBRATION', 'Celebration'), ('TRAINING', 'Workshop / Training'), ('SPORTS', 'Sports & Wellness'), ('CSR', 'CSR / Volunteering'), ('OFFSITE', 'Offsite / Team Outing'), ('OTHER', 'Other')], db_index=True, default='OTHER', max_length=12)),
                ('description', models.TextField(blank=True, null=True)),
                ('start_at', models.DateTimeField(db_index=True)),
                ('end_at', models.DateTimeField(blank=True, null=True)),
                ('location', models.CharField(blank=True, max_length=200, null=True)),
                ('mode', models.CharField(choices=[('ONSITE', 'On-site'), ('VIRTUAL', 'Virtual'), ('HYBRID', 'Hybrid')], default='ONSITE', max_length=8)),
                ('meeting_link', models.URLField(blank=True, max_length=300, null=True)),
                ('capacity', models.PositiveIntegerField(blank=True, null=True)),
                ('rsvp_required', models.BooleanField(default=False)),
                ('is_cancelled', models.BooleanField(default=False)),
                ('cancel_reason', models.CharField(blank=True, max_length=250, null=True)),
                ('banner_image', models.ImageField(blank=True, null=True, upload_to='engagement/events/')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='eng_events', to='Company.company_details')),
            ],
            options={
                'ordering': ['start_at', 'id'],
            },
        ),
        migrations.CreateModel(
            name='CompanyPolicy',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('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)),
                ('version', models.CharField(default='1.0', max_length=20)),
                ('effective_date', models.DateField(blank=True, null=True)),
                ('is_mandatory', models.BooleanField(default=False)),
                ('compliance_note', models.CharField(blank=True, max_length=120, null=True)),
                ('description', models.TextField(blank=True, null=True)),
                ('file', models.FileField(blank=True, null=True, upload_to='people/policies/')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_policies', to='Company.company_details')),
            ],
            options={
                'ordering': ['title', '-id'],
            },
        ),
        migrations.CreateModel(
            name='CompanyWelcomeMail',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('enabled', models.BooleanField(default=True)),
                ('include_password', models.BooleanField(default=True)),
                ('include_salary', models.BooleanField(default=True)),
                ('fields', models.JSONField(blank=True, default=list)),
                ('subject', models.CharField(default='Welcome to {company} - your login details', max_length=150)),
                ('intro', models.TextField(default='Dear {name},\n\nWelcome to {company}! Your employee login has been created. Your joining details are below.')),
                ('footer', models.TextField(default='Please keep these details safe and change your password after the first login.\n\nRegards,\nHR Team, {company}')),
                ('login_url', models.CharField(blank=True, default='', max_length=255)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('company', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='welcome_mail_settings', to='Company.company_details')),
            ],
        ),
        migrations.CreateModel(
            name='ComplianceRegistration',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('reg_type', models.CharField(choices=[('PF', 'EPF Establishment Code'), ('ESIC', 'ESIC Employer Code'), ('PT', 'Professional Tax Enrolment'), ('TDS', 'TAN (TDS)'), ('LWF', 'Labour Welfare Fund'), ('SHOPS', 'Shops & Establishments'), ('OTHER', 'Other')], db_index=True, max_length=8)),
                ('number', models.CharField(max_length=60)),
                ('state', models.CharField(blank=True, max_length=60, null=True)),
                ('state_code', models.CharField(blank=True, max_length=6, null=True)),
                ('authority', models.CharField(blank=True, max_length=120, null=True)),
                ('registered_on', models.DateField(blank=True, null=True)),
                ('valid_until', models.DateField(blank=True, null=True)),
                ('due_day', models.PositiveSmallIntegerField(default=15)),
                ('notes', models.TextField(blank=True, null=True)),
                ('branch', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='comp_registrations', to='People.branch')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='comp_registrations', to='Company.company_details')),
            ],
            options={
                'ordering': ['reg_type', 'state', 'number'],
            },
        ),
        migrations.CreateModel(
            name='ComplianceFiling',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('filing_type', models.CharField(choices=[('PF_ECR', 'EPF Monthly ECR Filing'), ('ESIC', 'ESIC Contribution Return'), ('PT', 'Professional Tax'), ('TDS_24Q', 'TDS Quarterly Return (24Q)'), ('LWF', 'Labour Welfare Fund'), ('OTHER', 'Other Statutory Filing')], db_index=True, max_length=10)),
                ('code', models.CharField(blank=True, max_length=30, null=True)),
                ('description', models.CharField(max_length=200)),
                ('period_month', models.PositiveSmallIntegerField(blank=True, null=True)),
                ('period_year', models.PositiveIntegerField(blank=True, null=True)),
                ('quarter', models.PositiveSmallIntegerField(blank=True, null=True)),
                ('financial_year', models.CharField(blank=True, max_length=9, null=True)),
                ('due_date', models.DateField(db_index=True)),
                ('amount_payable', models.DecimalField(decimal_places=2, default=0, max_digits=14)),
                ('amount_paid', models.DecimalField(blank=True, decimal_places=2, max_digits=14, null=True)),
                ('challan_no', models.CharField(blank=True, max_length=60, null=True)),
                ('filed_on', models.DateField(blank=True, null=True)),
                ('payment_date', models.DateField(blank=True, null=True)),
                ('penalty_amount', models.DecimalField(decimal_places=2, default=0, max_digits=14)),
                ('status', models.CharField(choices=[('PENDING_FILING', 'Pending Filing'), ('PENDING_PAYMENT', 'Pending Payment'), ('FILED', 'Filed'), ('FILED_PAID', 'Filed & Paid')], db_index=True, default='PENDING_PAYMENT', max_length=16)),
                ('receipt', models.FileField(blank=True, null=True, upload_to='compliance/receipts/')),
                ('remarks', models.TextField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='comp_filings', to='Company.company_details')),
                ('registration', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='filings', to='People.complianceregistration')),
            ],
            options={
                'ordering': ['-due_date', '-id'],
            },
        ),
        migrations.CreateModel(
            name='ComplianceDocument',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('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)),
                ('doc_type', models.CharField(choices=[('FORM_A', 'Form A'), ('FORM_B', 'Form B'), ('FORM_D', 'Form D'), ('ECR_SLIP', 'ECR Confirmation Slip'), ('CHALLAN', 'Challan'), ('RETURN', 'Return'), ('REGISTER', 'Register'), ('CERTIFICATE', 'Certificate'), ('OTHER', 'Other')], db_index=True, default='OTHER', max_length=12)),
                ('period_month', models.PositiveSmallIntegerField(blank=True, null=True)),
                ('period_year', models.PositiveIntegerField(blank=True, null=True)),
                ('financial_year', models.CharField(blank=True, max_length=9, null=True)),
                ('file', models.FileField(blank=True, null=True, upload_to='compliance/documents/')),
                ('notes', models.TextField(blank=True, null=True)),
                ('uploaded_by', models.CharField(blank=True, max_length=150, null=True)),
                ('branch', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='comp_documents', to='People.branch')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='comp_documents', to='Company.company_details')),
                ('filing', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='documents', to='People.compliancefiling')),
                ('registration', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='documents', to='People.complianceregistration')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='ComplianceReminder',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('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)),
                ('message', models.TextField(blank=True, null=True)),
                ('due_date', models.DateField(blank=True, null=True)),
                ('severity', models.CharField(choices=[('INFO', 'Info'), ('WARNING', 'Warning'), ('CRITICAL', 'Critical')], default='INFO', max_length=8)),
                ('is_done', models.BooleanField(default=False)),
                ('done_at', models.DateTimeField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='comp_reminders', to='Company.company_details')),
                ('filing', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='reminders', to='People.compliancefiling')),
            ],
            options={
                'ordering': ['is_done', 'due_date', '-id'],
            },
        ),
        migrations.CreateModel(
            name='DepartmentOwnership',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('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='department_owners', to='Company.company_details')),
                ('department', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='ownership', to='Employee.department')),
                ('deputy', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='deputy_departments', to='Employee.employeedt')),
                ('head', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='headed_departments', to='Employee.employeedt')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='DocumentCheck',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('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'), ('Verified', 'Verified'), ('Rejected', 'Rejected')], db_index=True, 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='people_check', to='Employee.employeedocument')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='EmployeeExtra',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('grade_band', models.CharField(blank=True, max_length=30, null=True)),
                ('uan_number', models.CharField(blank=True, max_length=30, null=True)),
                ('probation_due_date', models.DateField(blank=True, null=True)),
                ('confirmation_date', models.DateField(blank=True, null=True)),
                ('lifecycle_status', models.CharField(choices=[('Probation', 'On Probation'), ('Extended', 'Probation Extended'), ('Confirmed', 'Permanent Confirmed'), ('Notice', 'Serving Notice Period (Resigned)'), ('Exited', 'Exited')], db_index=True, default='Probation', max_length=12)),
                ('emergency_contact_name', models.CharField(blank=True, max_length=150, null=True)),
                ('emergency_contact_relation', models.CharField(blank=True, max_length=60, null=True)),
                ('emergency_contact_phone', models.CharField(blank=True, max_length=30, null=True)),
                ('branch', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='employees', to='People.branch')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_extras', to='Company.company_details')),
                ('employee', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='people_profile', to='Employee.employeedt')),
                ('reporting_manager', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='direct_reports', to='Employee.employeedt')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='EmployeeHrRoles',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('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='employee_hr_roles', to='Company.company_details')),
                ('employee', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='hr_roles', to='Employee.employeedt')),
                ('hcm', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='hcm_for', to='Employee.employeedt')),
                ('performance_reviewer', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='reviewees', to='Employee.employeedt')),
                ('reporting_manager', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='reportees_hr', to='Employee.employeedt')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='EmployeeLetter',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('letter_type', models.CharField(choices=[('APPOINTMENT', 'Appointment Letter'), ('CONFIRMATION', 'Confirmation Letter'), ('PROMOTION', 'Promotion Letter'), ('RELIEVING_EXPERIENCE', 'Relieving & Experience')], db_index=True, max_length=24)),
                ('letter_no', models.CharField(max_length=40)),
                ('subject', models.CharField(blank=True, max_length=250, null=True)),
                ('body', models.TextField()),
                ('variables', models.JSONField(blank=True, default=dict)),
                ('status', models.CharField(choices=[('Draft', 'Draft'), ('Issued', 'Issued'), ('Revoked', 'Revoked')], db_index=True, default='Issued', max_length=8)),
                ('issued_on', models.DateField(default=django.utils.timezone.localdate)),
                ('issued_by', models.CharField(blank=True, max_length=150, null=True)),
                ('pdf_file', models.FileField(blank=True, null=True, upload_to='employee_letters/')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_letters', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_letters', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['-issued_on', '-id'],
            },
        ),
        migrations.CreateModel(
            name='ConfirmationReview',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('probation_due_date', models.DateField(blank=True, null=True)),
                ('manager_rating', models.DecimalField(blank=True, decimal_places=1, max_digits=3, null=True)),
                ('manager_remarks', models.TextField(blank=True, null=True)),
                ('recommendation', models.CharField(blank=True, choices=[('Confirm Permanent', 'Confirm Permanent'), ('Extend Probation', 'Extend Probation'), ('Terminate', 'Terminate')], max_length=20, null=True)),
                ('status', models.CharField(choices=[('Pending', 'Pending'), ('Confirmed', 'Confirmed'), ('Extended', 'Extended'), ('Terminated', 'Terminated')], db_index=True, default='Pending', max_length=10)),
                ('extended_until', models.DateField(blank=True, null=True)),
                ('decided_by', models.CharField(blank=True, max_length=150, null=True)),
                ('decided_on', models.DateField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_confirmations', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='confirmations', to='Employee.employeedt')),
                ('letter', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='People.employeeletter')),
            ],
            options={
                'ordering': ['probation_due_date', '-id'],
            },
        ),
        migrations.CreateModel(
            name='EsslSource',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('name', models.CharField(max_length=120)),
                ('source_type', models.CharField(choices=[('mysql', 'MySQL'), ('sqlite', 'SQLite (dev / test only)')], default='mysql', max_length=10)),
                ('host', models.CharField(max_length=255)),
                ('port', models.PositiveIntegerField(default=3306)),
                ('database', models.CharField(blank=True, max_length=120, null=True)),
                ('username', models.CharField(blank=True, max_length=120, null=True)),
                ('password_enc', models.TextField(blank=True, null=True)),
                ('table_pattern', models.CharField(default='DeviceLogs_{month}_{year}', max_length=120)),
                ('id_column', models.CharField(default='DeviceLogId', max_length=64)),
                ('user_column', models.CharField(default='UserId', max_length=64)),
                ('time_column', models.CharField(default='LogDate', max_length=64)),
                ('device_column', models.CharField(blank=True, default='DeviceId', max_length=64, null=True)),
                ('direction_column', models.CharField(blank=True, default='Direction', max_length=64, null=True)),
                ('device_map', models.JSONField(blank=True, default=dict)),
                ('start_from_date', models.DateField(blank=True, null=True)),
                ('batch_size', models.PositiveIntegerField(default=500)),
                ('poll_interval_seconds', models.PositiveIntegerField(default=60)),
                ('min_gap_minutes', models.PositiveSmallIntegerField(default=2)),
                ('auto_enroll', models.BooleanField(default=False)),
                ('enabled', models.BooleanField(default=True)),
                ('cursor', models.JSONField(blank=True, default=dict)),
                ('last_status', models.CharField(choices=[('Idle', 'Idle'), ('Running', 'Running'), ('Success', 'Success'), ('Error', 'Error')], default='Idle', max_length=10)),
                ('running_since', models.DateTimeField(blank=True, null=True)),
                ('last_sync_at', models.DateTimeField(blank=True, null=True)),
                ('last_error', models.TextField(blank=True, null=True)),
                ('total_rows_synced', models.PositiveBigIntegerField(default=0)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_essl_sources', to='Company.company_details')),
            ],
            options={
                'ordering': ['name'],
            },
        ),
        migrations.CreateModel(
            name='EsslSyncRun',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('kind', models.CharField(choices=[('live', 'Live sync'), ('manual', 'Manual sync'), ('pdf-import', 'PDF import')], default='live', max_length=12)),
                ('trigger', models.CharField(default='command', max_length=20)),
                ('status', models.CharField(choices=[('Running', 'Running'), ('Success', 'Success'), ('Partial', 'Partial'), ('Error', 'Error')], db_index=True, default='Running', max_length=8)),
                ('started_at', models.DateTimeField(auto_now_add=True)),
                ('finished_at', models.DateTimeField(blank=True, null=True)),
                ('rows_fetched', models.PositiveIntegerField(default=0)),
                ('accepted', models.PositiveIntegerField(default=0)),
                ('reconciled', models.PositiveIntegerField(default=0)),
                ('unmatched', models.PositiveIntegerField(default=0)),
                ('duplicates', models.PositiveIntegerField(default=0)),
                ('failed', models.PositiveIntegerField(default=0)),
                ('file_name', models.CharField(blank=True, max_length=200, null=True)),
                ('error', models.TextField(blank=True, null=True)),
                ('detail', models.JSONField(blank=True, default=dict)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_essl_runs', to='Company.company_details')),
                ('source', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='runs', to='People.esslsource')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='EventRsvp',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('response', models.CharField(choices=[('GOING', 'Going'), ('MAYBE', 'Maybe'), ('DECLINED', 'Not going')], default='GOING', max_length=8)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='eng_rsvps', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='eng_rsvps', to='Employee.employeedt')),
                ('event', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='rsvps', to='People.companyevent')),
            ],
        ),
        migrations.CreateModel(
            name='ExitClearance',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('resignation_date', models.DateField(blank=True, null=True)),
                ('last_working_day', models.DateField(blank=True, null=True)),
                ('reason', models.TextField(blank=True, null=True)),
                ('items', models.JSONField(blank=True, default=list)),
                ('status', models.CharField(choices=[('Initiated', 'Initiated'), ('In Progress', 'In Progress'), ('Cleared', 'Cleared'), ('Completed', 'Completed'), ('Withdrawn', 'Withdrawn')], db_index=True, default='Initiated', max_length=12)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_exits', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_exits', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='ExitFnF',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('statement_no', models.CharField(max_length=40)),
                ('status', models.CharField(choices=[('Draft', 'Draft'), ('Calculated', 'Calculated'), ('Approved', 'Approved'), ('Paid', 'Paid')], db_index=True, default='Calculated', max_length=10)),
                ('basic_monthly', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=12)),
                ('per_day_rate', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=12)),
                ('pending_salary_days', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=6)),
                ('pending_salary', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=12)),
                ('leave_encashment_days', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=6)),
                ('leave_encashment', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=12)),
                ('gratuity', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=12)),
                ('bonus', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=12)),
                ('other_earnings', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=12)),
                ('notice_shortfall_days', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=6)),
                ('notice_recovery', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=12)),
                ('asset_recovery', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=12)),
                ('advance_recovery', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=12)),
                ('tds_deduction', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=12)),
                ('other_deductions', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=12)),
                ('gross_earnings', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=13)),
                ('total_deductions', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=13)),
                ('net_payable', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=13)),
                ('components', models.JSONField(blank=True, default=dict)),
                ('remarks', models.TextField(blank=True, null=True)),
                ('approved_by', models.CharField(blank=True, max_length=150, null=True)),
                ('approved_on', models.DateTimeField(blank=True, null=True)),
                ('paid_on', models.DateField(blank=True, null=True)),
                ('payment_mode', models.CharField(blank=True, max_length=30, null=True)),
                ('payment_reference', models.CharField(blank=True, max_length=100, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_exit_fnf', to='Company.company_details')),
                ('exit', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='fnf', to='People.exitclearance')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='ExitInterview',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('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=[('Scheduled', 'Scheduled'), ('Completed', 'Completed'), ('Skipped', 'Skipped')], db_index=True, default='Scheduled', max_length=10)),
                ('mode', models.CharField(choices=[('In-person', 'In-person'), ('Video', 'Video'), ('Phone', 'Phone'), ('Form', 'Form')], default='In-person', max_length=10)),
                ('scheduled_for', models.DateField(blank=True, null=True)),
                ('conducted_on', models.DateField(blank=True, null=True)),
                ('conducted_by', models.CharField(blank=True, max_length=150, null=True)),
                ('overall_rating', models.DecimalField(blank=True, decimal_places=1, max_digits=2, null=True)),
                ('reason_for_leaving', models.CharField(blank=True, choices=[('Better Opportunity', 'Better Opportunity'), ('Compensation', 'Compensation'), ('Career Growth', 'Career Growth'), ('Relocation', 'Relocation'), ('Higher Studies', 'Higher Studies'), ('Work Environment', 'Work Environment'), ('Personal / Family', 'Personal / Family'), ('Health', 'Health'), ('Other', 'Other')], max_length=24, null=True)),
                ('feedback', models.TextField(blank=True, null=True)),
                ('liked_most', models.TextField(blank=True, null=True)),
                ('improvement_suggestions', models.TextField(blank=True, null=True)),
                ('would_recommend', models.BooleanField(blank=True, null=True)),
                ('would_rejoin', models.BooleanField(blank=True, null=True)),
                ('submitted_by', models.CharField(default='HR', max_length=10)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_exit_interviews', to='Company.company_details')),
                ('exit', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='interview', to='People.exitclearance')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='ExitReasonGroup',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('name', models.CharField(max_length=120)),
                ('reasons', models.JSONField(blank=True, default=list)),
                ('preventable_percent', models.DecimalField(decimal_places=2, default=0, max_digits=5)),
                ('recommendation', models.TextField(blank=True, null=True)),
                ('sort_order', models.PositiveSmallIntegerField(default=0)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_exit_reason_groups', to='Company.company_details')),
            ],
            options={
                'ordering': ['sort_order', 'id'],
            },
        ),
        migrations.CreateModel(
            name='ExitResignationDetail',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('separation_type', models.CharField(choices=[('Resignation', 'Resignation'), ('Termination', 'Termination'), ('Retirement', 'Retirement'), ('Contract End', 'Contract End'), ('Absconding', 'Absconding')], default='Resignation', max_length=14)),
                ('notice_period_days', models.PositiveSmallIntegerField(default=30)),
                ('notice_waived_days', models.PositiveSmallIntegerField(default=0)),
                ('approval_status', models.CharField(choices=[('Submitted', 'Submitted'), ('Accepted', 'Accepted'), ('Rejected', 'Rejected')], db_index=True, default='Accepted', max_length=10)),
                ('requested_by', models.CharField(default='HR', max_length=10)),
                ('accepted_by', models.CharField(blank=True, max_length=150, null=True)),
                ('accepted_on', models.DateField(blank=True, null=True)),
                ('rejection_reason', models.TextField(blank=True, null=True)),
                ('handover_notes', models.TextField(blank=True, null=True)),
                ('hr_remarks', models.TextField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_exit_details', to='Company.company_details')),
                ('exit', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='detail', to='People.exitclearance')),
                ('handover_to', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='exit_handovers', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='FeedbackSuggestion',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('category', models.CharField(choices=[('WORKPLACE_FACILITIES', 'Workplace Facilities'), ('HR_POLICY', 'HR & Policies'), ('MANAGEMENT', 'Management & Leadership'), ('BENEFITS', 'Pay & Benefits'), ('CULTURE', 'Culture & Wellbeing'), ('IT_TOOLS', 'IT & Tools'), ('OTHER', 'Other')], db_index=True, default='OTHER', max_length=24)),
                ('subject', models.CharField(blank=True, max_length=200, null=True)),
                ('message', models.TextField()),
                ('is_anonymous', models.BooleanField(default=True)),
                ('status', models.CharField(choices=[('SUBMITTED', 'Submitted'), ('UNDER_REVIEW', 'Under Review'), ('APPROVED', 'Approved'), ('IMPLEMENTED', 'Implemented'), ('REJECTED', 'Rejected')], db_index=True, default='SUBMITTED', max_length=12)),
                ('response_note', models.TextField(blank=True, null=True)),
                ('assigned_team', models.CharField(blank=True, max_length=100, null=True)),
                ('reviewed_by', models.CharField(blank=True, max_length=150, null=True)),
                ('reviewed_at', models.DateTimeField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='eng_feedback', to='Company.company_details')),
                ('submitted_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='eng_feedback', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='FieldForceAgent',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('territory', models.CharField(blank=True, max_length=150, null=True)),
                ('ping_interval_minutes', models.PositiveSmallIntegerField(default=30)),
                ('per_km_rate', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=8)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_field_agents', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='field_agent_profiles', to='Employee.employeedt')),
            ],
        ),
        migrations.CreateModel(
            name='FieldTrackPoint',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('recorded_at', models.DateTimeField(db_index=True)),
                ('point_type', models.CharField(choices=[('Punch-In', 'Punch-In'), ('Interval Ping', 'Interval Ping'), ('Client Check-In', 'Client Check-In'), ('Punch-Out', 'Punch-Out')], default='Interval Ping', max_length=16)),
                ('location_label', models.CharField(blank=True, max_length=200, null=True)),
                ('client_name', models.CharField(blank=True, max_length=200, null=True)),
                ('latitude', models.FloatField()),
                ('longitude', models.FloatField()),
                ('speed_kmh', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True)),
                ('battery_percent', models.PositiveSmallIntegerField(blank=True, null=True)),
                ('notes', models.CharField(blank=True, max_length=300, null=True)),
                ('site_verified', models.BooleanField(default=False)),
                ('agent', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='points', to='People.fieldforceagent')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_field_points', to='Company.company_details')),
            ],
            options={
                'ordering': ['recorded_at', 'id'],
            },
        ),
        migrations.CreateModel(
            name='Form16Record',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('financial_year', models.CharField(db_index=True, max_length=9)),
                ('part', models.CharField(choices=[('FULL', 'Form 16 (Part A + B)'), ('PART_A', 'Part A'), ('PART_B', 'Part B')], default='FULL', max_length=7)),
                ('gross_income', models.DecimalField(blank=True, decimal_places=2, max_digits=14, null=True)),
                ('tds_deducted', models.DecimalField(blank=True, decimal_places=2, max_digits=14, null=True)),
                ('issued_on', models.DateField(blank=True, null=True)),
                ('file', models.FileField(blank=True, null=True, upload_to='compliance/form16/')),
                ('is_published', models.BooleanField(default=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='comp_form16', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='comp_form16', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['-financial_year', 'employee_id'],
            },
        ),
        migrations.CreateModel(
            name='HistoryEvent',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('event_type', models.CharField(choices=[('JOINED', 'Joined'), ('CONFIRMATION', 'Confirmation'), ('PROMOTION', 'Promotion'), ('TRANSFER', 'Transfer'), ('MANAGER_CHANGE', 'Manager Change'), ('DESIGNATION_CHANGE', 'Designation Change'), ('PROBATION_EXTENDED', 'Probation Extended'), ('EXIT', 'Exit'), ('NOTE', 'Note')], db_index=True, max_length=20)),
                ('title', models.CharField(max_length=250)),
                ('description', models.TextField(blank=True, null=True)),
                ('event_date', models.DateField(db_index=True, default=django.utils.timezone.localdate)),
                ('meta', models.JSONField(blank=True, default=dict)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_history', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_history', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['-event_date', '-id'],
            },
        ),
        migrations.CreateModel(
            name='HRDocument',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('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=[('SOP', 'SOP'), ('MANUAL', 'Manual'), ('FORM', 'Form'), ('OTHER', 'Other')], db_index=True, default='SOP', max_length=10)),
                ('description', models.TextField(blank=True, null=True)),
                ('version', models.CharField(default='1.0', max_length=20)),
                ('file', models.FileField(blank=True, null=True, upload_to='people/hr_documents/')),
                ('uploaded_by', models.CharField(blank=True, max_length=150, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_hr_documents', to='Company.company_details')),
            ],
            options={
                'ordering': ['title', '-id'],
            },
        ),
        migrations.CreateModel(
            name='Kudos',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('giver_name', models.CharField(blank=True, max_length=150, null=True)),
                ('badge', models.CharField(max_length=60)),
                ('message', models.TextField()),
                ('points', models.PositiveIntegerField(default=10)),
                ('is_public', models.BooleanField(default=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='eng_kudos', to='Company.company_details')),
                ('giver', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='eng_kudos_given', to='Employee.employeedt')),
                ('recipient', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='eng_kudos_received', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='LabourInspection',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('inspection_date', models.DateField()),
                ('authority', models.CharField(blank=True, max_length=150, null=True)),
                ('inspector_name', models.CharField(blank=True, max_length=120, null=True)),
                ('scope', models.CharField(blank=True, max_length=250, null=True)),
                ('outcome', models.CharField(choices=[('COMPLIANT', 'Compliant'), ('OBSERVATIONS', 'Observations raised'), ('NON_COMPLIANT', 'Non-compliant')], default='COMPLIANT', max_length=14)),
                ('observations', models.TextField(blank=True, null=True)),
                ('action_due_date', models.DateField(blank=True, null=True)),
                ('penalty_amount', models.DecimalField(decimal_places=2, default=0, max_digits=14)),
                ('status', models.CharField(choices=[('OPEN', 'Open'), ('CLOSED', 'Closed')], db_index=True, default='OPEN', max_length=8)),
                ('report', models.FileField(blank=True, null=True, upload_to='compliance/inspections/')),
                ('branch', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='comp_inspections', to='People.branch')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='comp_inspections', to='Company.company_details')),
            ],
            options={
                'ordering': ['-inspection_date', '-id'],
            },
        ),
        migrations.CreateModel(
            name='LabourLicense',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('license_type', models.CharField(choices=[('SHOPS_ESTABLISHMENT', 'Shops & Commercial Establishments'), ('CLRA', 'Contract Labour (CLRA)'), ('FACTORY', 'Factory Licence'), ('FIRE_NOC', 'Fire NOC'), ('TRADE', 'Trade Licence'), ('OTHER', 'Other')], db_index=True, max_length=20)),
                ('license_number', models.CharField(max_length=80)),
                ('authority', models.CharField(blank=True, max_length=150, null=True)),
                ('issued_on', models.DateField(blank=True, null=True)),
                ('valid_until', models.DateField(blank=True, null=True)),
                ('reminder_days', models.PositiveSmallIntegerField(default=30)),
                ('file', models.FileField(blank=True, null=True, upload_to='compliance/licenses/')),
                ('notes', models.TextField(blank=True, null=True)),
                ('branch', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='comp_licenses', to='People.branch')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='comp_licenses', to='Company.company_details')),
            ],
            options={
                'ordering': ['valid_until', 'id'],
            },
        ),
        migrations.CreateModel(
            name='LetterTemplate',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('code', models.CharField(db_index=True, max_length=24)),
                ('subject', models.CharField(blank=True, max_length=250, null=True)),
                ('body', models.TextField()),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_letter_templates', to='Company.company_details')),
            ],
        ),
        migrations.CreateModel(
            name='OnboardingRecord',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('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=[('On Track', 'On Track'), ('At Risk', 'At Risk'), ('Delayed', 'Delayed'), ('Completed', 'Completed')], db_index=True, default='On Track', max_length=12)),
                ('started_on', models.DateField(default=django.utils.timezone.localdate)),
                ('target_days', models.PositiveIntegerField(default=14)),
                ('it_kit_dispatched', models.BooleanField(default=False)),
                ('progress_override', models.PositiveIntegerField(blank=True, null=True)),
                ('last_checkin_at', models.DateTimeField(blank=True, null=True)),
                ('completed_on', models.DateField(blank=True, null=True)),
                ('notes', models.TextField(blank=True, null=True)),
                ('buddy', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='buddy_for', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_onboardings', to='Company.company_details')),
                ('employee', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='onboarding', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['-started_on', '-id'],
            },
        ),
        migrations.CreateModel(
            name='OnboardingTask',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('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(blank=True, max_length=60, null=True)),
                ('due_date', models.DateField(blank=True, null=True)),
                ('is_done', models.BooleanField(default=False)),
                ('done_at', models.DateTimeField(blank=True, null=True)),
                ('done_by', models.CharField(blank=True, max_length=150, null=True)),
                ('sort_order', models.PositiveIntegerField(default=0)),
                ('record', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='tasks', to='People.onboardingrecord')),
            ],
            options={
                'ordering': ['sort_order', 'id'],
            },
        ),
        migrations.CreateModel(
            name='OrgChartSettings',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('lead_keywords', models.JSONField(blank=True, default=People.org_chart_models.default_lead_keywords)),
                ('group_min_size', models.PositiveSmallIntegerField(default=3)),
                ('group_leaders', models.BooleanField(default=True)),
                ('leadership_label', models.CharField(default='Leadership Team', max_length=60)),
                ('max_depth', models.PositiveSmallIntegerField(default=15)),
                ('department_styles', models.JSONField(blank=True, default=dict)),
                ('company', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='org_chart_settings', to='Company.company_details')),
                ('root_employee', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='Employee.employeedt')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='PerimeterEvent',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('employee_code', models.CharField(blank=True, max_length=100, null=True)),
                ('event_time', models.DateTimeField(db_index=True)),
                ('attempted_action', models.CharField(max_length=60)),
                ('detected_ip', models.GenericIPAddressField(blank=True, null=True)),
                ('latitude', models.FloatField(blank=True, null=True)),
                ('longitude', models.FloatField(blank=True, null=True)),
                ('distance_m', models.DecimalField(blank=True, decimal_places=1, max_digits=10, null=True)),
                ('breach_reason', models.TextField(blank=True, null=True)),
                ('status', models.CharField(choices=[('Blocked by Perimeter Lock', 'Blocked by Perimeter Lock'), ('Redirected to WFH Portal', 'Redirected to WFH Portal'), ('Overridden by HR', 'Overridden by HR'), ('Resolved', 'Resolved')], db_index=True, default='Blocked by Perimeter Lock', max_length=26)),
                ('resolved_by', models.CharField(blank=True, max_length=150, null=True)),
                ('resolved_at', models.DateTimeField(blank=True, null=True)),
                ('resolution_note', models.TextField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_perimeter_events', to='Company.company_details')),
                ('employee', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='perimeter_events', to='Employee.employeedt')),
                ('geofence', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='People.attendancegeofence')),
            ],
            options={
                'ordering': ['-event_time', '-id'],
            },
        ),
        migrations.CreateModel(
            name='PromotionRequest',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('current_designation', models.CharField(blank=True, max_length=200, null=True)),
                ('proposed_designation', models.CharField(max_length=200)),
                ('current_grade', models.CharField(blank=True, max_length=30, null=True)),
                ('proposed_grade', models.CharField(blank=True, max_length=30, null=True)),
                ('hike_percent', models.DecimalField(decimal_places=2, default=0, max_digits=5)),
                ('manager_rating', models.DecimalField(blank=True, decimal_places=1, max_digits=3, null=True)),
                ('effective_date', models.DateField(blank=True, null=True)),
                ('remarks', models.TextField(blank=True, null=True)),
                ('status', models.CharField(choices=[('Nominated', 'Nominated'), ('Under Review', 'Under Review'), ('Approved by Committee', 'Approved by Committee'), ('Rejected', 'Rejected'), ('Executed', 'Executed')], db_index=True, default='Nominated', max_length=24)),
                ('nominated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('committee_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)),
                ('executed_at', models.DateTimeField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_promotions', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='promotions', to='Employee.employeedt')),
                ('letter', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='People.employeeletter')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='ReportBenchmark',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('key', models.CharField(max_length=60)),
                ('label', models.CharField(blank=True, max_length=150, null=True)),
                ('value', models.DecimalField(decimal_places=2, max_digits=16)),
                ('unit', models.CharField(blank=True, max_length=20, null=True)),
                ('financial_year', models.CharField(blank=True, default='', max_length=9)),
                ('notes', models.TextField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_report_benchmarks', to='Company.company_details')),
            ],
            options={
                'ordering': ['key', '-financial_year'],
            },
        ),
        migrations.CreateModel(
            name='ReportExport',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('report_type', models.CharField(choices=[('employee_master', 'Employee Master'), ('recruitment_data', 'Recruitment Data')], db_index=True, max_length=20)),
                ('file_format', models.CharField(choices=[('csv', 'CSV'), ('xlsx', 'Excel (.xlsx)')], default='csv', max_length=5)),
                ('title', models.CharField(blank=True, max_length=200, null=True)),
                ('filters', models.JSONField(blank=True, default=dict)),
                ('row_count', models.PositiveIntegerField(default=0)),
                ('status', models.CharField(choices=[('Completed', 'Completed'), ('Failed', 'Failed')], default='Completed', max_length=10)),
                ('error', models.TextField(blank=True, null=True)),
                ('file', models.FileField(blank=True, null=True, upload_to='report_exports/%Y/%m/')),
                ('file_name', models.CharField(blank=True, max_length=200, null=True)),
                ('file_size', models.PositiveIntegerField(default=0)),
                ('download_count', models.PositiveIntegerField(default=0)),
                ('last_downloaded_at', models.DateTimeField(blank=True, null=True)),
                ('notes', models.TextField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_report_exports', to='Company.company_details')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='ReviewMilestone',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('milestone_day', models.PositiveSmallIntegerField(choices=[(30, '30 Days - Performance of the Employee'), (60, '60 Days - Technical Strong'), (90, '90 Days - Overall Flow')], db_index=True)),
                ('status', models.CharField(choices=[('PENDING', 'Pending'), ('IN_PROGRESS', 'In Progress'), ('COMPLETED', 'Completed'), ('COMPETENT_STRONG', 'Competent & Strong'), ('CONFIRMED', 'Confirmed'), ('NEEDS_IMPROVEMENT', 'Needs Improvement')], db_index=True, default='PENDING', max_length=20)),
                ('score', models.DecimalField(blank=True, decimal_places=1, max_digits=3, null=True)),
                ('reviewer_name', models.CharField(blank=True, default='', max_length=150)),
                ('reviewer_title', models.CharField(blank=True, default='', max_length=150)),
                ('target_date', models.DateField(blank=True, null=True)),
                ('completed_date', models.DateField(blank=True, null=True)),
                ('strengths', models.JSONField(blank=True, default=list)),
                ('improvements', models.JSONField(blank=True, default=list)),
                ('remarks', models.TextField(blank=True, default='')),
                ('outcome', models.CharField(blank=True, choices=[('RECOMMENDED_CONFIRMATION', 'Recommended for Full Confirmation'), ('EXTEND_PROBATION', 'Extend Probation'), ('NOT_RECOMMENDED', 'Not Recommended for Confirmation')], default='', max_length=30)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='review_milestones', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='review_milestones', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['employee_id', 'milestone_day'],
            },
        ),
        migrations.CreateModel(
            name='ReviewCriterion',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('position', models.PositiveSmallIntegerField(default=0)),
                ('name', models.CharField(max_length=200)),
                ('score', models.DecimalField(blank=True, decimal_places=1, max_digits=3, null=True)),
                ('note', models.TextField(blank=True, default='')),
                ('milestone', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='criteria', to='People.reviewmilestone')),
            ],
            options={
                'ordering': ['milestone_id', 'position', 'id'],
            },
        ),
        migrations.CreateModel(
            name='ReviewOption',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('kind', models.CharField(choices=[('STATUS', 'Milestone status'), ('OUTCOME', 'Final outcome')], max_length=10)),
                ('code', models.CharField(max_length=30)),
                ('label', models.CharField(max_length=100)),
                ('counts_as_completed', models.BooleanField(default=False)),
                ('milestone_days', models.JSONField(blank=True, default=list)),
                ('position', models.PositiveSmallIntegerField(default=0)),
                ('is_system', models.BooleanField(default=False)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='review_options', to='Company.company_details')),
            ],
            options={
                'ordering': ['company_id', 'kind', 'position', 'id'],
            },
        ),
        migrations.CreateModel(
            name='ReviewSettings',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('due_soon_days', models.PositiveSmallIntegerField(default=7)),
                ('window_days', models.PositiveSmallIntegerField(default=120)),
                ('score_min', models.DecimalField(decimal_places=1, default=1, max_digits=3)),
                ('score_max', models.DecimalField(decimal_places=1, default=5, max_digits=3)),
                ('score_step', models.DecimalField(decimal_places=1, default=0.5, max_digits=3)),
                ('seeded', models.BooleanField(default=False)),
                ('company', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='review_settings', to='Company.company_details')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='ReviewTemplate',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('milestone_day', models.PositiveSmallIntegerField()),
                ('title', models.CharField(max_length=150)),
                ('tab_label', models.CharField(blank=True, default='', max_length=150)),
                ('subtitle', models.CharField(blank=True, default='', max_length=250)),
                ('section_title', models.CharField(blank=True, default='', max_length=150)),
                ('table_headers', models.JSONField(blank=True, default=dict)),
                ('labels', models.JSONField(blank=True, default=dict)),
                ('default_reviewer_title', models.CharField(blank=True, default='', max_length=150)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='review_templates', to='Company.company_details')),
            ],
            options={
                'ordering': ['company_id', 'milestone_day'],
            },
        ),
        migrations.CreateModel(
            name='ReviewTemplateCriterion',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('position', models.PositiveSmallIntegerField(default=0)),
                ('name', models.CharField(max_length=200)),
                ('template', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='criteria', to='People.reviewtemplate')),
            ],
            options={
                'ordering': ['template_id', 'position', 'id'],
            },
        ),
        migrations.CreateModel(
            name='Survey',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('audience_type', models.CharField(choices=[('ALL', 'All Organization'), ('DEPARTMENT', 'Department'), ('BRANCH', 'Branch')], db_index=True, default='ALL', max_length=10)),
                ('audience_ids', models.JSONField(blank=True, default=list)),
                ('title', models.CharField(max_length=200)),
                ('description', models.TextField(blank=True, null=True)),
                ('survey_type', models.CharField(choices=[('PULSE', 'Pulse Survey'), ('ENPS', 'eNPS Survey'), ('ENGAGEMENT', 'Engagement Survey'), ('CUSTOM', 'Custom Survey')], default='PULSE', max_length=12)),
                ('status', models.CharField(choices=[('DRAFT', 'Draft'), ('ACTIVE', 'Active'), ('CLOSED', 'Closed')], db_index=True, default='DRAFT', max_length=8)),
                ('is_anonymous', models.BooleanField(default=True)),
                ('start_date', models.DateField(blank=True, null=True)),
                ('end_date', models.DateField(blank=True, null=True)),
                ('launched_at', models.DateTimeField(blank=True, null=True)),
                ('closed_at', models.DateTimeField(blank=True, null=True)),
                ('target_count', models.PositiveIntegerField(default=0)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='eng_surveys', to='Company.company_details')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='SurveyQuestion',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('order', models.PositiveIntegerField(default=1)),
                ('text', models.CharField(max_length=500)),
                ('qtype', models.CharField(choices=[('RATING', 'Rating 1-5'), ('NPS', 'eNPS 0-10'), ('TEXT', 'Free text'), ('SINGLE', 'Single choice'), ('MULTI', 'Multiple choice'), ('YES_NO', 'Yes / No')], default='RATING', max_length=8)),
                ('options', models.JSONField(blank=True, default=list)),
                ('is_required', models.BooleanField(default=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='eng_survey_questions', to='Company.company_details')),
                ('survey', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='questions', to='People.survey')),
            ],
            options={
                'ordering': ['order', 'id'],
            },
        ),
        migrations.CreateModel(
            name='SurveyResponse',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('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='eng_survey_responses', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='eng_survey_responses', to='Employee.employeedt')),
                ('survey', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='responses', to='People.survey')),
            ],
        ),
        migrations.CreateModel(
            name='SurveyAnswer',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('rating', models.IntegerField(blank=True, null=True)),
                ('text', models.TextField(blank=True, null=True)),
                ('choices', models.JSONField(blank=True, default=list)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='eng_survey_answers', to='Company.company_details')),
                ('question', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='answers', to='People.surveyquestion')),
                ('response', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='answers', to='People.surveyresponse')),
            ],
        ),
        migrations.CreateModel(
            name='TransferRequest',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('from_department_name', models.CharField(blank=True, max_length=150, null=True)),
                ('from_branch_name', models.CharField(blank=True, max_length=150, null=True)),
                ('effective_date', models.DateField()),
                ('reason', models.TextField(blank=True, null=True)),
                ('hod_status', models.CharField(choices=[('Pending', 'Pending HOD'), ('Approved', 'Approved'), ('Rejected', 'Rejected')], db_index=True, default='Pending', max_length=10)),
                ('hod_remarks', models.TextField(blank=True, null=True)),
                ('status', models.CharField(choices=[('Requested', 'Requested'), ('Approved', 'Approved'), ('Executed', 'Executed'), ('Rejected', 'Rejected'), ('Cancelled', 'Cancelled')], db_index=True, default='Requested', max_length=10)),
                ('executed_at', models.DateTimeField(blank=True, null=True)),
                ('reminded_at', models.DateTimeField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='people_transfers', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='transfers', to='Employee.employeedt')),
                ('from_manager', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='Employee.employeedt')),
                ('hod_approver', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='Employee.employeedt')),
                ('to_branch', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='People.branch')),
                ('to_department', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='Employee.department')),
                ('to_manager', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['effective_date', '-id'],
            },
        ),
        migrations.CreateModel(
            name='AnnouncementReaction',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('reaction', models.CharField(choices=[('LIKE', 'Like'), ('CLAP', 'Clap'), ('HEART', 'Heart'), ('IDEA', 'Idea'), ('ROCKET', 'Rocket')], max_length=8)),
                ('announcement', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='reactions', to='People.announcement')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='eng_reactions', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='eng_reactions', to='Employee.employeedt')),
            ],
            options={
                'unique_together': {('announcement', 'employee')},
            },
        ),
        migrations.CreateModel(
            name='AnnouncementView',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('view_count', models.PositiveIntegerField(default=1)),
                ('last_viewed_at', models.DateTimeField(auto_now=True)),
                ('announcement', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='views', to='People.announcement')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='eng_views', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='eng_views', to='Employee.employeedt')),
            ],
            options={
                'unique_together': {('announcement', 'employee')},
            },
        ),
        migrations.AddConstraint(
            model_name='attendanceregularization',
            constraint=models.UniqueConstraint(fields=('company', 'request_id'), name='uniq_people_reg_request_id'),
        ),
        migrations.AddConstraint(
            model_name='attendanceregularization',
            constraint=models.UniqueConstraint(condition=models.Q(('status__in', ['Pending Approval', 'Approved'])), fields=('company', 'employee', 'attendance_date'), name='uniq_people_reg_open'),
        ),
        migrations.AlterUniqueTogether(
            name='biometricenrollment',
            unique_together={('company', 'biometric_id')},
        ),
        migrations.AddConstraint(
            model_name='biometricpunch',
            constraint=models.UniqueConstraint(fields=('company', 'device_code', 'biometric_id', 'punch_time', 'direction'), name='uniq_people_bio_punch'),
        ),
        migrations.AlterUniqueTogether(
            name='branch',
            unique_together={('company', 'name')},
        ),
        migrations.AlterUniqueTogether(
            name='biometricdevice',
            unique_together={('company', 'device_code')},
        ),
        migrations.AlterUniqueTogether(
            name='attendancegeofence',
            unique_together={('company', 'name')},
        ),
        migrations.AlterUniqueTogether(
            name='companyemailconfig',
            unique_together={('company', 'mailbox_key'), ('company', 'name_key')},
        ),
        migrations.AddIndex(
            model_name='companyemaillog',
            index=models.Index(fields=['company', 'created_at'], name='People_comp_company_7f5515_idx'),
        ),
        migrations.AlterUniqueTogether(
            name='complianceregistration',
            unique_together={('company', 'reg_type', 'number')},
        ),
        migrations.AlterUniqueTogether(
            name='employeeletter',
            unique_together={('company', 'letter_no')},
        ),
        migrations.AlterUniqueTogether(
            name='esslsource',
            unique_together={('company', 'name')},
        ),
        migrations.AlterUniqueTogether(
            name='eventrsvp',
            unique_together={('event', 'employee')},
        ),
        migrations.AlterUniqueTogether(
            name='exitfnf',
            unique_together={('company', 'statement_no')},
        ),
        migrations.AlterUniqueTogether(
            name='exitreasongroup',
            unique_together={('company', 'name')},
        ),
        migrations.AlterUniqueTogether(
            name='fieldforceagent',
            unique_together={('company', 'employee')},
        ),
        migrations.AlterUniqueTogether(
            name='form16record',
            unique_together={('company', 'employee', 'financial_year', 'part')},
        ),
        migrations.AlterUniqueTogether(
            name='labourlicense',
            unique_together={('company', 'license_type', 'license_number')},
        ),
        migrations.AlterUniqueTogether(
            name='lettertemplate',
            unique_together={('company', 'code')},
        ),
        migrations.AlterUniqueTogether(
            name='reportbenchmark',
            unique_together={('company', 'key', 'financial_year')},
        ),
        migrations.AlterUniqueTogether(
            name='reviewmilestone',
            unique_together={('employee', 'milestone_day')},
        ),
        migrations.AlterUniqueTogether(
            name='reviewoption',
            unique_together={('company', 'kind', 'code')},
        ),
        migrations.AlterUniqueTogether(
            name='reviewtemplate',
            unique_together={('company', 'milestone_day')},
        ),
        migrations.AlterUniqueTogether(
            name='surveyresponse',
            unique_together={('survey', 'employee')},
        ),
        migrations.AlterUniqueTogether(
            name='surveyanswer',
            unique_together={('response', 'question')},
        ),
    ]
