Nenhuma Descrição

models.py 53KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848
  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. r_type = models.CharField(max_length=50, 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. header = models.CharField(max_length=10, 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. lot_no = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  187. machine_id = models.IntegerField()
  188. code = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  189. row_no = models.IntegerField()
  190. dsize = models.FloatField(blank=True, null=True)
  191. tsize = models.FloatField(blank=True, null=True)
  192. hsize = models.FloatField(blank=True, null=True)
  193. csize = models.FloatField(blank=True, null=True)
  194. esize = models.FloatField(blank=True, null=True)
  195. fsize = models.FloatField(blank=True, null=True)
  196. gsize = models.FloatField(blank=True, null=True)
  197. psize = models.FloatField(blank=True, null=True)
  198. wsize = models.FloatField(blank=True, null=True)
  199. jksize = models.FloatField(blank=True, null=True)
  200. usize = models.FloatField(blank=True, null=True)
  201. msize = models.FloatField(blank=True, null=True)
  202. asize = models.FloatField(blank=True, null=True)
  203. nsize = models.FloatField(blank=True, null=True)
  204. jsize = models.FloatField(blank=True, null=True)
  205. xsize = models.FloatField(blank=True, null=True)
  206. flatnesssize = models.FloatField(blank=True, null=True)
  207. ksize = models.FloatField(blank=True, null=True)
  208. thicknesssize = models.FloatField(blank=True, null=True)
  209. qsize = models.FloatField(blank=True, null=True)
  210. ssize = models.FloatField(blank=True, null=True)
  211. 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.
  212. 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.
  213. 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.
  214. 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.
  215. 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.
  216. 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.
  217. 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.
  218. 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.
  219. 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.
  220. 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.
  221. 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.
  222. 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.
  223. 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.
  224. 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.
  225. 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.
  226. 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.
  227. 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.
  228. 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.
  229. 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.
  230. 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.
  231. 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.
  232. created_at = models.DateTimeField(blank=True, null=True)
  233. updated_at = models.DateTimeField(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. def __str__(self):
  296. return f"Lotno:{self.lot_no} Code:{self.code}"
  297. class DataMsLot2210062522(models.Model):
  298. row_no = models.IntegerField()
  299. dsize = models.FloatField(blank=True, null=True)
  300. tsize = models.FloatField(blank=True, null=True)
  301. hsize = models.FloatField(blank=True, null=True)
  302. csize = models.FloatField(blank=True, null=True)
  303. esize = models.FloatField(blank=True, null=True)
  304. fsize = models.FloatField(blank=True, null=True)
  305. gsize = models.FloatField(blank=True, null=True)
  306. psize = models.FloatField(blank=True, null=True)
  307. wsize = models.FloatField(blank=True, null=True)
  308. jksize = models.FloatField(blank=True, null=True)
  309. usize = models.FloatField(blank=True, null=True)
  310. msize = models.FloatField(blank=True, null=True)
  311. asize = models.FloatField(blank=True, null=True)
  312. nsize = models.FloatField(blank=True, null=True)
  313. jsize = models.FloatField(blank=True, null=True)
  314. xsize = models.FloatField(blank=True, null=True)
  315. flatnesssize = models.FloatField(blank=True, null=True)
  316. ksize = models.FloatField(blank=True, null=True)
  317. thicknesssize = models.FloatField(blank=True, null=True)
  318. qsize = models.FloatField(blank=True, null=True)
  319. ssize = models.FloatField(blank=True, null=True)
  320. 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.
  321. 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.
  322. 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.
  323. 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.
  324. 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.
  325. 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.
  326. 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.
  327. 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.
  328. 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.
  329. 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.
  330. 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.
  331. 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.
  332. 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.
  333. 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.
  334. 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.
  335. 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.
  336. 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.
  337. 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.
  338. 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.
  339. 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.
  340. 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.
  341. created_at = models.DateTimeField(blank=True, null=True)
  342. updated_at = models.DateTimeField(blank=True, null=True)
  343. lot_no = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  344. machine_id = models.IntegerField()
  345. code = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  346. emp_id = models.IntegerField()
  347. weight = models.FloatField(blank=True, null=True)
  348. devid = models.CharField(max_length=40, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  349. tpoint1 = models.FloatField(blank=True, null=True)
  350. tpoint2 = models.FloatField(blank=True, null=True)
  351. tpoint3 = models.FloatField(blank=True, null=True)
  352. tpoint4 = models.FloatField(blank=True, null=True)
  353. tpoint1ok = models.CharField(max_length=4, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  354. tpoint2ok = models.CharField(max_length=4, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  355. tpoint3ok = models.CharField(max_length=4, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  356. tpoint4ok = models.CharField(max_length=4, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  357. tdiff = models.FloatField(blank=True, null=True)
  358. tmin = models.FloatField(blank=True, null=True)
  359. tmax = models.FloatField(blank=True, null=True)
  360. hdev = models.CharField(max_length=20, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  361. hsizeproxy = models.CharField(max_length=20, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  362. restricts = models.CharField(max_length=40, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  363. shift = models.CharField(max_length=10, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  364. mode = models.CharField(max_length=10, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  365. cal_mode = models.IntegerField(blank=True, null=True)
  366. diasize = models.FloatField(blank=True, null=True)
  367. 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.
  368. censize = models.FloatField(blank=True, null=True)
  369. 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.
  370. osize = models.FloatField(blank=True, null=True)
  371. 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.
  372. size1 = models.FloatField(blank=True, null=True)
  373. size2 = models.FloatField(blank=True, null=True)
  374. 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.
  375. 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.
  376. 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.
  377. 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.
  378. bsize = models.FloatField(blank=True, null=True)
  379. 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.
  380. lsize = models.FloatField(blank=True, null=True)
  381. 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.
  382. zsize = models.FloatField(blank=True, null=True)
  383. 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.
  384. x1size = models.FloatField(blank=True, null=True)
  385. 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.
  386. x2size = models.FloatField(blank=True, null=True)
  387. 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.
  388. tpresssize = models.FloatField(blank=True, null=True)
  389. 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.
  390. t1 = models.FloatField()
  391. t2 = models.FloatField()
  392. t3 = models.FloatField()
  393. t4 = models.FloatField()
  394. 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.
  395. 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.
  396. 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.
  397. 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.
  398. t4avg = models.FloatField()
  399. 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.
  400. t4min = models.FloatField(blank=True, null=True)
  401. t4max = models.FloatField(blank=True, null=True)
  402. t4diff = models.FloatField(blank=True, null=True)
  403. class Meta:
  404. managed = False
  405. db_table = 'data_ms_LOT2210062522'
  406. app_label = "legacy"
  407. class DataRl(models.Model):
  408. row_no = models.IntegerField(blank=True, null=True)
  409. avg = models.FloatField(blank=True, null=True)
  410. grade = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  411. rgrade = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  412. r_type = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  413. p1 = models.FloatField(blank=True, null=True)
  414. p2 = models.FloatField(blank=True, null=True)
  415. p3 = models.FloatField(blank=True, null=True)
  416. p4 = models.FloatField(blank=True, null=True)
  417. p5 = models.FloatField(blank=True, null=True)
  418. p6 = models.FloatField(blank=True, null=True)
  419. p7 = models.FloatField(blank=True, null=True)
  420. p8 = models.FloatField(blank=True, null=True)
  421. p9 = models.FloatField(blank=True, null=True)
  422. p10 = models.FloatField(blank=True, null=True)
  423. created_at = models.DateTimeField(blank=True, null=True)
  424. updated_at = models.DateTimeField(blank=True, null=True)
  425. lot_no = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  426. ndata = models.IntegerField(blank=True, null=True)
  427. sub_order = models.IntegerField(blank=True, null=True)
  428. machine_id = models.IntegerField(blank=True, null=True)
  429. code = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  430. header = models.CharField(max_length=10, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  431. class Meta:
  432. managed = False
  433. db_table = 'data_rl'
  434. app_label = "legacy"
  435. class DataWb(models.Model):
  436. row_no = models.IntegerField(blank=True, null=True)
  437. lot_no = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  438. code = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  439. result = models.FloatField(blank=True, null=True)
  440. weight = models.FloatField(blank=True, null=True)
  441. judgement = models.CharField(max_length=10, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  442. created_at = models.DateTimeField(blank=True, null=True)
  443. updated_at = models.DateTimeField(blank=True, null=True)
  444. machine_id = models.IntegerField(blank=True, null=True)
  445. emp_id = models.IntegerField(blank=True, null=True)
  446. repair_by = models.CharField(max_length=30, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  447. class Meta:
  448. managed = False
  449. db_table = 'data_wb'
  450. app_label = "legacy"
  451. class DataWbTest(models.Model):
  452. row_no = models.IntegerField(blank=True, null=True)
  453. result = models.FloatField(blank=True, null=True)
  454. weight = models.FloatField(blank=True, null=True)
  455. judgement = models.CharField(max_length=10, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  456. created_at = models.DateTimeField(blank=True, null=True)
  457. updated_at = models.DateTimeField(blank=True, null=True)
  458. lot_no = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  459. machine_id = models.IntegerField(blank=True, null=True)
  460. code = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  461. emp_id = models.IntegerField(blank=True, null=True)
  462. repair_by = models.CharField(max_length=30, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  463. class Meta:
  464. managed = False
  465. db_table = 'data_wb_test'
  466. app_label = "legacy"
  467. class LoginTemps(models.Model):
  468. empid = models.CharField(max_length=255, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  469. password = models.CharField(max_length=255, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  470. created_at = models.DateTimeField(blank=True, null=True)
  471. updated_at = models.DateTimeField(blank=True, null=True)
  472. class Meta:
  473. managed = False
  474. db_table = 'login_temps'
  475. app_label = "legacy"
  476. class Lot(models.Model):
  477. lot_no = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  478. class Meta:
  479. managed = False
  480. db_table = 'lot'
  481. class LotRl(models.Model):
  482. lot_no = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  483. class Meta:
  484. managed = False
  485. db_table = 'lot_rl'
  486. app_label = "legacy"
  487. class LotSummary(models.Model):
  488. lot_no = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS')
  489. created_at = models.DateTimeField()
  490. avg = models.FloatField()
  491. code = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS')
  492. start_time = models.DateTimeField(blank=True, null=True)
  493. end_time = models.DateTimeField(blank=True, null=True)
  494. grade = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  495. machine_id = models.IntegerField(blank=True, null=True)
  496. avg0 = models.FloatField(blank=True, null=True)
  497. avg1 = models.FloatField(blank=True, null=True)
  498. avg2 = models.FloatField(blank=True, null=True)
  499. avg3 = models.FloatField(blank=True, null=True)
  500. avg0_name = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  501. avg1_name = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  502. avg2_name = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  503. avg3_name = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  504. class Meta:
  505. managed = False
  506. db_table = 'lot_summary'
  507. app_label = "legacy"
  508. class LotSummary20082018(models.Model):
  509. lot_no = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS')
  510. created_at = models.DateTimeField()
  511. avg = models.FloatField()
  512. code = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS')
  513. start_time = models.DateTimeField(blank=True, null=True)
  514. end_time = models.DateTimeField(blank=True, null=True)
  515. grade = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  516. machine_id = models.IntegerField(blank=True, null=True)
  517. avg0 = models.FloatField(blank=True, null=True)
  518. avg1 = models.FloatField(blank=True, null=True)
  519. avg2 = models.FloatField(blank=True, null=True)
  520. avg3 = models.FloatField(blank=True, null=True)
  521. avg0_name = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  522. avg1_name = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  523. avg2_name = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  524. avg3_name = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  525. class Meta:
  526. managed = False
  527. db_table = 'lot_summary (2008-2018)'
  528. app_label = "legacy"
  529. class LotSummaryRl(models.Model):
  530. lot_no = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS')
  531. created_at = models.DateTimeField()
  532. avg = models.FloatField()
  533. code = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS')
  534. start_time = models.DateTimeField(blank=True, null=True)
  535. end_time = models.DateTimeField(blank=True, null=True)
  536. grade = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  537. machine_id = models.IntegerField(blank=True, null=True)
  538. avg0 = models.FloatField(blank=True, null=True)
  539. avg1 = models.FloatField(blank=True, null=True)
  540. avg2 = models.FloatField(blank=True, null=True)
  541. avg3 = models.FloatField(blank=True, null=True)
  542. avg0_name = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  543. avg1_name = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  544. avg2_name = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  545. avg3_name = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  546. class Meta:
  547. managed = False
  548. db_table = 'lot_summary_rl'
  549. app_label = "legacy"
  550. class LotSummaryWb(models.Model):
  551. lot_no = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS')
  552. created_at = models.DateTimeField()
  553. w_avg = models.FloatField()
  554. wb_avg = models.FloatField()
  555. cp = models.FloatField()
  556. code = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS')
  557. start_time = models.DateTimeField(blank=True, null=True)
  558. end_time = models.DateTimeField(blank=True, null=True)
  559. machine_id = models.IntegerField(blank=True, null=True)
  560. class Meta:
  561. managed = False
  562. db_table = 'lot_summary_wb'
  563. app_label = "legacy"
  564. class Machinegroup(models.Model):
  565. 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.
  566. class Meta:
  567. managed = False
  568. db_table = 'machineGroup'
  569. app_label = "legacy"
  570. class Machines(models.Model):
  571. name = models.CharField(max_length=255, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  572. description = models.TextField(db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  573. created_at = models.DateTimeField(blank=True, null=True)
  574. updated_at = models.DateTimeField(blank=True, null=True)
  575. tag_name = models.TextField(db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  576. class Meta:
  577. managed = False
  578. db_table = 'machines'
  579. app_label = "legacy"
  580. class MachinesWb(models.Model):
  581. name = models.TextField(db_collation='SQL_Latin1_General_CP1_CI_AS')
  582. description = models.TextField(db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  583. created_at = models.DateTimeField()
  584. updated_at = models.DateTimeField(blank=True, null=True)
  585. tag_name = models.TextField(db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  586. ip = models.TextField(db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  587. isactive = models.BooleanField(db_column='isActive') # Field name made lowercase.
  588. machinestd = models.FloatField(db_column='machineStd', blank=True, null=True) # Field name made lowercase.
  589. groupid = models.ForeignKey(Machinegroup, models.DO_NOTHING, db_column='groupId', blank=True, null=True) # Field name made lowercase.
  590. class Meta:
  591. managed = False
  592. db_table = 'machines_wb'
  593. app_label = "legacy"
  594. class Manualsize(models.Model):
  595. 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.
  596. size_name = models.CharField(db_column='Size_Name', max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS') # Field name made lowercase.
  597. std = models.FloatField(db_column='Std', blank=True, null=True) # Field name made lowercase.
  598. tolun = models.FloatField(db_column='TolUn', blank=True, null=True) # Field name made lowercase.
  599. tolup = models.FloatField(db_column='TolUp', blank=True, null=True) # Field name made lowercase.
  600. created_at = models.DateTimeField()
  601. 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.
  602. class Meta:
  603. managed = False
  604. db_table = 'manualSize'
  605. unique_together = (('lotno', 'size_name'),)
  606. app_label = "legacy"
  607. class PressCal(models.Model):
  608. v0 = models.FloatField(blank=True, null=True)
  609. lot_no = models.CharField(primary_key=True, max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS')
  610. v1 = models.FloatField(blank=True, null=True)
  611. v2 = models.FloatField(blank=True, null=True)
  612. v3 = models.FloatField(blank=True, null=True)
  613. v4 = models.FloatField(blank=True, null=True)
  614. v5 = models.FloatField(blank=True, null=True)
  615. v6 = models.FloatField(blank=True, null=True)
  616. y0 = models.FloatField(blank=True, null=True)
  617. y1 = models.FloatField(blank=True, null=True)
  618. y2 = models.FloatField(blank=True, null=True)
  619. ac1 = models.FloatField(blank=True, null=True)
  620. ac2 = models.FloatField(blank=True, null=True)
  621. ac3 = models.FloatField(blank=True, null=True)
  622. ac4 = models.FloatField(blank=True, null=True)
  623. ac5 = models.FloatField(blank=True, null=True)
  624. ac6 = models.FloatField(blank=True, null=True)
  625. ac7 = models.FloatField(blank=True, null=True)
  626. r_result = models.FloatField(blank=True, null=True)
  627. created_at = models.DateTimeField(blank=True, null=True)
  628. updated_at = models.DateTimeField(blank=True, null=True)
  629. c0 = models.FloatField()
  630. class Meta:
  631. managed = False
  632. db_table = 'press_cal'
  633. app_label = "legacy"
  634. class RotateData(models.Model):
  635. row_no = models.IntegerField(blank=True, null=True)
  636. lot_no = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  637. code = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  638. speed_spec = models.FloatField(blank=True, null=True)
  639. speed_test = models.FloatField(blank=True, null=True)
  640. 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.
  641. qty = models.IntegerField()
  642. station_no = models.IntegerField()
  643. created_at = models.DateTimeField(blank=True, null=True)
  644. updated_at = models.DateTimeField(blank=True, null=True)
  645. machine_id = models.IntegerField(blank=True, null=True)
  646. emp_id = models.IntegerField()
  647. devid = models.CharField(max_length=40, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  648. mode = models.CharField(max_length=10, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  649. cal_mode = models.IntegerField(blank=True, null=True)
  650. class Meta:
  651. managed = False
  652. db_table = 'rotate_data'
  653. app_label = "legacy"
  654. class SchemaMigrations(models.Model):
  655. version = models.CharField(max_length=255, db_collation='SQL_Latin1_General_CP1_CI_AS')
  656. class Meta:
  657. managed = False
  658. db_table = 'schema_migrations'
  659. class SplitData(models.Model):
  660. data_ms = models.ForeignKey(DataMs, models.DO_NOTHING)
  661. v1 = models.FloatField(blank=True, null=True)
  662. v2 = models.FloatField(blank=True, null=True)
  663. v3 = models.FloatField(blank=True, null=True)
  664. v4 = models.FloatField(blank=True, null=True)
  665. v5 = models.FloatField(blank=True, null=True)
  666. unit = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  667. vr = models.FloatField(blank=True, null=True)
  668. vname = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  669. no = models.IntegerField()
  670. v1ok = models.CharField(max_length=20, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  671. v2ok = models.CharField(max_length=20, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  672. v3ok = models.CharField(max_length=20, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  673. v4ok = models.CharField(max_length=20, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  674. v5ok = models.CharField(max_length=20, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  675. vmax = models.FloatField(blank=True, null=True)
  676. vmin = models.FloatField(blank=True, null=True)
  677. vdiff = models.FloatField(blank=True, null=True)
  678. row_no = models.IntegerField(blank=True, null=True)
  679. class Meta:
  680. managed = False
  681. db_table = 'split_data'
  682. app_label = "legacy"
  683. class SysConfigs(models.Model):
  684. title = models.CharField(max_length=255, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  685. value = models.CharField(max_length=255, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  686. created_at = models.DateTimeField(blank=True, null=True)
  687. updated_at = models.DateTimeField(blank=True, null=True)
  688. class Meta:
  689. managed = False
  690. db_table = 'sys_configs'
  691. app_label = "legacy"
  692. class TbFgPressinfoLotlist(models.Model):
  693. 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.
  694. productcode = models.CharField(db_column='ProductCode', max_length=20, db_collation='SQL_Latin1_General_CP1_CI_AS') # Field name made lowercase.
  695. lotno = models.CharField(db_column='LotNo', max_length=20, db_collation='SQL_Latin1_General_CP1_CI_AS') # Field name made lowercase.
  696. lot_qty = models.FloatField(db_column='Lot_Qty', blank=True, null=True) # Field name made lowercase.
  697. def_qty = models.FloatField(db_column='Def_Qty', blank=True, null=True) # Field name made lowercase.
  698. fg_qty = models.FloatField(db_column='FG_Qty', blank=True, null=True) # Field name made lowercase.
  699. insp_date = models.DateTimeField(db_column='Insp_Date', blank=True, null=True) # Field name made lowercase.
  700. 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.
  701. 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.
  702. 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.
  703. class Meta:
  704. managed = False
  705. db_table = 'tb_fg_pressinfo_lotlist'
  706. unique_together = (('product_year', 'productcode', 'lotno'),)
  707. app_label = "legacy"
  708. class TbWbStdCode12(models.Model):
  709. id = models.IntegerField(db_column='ID', primary_key=True) # Field name made lowercase.
  710. u_weight = models.FloatField(db_column='U_Weight', blank=True, null=True) # Field name made lowercase.
  711. speed_from = models.FloatField(db_column='Speed_From', blank=True, null=True) # Field name made lowercase.
  712. speed_to = models.FloatField(db_column='Speed_To', blank=True, null=True) # Field name made lowercase.
  713. diameter_from = models.FloatField(db_column='Diameter_From', blank=True, null=True) # Field name made lowercase.
  714. diameter_to = models.FloatField(db_column='Diameter_To', blank=True, null=True) # Field name made lowercase.
  715. std_balance = models.FloatField(db_column='STD_Balance', blank=True, null=True) # Field name made lowercase.
  716. class Meta:
  717. managed = False
  718. db_table = 'tb_wb_std_code_1-2'
  719. app_label = "legacy"
  720. class TbWbStdCode345(models.Model):
  721. id = models.IntegerField(db_column='ID', primary_key=True) # Field name made lowercase.
  722. u_weight = models.FloatField(db_column='U_Weight', blank=True, null=True) # Field name made lowercase.
  723. speed_from = models.FloatField(db_column='Speed_From', blank=True, null=True) # Field name made lowercase.
  724. speed_to = models.FloatField(db_column='Speed_To', blank=True, null=True) # Field name made lowercase.
  725. diameter_from = models.FloatField(db_column='Diameter_From', blank=True, null=True) # Field name made lowercase.
  726. diameter_to = models.FloatField(db_column='Diameter_To', blank=True, null=True) # Field name made lowercase.
  727. std_balance = models.FloatField(db_column='STD_Balance', blank=True, null=True) # Field name made lowercase.
  728. class Meta:
  729. managed = False
  730. db_table = 'tb_wb_std_code_3-4-5'
  731. app_label = "legacy"
  732. class LegacyUsers(models.Model):
  733. email = models.CharField(max_length=255, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  734. password_digest = models.CharField(max_length=255, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  735. created_at = models.DateTimeField(blank=True, null=True)
  736. updated_at = models.DateTimeField(blank=True, null=True)
  737. roles_mask = models.IntegerField(blank=True, null=True)
  738. empid = models.CharField(max_length=255, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  739. fname = models.CharField(max_length=255, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  740. lname = models.CharField(max_length=255, db_collation='SQL_Latin1_General_CP1_CI_AS', blank=True, null=True)
  741. class Meta:
  742. managed = False
  743. db_table = 'users'
  744. app_label = "legacy"