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

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


class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='ProjectMeetingMinute',
            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)),
                ('project_meeting_type', models.CharField(choices=[('Kickoff', 'Kickoff'), ('Sprint Planning', 'Sprint Planning'), ('Status Review', 'Status Review'), ('Client Call', 'Client Call'), ('RCA', 'RCA / Post-mortem'), ('Retrospective', 'Retrospective'), ('Other', 'Other')], db_index=True, default='Status Review', max_length=20)),
                ('minutes', models.TextField(blank=True, null=True)),
                ('decisions', models.TextField(blank=True, null=True)),
                ('rca', models.TextField(blank=True, null=True)),
                ('action_items', models.JSONField(blank=True, default=list)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='project_meeting_minutes', to='Company.company_details')),
                ('meeting', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='project_minute', to='Communication.meeting')),
                ('project', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='meeting_minutes', to='Timesheet.timesheetproject')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='ProjectPlan',
            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)),
                ('priority', models.CharField(choices=[('Low', 'Low'), ('Medium', 'Medium'), ('High', 'High'), ('Critical', 'Critical')], db_index=True, default='Medium', max_length=8)),
                ('budget_amount', models.DecimalField(blank=True, decimal_places=2, max_digits=14, null=True)),
                ('baseline_end_date', models.DateField(blank=True, null=True)),
                ('approved_end_date', models.DateField(blank=True, null=True)),
                ('forecast_end_date', models.DateField(blank=True, null=True)),
                ('delivery_status', models.CharField(blank=True, max_length=40, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='project_plans', to='Company.company_details')),
                ('project', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='plan', to='Timesheet.timesheetproject')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='ProjectTask',
            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)),
                ('wbs_code', models.CharField(blank=True, max_length=30, null=True)),
                ('title', models.CharField(max_length=250)),
                ('description', models.TextField(blank=True, null=True)),
                ('is_milestone', models.BooleanField(db_index=True, default=False)),
                ('status', models.CharField(choices=[('To Do', 'To Do'), ('In Progress', 'In Progress'), ('Blocked', 'Blocked'), ('In Review', 'In Review'), ('Completed', 'Completed'), ('Cancelled', 'Cancelled')], db_index=True, default='To Do', max_length=12)),
                ('priority', models.CharField(choices=[('Low', 'Low'), ('Medium', 'Medium'), ('High', 'High'), ('Critical', 'Critical')], default='Medium', max_length=8)),
                ('progress', models.PositiveSmallIntegerField(default=0)),
                ('start_date', models.DateField(blank=True, null=True)),
                ('due_date', models.DateField(blank=True, null=True)),
                ('completed_on', models.DateField(blank=True, null=True)),
                ('planned_hours', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=8)),
                ('deliverable_verified', models.BooleanField(default=False)),
                ('blocked_reason', models.CharField(blank=True, max_length=300, null=True)),
                ('is_critical', models.BooleanField(default=False)),
                ('early_start', models.DateField(blank=True, null=True)),
                ('early_finish', models.DateField(blank=True, null=True)),
                ('slack_days', models.IntegerField(blank=True, null=True)),
                ('assignee', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='hub_tasks', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='project_tasks', to='Company.company_details')),
                ('parent', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='children', to='ProjectHub.projecttask')),
                ('project', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='hub_tasks', to='Timesheet.timesheetproject')),
            ],
            options={
                'ordering': ['project_id', 'wbs_code', 'id'],
            },
        ),
        migrations.CreateModel(
            name='ProjectBug',
            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)),
                ('bug_code', models.CharField(max_length=30)),
                ('title', models.CharField(max_length=250)),
                ('description', models.TextField(blank=True, null=True)),
                ('steps_to_reproduce', models.TextField(blank=True, null=True)),
                ('severity', models.CharField(choices=[('Low', 'Low'), ('Medium', 'Medium'), ('High', 'High'), ('Critical', 'Critical')], db_index=True, default='Medium', max_length=8)),
                ('status', models.CharField(choices=[('Open', 'Open'), ('In Progress', 'In Progress'), ('Fixed', 'Fixed'), ('Retest', 'Retest'), ('Closed', 'Closed'), ('Reopened', 'Reopened'), ("Won't Fix", "Won't Fix")], db_index=True, default='Open', max_length=12)),
                ('qa_result', models.CharField(choices=[('Pending', 'Pending'), ('Passed', 'Passed'), ('Failed', 'Failed')], default='Pending', max_length=8)),
                ('reported_by_code', models.CharField(blank=True, max_length=100, null=True)),
                ('rca', models.TextField(blank=True, null=True)),
                ('resolution', models.TextField(blank=True, null=True)),
                ('resolved_at', models.DateTimeField(blank=True, null=True)),
                ('assignee', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='hub_bugs', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='project_bugs', to='Company.company_details')),
                ('project', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='hub_bugs', to='Timesheet.timesheetproject')),
                ('task', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='bugs', to='ProjectHub.projecttask')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='DailyWorkReport',
            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_date', models.DateField(db_index=True)),
                ('summary', models.TextField()),
                ('blockers', models.TextField(blank=True, null=True)),
                ('hours', models.DecimalField(decimal_places=2, max_digits=4)),
                ('progress_percent', models.PositiveSmallIntegerField(blank=True, null=True)),
                ('status', models.CharField(choices=[('Pending', 'Pending Review'), ('Approved', 'Approved'), ('Revision', 'Revision Requested')], db_index=True, default='Pending', max_length=8)),
                ('reviewed_by', models.CharField(blank=True, max_length=150, null=True)),
                ('reviewed_at', models.DateTimeField(blank=True, null=True)),
                ('review_remarks', models.TextField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='daily_work_reports', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='daily_work_reports', to='Employee.employeedt')),
                ('project', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='daily_reports', to='Timesheet.timesheetproject')),
                ('task', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='daily_reports', to='ProjectHub.projecttask')),
            ],
            options={
                'ordering': ['-report_date', '-id'],
            },
        ),
        migrations.CreateModel(
            name='TaskDependency',
            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)),
                ('lag_days', models.IntegerField(default=0)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='task_dependencies', to='Company.company_details')),
                ('predecessor', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='successor_links', to='ProjectHub.projecttask')),
                ('successor', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='predecessor_links', to='ProjectHub.projecttask')),
            ],
        ),
        migrations.CreateModel(
            name='ChangeRequest',
            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)),
                ('cr_code', models.CharField(max_length=30)),
                ('reason', models.TextField()),
                ('scope_impact', models.TextField(blank=True, null=True)),
                ('budget_impact', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=14)),
                ('hours_impact', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=9)),
                ('revised_target_date', models.DateField(blank=True, null=True)),
                ('status', models.CharField(choices=[('Pending', 'Pending'), ('Approved', 'Approved'), ('Rejected', 'Rejected')], db_index=True, default='Pending', max_length=8)),
                ('requested_by_code', models.CharField(blank=True, max_length=100, null=True)),
                ('decided_by', models.CharField(blank=True, max_length=150, null=True)),
                ('decided_at', models.DateTimeField(blank=True, null=True)),
                ('decision_remarks', models.TextField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='project_change_requests', to='Company.company_details')),
                ('project', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='change_requests', to='Timesheet.timesheetproject')),
            ],
            options={
                'ordering': ['-id'],
                'unique_together': {('company', 'cr_code')},
            },
        ),
        migrations.AddIndex(
            model_name='projecttask',
            index=models.Index(fields=['company', 'project', 'status'], name='ProjectHub__company_cad772_idx'),
        ),
        migrations.AddIndex(
            model_name='projecttask',
            index=models.Index(fields=['company', 'assignee', 'status'], name='ProjectHub__company_6a47f2_idx'),
        ),
        migrations.AlterUniqueTogether(
            name='projectbug',
            unique_together={('company', 'bug_code')},
        ),
        migrations.AddIndex(
            model_name='dailyworkreport',
            index=models.Index(fields=['company', 'status'], name='ProjectHub__company_e3c0f2_idx'),
        ),
        migrations.AddIndex(
            model_name='dailyworkreport',
            index=models.Index(fields=['company', 'employee', 'report_date'], name='ProjectHub__company_ca57d1_idx'),
        ),
        migrations.AlterUniqueTogether(
            name='taskdependency',
            unique_together={('predecessor', 'successor')},
        ),
    ]
