# -*- coding: utf-8 -*-
# Generated by Django 1.10.6 on 2017-07-27 05:08
from __future__ import unicode_literals

import aspendb.models
import django.core.validators
from django.db import migrations, models
import django.db.models.deletion
import smart_selects.db_fields


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Department',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=30)),
            ],
        ),
        migrations.CreateModel(
            name='Downtime',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateField(default=aspendb.models.get_today, validators=[aspendb.models.date_validator])),
                ('shift', models.CharField(choices=[('1st', '1st'), ('2nd', '2nd')], max_length=3)),
                ('minutes', models.IntegerField(validators=[django.core.validators.MinValueValidator(1)])),
            ],
        ),
        migrations.CreateModel(
            name='DowntimeCode',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('code', models.IntegerField(validators=[django.core.validators.MaxValueValidator(518), django.core.validators.MinValueValidator(101)])),
                ('description', models.CharField(max_length=30)),
            ],
        ),
        migrations.CreateModel(
            name='Employee',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('first_name', models.CharField(max_length=30)),
                ('last_name', models.CharField(max_length=40)),
                ('hire_date', models.DateField(default=aspendb.models.get_today, validators=[aspendb.models.date_validator])),
                ('email', models.EmailField(blank=True, max_length=254)),
                ('shift', models.CharField(choices=[('1st', '1st'), ('2nd', '2nd')], max_length=3)),
                ('training_level', models.IntegerField(choices=[(1, '1'), (2, '2'), (3, '3'), (4, '4'), (5, '5')])),
            ],
        ),
        migrations.CreateModel(
            name='EndOfShift',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateField(default=aspendb.models.get_today, validators=[aspendb.models.date_validator])),
                ('shift', models.CharField(choices=[('1st', '1st'), ('2nd', '2nd')], max_length=3)),
                ('ending_shot', models.IntegerField(validators=[django.core.validators.MinValueValidator(1)])),
                ('scheduled_shots', models.IntegerField(validators=[django.core.validators.MinValueValidator(1)])),
                ('missed_shots', models.IntegerField(validators=[django.core.validators.MinValueValidator(0)])),
                ('total_scrap', models.IntegerField(validators=[django.core.validators.MinValueValidator(0)])),
                ('spray_pots', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('adequate_poly', models.CharField(choices=[('yes', 'Yes'), ('no', 'No')], max_length=3)),
                ('adequate_iso', models.CharField(choices=[('yes', 'Yes'), ('no', 'No')], max_length=3)),
                ('replacement_poly', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('scrap_labeled', models.CharField(choices=[('yes', 'Yes'), ('no', 'No')], max_length=3)),
                ('cabinet_stocked', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('pot_grounded', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('total_manhrs', models.DecimalField(decimal_places=2, max_digits=5, validators=[django.core.validators.MinValueValidator(0.1)])),
                ('comments', models.TextField(blank=True, max_length=1000)),
                ('total_shots', models.IntegerField()),
                ('oee', models.DecimalField(decimal_places=2, max_digits=5)),
                ('scrap_percent', models.DecimalField(decimal_places=2, max_digits=5)),
                ('labor_per_pc', models.DecimalField(decimal_places=4, max_digits=5)),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Employee')),
            ],
        ),
        migrations.CreateModel(
            name='LaborAllocationReport',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateField(default=aspendb.models.get_today, validators=[aspendb.models.date_validator])),
                ('shift', models.CharField(choices=[('1st', '1st'), ('2nd', '2nd')], max_length=3)),
                ('period', models.IntegerField(choices=[(1, '1'), (2, '2'), (3, '3'), (4, '4'), (5, '5')])),
                ('shooter', models.CharField(max_length=30)),
                ('puller', models.CharField(max_length=30)),
                ('sprayer', models.CharField(max_length=30)),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Employee')),
            ],
        ),
        migrations.CreateModel(
            name='LaborReport',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateField(default=aspendb.models.get_today, validators=[aspendb.models.date_validator])),
                ('shift', models.CharField(choices=[('1st', '1st'), ('2nd', '2nd')], max_length=3)),
                ('name', models.CharField(max_length=30)),
                ('start_time', models.TimeField()),
                ('end_time', models.TimeField()),
                ('man_hours', models.DecimalField(decimal_places=2, max_digits=10)),
            ],
        ),
        migrations.CreateModel(
            name='LayeredProcessAudit',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateField(default=aspendb.models.get_today, validators=[aspendb.models.date_validator])),
                ('shift', models.CharField(choices=[('1st', '1st'), ('2nd', '2nd')], max_length=3)),
                ('verified_parameters', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('weight_inspection', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('chemicals_tracked', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('components_tracked', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('setup_posted', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('chemicals_correct', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('event_missed_shot', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('demold_criteria', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('demold_ncm', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('mold_release', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('work_instructions', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('proper_equipment', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('trim_criteria', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('inspecting_prior', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('trim_dcm', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('quality_alerts', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('boxes_marked', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('pack_criteria', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('labels_match', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('fifo_product', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('product_tracked', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('ppe', models.CharField(choices=[('yes', 'Yes'), ('no', 'No')], max_length=3)),
                ('ppe_info', models.CharField(choices=[('yes', 'Yes'), ('no', 'No')], max_length=3)),
                ('sds', models.CharField(choices=[('yes', 'Yes'), ('no', 'No')], max_length=3)),
                ('iso_exposure', models.CharField(choices=[('yes', 'Yes'), ('no', 'No')], max_length=3)),
                ('comments', models.TextField(blank=True, max_length=1000)),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Employee')),
            ],
        ),
        migrations.CreateModel(
            name='MaintenanceRecord',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date_performed', models.DateField(default=aspendb.models.get_today, validators=[aspendb.models.date_validator])),
                ('problem_code', models.CharField(choices=[('mech', 'Mechanical'), ('elec', 'Electrical'), ('pneu', 'Pneumatic'), ('hydr', 'Hydraulic'), ('water', 'Water'), ('struc', 'Structural'), ('chem', 'Chemical')], max_length=5)),
                ('work_done', models.CharField(blank=True, max_length=50)),
                ('repair_time', models.IntegerField(validators=[django.core.validators.MinValueValidator(0)])),
                ('workcell_downtime', models.IntegerField(validators=[django.core.validators.MinValueValidator(0)])),
                ('parts_used', models.CharField(choices=[('yes', 'Yes'), ('no', 'No')], max_length=3)),
                ('parts_reordered', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('parts_cost', models.DecimalField(decimal_places=2, default=0, max_digits=10)),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Employee', verbose_name='Work performed by')),
            ],
        ),
        migrations.CreateModel(
            name='MaintenanceRequest',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateField(default=aspendb.models.get_today, validators=[aspendb.models.date_validator])),
                ('shift', models.CharField(choices=[('1st', '1st'), ('2nd', '2nd')], max_length=3)),
                ('problem', models.CharField(max_length=100)),
                ('urgency', models.IntegerField(choices=[(1, '1'), (2, '2'), (3, '3'), (4, '4'), (5, '5')])),
                ('status', models.CharField(choices=[('open', 'Open'), ('completed', 'Completed')], default='open', max_length=30)),
                ('approved_by', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='approved_by', to='aspendb.Employee')),
                ('created_by', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='created_by', to='aspendb.Employee')),
                ('department', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Department')),
                ('record', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='aspendb.MaintenanceRecord')),
            ],
        ),
        migrations.CreateModel(
            name='Part',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('part_number', models.CharField(max_length=30)),
            ],
        ),
        migrations.CreateModel(
            name='ProcessActivityReport',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateField(default=aspendb.models.get_today, validators=[aspendb.models.date_validator])),
                ('shift', models.CharField(choices=[('1st', '1st'), ('2nd', '2nd')], max_length=3)),
                ('timestamp', models.TimeField(auto_now=True)),
                ('defect', models.CharField(blank=True, max_length=20)),
                ('process_change', models.CharField(max_length=50)),
                ('effect', models.IntegerField(choices=[(1, '1'), (2, '2'), (3, '3'), (4, '4'), (5, '5')])),
                ('change_reverted', models.CharField(choices=[('yes', 'Yes'), ('no', 'No')], max_length=3)),
                ('comments', models.TextField(blank=True, max_length=1000)),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Employee')),
                ('part', smart_selects.db_fields.ChainedForeignKey(blank=True, chained_field='workcell', chained_model_field='workcell', null=True, on_delete=django.db.models.deletion.CASCADE, to='aspendb.Part')),
            ],
        ),
        migrations.CreateModel(
            name='ProductionSchedule',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateField(default=aspendb.models.get_today, validators=[aspendb.models.date_validator])),
                ('shift', models.CharField(choices=[('1st', '1st'), ('2nd', '2nd')], max_length=3)),
                ('hours', models.DecimalField(decimal_places=2, default=9.33, max_digits=4)),
                ('shots', models.IntegerField(validators=[django.core.validators.MinValueValidator(1)], verbose_name='Shots per round')),
                ('total_shots', models.IntegerField()),
                ('part', smart_selects.db_fields.ChainedForeignKey(chained_field='workcell', chained_model_field='workcell', on_delete=django.db.models.deletion.CASCADE, to='aspendb.Part')),
            ],
        ),
        migrations.CreateModel(
            name='Program',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=30)),
            ],
        ),
        migrations.CreateModel(
            name='ScrapReport',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateField(default=aspendb.models.get_today, validators=[aspendb.models.date_validator])),
                ('shift', models.CharField(choices=[('1st', '1st'), ('2nd', '2nd')], max_length=3)),
                ('bad_mix', models.IntegerField(default=0)),
                ('dents', models.IntegerField(default=0)),
                ('mold_release', models.IntegerField(default=0)),
                ('non_fill', models.IntegerField(default=0)),
                ('collapse', models.IntegerField(default=0)),
                ('tears', models.IntegerField(default=0)),
                ('trim', models.IntegerField(default=0)),
                ('voilds', models.IntegerField(default=0)),
                ('open_voilds', models.IntegerField(default=0)),
                ('under_weight', models.IntegerField(default=0)),
                ('over_weight', models.IntegerField(default=0)),
                ('swollen', models.IntegerField(default=0)),
                ('contamination', models.IntegerField(default=0)),
                ('total_scrap', models.IntegerField()),
                ('numbers', models.TextField(max_length=1000, validators=[aspendb.models.ScrapReport.scrap_numbers_validator])),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Employee')),
                ('part', smart_selects.db_fields.ChainedForeignKey(chained_field='workcell', chained_model_field='workcell', on_delete=django.db.models.deletion.CASCADE, to='aspendb.Part')),
            ],
        ),
        migrations.CreateModel(
            name='SpotCheckReport',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateField(default=aspendb.models.get_today, validators=[aspendb.models.date_validator])),
                ('shift', models.CharField(choices=[('1st', '1st'), ('2nd', '2nd')], max_length=3)),
                ('timestamp', models.TimeField(auto_now=True)),
                ('qty_checked', models.IntegerField(validators=[django.core.validators.MinValueValidator(0)])),
                ('defects', models.CharField(max_length=50)),
                ('packer_initials', models.CharField(max_length=15)),
                ('comments', models.TextField(blank=True, max_length=1000)),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Employee')),
                ('part', smart_selects.db_fields.ChainedForeignKey(chained_field='workcell', chained_model_field='workcell', on_delete=django.db.models.deletion.CASCADE, to='aspendb.Part')),
            ],
        ),
        migrations.CreateModel(
            name='StartOfShift',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateField(default=aspendb.models.get_today, validators=[aspendb.models.date_validator])),
                ('shift', models.CharField(choices=[('1st', '1st'), ('2nd', '2nd')], max_length=3)),
                ('process_verified', models.CharField(choices=[('yes', 'Yes'), ('no', 'No')], max_length=3)),
                ('weights_verified', models.CharField(choices=[('yes', 'Yes'), ('no', 'No')], max_length=3)),
                ('starting_shot', models.IntegerField(validators=[django.core.validators.MinValueValidator(0)])),
                ('mix_ratio', models.FloatField(validators=[django.core.validators.MaxValueValidator(2), django.core.validators.MinValueValidator(0)])),
                ('poly_temp', models.FloatField(validators=[django.core.validators.MaxValueValidator(90), django.core.validators.MinValueValidator(60)])),
                ('iso_temp', models.FloatField(validators=[django.core.validators.MaxValueValidator(90), django.core.validators.MinValueValidator(60)])),
                ('poly_flow', models.FloatField(validators=[django.core.validators.MaxValueValidator(200), django.core.validators.MinValueValidator(20)])),
                ('iso_flow', models.FloatField(validators=[django.core.validators.MaxValueValidator(200), django.core.validators.MinValueValidator(20)])),
                ('poly_pressure', models.IntegerField(validators=[django.core.validators.MaxValueValidator(2500), django.core.validators.MinValueValidator(50)])),
                ('iso_pressure', models.IntegerField(validators=[django.core.validators.MaxValueValidator(2500), django.core.validators.MinValueValidator(50)])),
                ('adequate_components', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('airhose_secure', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('poly_agitator', models.CharField(choices=[('yes', 'Yes'), ('no', 'No')], max_length=3)),
                ('chemical_tracked', models.CharField(choices=[('yes', 'Yes'), ('no', 'No'), ('na', 'N/A')], max_length=3)),
                ('poly_date', models.DateField()),
                ('iso_date', models.DateField()),
                ('stands_labels', models.CharField(choices=[('yes', 'Yes'), ('no', 'No')], max_length=3)),
                ('new_product', models.CharField(choices=[('yes', 'Yes'), ('no', 'No')], max_length=3)),
                ('opposite_parts', models.CharField(choices=[('yes', 'Yes'), ('no', 'No')], max_length=3)),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Employee')),
            ],
        ),
        migrations.CreateModel(
            name='Workcell',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=30, validators=[aspendb.models.nospace_validator])),
                ('foam_system', models.CharField(max_length=30)),
                ('table_time_minutes', models.IntegerField(default=0, validators=[django.core.validators.MaxValueValidator(10), django.core.validators.MinValueValidator(0)])),
                ('table_time_seconds', models.IntegerField(default=0, validators=[django.core.validators.MaxValueValidator(60), django.core.validators.MinValueValidator(0)])),
                ('turns_per_hour', models.DecimalField(blank=True, decimal_places=2, max_digits=4)),
                ('cell_leader_1st', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='cell_leader_1st', to='aspendb.Employee')),
                ('cell_leader_2nd', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='cell_leader_2nd', to='aspendb.Employee')),
            ],
        ),
        migrations.AddField(
            model_name='startofshift',
            name='workcell',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Workcell'),
        ),
        migrations.AddField(
            model_name='spotcheckreport',
            name='workcell',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Workcell'),
        ),
        migrations.AddField(
            model_name='scrapreport',
            name='workcell',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Workcell'),
        ),
        migrations.AddField(
            model_name='productionschedule',
            name='workcell',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Workcell'),
        ),
        migrations.AddField(
            model_name='processactivityreport',
            name='workcell',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Workcell'),
        ),
        migrations.AddField(
            model_name='part',
            name='program',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Program'),
        ),
        migrations.AddField(
            model_name='part',
            name='workcell',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Workcell'),
        ),
        migrations.AddField(
            model_name='maintenancerequest',
            name='workcell',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='aspendb.Workcell'),
        ),
        migrations.AddField(
            model_name='layeredprocessaudit',
            name='workcell',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Workcell'),
        ),
        migrations.AddField(
            model_name='laborreport',
            name='workcell',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Workcell'),
        ),
        migrations.AddField(
            model_name='laborallocationreport',
            name='workcell',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Workcell'),
        ),
        migrations.AddField(
            model_name='endofshift',
            name='workcell',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Workcell'),
        ),
        migrations.AlterUniqueTogether(
            name='employee',
            unique_together=set([('first_name', 'last_name')]),
        ),
        migrations.AddField(
            model_name='downtime',
            name='code',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.DowntimeCode'),
        ),
        migrations.AddField(
            model_name='downtime',
            name='employee',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Employee'),
        ),
        migrations.AddField(
            model_name='downtime',
            name='workcell',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='aspendb.Workcell'),
        ),
        migrations.AddField(
            model_name='department',
            name='representative_1st',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='representative_1st', to='aspendb.Employee'),
        ),
        migrations.AddField(
            model_name='department',
            name='representative_2nd',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='representative_2nd', to='aspendb.Employee'),
        ),
        migrations.AlterUniqueTogether(
            name='startofshift',
            unique_together=set([('date', 'shift', 'workcell')]),
        ),
        migrations.AlterUniqueTogether(
            name='scrapreport',
            unique_together=set([('date', 'shift', 'workcell', 'part')]),
        ),
        migrations.AlterUniqueTogether(
            name='layeredprocessaudit',
            unique_together=set([('date', 'shift', 'workcell')]),
        ),
        migrations.AlterUniqueTogether(
            name='laborallocationreport',
            unique_together=set([('date', 'shift', 'workcell', 'period')]),
        ),
        migrations.AlterUniqueTogether(
            name='endofshift',
            unique_together=set([('date', 'shift', 'workcell')]),
        ),
    ]
