coi/app/legacy/migrations/0003_allprod...

# Generated by Django 4.2 on 2025-05-06 04:36

from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ('legacy', '0002_belmasterview_emasterview_mgmasterview_vmasterview'),
    ]

    operations = [
        migrations.CreateModel(
            name='AllProductAverageObMinMaxView',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('ProductCode', models.CharField(max_length=255, null=True)),
                ('out_min', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('out_max', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('in_min', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('in_max', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
            ],
            options={
                'db_table': 'AllProduct_Average_OB_MIN_MAX_view',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='AllProductDimensionForInsProcess',
            fields=[
                ('ProdType', models.CharField(max_length=255, null=True)),
                ('ProductCode', models.CharField(max_length=255, primary_key=True, serialize=False)),
                ('Size_Id', models.CharField(max_length=255, null=True)),
                ('Size_Name', models.CharField(max_length=255, null=True)),
                ('Std', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('TolUn', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('TolUp', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
            ],
            options={
                'db_table': 'AllProduct_Dimension_ForInsProcess',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='AllProductPressPositionPressWeight',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('ProductCode', models.CharField(max_length=255, null=True)),
                ('Lot_No', models.CharField(max_length=255, null=True)),
                ('PO_Qty', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('UWeight', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('Current_ProNo', models.CharField(max_length=255, null=True)),
                ('Press_Time', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('PressType_1', models.CharField(max_length=255, null=True)),
                ('PressWeight_1', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('PressType_2', models.CharField(max_length=255, null=True)),
                ('PressWeight_2', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('Press_Ton', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('Press_T', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('Press_T_Tol', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('Mold_D', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('Mold_T', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('SegMold_T', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('SegMold_D', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('Center_D', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('Center_T', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('LowerPlate_T', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('StudPlate_T', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('UpperPlate_T', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('PinPlate_T', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('TopConcave_T', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
                ('BottomConcave_T', models.DecimalField(decimal_places=2, max_digits=10, null=True)),
            ],
            options={
                'db_table': 'AllProduct_PressPosition_PressWeight',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='RotateBrokenTest',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('row_no', models.IntegerField(blank=True, null=True)),
                ('speed_spec', models.FloatField(blank=True, null=True)),
                ('speed_test', models.FloatField(blank=True, null=True)),
                ('speedOk', models.CharField(blank=True, max_length=4, null=True)),
                ('qty', models.IntegerField()),
                ('station_no', models.IntegerField()),
                ('created_at', models.DateTimeField(blank=True, null=True)),
                ('updated_at', models.DateTimeField(blank=True, null=True)),
                ('lot_no', models.CharField(blank=True, max_length=50, null=True)),
                ('machine_id', models.IntegerField(blank=True, null=True)),
                ('code', models.CharField(blank=True, max_length=50, null=True)),
                ('emp_id', models.IntegerField()),
                ('devid', models.CharField(blank=True, max_length=40, null=True)),
                ('mode', models.CharField(blank=True, max_length=10, null=True)),
                ('cal_mode', models.IntegerField(blank=True, null=True)),
            ],
            options={
                'db_table': 'rotate_broken_test',
                'managed': False,
            },
        ),
    ]