# Generated by Django 4.2.30 on 2026-04-27 12:16

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('integrations', '0001_initial'),
    ]

    operations = [
        migrations.CreateModel(
            name='ClientRevenueTarget',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('branch_id', models.CharField(max_length=50)),
                ('company_id', models.IntegerField()),
                ('target', models.IntegerField(blank=True, null=True)),
                ('breakeven', models.IntegerField(blank=True, null=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('client', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='revenue_targets', to='integrations.client')),
            ],
            options={
                'db_table': 'client_revenue_targets',
                'unique_together': {('client', 'branch_id', 'company_id')},
            },
        ),
        migrations.CreateModel(
            name='ClientKPITargetOverride',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('branch', models.CharField(max_length=80)),
                ('department', models.CharField(max_length=80)),
                ('metric_key', models.CharField(max_length=80)),
                ('target', models.FloatField(blank=True, null=True)),
                ('weight', models.FloatField(blank=True, null=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('client', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='kpi_target_overrides', to='integrations.client')),
            ],
            options={
                'db_table': 'client_kpi_target_overrides',
                'unique_together': {('client', 'branch', 'department', 'metric_key')},
            },
        ),
        migrations.CreateModel(
            name='ClientGPThreshold',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('department_type', models.CharField(max_length=50)),
                ('green_min', models.FloatField()),
                ('yellow_min', models.FloatField()),
                ('yellow_max', models.FloatField()),
                ('red_max', models.FloatField()),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('client', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='gp_thresholds', to='integrations.client')),
            ],
            options={
                'db_table': 'client_gp_thresholds',
                'unique_together': {('client', 'department_type')},
            },
        ),
    ]