Sin descripción

0001_initial.py 63KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906
  1. # Generated by Django 5.0 on 2024-12-25 08:57
  2. from django.db import migrations, models
  3. class Migration(migrations.Migration):
  4. initial = True
  5. dependencies = [
  6. ]
  7. operations = [
  8. migrations.CreateModel(
  9. name='Agreements',
  10. fields=[
  11. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  12. ('title', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
  13. ('file', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
  14. ('description', models.TextField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', null=True)),
  15. ('created_at', models.DateTimeField(blank=True, null=True)),
  16. ('updated_at', models.DateTimeField(blank=True, null=True)),
  17. ],
  18. options={
  19. 'db_table': 'agreements',
  20. 'managed': False,
  21. },
  22. ),
  23. migrations.CreateModel(
  24. name='DailyChecks',
  25. fields=[
  26. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  27. ('p1', models.FloatField(blank=True, null=True)),
  28. ('p2', models.FloatField(blank=True, null=True)),
  29. ('p3', models.FloatField(blank=True, null=True)),
  30. ('avg', models.FloatField(blank=True, null=True)),
  31. ('machine_id', models.IntegerField(blank=True, null=True)),
  32. ('created_at', models.DateTimeField(blank=True, null=True)),
  33. ('updated_at', models.DateTimeField(blank=True, null=True)),
  34. ('header', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
  35. ('user_id', models.IntegerField(blank=True, null=True)),
  36. ('empid', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
  37. ('shift', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
  38. ('result', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
  39. ],
  40. options={
  41. 'db_table': 'daily_checks',
  42. 'managed': False,
  43. },
  44. ),
  45. migrations.CreateModel(
  46. name='DailyChecksWb',
  47. fields=[
  48. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  49. ('result', models.FloatField(blank=True, null=True)),
  50. ('weight', models.FloatField(blank=True, null=True)),
  51. ('judgement', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
  52. ('machine_id', models.IntegerField(blank=True, null=True)),
  53. ('created_at', models.DateTimeField(blank=True, null=True)),
  54. ('updated_at', models.DateTimeField(blank=True, null=True)),
  55. ('user_id', models.IntegerField(blank=True, null=True)),
  56. ('empid', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
  57. ('shift', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
  58. ],
  59. options={
  60. 'db_table': 'daily_checks_wb',
  61. 'managed': False,
  62. },
  63. ),
  64. migrations.CreateModel(
  65. name='Data',
  66. fields=[
  67. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  68. ('row_no', models.IntegerField(blank=True, null=True)),
  69. ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  70. ('code', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  71. ('header', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
  72. ('p1', models.FloatField(blank=True, null=True)),
  73. ('p2', models.FloatField(blank=True, null=True)),
  74. ('p3', models.FloatField(blank=True, null=True)),
  75. ('p4', models.FloatField(blank=True, null=True)),
  76. ('p5', models.FloatField(blank=True, null=True)),
  77. ('p6', models.FloatField(blank=True, null=True)),
  78. ('p7', models.FloatField(blank=True, null=True)),
  79. ('p8', models.FloatField(blank=True, null=True)),
  80. ('p9', models.FloatField(blank=True, null=True)),
  81. ('p10', models.FloatField(blank=True, null=True)),
  82. ('avg', models.FloatField(blank=True, null=True)),
  83. ('grade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  84. ('rgrade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  85. ('r_type', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  86. ('created_at', models.DateTimeField(blank=True, null=True)),
  87. ('updated_at', models.DateTimeField(blank=True, null=True)),
  88. ('ndata', models.IntegerField(blank=True, null=True)),
  89. ('sub_order', models.IntegerField(blank=True, null=True)),
  90. ('machine_id', models.IntegerField(blank=True, null=True)),
  91. ],
  92. options={
  93. 'db_table': 'data',
  94. 'managed': False,
  95. },
  96. ),
  97. migrations.CreateModel(
  98. name='Data13178079',
  99. fields=[
  100. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  101. ('row_no', models.IntegerField(blank=True, null=True)),
  102. ('avg', models.FloatField(blank=True, null=True)),
  103. ('grade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  104. ('rgrade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  105. ('r_type', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  106. ('p1', models.FloatField(blank=True, null=True)),
  107. ('p2', models.FloatField(blank=True, null=True)),
  108. ('p3', models.FloatField(blank=True, null=True)),
  109. ('p4', models.FloatField(blank=True, null=True)),
  110. ('p5', models.FloatField(blank=True, null=True)),
  111. ('p6', models.FloatField(blank=True, null=True)),
  112. ('p7', models.FloatField(blank=True, null=True)),
  113. ('p8', models.FloatField(blank=True, null=True)),
  114. ('p9', models.FloatField(blank=True, null=True)),
  115. ('p10', models.FloatField(blank=True, null=True)),
  116. ('created_at', models.DateTimeField(blank=True, null=True)),
  117. ('updated_at', models.DateTimeField(blank=True, null=True)),
  118. ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  119. ('ndata', models.IntegerField(blank=True, null=True)),
  120. ('sub_order', models.IntegerField(blank=True, null=True)),
  121. ('machine_id', models.IntegerField(blank=True, null=True)),
  122. ('code', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  123. ('header', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
  124. ],
  125. options={
  126. 'db_table': 'Data_131_78079',
  127. 'managed': False,
  128. },
  129. ),
  130. migrations.CreateModel(
  131. name='Data20082018',
  132. fields=[
  133. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  134. ('row_no', models.IntegerField(blank=True, null=True)),
  135. ('avg', models.FloatField(blank=True, null=True)),
  136. ('grade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  137. ('rgrade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  138. ('r_type', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  139. ('p1', models.FloatField(blank=True, null=True)),
  140. ('p2', models.FloatField(blank=True, null=True)),
  141. ('p3', models.FloatField(blank=True, null=True)),
  142. ('p4', models.FloatField(blank=True, null=True)),
  143. ('p5', models.FloatField(blank=True, null=True)),
  144. ('p6', models.FloatField(blank=True, null=True)),
  145. ('p7', models.FloatField(blank=True, null=True)),
  146. ('p8', models.FloatField(blank=True, null=True)),
  147. ('p9', models.FloatField(blank=True, null=True)),
  148. ('p10', models.FloatField(blank=True, null=True)),
  149. ('created_at', models.DateTimeField(blank=True, null=True)),
  150. ('updated_at', models.DateTimeField(blank=True, null=True)),
  151. ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  152. ('ndata', models.IntegerField(blank=True, null=True)),
  153. ('sub_order', models.IntegerField(blank=True, null=True)),
  154. ('machine_id', models.IntegerField(blank=True, null=True)),
  155. ('code', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  156. ('header', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
  157. ],
  158. options={
  159. 'db_table': 'data (2008-2018)',
  160. 'managed': False,
  161. },
  162. ),
  163. migrations.CreateModel(
  164. name='Data25113027G',
  165. fields=[
  166. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  167. ('row_no', models.IntegerField(blank=True, null=True)),
  168. ('avg', models.FloatField(blank=True, null=True)),
  169. ('grade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  170. ('rgrade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  171. ('r_type', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  172. ('p1', models.FloatField(blank=True, null=True)),
  173. ('p2', models.FloatField(blank=True, null=True)),
  174. ('p3', models.FloatField(blank=True, null=True)),
  175. ('p4', models.FloatField(blank=True, null=True)),
  176. ('p5', models.FloatField(blank=True, null=True)),
  177. ('p6', models.FloatField(blank=True, null=True)),
  178. ('p7', models.FloatField(blank=True, null=True)),
  179. ('p8', models.FloatField(blank=True, null=True)),
  180. ('p9', models.FloatField(blank=True, null=True)),
  181. ('p10', models.FloatField(blank=True, null=True)),
  182. ('created_at', models.DateTimeField(blank=True, null=True)),
  183. ('updated_at', models.DateTimeField(blank=True, null=True)),
  184. ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  185. ('ndata', models.IntegerField(blank=True, null=True)),
  186. ('sub_order', models.IntegerField(blank=True, null=True)),
  187. ('machine_id', models.IntegerField(blank=True, null=True)),
  188. ('code', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  189. ('header', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
  190. ],
  191. options={
  192. 'db_table': 'data_251-13027G',
  193. 'managed': False,
  194. },
  195. ),
  196. migrations.CreateModel(
  197. name='DataMs',
  198. fields=[
  199. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  200. ('row_no', models.IntegerField()),
  201. ('dsize', models.FloatField(blank=True, null=True)),
  202. ('tsize', models.FloatField(blank=True, null=True)),
  203. ('hsize', models.FloatField(blank=True, null=True)),
  204. ('csize', models.FloatField(blank=True, null=True)),
  205. ('esize', models.FloatField(blank=True, null=True)),
  206. ('fsize', models.FloatField(blank=True, null=True)),
  207. ('gsize', models.FloatField(blank=True, null=True)),
  208. ('psize', models.FloatField(blank=True, null=True)),
  209. ('wsize', models.FloatField(blank=True, null=True)),
  210. ('jksize', models.FloatField(blank=True, null=True)),
  211. ('usize', models.FloatField(blank=True, null=True)),
  212. ('msize', models.FloatField(blank=True, null=True)),
  213. ('asize', models.FloatField(blank=True, null=True)),
  214. ('nsize', models.FloatField(blank=True, null=True)),
  215. ('jsize', models.FloatField(blank=True, null=True)),
  216. ('xsize', models.FloatField(blank=True, null=True)),
  217. ('flatnesssize', models.FloatField(blank=True, null=True)),
  218. ('ksize', models.FloatField(blank=True, null=True)),
  219. ('thicknesssize', models.FloatField(blank=True, null=True)),
  220. ('qsize', models.FloatField(blank=True, null=True)),
  221. ('ssize', models.FloatField(blank=True, null=True)),
  222. ('dsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='dsizeOk', max_length=4, null=True)),
  223. ('tsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='tsizeOk', max_length=4, null=True)),
  224. ('hsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='hsizeOk', max_length=4, null=True)),
  225. ('csizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='csizeOk', max_length=4, null=True)),
  226. ('esizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='esizeOk', max_length=4, null=True)),
  227. ('fsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='fsizeOk', max_length=4, null=True)),
  228. ('gsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='gsizeOk', max_length=4, null=True)),
  229. ('psizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='psizeOk', max_length=4, null=True)),
  230. ('wsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='wsizeOk', max_length=4, null=True)),
  231. ('jksizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='jksizeOk', max_length=4, null=True)),
  232. ('usizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='usizeOk', max_length=4, null=True)),
  233. ('msizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='msizeOk', max_length=4, null=True)),
  234. ('asizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='asizeOk', max_length=4, null=True)),
  235. ('nsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='nsizeOk', max_length=4, null=True)),
  236. ('jsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='jsizeOk', max_length=4, null=True)),
  237. ('xsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='xsizeOk', max_length=4, null=True)),
  238. ('flatnesssizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='flatnesssizeOk', max_length=4, null=True)),
  239. ('ksizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='ksizeOk', max_length=4, null=True)),
  240. ('thicknesssizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='thicknesssizeOk', max_length=4, null=True)),
  241. ('qsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='qsizeOk', max_length=4, null=True)),
  242. ('ssizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='ssizeOk', max_length=4, null=True)),
  243. ('created_at', models.DateTimeField(blank=True, null=True)),
  244. ('updated_at', models.DateTimeField(blank=True, null=True)),
  245. ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  246. ('machine_id', models.IntegerField()),
  247. ('code', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  248. ('emp_id', models.IntegerField()),
  249. ('weight', models.FloatField(blank=True, null=True)),
  250. ('devid', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=40, null=True)),
  251. ('tpoint1', models.FloatField(blank=True, null=True)),
  252. ('tpoint2', models.FloatField(blank=True, null=True)),
  253. ('tpoint3', models.FloatField(blank=True, null=True)),
  254. ('tpoint4', models.FloatField(blank=True, null=True)),
  255. ('tpoint1ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=4, null=True)),
  256. ('tpoint2ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=4, null=True)),
  257. ('tpoint3ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=4, null=True)),
  258. ('tpoint4ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=4, null=True)),
  259. ('tdiff', models.FloatField(blank=True, null=True)),
  260. ('tmin', models.FloatField(blank=True, null=True)),
  261. ('tmax', models.FloatField(blank=True, null=True)),
  262. ('hdev', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=20, null=True)),
  263. ('hsizeproxy', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=20, null=True)),
  264. ('restricts', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=40, null=True)),
  265. ('shift', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
  266. ('mode', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
  267. ('cal_mode', models.IntegerField(blank=True, null=True)),
  268. ('diasize', models.FloatField(blank=True, null=True)),
  269. ('diasizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='diasizeOk', max_length=4, null=True)),
  270. ('censize', models.FloatField(blank=True, null=True)),
  271. ('censizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='censizeOk', max_length=4, null=True)),
  272. ('osize', models.FloatField(blank=True, null=True)),
  273. ('osizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='osizeOk', max_length=4, null=True)),
  274. ('size1', models.FloatField(blank=True, null=True)),
  275. ('size2', models.FloatField(blank=True, null=True)),
  276. ('size1ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='size1Ok', max_length=50, null=True)),
  277. ('size2ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='size2Ok', max_length=50, null=True)),
  278. ('size1name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='size1Name', max_length=50, null=True)),
  279. ('size2name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='size2Name', max_length=50, null=True)),
  280. ('bsize', models.FloatField(blank=True, null=True)),
  281. ('bsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='bsizeOk', max_length=50, null=True)),
  282. ('lsize', models.FloatField(blank=True, null=True)),
  283. ('lsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='lsizeOk', max_length=50, null=True)),
  284. ('zsize', models.FloatField(blank=True, null=True)),
  285. ('zsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='zsizeOk', max_length=50, null=True)),
  286. ('x1size', models.FloatField(blank=True, null=True)),
  287. ('x1sizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='x1sizeOk', max_length=50, null=True)),
  288. ('x2size', models.FloatField(blank=True, null=True)),
  289. ('x2sizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='x2sizeOk', max_length=50, null=True)),
  290. ('tpresssize', models.FloatField(blank=True, null=True)),
  291. ('tpresssizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='tpresssizeOk', max_length=50, null=True)),
  292. ('t1', models.FloatField()),
  293. ('t2', models.FloatField()),
  294. ('t3', models.FloatField()),
  295. ('t4', models.FloatField()),
  296. ('t1ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='t1Ok', max_length=50, null=True)),
  297. ('t2ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='t2Ok', max_length=50, null=True)),
  298. ('t3ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='t3Ok', max_length=50, null=True)),
  299. ('t4ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='t4Ok', max_length=50, null=True)),
  300. ('t4avg', models.FloatField()),
  301. ('tpok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='tpOk', max_length=50, null=True)),
  302. ('t4min', models.FloatField(blank=True, null=True)),
  303. ('t4max', models.FloatField(blank=True, null=True)),
  304. ('t4diff', models.FloatField(blank=True, null=True)),
  305. ],
  306. options={
  307. 'db_table': 'data_ms',
  308. 'managed': False,
  309. },
  310. ),
  311. migrations.CreateModel(
  312. name='DataMsLot2210062522',
  313. fields=[
  314. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  315. ('row_no', models.IntegerField()),
  316. ('dsize', models.FloatField(blank=True, null=True)),
  317. ('tsize', models.FloatField(blank=True, null=True)),
  318. ('hsize', models.FloatField(blank=True, null=True)),
  319. ('csize', models.FloatField(blank=True, null=True)),
  320. ('esize', models.FloatField(blank=True, null=True)),
  321. ('fsize', models.FloatField(blank=True, null=True)),
  322. ('gsize', models.FloatField(blank=True, null=True)),
  323. ('psize', models.FloatField(blank=True, null=True)),
  324. ('wsize', models.FloatField(blank=True, null=True)),
  325. ('jksize', models.FloatField(blank=True, null=True)),
  326. ('usize', models.FloatField(blank=True, null=True)),
  327. ('msize', models.FloatField(blank=True, null=True)),
  328. ('asize', models.FloatField(blank=True, null=True)),
  329. ('nsize', models.FloatField(blank=True, null=True)),
  330. ('jsize', models.FloatField(blank=True, null=True)),
  331. ('xsize', models.FloatField(blank=True, null=True)),
  332. ('flatnesssize', models.FloatField(blank=True, null=True)),
  333. ('ksize', models.FloatField(blank=True, null=True)),
  334. ('thicknesssize', models.FloatField(blank=True, null=True)),
  335. ('qsize', models.FloatField(blank=True, null=True)),
  336. ('ssize', models.FloatField(blank=True, null=True)),
  337. ('dsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='dsizeOk', max_length=4, null=True)),
  338. ('tsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='tsizeOk', max_length=4, null=True)),
  339. ('hsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='hsizeOk', max_length=4, null=True)),
  340. ('csizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='csizeOk', max_length=4, null=True)),
  341. ('esizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='esizeOk', max_length=4, null=True)),
  342. ('fsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='fsizeOk', max_length=4, null=True)),
  343. ('gsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='gsizeOk', max_length=4, null=True)),
  344. ('psizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='psizeOk', max_length=4, null=True)),
  345. ('wsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='wsizeOk', max_length=4, null=True)),
  346. ('jksizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='jksizeOk', max_length=4, null=True)),
  347. ('usizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='usizeOk', max_length=4, null=True)),
  348. ('msizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='msizeOk', max_length=4, null=True)),
  349. ('asizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='asizeOk', max_length=4, null=True)),
  350. ('nsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='nsizeOk', max_length=4, null=True)),
  351. ('jsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='jsizeOk', max_length=4, null=True)),
  352. ('xsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='xsizeOk', max_length=4, null=True)),
  353. ('flatnesssizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='flatnesssizeOk', max_length=4, null=True)),
  354. ('ksizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='ksizeOk', max_length=4, null=True)),
  355. ('thicknesssizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='thicknesssizeOk', max_length=4, null=True)),
  356. ('qsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='qsizeOk', max_length=4, null=True)),
  357. ('ssizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='ssizeOk', max_length=4, null=True)),
  358. ('created_at', models.DateTimeField(blank=True, null=True)),
  359. ('updated_at', models.DateTimeField(blank=True, null=True)),
  360. ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  361. ('machine_id', models.IntegerField()),
  362. ('code', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  363. ('emp_id', models.IntegerField()),
  364. ('weight', models.FloatField(blank=True, null=True)),
  365. ('devid', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=40, null=True)),
  366. ('tpoint1', models.FloatField(blank=True, null=True)),
  367. ('tpoint2', models.FloatField(blank=True, null=True)),
  368. ('tpoint3', models.FloatField(blank=True, null=True)),
  369. ('tpoint4', models.FloatField(blank=True, null=True)),
  370. ('tpoint1ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=4, null=True)),
  371. ('tpoint2ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=4, null=True)),
  372. ('tpoint3ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=4, null=True)),
  373. ('tpoint4ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=4, null=True)),
  374. ('tdiff', models.FloatField(blank=True, null=True)),
  375. ('tmin', models.FloatField(blank=True, null=True)),
  376. ('tmax', models.FloatField(blank=True, null=True)),
  377. ('hdev', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=20, null=True)),
  378. ('hsizeproxy', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=20, null=True)),
  379. ('restricts', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=40, null=True)),
  380. ('shift', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
  381. ('mode', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
  382. ('cal_mode', models.IntegerField(blank=True, null=True)),
  383. ('diasize', models.FloatField(blank=True, null=True)),
  384. ('diasizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='diasizeOk', max_length=4, null=True)),
  385. ('censize', models.FloatField(blank=True, null=True)),
  386. ('censizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='censizeOk', max_length=4, null=True)),
  387. ('osize', models.FloatField(blank=True, null=True)),
  388. ('osizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='osizeOk', max_length=4, null=True)),
  389. ('size1', models.FloatField(blank=True, null=True)),
  390. ('size2', models.FloatField(blank=True, null=True)),
  391. ('size1ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='size1Ok', max_length=50, null=True)),
  392. ('size2ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='size2Ok', max_length=50, null=True)),
  393. ('size1name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='size1Name', max_length=50, null=True)),
  394. ('size2name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='size2Name', max_length=50, null=True)),
  395. ('bsize', models.FloatField(blank=True, null=True)),
  396. ('bsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='bsizeOk', max_length=50, null=True)),
  397. ('lsize', models.FloatField(blank=True, null=True)),
  398. ('lsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='lsizeOk', max_length=50, null=True)),
  399. ('zsize', models.FloatField(blank=True, null=True)),
  400. ('zsizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='zsizeOk', max_length=50, null=True)),
  401. ('x1size', models.FloatField(blank=True, null=True)),
  402. ('x1sizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='x1sizeOk', max_length=50, null=True)),
  403. ('x2size', models.FloatField(blank=True, null=True)),
  404. ('x2sizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='x2sizeOk', max_length=50, null=True)),
  405. ('tpresssize', models.FloatField(blank=True, null=True)),
  406. ('tpresssizeok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='tpresssizeOk', max_length=50, null=True)),
  407. ('t1', models.FloatField()),
  408. ('t2', models.FloatField()),
  409. ('t3', models.FloatField()),
  410. ('t4', models.FloatField()),
  411. ('t1ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='t1Ok', max_length=50, null=True)),
  412. ('t2ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='t2Ok', max_length=50, null=True)),
  413. ('t3ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='t3Ok', max_length=50, null=True)),
  414. ('t4ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='t4Ok', max_length=50, null=True)),
  415. ('t4avg', models.FloatField()),
  416. ('tpok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='tpOk', max_length=50, null=True)),
  417. ('t4min', models.FloatField(blank=True, null=True)),
  418. ('t4max', models.FloatField(blank=True, null=True)),
  419. ('t4diff', models.FloatField(blank=True, null=True)),
  420. ],
  421. options={
  422. 'db_table': 'data_ms_LOT2210062522',
  423. 'managed': False,
  424. },
  425. ),
  426. migrations.CreateModel(
  427. name='DataRl',
  428. fields=[
  429. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  430. ('row_no', models.IntegerField(blank=True, null=True)),
  431. ('avg', models.FloatField(blank=True, null=True)),
  432. ('grade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  433. ('rgrade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  434. ('r_type', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  435. ('p1', models.FloatField(blank=True, null=True)),
  436. ('p2', models.FloatField(blank=True, null=True)),
  437. ('p3', models.FloatField(blank=True, null=True)),
  438. ('p4', models.FloatField(blank=True, null=True)),
  439. ('p5', models.FloatField(blank=True, null=True)),
  440. ('p6', models.FloatField(blank=True, null=True)),
  441. ('p7', models.FloatField(blank=True, null=True)),
  442. ('p8', models.FloatField(blank=True, null=True)),
  443. ('p9', models.FloatField(blank=True, null=True)),
  444. ('p10', models.FloatField(blank=True, null=True)),
  445. ('created_at', models.DateTimeField(blank=True, null=True)),
  446. ('updated_at', models.DateTimeField(blank=True, null=True)),
  447. ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  448. ('ndata', models.IntegerField(blank=True, null=True)),
  449. ('sub_order', models.IntegerField(blank=True, null=True)),
  450. ('machine_id', models.IntegerField(blank=True, null=True)),
  451. ('code', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  452. ('header', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
  453. ],
  454. options={
  455. 'db_table': 'data_rl',
  456. 'managed': False,
  457. },
  458. ),
  459. migrations.CreateModel(
  460. name='DataWb',
  461. fields=[
  462. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  463. ('row_no', models.IntegerField(blank=True, null=True)),
  464. ('result', models.FloatField(blank=True, null=True)),
  465. ('weight', models.FloatField(blank=True, null=True)),
  466. ('judgement', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
  467. ('created_at', models.DateTimeField(blank=True, null=True)),
  468. ('updated_at', models.DateTimeField(blank=True, null=True)),
  469. ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  470. ('machine_id', models.IntegerField(blank=True, null=True)),
  471. ('code', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  472. ('emp_id', models.IntegerField(blank=True, null=True)),
  473. ('repair_by', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=30, null=True)),
  474. ],
  475. options={
  476. 'db_table': 'data_wb',
  477. 'managed': False,
  478. },
  479. ),
  480. migrations.CreateModel(
  481. name='DataWbTest',
  482. fields=[
  483. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  484. ('row_no', models.IntegerField(blank=True, null=True)),
  485. ('result', models.FloatField(blank=True, null=True)),
  486. ('weight', models.FloatField(blank=True, null=True)),
  487. ('judgement', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
  488. ('created_at', models.DateTimeField(blank=True, null=True)),
  489. ('updated_at', models.DateTimeField(blank=True, null=True)),
  490. ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  491. ('machine_id', models.IntegerField(blank=True, null=True)),
  492. ('code', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  493. ('emp_id', models.IntegerField(blank=True, null=True)),
  494. ('repair_by', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=30, null=True)),
  495. ],
  496. options={
  497. 'db_table': 'data_wb_test',
  498. 'managed': False,
  499. },
  500. ),
  501. migrations.CreateModel(
  502. name='LegacyUsers',
  503. fields=[
  504. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  505. ('email', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
  506. ('password_digest', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
  507. ('created_at', models.DateTimeField(blank=True, null=True)),
  508. ('updated_at', models.DateTimeField(blank=True, null=True)),
  509. ('roles_mask', models.IntegerField(blank=True, null=True)),
  510. ('empid', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
  511. ('fname', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
  512. ('lname', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
  513. ],
  514. options={
  515. 'db_table': 'users',
  516. 'managed': False,
  517. },
  518. ),
  519. migrations.CreateModel(
  520. name='LoginTemps',
  521. fields=[
  522. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  523. ('empid', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
  524. ('password', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
  525. ('created_at', models.DateTimeField(blank=True, null=True)),
  526. ('updated_at', models.DateTimeField(blank=True, null=True)),
  527. ],
  528. options={
  529. 'db_table': 'login_temps',
  530. 'managed': False,
  531. },
  532. ),
  533. migrations.CreateModel(
  534. name='Lot',
  535. fields=[
  536. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  537. ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  538. ],
  539. options={
  540. 'db_table': 'lot',
  541. 'managed': False,
  542. },
  543. ),
  544. migrations.CreateModel(
  545. name='LotRl',
  546. fields=[
  547. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  548. ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  549. ],
  550. options={
  551. 'db_table': 'lot_rl',
  552. 'managed': False,
  553. },
  554. ),
  555. migrations.CreateModel(
  556. name='Lotsizeorder',
  557. fields=[
  558. ('oid', models.AutoField(primary_key=True, serialize=False)),
  559. ('lotno', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=100, null=True)),
  560. ('sizes', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=400, null=True)),
  561. ],
  562. options={
  563. 'db_table': 'LotSizeOrder',
  564. 'managed': False,
  565. },
  566. ),
  567. migrations.CreateModel(
  568. name='LotSummary',
  569. fields=[
  570. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  571. ('lot_no', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50)),
  572. ('created_at', models.DateTimeField()),
  573. ('avg', models.FloatField()),
  574. ('code', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50)),
  575. ('start_time', models.DateTimeField(blank=True, null=True)),
  576. ('end_time', models.DateTimeField(blank=True, null=True)),
  577. ('grade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  578. ('machine_id', models.IntegerField(blank=True, null=True)),
  579. ('avg0', models.FloatField(blank=True, null=True)),
  580. ('avg1', models.FloatField(blank=True, null=True)),
  581. ('avg2', models.FloatField(blank=True, null=True)),
  582. ('avg3', models.FloatField(blank=True, null=True)),
  583. ('avg0_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  584. ('avg1_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  585. ('avg2_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  586. ('avg3_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  587. ],
  588. options={
  589. 'db_table': 'lot_summary',
  590. 'managed': False,
  591. },
  592. ),
  593. migrations.CreateModel(
  594. name='LotSummary20082018',
  595. fields=[
  596. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  597. ('lot_no', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50)),
  598. ('created_at', models.DateTimeField()),
  599. ('avg', models.FloatField()),
  600. ('code', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50)),
  601. ('start_time', models.DateTimeField(blank=True, null=True)),
  602. ('end_time', models.DateTimeField(blank=True, null=True)),
  603. ('grade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  604. ('machine_id', models.IntegerField(blank=True, null=True)),
  605. ('avg0', models.FloatField(blank=True, null=True)),
  606. ('avg1', models.FloatField(blank=True, null=True)),
  607. ('avg2', models.FloatField(blank=True, null=True)),
  608. ('avg3', models.FloatField(blank=True, null=True)),
  609. ('avg0_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  610. ('avg1_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  611. ('avg2_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  612. ('avg3_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  613. ],
  614. options={
  615. 'db_table': 'lot_summary (2008-2018)',
  616. 'managed': False,
  617. },
  618. ),
  619. migrations.CreateModel(
  620. name='LotSummaryRl',
  621. fields=[
  622. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  623. ('lot_no', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50)),
  624. ('created_at', models.DateTimeField()),
  625. ('avg', models.FloatField()),
  626. ('code', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50)),
  627. ('start_time', models.DateTimeField(blank=True, null=True)),
  628. ('end_time', models.DateTimeField(blank=True, null=True)),
  629. ('grade', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  630. ('machine_id', models.IntegerField(blank=True, null=True)),
  631. ('avg0', models.FloatField(blank=True, null=True)),
  632. ('avg1', models.FloatField(blank=True, null=True)),
  633. ('avg2', models.FloatField(blank=True, null=True)),
  634. ('avg3', models.FloatField(blank=True, null=True)),
  635. ('avg0_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  636. ('avg1_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  637. ('avg2_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  638. ('avg3_name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  639. ],
  640. options={
  641. 'db_table': 'lot_summary_rl',
  642. 'managed': False,
  643. },
  644. ),
  645. migrations.CreateModel(
  646. name='LotSummaryWb',
  647. fields=[
  648. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  649. ('lot_no', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50)),
  650. ('created_at', models.DateTimeField()),
  651. ('w_avg', models.FloatField()),
  652. ('wb_avg', models.FloatField()),
  653. ('cp', models.FloatField()),
  654. ('code', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50)),
  655. ('start_time', models.DateTimeField(blank=True, null=True)),
  656. ('end_time', models.DateTimeField(blank=True, null=True)),
  657. ('machine_id', models.IntegerField(blank=True, null=True)),
  658. ],
  659. options={
  660. 'db_table': 'lot_summary_wb',
  661. 'managed': False,
  662. },
  663. ),
  664. migrations.CreateModel(
  665. name='Lottracking',
  666. fields=[
  667. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  668. ('lotno', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
  669. ('machinegroup', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='machineGroup', max_length=255, null=True)),
  670. ('datams_id', models.IntegerField(blank=True, null=True)),
  671. ('created_at', models.DateTimeField(blank=True, null=True)),
  672. ('updated_at', models.DateTimeField(blank=True, null=True)),
  673. ],
  674. options={
  675. 'db_table': 'LotTracking',
  676. 'managed': False,
  677. },
  678. ),
  679. migrations.CreateModel(
  680. name='Machinegroup',
  681. fields=[
  682. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  683. ('groupname', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='groupName', max_length=255, null=True)),
  684. ],
  685. options={
  686. 'db_table': 'machineGroup',
  687. 'managed': False,
  688. },
  689. ),
  690. migrations.CreateModel(
  691. name='Machines',
  692. fields=[
  693. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  694. ('name', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
  695. ('description', models.TextField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', null=True)),
  696. ('created_at', models.DateTimeField(blank=True, null=True)),
  697. ('updated_at', models.DateTimeField(blank=True, null=True)),
  698. ('tag_name', models.TextField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', null=True)),
  699. ],
  700. options={
  701. 'db_table': 'machines',
  702. 'managed': False,
  703. },
  704. ),
  705. migrations.CreateModel(
  706. name='MachinesWb',
  707. fields=[
  708. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  709. ('name', models.TextField(db_collation='SQL_Latin1_General_CP1_CI_AS')),
  710. ('description', models.TextField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', null=True)),
  711. ('created_at', models.DateTimeField()),
  712. ('updated_at', models.DateTimeField(blank=True, null=True)),
  713. ('tag_name', models.TextField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', null=True)),
  714. ('ip', models.TextField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', null=True)),
  715. ('isactive', models.BooleanField(db_column='isActive')),
  716. ('machinestd', models.FloatField(blank=True, db_column='machineStd', null=True)),
  717. ],
  718. options={
  719. 'db_table': 'machines_wb',
  720. 'managed': False,
  721. },
  722. ),
  723. migrations.CreateModel(
  724. name='Manualsize',
  725. fields=[
  726. ('lotno', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='lotNo', max_length=20, primary_key=True, serialize=False)),
  727. ('size_name', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='Size_Name', max_length=50)),
  728. ('std', models.FloatField(blank=True, db_column='Std', null=True)),
  729. ('tolun', models.FloatField(blank=True, db_column='TolUn', null=True)),
  730. ('tolup', models.FloatField(blank=True, db_column='TolUp', null=True)),
  731. ('created_at', models.DateTimeField()),
  732. ('productcode', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='ProductCode', max_length=30, null=True)),
  733. ],
  734. options={
  735. 'db_table': 'manualSize',
  736. 'managed': False,
  737. },
  738. ),
  739. migrations.CreateModel(
  740. name='PressCal',
  741. fields=[
  742. ('v0', models.FloatField(blank=True, null=True)),
  743. ('lot_no', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, primary_key=True, serialize=False)),
  744. ('v1', models.FloatField(blank=True, null=True)),
  745. ('v2', models.FloatField(blank=True, null=True)),
  746. ('v3', models.FloatField(blank=True, null=True)),
  747. ('v4', models.FloatField(blank=True, null=True)),
  748. ('v5', models.FloatField(blank=True, null=True)),
  749. ('v6', models.FloatField(blank=True, null=True)),
  750. ('y0', models.FloatField(blank=True, null=True)),
  751. ('y1', models.FloatField(blank=True, null=True)),
  752. ('y2', models.FloatField(blank=True, null=True)),
  753. ('ac1', models.FloatField(blank=True, null=True)),
  754. ('ac2', models.FloatField(blank=True, null=True)),
  755. ('ac3', models.FloatField(blank=True, null=True)),
  756. ('ac4', models.FloatField(blank=True, null=True)),
  757. ('ac5', models.FloatField(blank=True, null=True)),
  758. ('ac6', models.FloatField(blank=True, null=True)),
  759. ('ac7', models.FloatField(blank=True, null=True)),
  760. ('r_result', models.FloatField(blank=True, null=True)),
  761. ('created_at', models.DateTimeField(blank=True, null=True)),
  762. ('updated_at', models.DateTimeField(blank=True, null=True)),
  763. ('c0', models.FloatField()),
  764. ],
  765. options={
  766. 'db_table': 'press_cal',
  767. 'managed': False,
  768. },
  769. ),
  770. migrations.CreateModel(
  771. name='RotateData',
  772. fields=[
  773. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  774. ('row_no', models.IntegerField(blank=True, null=True)),
  775. ('speed_spec', models.FloatField(blank=True, null=True)),
  776. ('speed_test', models.FloatField(blank=True, null=True)),
  777. ('speedok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='speedOk', max_length=4, null=True)),
  778. ('qty', models.IntegerField()),
  779. ('station_no', models.IntegerField()),
  780. ('created_at', models.DateTimeField(blank=True, null=True)),
  781. ('updated_at', models.DateTimeField(blank=True, null=True)),
  782. ('lot_no', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  783. ('machine_id', models.IntegerField(blank=True, null=True)),
  784. ('code', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  785. ('emp_id', models.IntegerField()),
  786. ('devid', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=40, null=True)),
  787. ('mode', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=10, null=True)),
  788. ('cal_mode', models.IntegerField(blank=True, null=True)),
  789. ],
  790. options={
  791. 'db_table': 'rotate_data',
  792. 'managed': False,
  793. },
  794. ),
  795. migrations.CreateModel(
  796. name='SchemaMigrations',
  797. fields=[
  798. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  799. ('version', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255)),
  800. ],
  801. options={
  802. 'db_table': 'schema_migrations',
  803. 'managed': False,
  804. },
  805. ),
  806. migrations.CreateModel(
  807. name='SplitData',
  808. fields=[
  809. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  810. ('v1', models.FloatField(blank=True, null=True)),
  811. ('v2', models.FloatField(blank=True, null=True)),
  812. ('v3', models.FloatField(blank=True, null=True)),
  813. ('v4', models.FloatField(blank=True, null=True)),
  814. ('v5', models.FloatField(blank=True, null=True)),
  815. ('unit', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  816. ('vr', models.FloatField(blank=True, null=True)),
  817. ('vname', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=50, null=True)),
  818. ('no', models.IntegerField()),
  819. ('v1ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=20, null=True)),
  820. ('v2ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=20, null=True)),
  821. ('v3ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=20, null=True)),
  822. ('v4ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=20, null=True)),
  823. ('v5ok', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=20, null=True)),
  824. ('vmax', models.FloatField(blank=True, null=True)),
  825. ('vmin', models.FloatField(blank=True, null=True)),
  826. ('vdiff', models.FloatField(blank=True, null=True)),
  827. ('row_no', models.IntegerField(blank=True, null=True)),
  828. ],
  829. options={
  830. 'db_table': 'split_data',
  831. 'managed': False,
  832. },
  833. ),
  834. migrations.CreateModel(
  835. name='SysConfigs',
  836. fields=[
  837. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  838. ('title', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
  839. ('value', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', max_length=255, null=True)),
  840. ('created_at', models.DateTimeField(blank=True, null=True)),
  841. ('updated_at', models.DateTimeField(blank=True, null=True)),
  842. ],
  843. options={
  844. 'db_table': 'sys_configs',
  845. 'managed': False,
  846. },
  847. ),
  848. migrations.CreateModel(
  849. name='TbFgPressinfoLotlist',
  850. fields=[
  851. ('product_year', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='Product_Year', max_length=10, primary_key=True, serialize=False)),
  852. ('productcode', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='ProductCode', max_length=20)),
  853. ('lotno', models.CharField(db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='LotNo', max_length=20)),
  854. ('lot_qty', models.FloatField(blank=True, db_column='Lot_Qty', null=True)),
  855. ('def_qty', models.FloatField(blank=True, db_column='Def_Qty', null=True)),
  856. ('fg_qty', models.FloatField(blank=True, db_column='FG_Qty', null=True)),
  857. ('insp_date', models.DateTimeField(blank=True, db_column='Insp_Date', null=True)),
  858. ('current_prono', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='Current_ProNo', max_length=5, null=True)),
  859. ('press_mcname', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='Press_McName', max_length=50, null=True)),
  860. ('press_username', models.CharField(blank=True, db_collation='SQL_Latin1_General_CP1_CI_AS', db_column='Press_UserName', max_length=50, null=True)),
  861. ],
  862. options={
  863. 'db_table': 'tb_fg_pressinfo_lotlist',
  864. 'managed': False,
  865. },
  866. ),
  867. migrations.CreateModel(
  868. name='TbWbStdCode12',
  869. fields=[
  870. ('id', models.IntegerField(db_column='ID', primary_key=True, serialize=False)),
  871. ('u_weight', models.FloatField(blank=True, db_column='U_Weight', null=True)),
  872. ('speed_from', models.FloatField(blank=True, db_column='Speed_From', null=True)),
  873. ('speed_to', models.FloatField(blank=True, db_column='Speed_To', null=True)),
  874. ('diameter_from', models.FloatField(blank=True, db_column='Diameter_From', null=True)),
  875. ('diameter_to', models.FloatField(blank=True, db_column='Diameter_To', null=True)),
  876. ('std_balance', models.FloatField(blank=True, db_column='STD_Balance', null=True)),
  877. ],
  878. options={
  879. 'db_table': 'tb_wb_std_code_1-2',
  880. 'managed': False,
  881. },
  882. ),
  883. migrations.CreateModel(
  884. name='TbWbStdCode345',
  885. fields=[
  886. ('id', models.IntegerField(db_column='ID', primary_key=True, serialize=False)),
  887. ('u_weight', models.FloatField(blank=True, db_column='U_Weight', null=True)),
  888. ('speed_from', models.FloatField(blank=True, db_column='Speed_From', null=True)),
  889. ('speed_to', models.FloatField(blank=True, db_column='Speed_To', null=True)),
  890. ('diameter_from', models.FloatField(blank=True, db_column='Diameter_From', null=True)),
  891. ('diameter_to', models.FloatField(blank=True, db_column='Diameter_To', null=True)),
  892. ('std_balance', models.FloatField(blank=True, db_column='STD_Balance', null=True)),
  893. ],
  894. options={
  895. 'db_table': 'tb_wb_std_code_3-4-5',
  896. 'managed': False,
  897. },
  898. ),
  899. ]