| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906 |
- # Generated by Django 5.0 on 2024-12-25 08:57
- from django.db import migrations, models
- class Migration(migrations.Migration):
- initial = True
- dependencies = [
- ]
- operations = [
- migrations.CreateModel(
- name='Agreements',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('title', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
- ('file', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
- ('description', models.TextField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', null=True)),
- ('created_at', models.DateTimeField(blank=True, null=True)),
- ('updated_at', models.DateTimeField(blank=True, null=True)),
- ],
- options={
- 'db_table': 'agreements',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='DailyChecks',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('p1', models.FloatField(blank=True, null=True)),
- ('p2', models.FloatField(blank=True, null=True)),
- ('p3', models.FloatField(blank=True, null=True)),
- ('avg', models.FloatField(blank=True, null=True)),
- ('machine_id', models.IntegerField(blank=True, null=True)),
- ('created_at', models.DateTimeField(blank=True, null=True)),
- ('updated_at', models.DateTimeField(blank=True, null=True)),
- ('header', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
- ('user_id', models.IntegerField(blank=True, null=True)),
- ('empid', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
- ('shift', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
- ('result', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
- ],
- options={
- 'db_table': 'daily_checks',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='DailyChecksWb',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('result', models.FloatField(blank=True, null=True)),
- ('weight', models.FloatField(blank=True, null=True)),
- ('judgement', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
- ('machine_id', models.IntegerField(blank=True, null=True)),
- ('created_at', models.DateTimeField(blank=True, null=True)),
- ('updated_at', models.DateTimeField(blank=True, null=True)),
- ('user_id', models.IntegerField(blank=True, null=True)),
- ('empid', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
- ('shift', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
- ],
- options={
- 'db_table': 'daily_checks_wb',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='Data',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('row_no', models.IntegerField(blank=True, null=True)),
- ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('code', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('header', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
- ('p1', models.FloatField(blank=True, null=True)),
- ('p2', models.FloatField(blank=True, null=True)),
- ('p3', models.FloatField(blank=True, null=True)),
- ('p4', models.FloatField(blank=True, null=True)),
- ('p5', models.FloatField(blank=True, null=True)),
- ('p6', models.FloatField(blank=True, null=True)),
- ('p7', models.FloatField(blank=True, null=True)),
- ('p8', models.FloatField(blank=True, null=True)),
- ('p9', models.FloatField(blank=True, null=True)),
- ('p10', models.FloatField(blank=True, null=True)),
- ('avg', models.FloatField(blank=True, null=True)),
- ('grade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('rgrade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('r_type', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('created_at', models.DateTimeField(blank=True, null=True)),
- ('updated_at', models.DateTimeField(blank=True, null=True)),
- ('ndata', models.IntegerField(blank=True, null=True)),
- ('sub_order', models.IntegerField(blank=True, null=True)),
- ('machine_id', models.IntegerField(blank=True, null=True)),
- ],
- options={
- 'db_table': 'data',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='Data13178079',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('row_no', models.IntegerField(blank=True, null=True)),
- ('avg', models.FloatField(blank=True, null=True)),
- ('grade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('rgrade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('r_type', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('p1', models.FloatField(blank=True, null=True)),
- ('p2', models.FloatField(blank=True, null=True)),
- ('p3', models.FloatField(blank=True, null=True)),
- ('p4', models.FloatField(blank=True, null=True)),
- ('p5', models.FloatField(blank=True, null=True)),
- ('p6', models.FloatField(blank=True, null=True)),
- ('p7', models.FloatField(blank=True, null=True)),
- ('p8', models.FloatField(blank=True, null=True)),
- ('p9', models.FloatField(blank=True, null=True)),
- ('p10', models.FloatField(blank=True, null=True)),
- ('created_at', models.DateTimeField(blank=True, null=True)),
- ('updated_at', models.DateTimeField(blank=True, null=True)),
- ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('ndata', models.IntegerField(blank=True, null=True)),
- ('sub_order', models.IntegerField(blank=True, null=True)),
- ('machine_id', models.IntegerField(blank=True, null=True)),
- ('code', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('header', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
- ],
- options={
- 'db_table': 'Data_131_78079',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='Data20082018',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('row_no', models.IntegerField(blank=True, null=True)),
- ('avg', models.FloatField(blank=True, null=True)),
- ('grade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('rgrade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('r_type', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('p1', models.FloatField(blank=True, null=True)),
- ('p2', models.FloatField(blank=True, null=True)),
- ('p3', models.FloatField(blank=True, null=True)),
- ('p4', models.FloatField(blank=True, null=True)),
- ('p5', models.FloatField(blank=True, null=True)),
- ('p6', models.FloatField(blank=True, null=True)),
- ('p7', models.FloatField(blank=True, null=True)),
- ('p8', models.FloatField(blank=True, null=True)),
- ('p9', models.FloatField(blank=True, null=True)),
- ('p10', models.FloatField(blank=True, null=True)),
- ('created_at', models.DateTimeField(blank=True, null=True)),
- ('updated_at', models.DateTimeField(blank=True, null=True)),
- ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('ndata', models.IntegerField(blank=True, null=True)),
- ('sub_order', models.IntegerField(blank=True, null=True)),
- ('machine_id', models.IntegerField(blank=True, null=True)),
- ('code', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('header', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
- ],
- options={
- 'db_table': 'data (2008-2018)',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='Data25113027G',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('row_no', models.IntegerField(blank=True, null=True)),
- ('avg', models.FloatField(blank=True, null=True)),
- ('grade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('rgrade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('r_type', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('p1', models.FloatField(blank=True, null=True)),
- ('p2', models.FloatField(blank=True, null=True)),
- ('p3', models.FloatField(blank=True, null=True)),
- ('p4', models.FloatField(blank=True, null=True)),
- ('p5', models.FloatField(blank=True, null=True)),
- ('p6', models.FloatField(blank=True, null=True)),
- ('p7', models.FloatField(blank=True, null=True)),
- ('p8', models.FloatField(blank=True, null=True)),
- ('p9', models.FloatField(blank=True, null=True)),
- ('p10', models.FloatField(blank=True, null=True)),
- ('created_at', models.DateTimeField(blank=True, null=True)),
- ('updated_at', models.DateTimeField(blank=True, null=True)),
- ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('ndata', models.IntegerField(blank=True, null=True)),
- ('sub_order', models.IntegerField(blank=True, null=True)),
- ('machine_id', models.IntegerField(blank=True, null=True)),
- ('code', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('header', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
- ],
- options={
- 'db_table': 'data_251-13027G',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='DataMs',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('row_no', models.IntegerField()),
- ('dsize', models.FloatField(blank=True, null=True)),
- ('tsize', models.FloatField(blank=True, null=True)),
- ('hsize', models.FloatField(blank=True, null=True)),
- ('csize', models.FloatField(blank=True, null=True)),
- ('esize', models.FloatField(blank=True, null=True)),
- ('fsize', models.FloatField(blank=True, null=True)),
- ('gsize', models.FloatField(blank=True, null=True)),
- ('psize', models.FloatField(blank=True, null=True)),
- ('wsize', models.FloatField(blank=True, null=True)),
- ('jksize', models.FloatField(blank=True, null=True)),
- ('usize', models.FloatField(blank=True, null=True)),
- ('msize', models.FloatField(blank=True, null=True)),
- ('asize', models.FloatField(blank=True, null=True)),
- ('nsize', models.FloatField(blank=True, null=True)),
- ('jsize', models.FloatField(blank=True, null=True)),
- ('xsize', models.FloatField(blank=True, null=True)),
- ('flatnesssize', models.FloatField(blank=True, null=True)),
- ('ksize', models.FloatField(blank=True, null=True)),
- ('thicknesssize', models.FloatField(blank=True, null=True)),
- ('qsize', models.FloatField(blank=True, null=True)),
- ('ssize', models.FloatField(blank=True, null=True)),
- ('dsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='dsizeOk', max_length=4, null=True)),
- ('tsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='tsizeOk', max_length=4, null=True)),
- ('hsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='hsizeOk', max_length=4, null=True)),
- ('csizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='csizeOk', max_length=4, null=True)),
- ('esizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='esizeOk', max_length=4, null=True)),
- ('fsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='fsizeOk', max_length=4, null=True)),
- ('gsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='gsizeOk', max_length=4, null=True)),
- ('psizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='psizeOk', max_length=4, null=True)),
- ('wsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='wsizeOk', max_length=4, null=True)),
- ('jksizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='jksizeOk', max_length=4, null=True)),
- ('usizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='usizeOk', max_length=4, null=True)),
- ('msizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='msizeOk', max_length=4, null=True)),
- ('asizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='asizeOk', max_length=4, null=True)),
- ('nsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='nsizeOk', max_length=4, null=True)),
- ('jsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='jsizeOk', max_length=4, null=True)),
- ('xsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='xsizeOk', max_length=4, null=True)),
- ('flatnesssizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='flatnesssizeOk', max_length=4, null=True)),
- ('ksizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='ksizeOk', max_length=4, null=True)),
- ('thicknesssizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='thicknesssizeOk', max_length=4, null=True)),
- ('qsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='qsizeOk', max_length=4, null=True)),
- ('ssizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='ssizeOk', max_length=4, null=True)),
- ('created_at', models.DateTimeField(blank=True, null=True)),
- ('updated_at', models.DateTimeField(blank=True, null=True)),
- ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('machine_id', models.IntegerField()),
- ('code', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('emp_id', models.IntegerField()),
- ('weight', models.FloatField(blank=True, null=True)),
- ('devid', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=40, null=True)),
- ('tpoint1', models.FloatField(blank=True, null=True)),
- ('tpoint2', models.FloatField(blank=True, null=True)),
- ('tpoint3', models.FloatField(blank=True, null=True)),
- ('tpoint4', models.FloatField(blank=True, null=True)),
- ('tpoint1ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=4, null=True)),
- ('tpoint2ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=4, null=True)),
- ('tpoint3ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=4, null=True)),
- ('tpoint4ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=4, null=True)),
- ('tdiff', models.FloatField(blank=True, null=True)),
- ('tmin', models.FloatField(blank=True, null=True)),
- ('tmax', models.FloatField(blank=True, null=True)),
- ('hdev', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=20, null=True)),
- ('hsizeproxy', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=20, null=True)),
- ('restricts', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=40, null=True)),
- ('shift', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
- ('mode', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
- ('cal_mode', models.IntegerField(blank=True, null=True)),
- ('diasize', models.FloatField(blank=True, null=True)),
- ('diasizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='diasizeOk', max_length=4, null=True)),
- ('censize', models.FloatField(blank=True, null=True)),
- ('censizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='censizeOk', max_length=4, null=True)),
- ('osize', models.FloatField(blank=True, null=True)),
- ('osizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='osizeOk', max_length=4, null=True)),
- ('size1', models.FloatField(blank=True, null=True)),
- ('size2', models.FloatField(blank=True, null=True)),
- ('size1ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='size1Ok', max_length=50, null=True)),
- ('size2ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='size2Ok', max_length=50, null=True)),
- ('size1name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='size1Name', max_length=50, null=True)),
- ('size2name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='size2Name', max_length=50, null=True)),
- ('bsize', models.FloatField(blank=True, null=True)),
- ('bsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='bsizeOk', max_length=50, null=True)),
- ('lsize', models.FloatField(blank=True, null=True)),
- ('lsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='lsizeOk', max_length=50, null=True)),
- ('zsize', models.FloatField(blank=True, null=True)),
- ('zsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='zsizeOk', max_length=50, null=True)),
- ('x1size', models.FloatField(blank=True, null=True)),
- ('x1sizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='x1sizeOk', max_length=50, null=True)),
- ('x2size', models.FloatField(blank=True, null=True)),
- ('x2sizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='x2sizeOk', max_length=50, null=True)),
- ('tpresssize', models.FloatField(blank=True, null=True)),
- ('tpresssizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='tpresssizeOk', max_length=50, null=True)),
- ('t1', models.FloatField()),
- ('t2', models.FloatField()),
- ('t3', models.FloatField()),
- ('t4', models.FloatField()),
- ('t1ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='t1Ok', max_length=50, null=True)),
- ('t2ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='t2Ok', max_length=50, null=True)),
- ('t3ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='t3Ok', max_length=50, null=True)),
- ('t4ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='t4Ok', max_length=50, null=True)),
- ('t4avg', models.FloatField()),
- ('tpok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='tpOk', max_length=50, null=True)),
- ('t4min', models.FloatField(blank=True, null=True)),
- ('t4max', models.FloatField(blank=True, null=True)),
- ('t4diff', models.FloatField(blank=True, null=True)),
- ],
- options={
- 'db_table': 'data_ms',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='DataMsLot2210062522',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('row_no', models.IntegerField()),
- ('dsize', models.FloatField(blank=True, null=True)),
- ('tsize', models.FloatField(blank=True, null=True)),
- ('hsize', models.FloatField(blank=True, null=True)),
- ('csize', models.FloatField(blank=True, null=True)),
- ('esize', models.FloatField(blank=True, null=True)),
- ('fsize', models.FloatField(blank=True, null=True)),
- ('gsize', models.FloatField(blank=True, null=True)),
- ('psize', models.FloatField(blank=True, null=True)),
- ('wsize', models.FloatField(blank=True, null=True)),
- ('jksize', models.FloatField(blank=True, null=True)),
- ('usize', models.FloatField(blank=True, null=True)),
- ('msize', models.FloatField(blank=True, null=True)),
- ('asize', models.FloatField(blank=True, null=True)),
- ('nsize', models.FloatField(blank=True, null=True)),
- ('jsize', models.FloatField(blank=True, null=True)),
- ('xsize', models.FloatField(blank=True, null=True)),
- ('flatnesssize', models.FloatField(blank=True, null=True)),
- ('ksize', models.FloatField(blank=True, null=True)),
- ('thicknesssize', models.FloatField(blank=True, null=True)),
- ('qsize', models.FloatField(blank=True, null=True)),
- ('ssize', models.FloatField(blank=True, null=True)),
- ('dsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='dsizeOk', max_length=4, null=True)),
- ('tsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='tsizeOk', max_length=4, null=True)),
- ('hsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='hsizeOk', max_length=4, null=True)),
- ('csizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='csizeOk', max_length=4, null=True)),
- ('esizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='esizeOk', max_length=4, null=True)),
- ('fsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='fsizeOk', max_length=4, null=True)),
- ('gsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='gsizeOk', max_length=4, null=True)),
- ('psizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='psizeOk', max_length=4, null=True)),
- ('wsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='wsizeOk', max_length=4, null=True)),
- ('jksizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='jksizeOk', max_length=4, null=True)),
- ('usizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='usizeOk', max_length=4, null=True)),
- ('msizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='msizeOk', max_length=4, null=True)),
- ('asizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='asizeOk', max_length=4, null=True)),
- ('nsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='nsizeOk', max_length=4, null=True)),
- ('jsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='jsizeOk', max_length=4, null=True)),
- ('xsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='xsizeOk', max_length=4, null=True)),
- ('flatnesssizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='flatnesssizeOk', max_length=4, null=True)),
- ('ksizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='ksizeOk', max_length=4, null=True)),
- ('thicknesssizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='thicknesssizeOk', max_length=4, null=True)),
- ('qsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='qsizeOk', max_length=4, null=True)),
- ('ssizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='ssizeOk', max_length=4, null=True)),
- ('created_at', models.DateTimeField(blank=True, null=True)),
- ('updated_at', models.DateTimeField(blank=True, null=True)),
- ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('machine_id', models.IntegerField()),
- ('code', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('emp_id', models.IntegerField()),
- ('weight', models.FloatField(blank=True, null=True)),
- ('devid', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=40, null=True)),
- ('tpoint1', models.FloatField(blank=True, null=True)),
- ('tpoint2', models.FloatField(blank=True, null=True)),
- ('tpoint3', models.FloatField(blank=True, null=True)),
- ('tpoint4', models.FloatField(blank=True, null=True)),
- ('tpoint1ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=4, null=True)),
- ('tpoint2ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=4, null=True)),
- ('tpoint3ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=4, null=True)),
- ('tpoint4ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=4, null=True)),
- ('tdiff', models.FloatField(blank=True, null=True)),
- ('tmin', models.FloatField(blank=True, null=True)),
- ('tmax', models.FloatField(blank=True, null=True)),
- ('hdev', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=20, null=True)),
- ('hsizeproxy', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=20, null=True)),
- ('restricts', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=40, null=True)),
- ('shift', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
- ('mode', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
- ('cal_mode', models.IntegerField(blank=True, null=True)),
- ('diasize', models.FloatField(blank=True, null=True)),
- ('diasizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='diasizeOk', max_length=4, null=True)),
- ('censize', models.FloatField(blank=True, null=True)),
- ('censizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='censizeOk', max_length=4, null=True)),
- ('osize', models.FloatField(blank=True, null=True)),
- ('osizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='osizeOk', max_length=4, null=True)),
- ('size1', models.FloatField(blank=True, null=True)),
- ('size2', models.FloatField(blank=True, null=True)),
- ('size1ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='size1Ok', max_length=50, null=True)),
- ('size2ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='size2Ok', max_length=50, null=True)),
- ('size1name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='size1Name', max_length=50, null=True)),
- ('size2name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='size2Name', max_length=50, null=True)),
- ('bsize', models.FloatField(blank=True, null=True)),
- ('bsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='bsizeOk', max_length=50, null=True)),
- ('lsize', models.FloatField(blank=True, null=True)),
- ('lsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='lsizeOk', max_length=50, null=True)),
- ('zsize', models.FloatField(blank=True, null=True)),
- ('zsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='zsizeOk', max_length=50, null=True)),
- ('x1size', models.FloatField(blank=True, null=True)),
- ('x1sizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='x1sizeOk', max_length=50, null=True)),
- ('x2size', models.FloatField(blank=True, null=True)),
- ('x2sizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='x2sizeOk', max_length=50, null=True)),
- ('tpresssize', models.FloatField(blank=True, null=True)),
- ('tpresssizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='tpresssizeOk', max_length=50, null=True)),
- ('t1', models.FloatField()),
- ('t2', models.FloatField()),
- ('t3', models.FloatField()),
- ('t4', models.FloatField()),
- ('t1ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='t1Ok', max_length=50, null=True)),
- ('t2ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='t2Ok', max_length=50, null=True)),
- ('t3ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='t3Ok', max_length=50, null=True)),
- ('t4ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='t4Ok', max_length=50, null=True)),
- ('t4avg', models.FloatField()),
- ('tpok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='tpOk', max_length=50, null=True)),
- ('t4min', models.FloatField(blank=True, null=True)),
- ('t4max', models.FloatField(blank=True, null=True)),
- ('t4diff', models.FloatField(blank=True, null=True)),
- ],
- options={
- 'db_table': 'data_ms_LOT2210062522',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='DataRl',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('row_no', models.IntegerField(blank=True, null=True)),
- ('avg', models.FloatField(blank=True, null=True)),
- ('grade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('rgrade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('r_type', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('p1', models.FloatField(blank=True, null=True)),
- ('p2', models.FloatField(blank=True, null=True)),
- ('p3', models.FloatField(blank=True, null=True)),
- ('p4', models.FloatField(blank=True, null=True)),
- ('p5', models.FloatField(blank=True, null=True)),
- ('p6', models.FloatField(blank=True, null=True)),
- ('p7', models.FloatField(blank=True, null=True)),
- ('p8', models.FloatField(blank=True, null=True)),
- ('p9', models.FloatField(blank=True, null=True)),
- ('p10', models.FloatField(blank=True, null=True)),
- ('created_at', models.DateTimeField(blank=True, null=True)),
- ('updated_at', models.DateTimeField(blank=True, null=True)),
- ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('ndata', models.IntegerField(blank=True, null=True)),
- ('sub_order', models.IntegerField(blank=True, null=True)),
- ('machine_id', models.IntegerField(blank=True, null=True)),
- ('code', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('header', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
- ],
- options={
- 'db_table': 'data_rl',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='DataWb',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('row_no', models.IntegerField(blank=True, null=True)),
- ('result', models.FloatField(blank=True, null=True)),
- ('weight', models.FloatField(blank=True, null=True)),
- ('judgement', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
- ('created_at', models.DateTimeField(blank=True, null=True)),
- ('updated_at', models.DateTimeField(blank=True, null=True)),
- ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('machine_id', models.IntegerField(blank=True, null=True)),
- ('code', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('emp_id', models.IntegerField(blank=True, null=True)),
- ('repair_by', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=30, null=True)),
- ],
- options={
- 'db_table': 'data_wb',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='DataWbTest',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('row_no', models.IntegerField(blank=True, null=True)),
- ('result', models.FloatField(blank=True, null=True)),
- ('weight', models.FloatField(blank=True, null=True)),
- ('judgement', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
- ('created_at', models.DateTimeField(blank=True, null=True)),
- ('updated_at', models.DateTimeField(blank=True, null=True)),
- ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('machine_id', models.IntegerField(blank=True, null=True)),
- ('code', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('emp_id', models.IntegerField(blank=True, null=True)),
- ('repair_by', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=30, null=True)),
- ],
- options={
- 'db_table': 'data_wb_test',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='LegacyUsers',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('email', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
- ('password_digest', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
- ('created_at', models.DateTimeField(blank=True, null=True)),
- ('updated_at', models.DateTimeField(blank=True, null=True)),
- ('roles_mask', models.IntegerField(blank=True, null=True)),
- ('empid', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
- ('fname', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
- ('lname', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
- ],
- options={
- 'db_table': 'users',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='LoginTemps',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('empid', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
- ('password', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
- ('created_at', models.DateTimeField(blank=True, null=True)),
- ('updated_at', models.DateTimeField(blank=True, null=True)),
- ],
- options={
- 'db_table': 'login_temps',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='Lot',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ],
- options={
- 'db_table': 'lot',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='LotRl',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ],
- options={
- 'db_table': 'lot_rl',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='Lotsizeorder',
- fields=[
- ('oid', models.AutoField(primary_key=True, serialize=False)),
- ('lotno', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=100, null=True)),
- ('sizes', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=400, null=True)),
- ],
- options={
- 'db_table': 'LotSizeOrder',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='LotSummary',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('lot_no', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50)),
- ('created_at', models.DateTimeField()),
- ('avg', models.FloatField()),
- ('code', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50)),
- ('start_time', models.DateTimeField(blank=True, null=True)),
- ('end_time', models.DateTimeField(blank=True, null=True)),
- ('grade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('machine_id', models.IntegerField(blank=True, null=True)),
- ('avg0', models.FloatField(blank=True, null=True)),
- ('avg1', models.FloatField(blank=True, null=True)),
- ('avg2', models.FloatField(blank=True, null=True)),
- ('avg3', models.FloatField(blank=True, null=True)),
- ('avg0_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('avg1_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('avg2_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('avg3_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ],
- options={
- 'db_table': 'lot_summary',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='LotSummary20082018',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('lot_no', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50)),
- ('created_at', models.DateTimeField()),
- ('avg', models.FloatField()),
- ('code', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50)),
- ('start_time', models.DateTimeField(blank=True, null=True)),
- ('end_time', models.DateTimeField(blank=True, null=True)),
- ('grade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('machine_id', models.IntegerField(blank=True, null=True)),
- ('avg0', models.FloatField(blank=True, null=True)),
- ('avg1', models.FloatField(blank=True, null=True)),
- ('avg2', models.FloatField(blank=True, null=True)),
- ('avg3', models.FloatField(blank=True, null=True)),
- ('avg0_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('avg1_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('avg2_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('avg3_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ],
- options={
- 'db_table': 'lot_summary (2008-2018)',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='LotSummaryRl',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('lot_no', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50)),
- ('created_at', models.DateTimeField()),
- ('avg', models.FloatField()),
- ('code', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50)),
- ('start_time', models.DateTimeField(blank=True, null=True)),
- ('end_time', models.DateTimeField(blank=True, null=True)),
- ('grade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('machine_id', models.IntegerField(blank=True, null=True)),
- ('avg0', models.FloatField(blank=True, null=True)),
- ('avg1', models.FloatField(blank=True, null=True)),
- ('avg2', models.FloatField(blank=True, null=True)),
- ('avg3', models.FloatField(blank=True, null=True)),
- ('avg0_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('avg1_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('avg2_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('avg3_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ],
- options={
- 'db_table': 'lot_summary_rl',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='LotSummaryWb',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('lot_no', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50)),
- ('created_at', models.DateTimeField()),
- ('w_avg', models.FloatField()),
- ('wb_avg', models.FloatField()),
- ('cp', models.FloatField()),
- ('code', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50)),
- ('start_time', models.DateTimeField(blank=True, null=True)),
- ('end_time', models.DateTimeField(blank=True, null=True)),
- ('machine_id', models.IntegerField(blank=True, null=True)),
- ],
- options={
- 'db_table': 'lot_summary_wb',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='Lottracking',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('lotno', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
- ('machinegroup', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='machineGroup', max_length=255, null=True)),
- ('datams_id', models.IntegerField(blank=True, null=True)),
- ('created_at', models.DateTimeField(blank=True, null=True)),
- ('updated_at', models.DateTimeField(blank=True, null=True)),
- ],
- options={
- 'db_table': 'LotTracking',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='Machinegroup',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('groupname', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='groupName', max_length=255, null=True)),
- ],
- options={
- 'db_table': 'machineGroup',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='Machines',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
- ('description', models.TextField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', null=True)),
- ('created_at', models.DateTimeField(blank=True, null=True)),
- ('updated_at', models.DateTimeField(blank=True, null=True)),
- ('tag_name', models.TextField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', null=True)),
- ],
- options={
- 'db_table': 'machines',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='MachinesWb',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('name', models.TextField(db_collation='SQL_Latin1_General_CP1_CI_AS')),
- ('description', models.TextField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', null=True)),
- ('created_at', models.DateTimeField()),
- ('updated_at', models.DateTimeField(blank=True, null=True)),
- ('tag_name', models.TextField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', null=True)),
- ('ip', models.TextField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', null=True)),
- ('isactive', models.BooleanField(db_column='isActive')),
- ('machinestd', models.FloatField(blank=True, db_column='machineStd', null=True)),
- ],
- options={
- 'db_table': 'machines_wb',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='Manualsize',
- fields=[
- ('lotno', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='lotNo', max_length=20, primary_key=True, serialize=False)),
- ('size_name', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='Size_Name', max_length=50)),
- ('std', models.FloatField(blank=True, db_column='Std', null=True)),
- ('tolun', models.FloatField(blank=True, db_column='TolUn', null=True)),
- ('tolup', models.FloatField(blank=True, db_column='TolUp', null=True)),
- ('created_at', models.DateTimeField()),
- ('productcode', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='ProductCode', max_length=30, null=True)),
- ],
- options={
- 'db_table': 'manualSize',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='PressCal',
- fields=[
- ('v0', models.FloatField(blank=True, null=True)),
- ('lot_no', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, primary_key=True, serialize=False)),
- ('v1', models.FloatField(blank=True, null=True)),
- ('v2', models.FloatField(blank=True, null=True)),
- ('v3', models.FloatField(blank=True, null=True)),
- ('v4', models.FloatField(blank=True, null=True)),
- ('v5', models.FloatField(blank=True, null=True)),
- ('v6', models.FloatField(blank=True, null=True)),
- ('y0', models.FloatField(blank=True, null=True)),
- ('y1', models.FloatField(blank=True, null=True)),
- ('y2', models.FloatField(blank=True, null=True)),
- ('ac1', models.FloatField(blank=True, null=True)),
- ('ac2', models.FloatField(blank=True, null=True)),
- ('ac3', models.FloatField(blank=True, null=True)),
- ('ac4', models.FloatField(blank=True, null=True)),
- ('ac5', models.FloatField(blank=True, null=True)),
- ('ac6', models.FloatField(blank=True, null=True)),
- ('ac7', models.FloatField(blank=True, null=True)),
- ('r_result', models.FloatField(blank=True, null=True)),
- ('created_at', models.DateTimeField(blank=True, null=True)),
- ('updated_at', models.DateTimeField(blank=True, null=True)),
- ('c0', models.FloatField()),
- ],
- options={
- 'db_table': 'press_cal',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='RotateData',
- 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, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='speedOk', 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, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('machine_id', models.IntegerField(blank=True, null=True)),
- ('code', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('emp_id', models.IntegerField()),
- ('devid', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=40, null=True)),
- ('mode', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
- ('cal_mode', models.IntegerField(blank=True, null=True)),
- ],
- options={
- 'db_table': 'rotate_data',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='SchemaMigrations',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('version', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255)),
- ],
- options={
- 'db_table': 'schema_migrations',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='SplitData',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('v1', models.FloatField(blank=True, null=True)),
- ('v2', models.FloatField(blank=True, null=True)),
- ('v3', models.FloatField(blank=True, null=True)),
- ('v4', models.FloatField(blank=True, null=True)),
- ('v5', models.FloatField(blank=True, null=True)),
- ('unit', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('vr', models.FloatField(blank=True, null=True)),
- ('vname', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
- ('no', models.IntegerField()),
- ('v1ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=20, null=True)),
- ('v2ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=20, null=True)),
- ('v3ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=20, null=True)),
- ('v4ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=20, null=True)),
- ('v5ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=20, null=True)),
- ('vmax', models.FloatField(blank=True, null=True)),
- ('vmin', models.FloatField(blank=True, null=True)),
- ('vdiff', models.FloatField(blank=True, null=True)),
- ('row_no', models.IntegerField(blank=True, null=True)),
- ],
- options={
- 'db_table': 'split_data',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='SysConfigs',
- fields=[
- ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('title', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
- ('value', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
- ('created_at', models.DateTimeField(blank=True, null=True)),
- ('updated_at', models.DateTimeField(blank=True, null=True)),
- ],
- options={
- 'db_table': 'sys_configs',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='TbFgPressinfoLotlist',
- fields=[
- ('product_year', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='Product_Year', max_length=10, primary_key=True, serialize=False)),
- ('productcode', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='ProductCode', max_length=20)),
- ('lotno', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='LotNo', max_length=20)),
- ('lot_qty', models.FloatField(blank=True, db_column='Lot_Qty', null=True)),
- ('def_qty', models.FloatField(blank=True, db_column='Def_Qty', null=True)),
- ('fg_qty', models.FloatField(blank=True, db_column='FG_Qty', null=True)),
- ('insp_date', models.DateTimeField(blank=True, db_column='Insp_Date', null=True)),
- ('current_prono', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='Current_ProNo', max_length=5, null=True)),
- ('press_mcname', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='Press_McName', max_length=50, null=True)),
- ('press_username', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='Press_UserName', max_length=50, null=True)),
- ],
- options={
- 'db_table': 'tb_fg_pressinfo_lotlist',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='TbWbStdCode12',
- fields=[
- ('id', models.IntegerField(db_column='ID', primary_key=True, serialize=False)),
- ('u_weight', models.FloatField(blank=True, db_column='U_Weight', null=True)),
- ('speed_from', models.FloatField(blank=True, db_column='Speed_From', null=True)),
- ('speed_to', models.FloatField(blank=True, db_column='Speed_To', null=True)),
- ('diameter_from', models.FloatField(blank=True, db_column='Diameter_From', null=True)),
- ('diameter_to', models.FloatField(blank=True, db_column='Diameter_To', null=True)),
- ('std_balance', models.FloatField(blank=True, db_column='STD_Balance', null=True)),
- ],
- options={
- 'db_table': 'tb_wb_std_code_1-2',
- 'managed': False,
- },
- ),
- migrations.CreateModel(
- name='TbWbStdCode345',
- fields=[
- ('id', models.IntegerField(db_column='ID', primary_key=True, serialize=False)),
- ('u_weight', models.FloatField(blank=True, db_column='U_Weight', null=True)),
- ('speed_from', models.FloatField(blank=True, db_column='Speed_From', null=True)),
- ('speed_to', models.FloatField(blank=True, db_column='Speed_To', null=True)),
- ('diameter_from', models.FloatField(blank=True, db_column='Diameter_From', null=True)),
- ('diameter_to', models.FloatField(blank=True, db_column='Diameter_To', null=True)),
- ('std_balance', models.FloatField(blank=True, db_column='STD_Balance', null=True)),
- ],
- options={
- 'db_table': 'tb_wb_std_code_3-4-5',
- 'managed': False,
- },
- ),
- ]
|