Нема описа

models.py 53KB

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