# Generated by Django 3.1.5 on 2021-03-14 18:13

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Analysiscode',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('language1', models.CharField(blank=True, max_length=50, null=True)),
                ('language2', models.CharField(blank=True, max_length=50, null=True)),
                ('language3', models.CharField(blank=True, max_length=50, null=True)),
                ('language4', models.CharField(blank=True, max_length=50, null=True)),
            ],
            options={
                'db_table': 'AnalysisCode',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Approvalhistoryasking',
            fields=[
                ('iid', models.AutoField(primary_key=True, serialize=False)),
                ('o_id', models.CharField(blank=True, max_length=20, null=True)),
                ('id', models.CharField(max_length=20)),
                ('cs', models.IntegerField(blank=True, null=True)),
                ('language1', models.CharField(blank=True, max_length=50, null=True)),
                ('language2', models.CharField(blank=True, max_length=50, null=True)),
                ('language3', models.CharField(blank=True, max_length=50, null=True)),
                ('language4', models.CharField(blank=True, max_length=50, null=True)),
                ('responsibilities1', models.CharField(blank=True, max_length=50, null=True)),
                ('responsibilities2', models.CharField(blank=True, max_length=50, null=True)),
                ('responsibilities3', models.CharField(blank=True, max_length=50, null=True)),
                ('responsibilities4', models.CharField(blank=True, max_length=50, null=True)),
            ],
            options={
                'db_table': 'ApprovalHistoryAsking',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Approvalline',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('rqtano', models.CharField(blank=True, db_column='RqtANo', max_length=50, null=True)),
                ('approvalcount', models.IntegerField(blank=True, db_column='ApprovalCount', null=True)),
                ('approvalcurrent', models.IntegerField(blank=True, db_column='ApprovalCurrent', null=True)),
                ('approvalid1', models.CharField(blank=True, db_column='ApprovalId1', max_length=20, null=True)),
                ('approvalid2', models.CharField(blank=True, db_column='ApprovalId2', max_length=20, null=True)),
                ('approvalid3', models.CharField(blank=True, db_column='ApprovalId3', max_length=20, null=True)),
                ('approvalid4', models.CharField(blank=True, db_column='ApprovalId4', max_length=20, null=True)),
                ('approvalid5', models.CharField(blank=True, db_column='ApprovalId5', max_length=20, null=True)),
                ('approvalid6', models.CharField(blank=True, db_column='ApprovalId6', max_length=20, null=True)),
                ('approvalid7', models.CharField(blank=True, db_column='ApprovalId7', max_length=20, null=True)),
                ('approvalid8', models.CharField(blank=True, db_column='ApprovalId8', max_length=20, null=True)),
                ('approvalid9', models.CharField(blank=True, db_column='ApprovalId9', max_length=20, null=True)),
                ('approvalornot1', models.CharField(blank=True, db_column='ApprovalOrNot1', max_length=1, null=True)),
                ('approvalornot2', models.CharField(blank=True, db_column='ApprovalOrNot2', max_length=1, null=True)),
                ('approvalornot3', models.CharField(blank=True, db_column='ApprovalOrNot3', max_length=1, null=True)),
                ('approvalornot4', models.CharField(blank=True, db_column='ApprovalOrNot4', max_length=1, null=True)),
                ('approvalornot5', models.CharField(blank=True, db_column='ApprovalOrNot5', max_length=1, null=True)),
                ('approvalornot6', models.CharField(blank=True, db_column='ApprovalOrNot6', max_length=1, null=True)),
                ('approvalornot7', models.CharField(blank=True, db_column='ApprovalOrNot7', max_length=1, null=True)),
                ('approvalornot8', models.CharField(blank=True, db_column='ApprovalOrNot8', max_length=1, null=True)),
                ('approvalornot9', models.CharField(blank=True, db_column='ApprovalOrNot9', max_length=1, null=True)),
                ('approvaldate1', models.DateTimeField(blank=True, db_column='ApprovalDate1', null=True)),
                ('approvaldate2', models.DateTimeField(blank=True, db_column='ApprovalDate2', null=True)),
                ('approvaldate3', models.DateTimeField(blank=True, db_column='ApprovalDate3', null=True)),
                ('approvaldate4', models.DateTimeField(blank=True, db_column='ApprovalDate4', null=True)),
                ('approvaldate5', models.DateTimeField(blank=True, db_column='ApprovalDate5', null=True)),
                ('approvaldate6', models.DateTimeField(blank=True, db_column='ApprovalDate6', null=True)),
                ('approvaldate7', models.DateTimeField(blank=True, db_column='ApprovalDate7', null=True)),
                ('approvaldate8', models.DateTimeField(blank=True, db_column='ApprovalDate8', null=True)),
                ('approvaldate9', models.DateTimeField(blank=True, db_column='ApprovalDate9', null=True)),
                ('confirmcount', models.IntegerField(blank=True, db_column='ConfirmCount', null=True)),
                ('confirmcurrent', models.IntegerField(blank=True, db_column='ConfirmCurrent', null=True)),
                ('confirmid1', models.CharField(blank=True, db_column='ConfirmId1', max_length=20, null=True)),
                ('confirmid2', models.CharField(blank=True, db_column='ConfirmId2', max_length=20, null=True)),
                ('confirmid3', models.CharField(blank=True, db_column='ConfirmId3', max_length=20, null=True)),
                ('confirmid4', models.CharField(blank=True, db_column='ConfirmId4', max_length=20, null=True)),
                ('confirmid5', models.CharField(blank=True, db_column='ConfirmId5', max_length=20, null=True)),
                ('confirmid6', models.CharField(blank=True, db_column='ConfirmId6', max_length=20, null=True)),
                ('confirmid7', models.CharField(blank=True, db_column='ConfirmId7', max_length=20, null=True)),
                ('confirmid8', models.CharField(blank=True, db_column='ConfirmId8', max_length=20, null=True)),
                ('confirmid9', models.CharField(blank=True, db_column='ConfirmId9', max_length=20, null=True)),
                ('confirmornot1', models.CharField(blank=True, db_column='ConfirmOrNot1', max_length=1, null=True)),
                ('confirmornot2', models.CharField(blank=True, db_column='ConfirmOrNot2', max_length=1, null=True)),
                ('confirmornot3', models.CharField(blank=True, db_column='ConfirmOrNot3', max_length=1, null=True)),
                ('confirmornot4', models.CharField(blank=True, db_column='ConfirmOrNot4', max_length=1, null=True)),
                ('confirmornot5', models.CharField(blank=True, db_column='ConfirmOrNot5', max_length=1, null=True)),
                ('confirmornot6', models.CharField(blank=True, db_column='ConfirmOrNot6', max_length=1, null=True)),
                ('confirmornot7', models.CharField(blank=True, db_column='ConfirmOrNot7', max_length=1, null=True)),
                ('confirmornot8', models.CharField(blank=True, db_column='ConfirmOrNot8', max_length=1, null=True)),
                ('confirmornot9', models.CharField(blank=True, db_column='ConfirmOrNot9', max_length=1, null=True)),
                ('confirmdate1', models.DateTimeField(blank=True, db_column='ConfirmDate1', null=True)),
                ('confirmdate2', models.DateTimeField(blank=True, db_column='ConfirmDate2', null=True)),
                ('confirmdate3', models.DateTimeField(blank=True, db_column='ConfirmDate3', null=True)),
                ('confirmdate4', models.DateTimeField(blank=True, db_column='ConfirmDate4', null=True)),
                ('confirmdate5', models.DateTimeField(blank=True, db_column='ConfirmDate5', null=True)),
                ('confirmdate6', models.DateTimeField(blank=True, db_column='ConfirmDate6', null=True)),
                ('confirmdate7', models.DateTimeField(blank=True, db_column='ConfirmDate7', null=True)),
                ('confirmdate8', models.DateTimeField(blank=True, db_column='ConfirmDate8', null=True)),
                ('confirmdate9', models.DateTimeField(blank=True, db_column='ConfirmDate9', null=True)),
                ('autoslip', models.CharField(blank=True, max_length=1, null=True)),
                ('approvalname1', models.CharField(blank=True, db_column='ApprovalName1', max_length=50, null=True)),
                ('approvalname2', models.CharField(blank=True, db_column='ApprovalName2', max_length=50, null=True)),
                ('approvalname3', models.CharField(blank=True, db_column='ApprovalName3', max_length=50, null=True)),
                ('approvalname4', models.CharField(blank=True, db_column='ApprovalName4', max_length=50, null=True)),
                ('approvalname5', models.CharField(blank=True, db_column='ApprovalName5', max_length=50, null=True)),
                ('approvalname6', models.CharField(blank=True, db_column='ApprovalName6', max_length=50, null=True)),
                ('approvalname7', models.CharField(blank=True, db_column='ApprovalName7', max_length=50, null=True)),
                ('approvalname8', models.CharField(blank=True, db_column='ApprovalName8', max_length=50, null=True)),
                ('approvalname9', models.CharField(blank=True, db_column='ApprovalName9', max_length=50, null=True)),
                ('confirmname1', models.CharField(blank=True, db_column='ConfirmName1', max_length=50, null=True)),
                ('confirmname2', models.CharField(blank=True, db_column='ConfirmName2', max_length=50, null=True)),
                ('confirmname3', models.CharField(blank=True, db_column='ConfirmName3', max_length=50, null=True)),
                ('confirmname4', models.CharField(blank=True, db_column='ConfirmName4', max_length=50, null=True)),
                ('confirmname5', models.CharField(blank=True, db_column='ConfirmName5', max_length=50, null=True)),
                ('confirmname6', models.CharField(blank=True, db_column='ConfirmName6', max_length=50, null=True)),
                ('confirmname7', models.CharField(blank=True, db_column='ConfirmName7', max_length=50, null=True)),
                ('confirmname8', models.CharField(blank=True, db_column='ConfirmName8', max_length=50, null=True)),
                ('confirmname9', models.CharField(blank=True, db_column='ConfirmName9', max_length=50, null=True)),
            ],
            options={
                'db_table': 'ApprovalLine',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Asking',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('askingno', models.CharField(blank=True, db_column='AskingNo', max_length=12, null=True)),
                ('askingdate', models.DateTimeField(blank=True, db_column='AskingDate', null=True)),
                ('askinguserid', models.CharField(blank=True, db_column='AskingUserId', max_length=20, null=True)),
                ('askingwarehouse', models.IntegerField(blank=True, db_column='AskingWarehouse', null=True)),
                ('movingwarehouse', models.IntegerField(blank=True, db_column='MovingWarehouse', null=True)),
                ('confirmstatus', models.IntegerField(blank=True, db_column='ConfirmStatus', null=True)),
                ('confirmdate', models.DateTimeField(blank=True, db_column='ConfirmDate', null=True)),
                ('confirmuserid', models.CharField(blank=True, db_column='ConfirmUserId', max_length=20, null=True)),
                ('approvalex', models.CharField(blank=True, db_column='ApprovalEx', max_length=10, null=True)),
                ('approvalfi', models.CharField(blank=True, db_column='ApprovalFi', max_length=10, null=True)),
                ('comments', models.CharField(blank=True, db_column='Comments', max_length=300, null=True)),
            ],
            options={
                'db_table': 'ASKING',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Askingdata',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('askingno', models.CharField(blank=True, db_column='AskingNo', max_length=12, null=True)),
                ('askingwarehouse', models.IntegerField(blank=True, db_column='AskingWarehouse', null=True)),
                ('movingwarehouse', models.IntegerField(blank=True, db_column='MovingWarehouse', null=True)),
                ('confirmstatus', models.IntegerField(blank=True, db_column='ConfirmStatus', null=True)),
                ('code', models.CharField(blank=True, max_length=20, null=True)),
                ('description', models.IntegerField(blank=True, null=True)),
                ('steps', models.CharField(blank=True, max_length=100, null=True)),
                ('askingqty', models.DecimalField(blank=True, db_column='AskingQty', decimal_places=0, max_digits=18, null=True)),
                ('stock', models.DecimalField(blank=True, db_column='Stock', decimal_places=0, max_digits=18, null=True)),
                ('movingqty', models.DecimalField(blank=True, db_column='MovingQty', decimal_places=0, max_digits=18, null=True)),
                ('shortage', models.DecimalField(blank=True, db_column='Shortage', decimal_places=0, max_digits=18, null=True)),
            ],
            options={
                'db_table': 'ASKINGDATA',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Category',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('category', models.CharField(max_length=100)),
            ],
        ),
        migrations.CreateModel(
            name='Count',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
            ],
        ),
        migrations.CreateModel(
            name='Customer',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200, null=True)),
                ('phone', models.CharField(max_length=200, null=True)),
                ('email', models.CharField(max_length=200, null=True)),
                ('date_created', models.DateTimeField(auto_now_add=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='GoodsMaster',
            fields=[
                ('code', models.CharField(db_column='Code', max_length=20, primary_key=True, serialize=False)),
                ('revisiondate', models.DateTimeField(blank=True, db_column='RevisionDate', null=True)),
                ('revisionmathercode', models.IntegerField(blank=True, db_column='RevisionMatherCode', null=True)),
                ('partno', models.CharField(blank=True, db_column='PartNo', max_length=50, null=True)),
                ('goods', models.CharField(blank=True, db_column='Goods', max_length=100, null=True)),
                ('goodsassets', models.IntegerField(blank=True, db_column='GoodsAssets', null=True)),
                ('goods0', models.IntegerField(blank=True, db_column='Goods0', null=True)),
                ('goods1', models.IntegerField(blank=True, db_column='Goods1', null=True)),
                ('goods2', models.IntegerField(blank=True, db_column='Goods2', null=True)),
                ('goods3', models.IntegerField(blank=True, db_column='Goods3', null=True)),
                ('goods4', models.IntegerField(blank=True, db_column='Goods4', null=True)),
                ('goods5', models.IntegerField(blank=True, db_column='Goods5', null=True)),
                ('description', models.IntegerField(blank=True, db_column='Description', null=True)),
                ('step1', models.CharField(blank=True, db_column='Step1', max_length=50, null=True)),
                ('step2', models.CharField(blank=True, db_column='Step2', max_length=50, null=True)),
                ('step3', models.CharField(blank=True, db_column='Step3', max_length=50, null=True)),
                ('step4', models.CharField(blank=True, db_column='Step4', max_length=50, null=True)),
                ('step5', models.CharField(blank=True, db_column='Step5', max_length=50, null=True)),
                ('step6', models.CharField(blank=True, db_column='Step6', max_length=50, null=True)),
                ('step7', models.CharField(blank=True, db_column='Step7', max_length=50, null=True)),
                ('step8', models.CharField(blank=True, db_column='Step8', max_length=50, null=True)),
                ('step9', models.CharField(blank=True, db_column='Step9', max_length=100, null=True)),
                ('color', models.IntegerField(blank=True, db_column='Color', null=True)),
                ('unit', models.IntegerField(blank=True, db_column='Unit', null=True)),
                ('unit_qty', models.DecimalField(blank=True, db_column='Unit_Qty', decimal_places=3, max_digits=18, null=True)),
                ('supplydemand', models.IntegerField(blank=True, db_column='SupplyDemand', null=True)),
                ('abolitiondate', models.DateTimeField(blank=True, db_column='AbolitionDate', null=True)),
                ('confirmdate', models.DateTimeField(blank=True, db_column='ConfirmDate', null=True)),
                ('confirmname', models.CharField(blank=True, db_column='ConfirmName', max_length=50, null=True)),
                ('standardtime', models.DecimalField(blank=True, db_column='StandardTime', decimal_places=0, max_digits=18, null=True)),
                ('standardinferior', models.DecimalField(blank=True, db_column='StandardInferior', decimal_places=0, max_digits=18, null=True)),
                ('special_flag', models.CharField(blank=True, max_length=10, null=True)),
                ('parity', models.IntegerField(blank=True, db_column='Parity', null=True)),
                ('locationposition', models.CharField(blank=True, db_column='LocationPosition', max_length=10, null=True)),
                ('markingno', models.CharField(blank=True, db_column='MarkingNo', max_length=50, null=True)),
                ('process', models.CharField(blank=True, db_column='Process', max_length=20, null=True)),
                ('codeno', models.CharField(db_column='CodeNo', max_length=20)),
                ('companyid', models.IntegerField(blank=True, db_column='CompanyId', null=True)),
                ('language1', models.CharField(blank=True, db_column='Language1', max_length=100, null=True)),
                ('language2', models.CharField(blank=True, db_column='Language2', max_length=100, null=True)),
                ('language3', models.CharField(blank=True, db_column='Language3', max_length=100, null=True)),
                ('language4', models.CharField(blank=True, db_column='Language4', max_length=100, null=True)),
                ('model', models.CharField(blank=True, db_column='Model', max_length=100, null=True)),
                ('box_qty', models.DecimalField(blank=True, db_column='Box_Qty', decimal_places=3, max_digits=18, null=True)),
                ('safe_qty', models.DecimalField(blank=True, db_column='Safe_Qty', decimal_places=3, max_digits=18, null=True)),
                ('safe_day', models.IntegerField(blank=True, db_column='Safe_Day', null=True)),
                ('remark', models.CharField(blank=True, db_column='Remark', max_length=100, null=True)),
                ('use_yn', models.CharField(blank=True, db_column='Use_Yn', max_length=1, null=True)),
                ('create_date', models.DateTimeField(blank=True, db_column='Create_Date', null=True)),
                ('create_user_id', models.CharField(blank=True, db_column='Create_User_Id', max_length=100, null=True)),
                ('last_user_id', models.CharField(blank=True, db_column='Last_User_Id', max_length=100, null=True)),
                ('modifieddate', models.DateTimeField(blank=True, db_column='ModifiedDate', null=True)),
                ('location', models.IntegerField(blank=True, db_column='Location', null=True)),
            ],
            options={
                'db_table': 'GOODSMASTER',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='Log',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
            ],
        ),
        migrations.CreateModel(
            name='ProductionActual',
            fields=[
                ('ppk', models.IntegerField(blank=True, db_column='Ppk', null=True)),
                ('productionactualno', models.CharField(db_column='ProductionActualNo', max_length=100, primary_key=True, serialize=False)),
                ('lotno', models.CharField(db_column='LotNo', max_length=100)),
                ('revision', models.CharField(db_column='Revision', max_length=10)),
                ('workdate', models.DateTimeField(db_column='WorkDate')),
                ('workfrom', models.DateTimeField(blank=True, db_column='Workfrom', null=True)),
                ('workto', models.DateTimeField(blank=True, null=True)),
                ('code', models.CharField(db_column='Code', max_length=100)),
                ('costcenter', models.CharField(db_column='CostCenter', max_length=10)),
                ('workcenter', models.CharField(db_column='WorkCenter', max_length=10)),
                ('machine', models.CharField(db_column='Machine', max_length=10)),
                ('groups', models.CharField(db_column='Groups', max_length=10)),
                ('facode', models.CharField(blank=True, db_column='FACode', max_length=10, null=True)),
                ('producingorderno', models.CharField(db_column='ProducingOrderNo', max_length=100)),
                ('mp', models.DecimalField(blank=True, decimal_places=4, max_digits=18, null=True)),
                ('ma', models.DecimalField(blank=True, decimal_places=4, max_digits=18, null=True)),
                ('producingorder', models.DecimalField(blank=True, db_column='ProducingOrder', decimal_places=4, max_digits=18, null=True)),
                ('ap', models.DecimalField(blank=True, decimal_places=4, max_digits=18, null=True)),
                ('aa', models.DecimalField(blank=True, decimal_places=4, max_digits=18, null=True)),
                ('produced', models.DecimalField(db_column='Produced', decimal_places=4, max_digits=18)),
                ('beginninging', models.DecimalField(blank=True, db_column='BeginningING', decimal_places=4, max_digits=18, null=True)),
                ('beginningstk', models.DecimalField(blank=True, db_column='BeginningSTK', decimal_places=4, max_digits=18, null=True)),
                ('outgoingno', models.CharField(blank=True, db_column='OutgoingNo', max_length=16, null=True)),
                ('outgoing', models.DecimalField(blank=True, db_column='Outgoing', decimal_places=4, max_digits=18, null=True)),
                ('spqty', models.DecimalField(blank=True, db_column='SPQty', decimal_places=4, max_digits=18, null=True)),
                ('daywork', models.DecimalField(db_column='Daywork', decimal_places=4, max_digits=18)),
                ('daynight', models.CharField(db_column='DayNight', max_length=1)),
                ('incominglocation', models.IntegerField(blank=True, db_column='IncomingLocation', null=True)),
                ('incomingqty', models.DecimalField(blank=True, db_column='IncomingQTY', decimal_places=4, max_digits=18, null=True)),
                ('goodness', models.DecimalField(db_column='Goodness', decimal_places=4, max_digits=18)),
                ('badness', models.DecimalField(blank=True, db_column='Badness', decimal_places=4, max_digits=18, null=True)),
                ('badnessid', models.CharField(blank=True, db_column='BadnessID', max_length=30, null=True)),
                ('badnesspro', models.DecimalField(blank=True, db_column='BadnessPro', decimal_places=4, max_digits=18, null=True)),
                ('saleslocal', models.DecimalField(blank=True, db_column='SalesLocal', decimal_places=4, max_digits=18, null=True)),
                ('salesexport', models.DecimalField(blank=True, db_column='SalesExport', decimal_places=4, max_digits=18, null=True)),
                ('outgoinglocation', models.IntegerField(blank=True, db_column='OutgoingLocation', null=True)),
                ('outgoingqty', models.DecimalField(blank=True, db_column='OutgoingQTY', decimal_places=4, max_digits=18, null=True)),
                ('outgoingsupplier', models.DecimalField(blank=True, db_column='OutgoingSupplier', decimal_places=0, max_digits=10, null=True)),
                ('rnd', models.DecimalField(blank=True, db_column='RnD', decimal_places=4, max_digits=18, null=True)),
                ('iqc', models.DecimalField(blank=True, db_column='IQC', decimal_places=4, max_digits=18, null=True)),
                ('afterservice', models.DecimalField(blank=True, db_column='AfterService', decimal_places=4, max_digits=18, null=True)),
                ('sample', models.DecimalField(blank=True, db_column='Sample', decimal_places=4, max_digits=18, null=True)),
                ('disuse', models.DecimalField(blank=True, db_column='Disuse', decimal_places=4, max_digits=18, null=True)),
                ('controlstock', models.DecimalField(blank=True, db_column='ControlStock', decimal_places=4, max_digits=18, null=True)),
                ('movelocation', models.IntegerField(blank=True, db_column='MoveLocation', null=True)),
                ('movelocationqty', models.DecimalField(blank=True, db_column='MoveLocationQty', decimal_places=4, max_digits=18, null=True)),
                ('finaling', models.DecimalField(blank=True, db_column='FinalING', decimal_places=4, max_digits=18, null=True)),
                ('finalstk', models.DecimalField(blank=True, db_column='FinalSTK', decimal_places=4, max_digits=18, null=True)),
                ('measuresqty', models.DecimalField(blank=True, db_column='MeasuresQty', decimal_places=4, max_digits=18, null=True)),
                ('s_date', models.CharField(max_length=10)),
                ('rateproduced', models.DecimalField(blank=True, db_column='RateProduced', decimal_places=4, max_digits=18, null=True)),
                ('analysiscode', models.IntegerField(blank=True, db_column='AnalysisCode', null=True)),
                ('worker', models.DecimalField(decimal_places=0, max_digits=18)),
                ('sdmcperunit', models.DecimalField(blank=True, db_column='SDMCPerUnit', decimal_places=4, max_digits=18, null=True)),
                ('admcperunit', models.DecimalField(blank=True, db_column='ADMCPerUnit', decimal_places=4, max_digits=18, null=True)),
                ('sdmc', models.DecimalField(blank=True, db_column='SDMC', decimal_places=4, max_digits=18, null=True)),
                ('admc', models.DecimalField(blank=True, db_column='ADMC', decimal_places=4, max_digits=18, null=True)),
                ('qcdate', models.DateTimeField(blank=True, db_column='QCDate', null=True)),
                ('firstmodified', models.DateTimeField(blank=True, db_column='FirstModified', null=True)),
                ('lastmodified', models.DateTimeField(blank=True, db_column='LastModified', null=True)),
                ('modified', models.IntegerField(blank=True, db_column='Modified', null=True)),
                ('location', models.IntegerField(blank=True, db_column='Location', null=True)),
                ('outsourcingrecoveryno', models.CharField(blank=True, db_column='OutsourcingRecoveryNo', max_length=100, null=True)),
                ('incomingwarehouse', models.CharField(blank=True, db_column='IncomingWarehouse', max_length=20, null=True)),
                ('outgoingwarehouse', models.CharField(blank=True, db_column='OutgoingWarehouse', max_length=20, null=True)),
                ('movingwarehouse', models.CharField(blank=True, db_column='MovingWarehouse', max_length=20, null=True)),
                ('movingqty', models.DecimalField(blank=True, db_column='MovingQty', decimal_places=4, max_digits=18, null=True)),
                ('requiredmeasured', models.DecimalField(blank=True, db_column='RequiredMeasured', decimal_places=4, max_digits=18, null=True)),
                ('suboutgoingno', models.DecimalField(blank=True, db_column='SubOutgoingNo', decimal_places=4, max_digits=18, null=True)),
                ('suboutgoing', models.DecimalField(blank=True, db_column='SubOutgoing', decimal_places=4, max_digits=18, null=True)),
                ('dischargeing', models.DecimalField(blank=True, db_column='DischargeIng', decimal_places=4, max_digits=18, null=True)),
                ('badnessweightsuming', models.DecimalField(blank=True, db_column='BadnessWeightSumIng', decimal_places=4, max_digits=18, null=True)),
                ('badnessqtying', models.DecimalField(blank=True, db_column='BadnessQtyIng', decimal_places=4, max_digits=18, null=True)),
                ('badnessweighting', models.DecimalField(blank=True, db_column='BadnessWeightIng', decimal_places=4, max_digits=18, null=True)),
                ('testqtying', models.DecimalField(blank=True, db_column='TestQtyIng', decimal_places=4, max_digits=18, null=True)),
                ('testweighting', models.DecimalField(blank=True, db_column='TestWeightIng', decimal_places=4, max_digits=18, null=True)),
                ('scrapweightuniting', models.DecimalField(blank=True, db_column='ScrapWeightUnitIng', decimal_places=4, max_digits=18, null=True)),
                ('scrapweightsuming', models.DecimalField(blank=True, db_column='ScrapWeightSumIng', decimal_places=4, max_digits=18, null=True)),
                ('requiredstandard', models.DecimalField(blank=True, db_column='RequiredStandard', decimal_places=4, max_digits=18, null=True)),
                ('requiredtolerance', models.DecimalField(blank=True, db_column='RequiredTolerance', decimal_places=4, max_digits=18, null=True)),
            ],
            options={
                'db_table': 'PRODUCTIONACTUAL',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='ProductionPerformance',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('code', models.CharField(max_length=100)),
                ('specification', models.CharField(max_length=1000)),
                ('d1', models.IntegerField(blank=True, default=0)),
                ('d2', models.IntegerField(blank=True, default=0)),
                ('d3', models.IntegerField(blank=True, default=0)),
                ('d4', models.IntegerField(blank=True, default=0)),
                ('d5', models.IntegerField(blank=True, default=0)),
                ('d6', models.IntegerField(blank=True, default=0)),
                ('d7', models.IntegerField(blank=True, default=0)),
                ('d8', models.IntegerField(blank=True, default=0)),
                ('d9', models.IntegerField(blank=True, default=0)),
                ('d10', models.IntegerField(blank=True, default=0)),
                ('d11', models.IntegerField(blank=True, default=0)),
                ('d12', models.IntegerField(blank=True, default=0)),
                ('d13', models.IntegerField(blank=True, default=0)),
                ('d14', models.IntegerField(blank=True, default=0)),
                ('d15', models.IntegerField(blank=True, default=0)),
                ('d16', models.IntegerField(blank=True, default=0)),
                ('d17', models.IntegerField(blank=True, default=0)),
                ('d18', models.IntegerField(blank=True, default=0)),
                ('d19', models.IntegerField(blank=True, default=0)),
                ('d20', models.IntegerField(blank=True, default=0)),
                ('d21', models.IntegerField(blank=True, default=0)),
                ('d22', models.IntegerField(blank=True, default=0)),
                ('d23', models.IntegerField(blank=True, default=0)),
                ('d24', models.IntegerField(blank=True, default=0)),
                ('d25', models.IntegerField(blank=True, default=0)),
                ('d26', models.IntegerField(blank=True, default=0)),
                ('d27', models.IntegerField(blank=True, default=0)),
                ('d28', models.IntegerField(blank=True, default=0)),
                ('d29', models.IntegerField(blank=True, default=0)),
                ('d30', models.IntegerField(blank=True, default=0)),
                ('d31', models.IntegerField(blank=True, default=0)),
            ],
        ),
        migrations.CreateModel(
            name='Subject',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=50)),
                ('number_credits', models.IntegerField()),
            ],
        ),
        migrations.CreateModel(
            name='Tag',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Student',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=50)),
                ('last_name', models.CharField(max_length=50)),
                ('subject_student', models.ManyToManyField(to='ppp.Subject')),
            ],
        ),
        migrations.CreateModel(
            name='Product',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=100)),
                ('price', models.FloatField(null=True)),
                ('category', models.CharField(choices=[('Indoor', 'Indoor'), ('Out Door', 'Out Door')], max_length=200, null=True)),
                ('description', models.CharField(blank=True, max_length=200, null=True)),
                ('date_created', models.DateTimeField(auto_now_add=True, null=True)),
                ('tags', models.ManyToManyField(to='ppp.Tag')),
            ],
        ),
        migrations.CreateModel(
            name='Process',
            fields=[
                ('code', models.CharField(db_column='Code', max_length=20, primary_key=True, serialize=False)),
                ('language1', models.CharField(blank=True, db_column='Language1', max_length=100, null=True)),
                ('language2', models.CharField(blank=True, db_column='Language2', max_length=100, null=True)),
                ('language3', models.CharField(blank=True, db_column='Language3', max_length=100, null=True)),
                ('language4', models.CharField(blank=True, db_column='Language4', max_length=100, null=True)),
                ('appliedstandard', models.CharField(blank=True, db_column='AppliedStandard', max_length=1, null=True)),
                ('nextprocessst', models.CharField(blank=True, db_column='NextProcessSt', max_length=1, null=True)),
                ('skipvalue', models.CharField(blank=True, db_column='SkipValue', max_length=1, null=True)),
                ('lotnobase', models.CharField(blank=True, db_column='LotNoBase', max_length=1, null=True)),
                ('registrationdate', models.DateTimeField(db_column='RegistrationDate')),
                ('registrationusercode', models.CharField(db_column='RegistrationUserCode', max_length=20)),
                ('obsoletecode', models.CharField(blank=True, db_column='ObsoleteCode', max_length=20, null=True)),
                ('previousprocess', models.CharField(blank=True, db_column='PreviousProcess', max_length=10, null=True)),
                ('nextprocess', models.CharField(blank=True, db_column='NextProcess', max_length=10, null=True)),
                ('processsuperior', models.CharField(db_column='ProcessSuperior', max_length=10)),
                ('followupprocess', models.CharField(blank=True, db_column='FollowUpProcess', max_length=10, null=True)),
                ('leadtime', models.DecimalField(blank=True, db_column='LeadTime', decimal_places=0, max_digits=10, null=True)),
                ('workingorderkey', models.CharField(db_column='WorkingOrderKey', max_length=1)),
                ('dayworklimitst', models.CharField(db_column='DayworkLimitSt', max_length=1)),
                ('beinuse', models.IntegerField(db_column='BeInUse')),
                ('warehousest', models.CharField(db_column='WarehouseSt', max_length=20)),
                ('colorst', models.CharField(blank=True, db_column='ColorSt', max_length=100, null=True)),
            ],
            options={
                'db_table': 'PROCESS',
                'managed': True,
                'unique_together': {('code', 'processsuperior')},
            },
        ),
        migrations.CreateModel(
            name='Order',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date_created', models.DateTimeField(auto_now_add=True, null=True)),
                ('status', models.CharField(choices=[('Pending', 'Pending'), ('Out for delivery', 'Out for delivery'), ('Delivery', 'Delivery')], max_length=200, null=True)),
                ('customer', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='ppp.customer')),
                ('product', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='ppp.product')),
            ],
        ),
    ]
