API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 22nd, 2016
122
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 64.50 KB | None | 0 0
raw download clone embed print report
  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 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 __future__ import unicode_literals
  9.  
  10. from django.db import models
  11.  
  12.  
  13. class CutCutlists(models.Model):
  14. clid = models.AutoField(db_column='CLID') # Field name made lowercase.
  15. partnum = models.CharField(db_column='PARTNUM', max_length=35) # Field name made lowercase.
  16. rev = models.CharField(db_column='REV', max_length=3, blank=True, null=True) # Field name made lowercase.
  17. drawing = models.CharField(db_column='DRAWING', max_length=30) # Field name made lowercase.
  18. custid = models.IntegerField(db_column='CUSTID', blank=True, null=True) # Field name made lowercase.
  19. cdate = models.DateTimeField(db_column='CDATE', blank=True, null=True) # Field name made lowercase.
  20. descr = models.CharField(db_column='DESCR', max_length=50) # Field name made lowercase.
  21. length = models.TextField(db_column='LENGTH', blank=True, null=True) # Field name made lowercase. This field type is a guess.
  22. width = models.TextField(db_column='WIDTH', blank=True, null=True) # Field name made lowercase. This field type is a guess.
  23. height = models.TextField(db_column='HEIGHT', blank=True, null=True) # Field name made lowercase. This field type is a guess.
  24. setup_by = models.IntegerField(db_column='SETUP_BY', blank=True, null=True) # Field name made lowercase.
  25. state_by = models.IntegerField(db_column='STATE_BY', blank=True, null=True) # Field name made lowercase.
  26. stateid = models.IntegerField(db_column='STATEID', blank=True, null=True) # Field name made lowercase.
  27. clts = models.TextField(db_column='CLTS', blank=True, null=True) # Field name made lowercase. This field type is a guess.
  28.  
  29. class Meta:
  30. managed = False
  31. db_table = 'CUT_CUTLISTS'
  32.  
  33.  
  34. class CutCutlistParts(models.Model):
  35. clpartid = models.AutoField(db_column='CLPARTID') # Field name made lowercase.
  36. clid = models.IntegerField(db_column='CLID', blank=True, null=True) # Field name made lowercase.
  37. partid = models.IntegerField(db_column='PARTID', blank=True, null=True) # Field name made lowercase.
  38. matid = models.IntegerField(db_column='MATID', blank=True, null=True) # Field name made lowercase.
  39. edgeid_lf = models.IntegerField(db_column='EDGEID_LF', blank=True, null=True) # Field name made lowercase.
  40. edgeid_lb = models.IntegerField(db_column='EDGEID_LB', blank=True, null=True) # Field name made lowercase.
  41. edgeid_wr = models.IntegerField(db_column='EDGEID_WR', blank=True, null=True) # Field name made lowercase.
  42. edgeid_wl = models.IntegerField(db_column='EDGEID_WL', blank=True, null=True) # Field name made lowercase.
  43. qty = models.TextField(db_column='QTY', blank=True, null=True) # Field name made lowercase. This field type is a guess.
  44.  
  45. class Meta:
  46. managed = False
  47. db_table = 'CUT_CUTLIST_PARTS'
  48.  
  49.  
  50. class CutEdges(models.Model):
  51. edgeid = models.AutoField(db_column='EDGEID') # Field name made lowercase.
  52. partnum = models.CharField(db_column='PARTNUM', max_length=25, blank=True, null=True) # Field name made lowercase.
  53. descr = models.CharField(db_column='DESCR', max_length=50, blank=True, null=True) # Field name made lowercase.
  54. color = models.CharField(db_column='COLOR', max_length=50, blank=True, null=True) # Field name made lowercase.
  55. thickness = models.TextField(db_column='THICKNESS', blank=True, null=True) # Field name made lowercase. This field type is a guess.
  56. derived = models.BooleanField(db_column='DERIVED') # Field name made lowercase.
  57. matid = models.IntegerField(db_column='MATID', blank=True, null=True) # Field name made lowercase.
  58.  
  59. class Meta:
  60. managed = False
  61. db_table = 'CUT_EDGES'
  62.  
  63.  
  64. class CutEdgesXref(models.Model):
  65. edgeid = models.IntegerField(db_column='EDGEID') # Field name made lowercase.
  66. descr = models.CharField(db_column='DESCR', max_length=50, blank=True, null=True) # Field name made lowercase.
  67.  
  68. class Meta:
  69. managed = False
  70. db_table = 'CUT_EDGES_XREF'
  71.  
  72.  
  73. class CutJobs(models.Model):
  74. jobid = models.AutoField(db_column='JOBID') # Field name made lowercase.
  75. job = models.CharField(db_column='JOB', max_length=10, blank=True, null=True) # Field name made lowercase.
  76. op = models.IntegerField(db_column='OP', blank=True, null=True) # Field name made lowercase.
  77. date = models.DateTimeField(db_column='DATE', blank=True, null=True) # Field name made lowercase.
  78. clid = models.IntegerField(db_column='CLID', blank=True, null=True) # Field name made lowercase.
  79. partid = models.IntegerField(db_column='PARTID', blank=True, null=True) # Field name made lowercase.
  80. userid = models.IntegerField(db_column='USERID', blank=True, null=True) # Field name made lowercase.
  81.  
  82. class Meta:
  83. managed = False
  84. db_table = 'CUT_JOBS'
  85.  
  86.  
  87. class CutJobsIgnore(models.Model):
  88. ignid = models.AutoField(db_column='IGNID') # Field name made lowercase.
  89. igndate = models.DateTimeField(db_column='IGNDATE') # Field name made lowercase.
  90. ignusr = models.IntegerField(db_column='IGNUSR') # Field name made lowercase.
  91. ignjob = models.CharField(db_column='IGNJOB', max_length=10) # Field name made lowercase.
  92. ignop = models.IntegerField(db_column='IGNOP') # Field name made lowercase.
  93.  
  94. class Meta:
  95. managed = False
  96. db_table = 'CUT_JOBS_IGNORE'
  97.  
  98.  
  99. class CutJobsUserinc(models.Model):
  100. usrtypeid = models.AutoField(db_column='USRTYPEID') # Field name made lowercase.
  101. usruid = models.IntegerField(db_column='USRUID') # Field name made lowercase.
  102. usrwc = models.CharField(db_column='USRWC', max_length=7) # Field name made lowercase.
  103. usrtype = models.IntegerField(db_column='USRTYPE') # Field name made lowercase.
  104. usrinc = models.BooleanField(db_column='USRINC') # Field name made lowercase.
  105.  
  106. class Meta:
  107. managed = False
  108. db_table = 'CUT_JOBS_USERINC'
  109.  
  110.  
  111. class CutJobIgnore(models.Model):
  112. cjiid = models.AutoField(db_column='CJIID') # Field name made lowercase.
  113. cjijob = models.CharField(db_column='CJIJOB', max_length=10, blank=True, null=True) # Field name made lowercase.
  114. cjiop = models.IntegerField(db_column='CJIOP', blank=True, null=True) # Field name made lowercase.
  115.  
  116. class Meta:
  117. managed = False
  118. db_table = 'CUT_JOB_IGNORE'
  119.  
  120.  
  121. class CutJobJobinfo(models.Model):
  122. jinfid = models.AutoField(db_column='JINFID') # Field name made lowercase.
  123. jinfno = models.CharField(db_column='JINFNO', max_length=10, blank=True, null=True) # Field name made lowercase.
  124. jinfop = models.IntegerField(db_column='JINFOP', blank=True, null=True) # Field name made lowercase.
  125. jinfclid = models.IntegerField(db_column='JINFCLID', blank=True, null=True) # Field name made lowercase.
  126. jinfcts = models.DateTimeField(db_column='JINFCTS', blank=True, null=True) # Field name made lowercase.
  127. jinfcuid = models.IntegerField(db_column='JINFCUID', blank=True, null=True) # Field name made lowercase.
  128. jinfdwg = models.NullBooleanField(db_column='JINFDWG') # Field name made lowercase.
  129. jinfdts = models.DateTimeField(db_column='JINFDTS', blank=True, null=True) # Field name made lowercase.
  130. jinfduid = models.IntegerField(db_column='JINFDUID', blank=True, null=True) # Field name made lowercase.
  131. jinfdpath = models.CharField(db_column='JINFDPATH', max_length=255, blank=True, null=True) # Field name made lowercase.
  132.  
  133. class Meta:
  134. managed = False
  135. db_table = 'CUT_JOB_JOBINFO'
  136.  
  137.  
  138. class CutMachines(models.Model):
  139. machid = models.AutoField(db_column='MACHID') # Field name made lowercase.
  140. machnum = models.CharField(db_column='MACHNUM', max_length=12, blank=True, null=True) # Field name made lowercase.
  141. machname = models.CharField(db_column='MACHNAME', max_length=50, blank=True, null=True) # Field name made lowercase.
  142. nickname = models.CharField(db_column='NICKNAME', max_length=255, blank=True, null=True) # Field name made lowercase.
  143. type = models.CharField(db_column='TYPE', max_length=255, blank=True, null=True) # Field name made lowercase.
  144. loc = models.CharField(db_column='LOC', max_length=255, blank=True, null=True) # Field name made lowercase.
  145. msort = models.SmallIntegerField(db_column='MSORT', blank=True, null=True) # Field name made lowercase.
  146.  
  147. class Meta:
  148. managed = False
  149. db_table = 'CUT_MACHINES'
  150.  
  151.  
  152. class CutMachinePrograms(models.Model):
  153. progid = models.AutoField(db_column='PROGID') # Field name made lowercase.
  154. machid = models.IntegerField(db_column='MACHID', blank=True, null=True) # Field name made lowercase.
  155. partid = models.IntegerField(db_column='PARTID', blank=True, null=True) # Field name made lowercase.
  156. priority = models.SmallIntegerField(db_column='PRIORITY') # Field name made lowercase.
  157.  
  158. class Meta:
  159. managed = False
  160. db_table = 'CUT_MACHINE_PROGRAMS'
  161.  
  162.  
  163. class CutMaterials(models.Model):
  164. matid = models.AutoField(db_column='MATID') # Field name made lowercase.
  165. descr = models.CharField(db_column='DESCR', max_length=45) # Field name made lowercase.
  166. color = models.CharField(db_column='COLOR', max_length=40, blank=True, null=True) # Field name made lowercase.
  167. thickness = models.TextField(db_column='THICKNESS') # Field name made lowercase. This field type is a guess.
  168. grain = models.BooleanField(db_column='GRAIN') # Field name made lowercase.
  169. type = models.CharField(db_column='TYPE', max_length=5) # Field name made lowercase.
  170. old_descr = models.CharField(db_column='OLD_DESCR', max_length=45, blank=True, null=True) # Field name made lowercase.
  171.  
  172. class Meta:
  173. managed = False
  174. db_table = 'CUT_MATERIALS'
  175.  
  176.  
  177. class CutMaterialSizes(models.Model):
  178. sheetid = models.AutoField(db_column='SHEETID') # Field name made lowercase.
  179. matid = models.IntegerField(db_column='MATID', blank=True, null=True) # Field name made lowercase.
  180. partnum = models.CharField(db_column='PARTNUM', max_length=25, blank=True, null=True) # Field name made lowercase.
  181. length = models.TextField(db_column='LENGTH', blank=True, null=True) # Field name made lowercase. This field type is a guess.
  182. width = models.TextField(db_column='WIDTH', blank=True, null=True) # Field name made lowercase. This field type is a guess.
  183. top_t = models.TextField(db_column='TOP_T', blank=True, null=True) # Field name made lowercase. This field type is a guess.
  184. right_t = models.TextField(db_column='RIGHT_T', blank=True, null=True) # Field name made lowercase. This field type is a guess.
  185. btm_t = models.TextField(db_column='BTM_T', blank=True, null=True) # Field name made lowercase. This field type is a guess.
  186. left_t = models.TextField(db_column='LEFT_T', blank=True, null=True) # Field name made lowercase. This field type is a guess.
  187.  
  188. class Meta:
  189. managed = False
  190. db_table = 'CUT_MATERIAL_SIZES'
  191.  
  192.  
  193. class CutOps(models.Model):
  194. opid = models.AutoField(db_column='OPID') # Field name made lowercase.
  195. opname = models.CharField(db_column='OPNAME', max_length=3, blank=True, null=True) # Field name made lowercase.
  196. opdescr = models.CharField(db_column='OPDESCR', max_length=35, blank=True, null=True) # Field name made lowercase.
  197. optype = models.IntegerField(db_column='OPTYPE', blank=True, null=True) # Field name made lowercase.
  198.  
  199. class Meta:
  200. managed = False
  201. db_table = 'CUT_OPS'
  202.  
  203.  
  204. class CutParts(models.Model):
  205. partid = models.AutoField(db_column='PARTID') # Field name made lowercase.
  206. partnum = models.CharField(db_column='PARTNUM', max_length=25) # Field name made lowercase.
  207. descr = models.CharField(db_column='DESCR', max_length=35, blank=True, null=True) # Field name made lowercase.
  208. fin_l = models.TextField(db_column='FIN_L') # Field name made lowercase. This field type is a guess.
  209. fin_w = models.TextField(db_column='FIN_W') # Field name made lowercase. This field type is a guess.
  210. thickness = models.TextField(db_column='THICKNESS') # Field name made lowercase. This field type is a guess.
  211. cnc1 = models.CharField(db_column='CNC1', max_length=25, blank=True, null=True) # Field name made lowercase.
  212. cnc2 = models.CharField(db_column='CNC2', max_length=25, blank=True, null=True) # Field name made lowercase.
  213. blankqty = models.IntegerField(db_column='BLANKQTY') # Field name made lowercase.
  214. over_l = models.TextField(db_column='OVER_L', blank=True, null=True) # Field name made lowercase. This field type is a guess.
  215. over_w = models.TextField(db_column='OVER_W', blank=True, null=True) # Field name made lowercase. This field type is a guess.
  216. op1id = models.IntegerField(db_column='OP1ID', blank=True, null=True) # Field name made lowercase.
  217. op2id = models.IntegerField(db_column='OP2ID', blank=True, null=True) # Field name made lowercase.
  218. op3id = models.IntegerField(db_column='OP3ID', blank=True, null=True) # Field name made lowercase.
  219. op4id = models.IntegerField(db_column='OP4ID', blank=True, null=True) # Field name made lowercase.
  220. op5id = models.IntegerField(db_column='OP5ID', blank=True, null=True) # Field name made lowercase.
  221. comment = models.CharField(db_column='COMMENT', max_length=105, blank=True, null=True) # Field name made lowercase.
  222. update_cnc = models.BooleanField(db_column='UPDATE_CNC') # Field name made lowercase.
  223. type = models.IntegerField(db_column='TYPE', blank=True, null=True) # Field name made lowercase.
  224. hash = models.IntegerField(db_column='HASH', blank=True, null=True) # Field name made lowercase.
  225.  
  226. class Meta:
  227. managed = False
  228. db_table = 'CUT_PARTS'
  229.  
  230.  
  231. class CutPartRepTypes(models.Model):
  232. reptypeid = models.SmallIntegerField(db_column='REPTYPEID') # Field name made lowercase.
  233. reptypedesc = models.CharField(db_column='REPTYPEDESC', max_length=20, blank=True, null=True) # Field name made lowercase.
  234.  
  235. class Meta:
  236. managed = False
  237. db_table = 'CUT_PART_REP_TYPES'
  238.  
  239.  
  240. class CutPartTypes(models.Model):
  241. typeid = models.AutoField(db_column='TYPEID') # Field name made lowercase.
  242. typedesc = models.CharField(db_column='TYPEDESC', max_length=20, blank=True, null=True) # Field name made lowercase.
  243. typeinc = models.BooleanField(db_column='TYPEINC') # Field name made lowercase.
  244. typerep = models.IntegerField(db_column='TYPEREP', blank=True, null=True) # Field name made lowercase.
  245.  
  246. class Meta:
  247. managed = False
  248. db_table = 'CUT_PART_TYPES'
  249.  
  250.  
  251. class CutStates(models.Model):
  252. id = models.AutoField(db_column='ID') # Field name made lowercase.
  253. state = models.CharField(db_column='STATE', max_length=15, blank=True, null=True) # Field name made lowercase.
  254. statenumber = models.IntegerField(db_column='STATENUMBER', blank=True, null=True) # Field name made lowercase.
  255.  
  256. class Meta:
  257. managed = False
  258. db_table = 'CUT_STATES'
  259.  
  260.  
  261. class EcrBom(models.Model):
  262. bom_id = models.AutoField(db_column='BOM_ID') # Field name made lowercase.
  263. item_id = models.IntegerField(db_column='ITEM_ID', blank=True, null=True) # Field name made lowercase.
  264. bompart = models.CharField(db_column='BOMPART', max_length=50, blank=True, null=True) # Field name made lowercase.
  265. bomrev = models.CharField(db_column='BOMREV', max_length=3, blank=True, null=True) # Field name made lowercase.
  266. qty_before = models.DecimalField(db_column='QTY_BEFORE', max_digits=15, decimal_places=5, blank=True, null=True) # Field name made lowercase.
  267. qty_after = models.DecimalField(db_column='QTY_AFTER', max_digits=15, decimal_places=5, blank=True, null=True) # Field name made lowercase.
  268.  
  269. class Meta:
  270. managed = False
  271. db_table = 'ECR_BOM'
  272.  
  273.  
  274. class EcrBomItems(models.Model):
  275. itembid = models.AutoField(db_column='ITEMBID') # Field name made lowercase.
  276. item_id = models.IntegerField(db_column='ITEM_ID', blank=True, null=True) # Field name made lowercase.
  277. cpart = models.CharField(db_column='CPART', max_length=25, blank=True, null=True) # Field name made lowercase.
  278. crev = models.CharField(db_column='CREV', max_length=3, blank=True, null=True) # Field name made lowercase.
  279. cdesc = models.CharField(db_column='CDESC', max_length=35, blank=True, null=True) # Field name made lowercase.
  280. cqty = models.DecimalField(db_column='CQTY', max_digits=14, decimal_places=5, blank=True, null=True) # Field name made lowercase.
  281. cuom = models.CharField(db_column='CUOM', max_length=3, blank=True, null=True) # Field name made lowercase.
  282. before = models.NullBooleanField(db_column='BEFORE') # Field name made lowercase.
  283.  
  284. class Meta:
  285. managed = False
  286. db_table = 'ECR_BOM_ITEMS'
  287.  
  288.  
  289. class EcrDrawings(models.Model):
  290. draw_id = models.AutoField(db_column='DRAW_ID') # Field name made lowercase.
  291. item_id = models.IntegerField(db_column='ITEM_ID', blank=True, null=True) # Field name made lowercase.
  292. file_id = models.IntegerField(db_column='FILE_ID', blank=True, null=True) # Field name made lowercase.
  293. drwrev = models.CharField(db_column='DRWREV', max_length=2, blank=True, null=True) # Field name made lowercase.
  294. orig_path = models.CharField(db_column='ORIG_PATH', max_length=255, blank=True, null=True) # Field name made lowercase.
  295. drw_file = models.CharField(db_column='DRW_FILE', max_length=255, blank=True, null=True) # Field name made lowercase.
  296.  
  297. class Meta:
  298. managed = False
  299. db_table = 'ECR_DRAWINGS'
  300.  
  301.  
  302. class EcrEng(models.Model):
  303. eng_id = models.AutoField(db_column='ENG_ID') # Field name made lowercase.
  304. ecr_num = models.IntegerField(db_column='ECR_NUM', blank=True, null=True) # Field name made lowercase.
  305. eng_num = models.IntegerField(db_column='ENG_NUM', blank=True, null=True) # Field name made lowercase.
  306. type = models.IntegerField(db_column='TYPE', blank=True, null=True) # Field name made lowercase.
  307.  
  308. class Meta:
  309. managed = False
  310. db_table = 'ECR_ENG'
  311.  
  312.  
  313. class EcrEngTypes(models.Model):
  314. type_id = models.AutoField(db_column='TYPE_ID') # Field name made lowercase.
  315. type = models.CharField(db_column='TYPE', max_length=20, blank=True, null=True) # Field name made lowercase.
  316.  
  317. class Meta:
  318. managed = False
  319. db_table = 'ECR_ENG_TYPES'
  320.  
  321.  
  322. class EcrErrTypes(models.Model):
  323. errid = models.AutoField(db_column='ERRID') # Field name made lowercase.
  324. errname = models.CharField(db_column='ERRNAME', max_length=20, blank=True, null=True) # Field name made lowercase.
  325.  
  326. class Meta:
  327. managed = False
  328. db_table = 'ECR_ERR_TYPES'
  329.  
  330.  
  331. class EcrHolders(models.Model):
  332. hldr_id = models.AutoField(db_column='HLDR_ID') # Field name made lowercase.
  333. ecr_num = models.IntegerField(db_column='ECR_NUM', blank=True, null=True) # Field name made lowercase.
  334. priority = models.IntegerField(db_column='PRIORITY', blank=True, null=True) # Field name made lowercase.
  335. status = models.IntegerField(db_column='STATUS', blank=True, null=True) # Field name made lowercase.
  336. dept = models.IntegerField(db_column='DEPT', blank=True, null=True) # Field name made lowercase.
  337. holder = models.IntegerField(db_column='HOLDER', blank=True, null=True) # Field name made lowercase.
  338. comment = models.CharField(db_column='COMMENT', max_length=255, blank=True, null=True) # Field name made lowercase.
  339. holder_note = models.CharField(db_column='HOLDER_NOTE', max_length=255, blank=True, null=True) # Field name made lowercase.
  340. signee = models.IntegerField(db_column='SIGNEE', blank=True, null=True) # Field name made lowercase.
  341. signoff = models.DateTimeField(db_column='SIGNOFF', blank=True, null=True) # Field name made lowercase.
  342. compname = models.CharField(db_column='COMPNAME', max_length=15, blank=True, null=True) # Field name made lowercase.
  343. active = models.DateTimeField(db_column='ACTIVE', blank=True, null=True) # Field name made lowercase.
  344. notified = models.NullBooleanField(db_column='NOTIFIED') # Field name made lowercase.
  345.  
  346. class Meta:
  347. managed = False
  348. db_table = 'ECR_HOLDERS'
  349.  
  350.  
  351. class EcrHolderStatus(models.Model):
  352. hstat_id = models.AutoField(db_column='HSTAT_ID') # Field name made lowercase.
  353. status = models.CharField(db_column='STATUS', max_length=20, blank=True, null=True) # Field name made lowercase.
  354.  
  355. class Meta:
  356. managed = False
  357. db_table = 'ECR_HOLDER_STATUS'
  358.  
  359.  
  360. class EcrItems(models.Model):
  361. item_id = models.AutoField(db_column='ITEM_ID') # Field name made lowercase.
  362. ecr_num = models.IntegerField(db_column='ECR_NUM', blank=True, null=True) # Field name made lowercase.
  363. itemnumber = models.CharField(db_column='ITEMNUMBER', max_length=255, blank=True, null=True) # Field name made lowercase.
  364. itemrev = models.CharField(db_column='ITEMREV', max_length=255, blank=True, null=True) # Field name made lowercase.
  365. type = models.IntegerField(db_column='TYPE', blank=True, null=True) # Field name made lowercase.
  366. item_note = models.CharField(db_column='ITEM_NOTE', max_length=255, blank=True, null=True) # Field name made lowercase.
  367. im_chk = models.BooleanField(db_column='IM_CHK') # Field name made lowercase.
  368. im_change = models.CharField(db_column='IM_CHANGE', max_length=255, blank=True, null=True) # Field name made lowercase.
  369. rtg_chk = models.BooleanField(db_column='RTG_CHK') # Field name made lowercase.
  370. rtg_change = models.CharField(db_column='RTG_CHANGE', max_length=255, blank=True, null=True) # Field name made lowercase.
  371.  
  372. class Meta:
  373. managed = False
  374. db_table = 'ECR_ITEMS'
  375.  
  376.  
  377. class EcrItemTypes(models.Model):
  378. itemtype_id = models.AutoField(db_column='ITEMTYPE_ID') # Field name made lowercase.
  379. type = models.CharField(db_column='TYPE', max_length=20, blank=True, null=True) # Field name made lowercase.
  380. bom_flag = models.BooleanField(db_column='BOM_FLAG') # Field name made lowercase.
  381. m2m_flag = models.BooleanField(db_column='M2M_FLAG') # Field name made lowercase.
  382.  
  383. class Meta:
  384. managed = False
  385. db_table = 'ECR_ITEM_TYPES'
  386.  
  387.  
  388. class EcrLegacy(models.Model):
  389. lgcyid = models.AutoField(db_column='LGCYID') # Field name made lowercase.
  390. ecrnum = models.CharField(db_column='ECRNum', max_length=255, blank=True, null=True) # Field name made lowercase.
  391. daterequested = models.DateTimeField(db_column='DateRequested', blank=True, null=True) # Field name made lowercase.
  392. datestarted = models.DateTimeField(db_column='DateStarted', blank=True, null=True) # Field name made lowercase.
  393. datecompleted = models.DateTimeField(db_column='DateCompleted', blank=True, null=True) # Field name made lowercase.
  394. affectedparts = models.CharField(db_column='AffectedParts', max_length=255, blank=True, null=True) # Field name made lowercase.
  395. change = models.CharField(db_column='Change', max_length=255, blank=True, null=True) # Field name made lowercase.
  396. engineer = models.CharField(db_column='Engineer', max_length=255, blank=True, null=True) # Field name made lowercase.
  397. holder = models.CharField(db_column='Holder', max_length=255, blank=True, null=True) # Field name made lowercase.
  398.  
  399. class Meta:
  400. managed = False
  401. db_table = 'ECR_LEGACY'
  402.  
  403.  
  404. class EcrMain(models.Model):
  405. ecr_num = models.IntegerField(db_column='ECR_NUM') # Field name made lowercase.
  406. reqid = models.IntegerField(db_column='REQID', blank=True, null=True) # Field name made lowercase.
  407. date_create = models.DateTimeField(db_column='DATE_CREATE', blank=True, null=True) # Field name made lowercase.
  408. date_req = models.DateTimeField(db_column='DATE_REQ', blank=True, null=True) # Field name made lowercase.
  409. date_eng = models.DateTimeField(db_column='DATE_ENG', blank=True, null=True) # Field name made lowercase.
  410. date_fin = models.DateTimeField(db_column='DATE_FIN', blank=True, null=True) # Field name made lowercase.
  411. req_by = models.IntegerField(db_column='REQ_BY', blank=True, null=True) # Field name made lowercase.
  412. changes = models.TextField(db_column='CHANGES', blank=True, null=True) # Field name made lowercase.
  413. status = models.IntegerField(db_column='STATUS', blank=True, null=True) # Field name made lowercase.
  414. chk_err = models.BooleanField(db_column='CHK_ERR') # Field name made lowercase.
  415. err_type = models.IntegerField(db_column='ERR_TYPE', blank=True, null=True) # Field name made lowercase.
  416. err_desc = models.TextField(db_column='ERR_DESC', blank=True, null=True) # Field name made lowercase.
  417. chk_inv = models.BooleanField(db_column='CHK_INV') # Field name made lowercase.
  418. mat_coord = models.IntegerField(db_column='MAT_COORD', blank=True, null=True) # Field name made lowercase.
  419. mat_note = models.TextField(db_column='MAT_NOTE', blank=True, null=True) # Field name made lowercase.
  420. chk_im = models.BooleanField(db_column='CHK_IM') # Field name made lowercase.
  421. chk_bom = models.BooleanField(db_column='CHK_BOM') # Field name made lowercase.
  422. chk_rtg = models.BooleanField(db_column='CHK_RTG') # Field name made lowercase.
  423. chk_cut = models.BooleanField(db_column='CHK_CUT') # Field name made lowercase.
  424. chk_cnc = models.BooleanField(db_column='CHK_CNC') # Field name made lowercase.
  425. chk_drw = models.BooleanField(db_column='CHK_DRW') # Field name made lowercase.
  426. chk_ul = models.BooleanField(db_column='CHK_UL') # Field name made lowercase.
  427. chk_ins = models.BooleanField(db_column='CHK_INS') # Field name made lowercase.
  428. chk_pro = models.BooleanField(db_column='CHK_PRO') # Field name made lowercase.
  429. revision = models.TextField(db_column='REVISION', blank=True, null=True) # Field name made lowercase.
  430.  
  431. class Meta:
  432. managed = False
  433. db_table = 'ECR_MAIN'
  434.  
  435.  
  436. class EcrSavedHolders(models.Model):
  437. shid = models.AutoField(db_column='SHID') # Field name made lowercase.
  438. user = models.IntegerField(db_column='USER', blank=True, null=True) # Field name made lowercase.
  439. preset = models.IntegerField(db_column='PRESET', blank=True, null=True) # Field name made lowercase.
  440. priority = models.IntegerField(db_column='PRIORITY', blank=True, null=True) # Field name made lowercase.
  441. dept = models.IntegerField(db_column='DEPT', blank=True, null=True) # Field name made lowercase.
  442. holder = models.IntegerField(db_column='HOLDER', blank=True, null=True) # Field name made lowercase.
  443. comment = models.CharField(db_column='COMMENT', max_length=255, blank=True, null=True) # Field name made lowercase.
  444.  
  445. class Meta:
  446. managed = False
  447. db_table = 'ECR_SAVED_HOLDERS'
  448.  
  449.  
  450. class EcrStatus(models.Model):
  451. stat_id = models.AutoField(db_column='STAT_ID') # Field name made lowercase.
  452. status = models.CharField(db_column='STATUS', max_length=20, blank=True, null=True) # Field name made lowercase.
  453.  
  454. class Meta:
  455. managed = False
  456. db_table = 'ECR_STATUS'
  457.  
  458.  
  459. class FileExtensions(models.Model):
  460. extid = models.AutoField(db_column='EXTID') # Field name made lowercase.
  461. extension = models.CharField(db_column='EXTENSION', max_length=10, blank=True, null=True) # Field name made lowercase.
  462. ftypeid = models.IntegerField(db_column='FTYPEID', blank=True, null=True) # Field name made lowercase.
  463.  
  464. class Meta:
  465. managed = False
  466. db_table = 'FILE_EXTENSIONS'
  467.  
  468.  
  469. class FileFolder(models.Model):
  470. type = models.IntegerField(db_column='Type') # Field name made lowercase.
  471. path = models.CharField(db_column='Path', max_length=255, blank=True, null=True) # Field name made lowercase.
  472. description = models.CharField(db_column='DESCRIPTION', max_length=100, blank=True, null=True) # Field name made lowercase.
  473.  
  474. class Meta:
  475. managed = False
  476. db_table = 'FILE_FOLDER'
  477.  
  478.  
  479. class FileMain(models.Model):
  480. fileid = models.AutoField(db_column='FILEID') # Field name made lowercase.
  481. ext = models.CharField(db_column='EXT', max_length=10, blank=True, null=True) # Field name made lowercase.
  482. filename = models.CharField(db_column='FILENAME', max_length=255, blank=True, null=True) # Field name made lowercase.
  483. comment = models.CharField(db_column='COMMENT', max_length=255, blank=True, null=True) # Field name made lowercase.
  484.  
  485. class Meta:
  486. managed = False
  487. db_table = 'FILE_MAIN'
  488.  
  489.  
  490. class FileTypes(models.Model):
  491. ftypeid = models.AutoField(db_column='FTYPEID') # Field name made lowercase.
  492. ftype = models.CharField(db_column='FTYPE', max_length=25, blank=True, null=True) # Field name made lowercase.
  493. fdesc = models.CharField(db_column='FDESC', max_length=100, blank=True, null=True) # Field name made lowercase.
  494. ficon = models.CharField(db_column='FICON', max_length=25, blank=True, null=True) # Field name made lowercase.
  495. fdanger = models.BooleanField(db_column='FDANGER') # Field name made lowercase.
  496.  
  497. class Meta:
  498. managed = False
  499. db_table = 'FILE_TYPES'
  500.  
  501.  
  502. class FixFixtures(models.Model):
  503. fixid = models.CharField(db_column='FIXID', max_length=10) # Field name made lowercase.
  504. prefix = models.CharField(db_column='PREFIX', max_length=4, blank=True, null=True) # Field name made lowercase.
  505. custpn = models.CharField(db_column='CUSTPN', max_length=40, blank=True, null=True) # Field name made lowercase.
  506. fixdesc = models.CharField(db_column='FIXDESC', max_length=100, blank=True, null=True) # Field name made lowercase.
  507. cdate = models.DateTimeField(db_column='CDATE', blank=True, null=True) # Field name made lowercase.
  508. user = models.IntegerField(db_column='USER', blank=True, null=True) # Field name made lowercase.
  509. statid = models.IntegerField(db_column='STATID', blank=True, null=True) # Field name made lowercase.
  510. fixyear = models.CharField(db_column='FIXYEAR', max_length=2, blank=True, null=True) # Field name made lowercase.
  511.  
  512. class Meta:
  513. managed = False
  514. db_table = 'FIX_FIXTURES'
  515.  
  516.  
  517. class FixMain(models.Model):
  518. fixid = models.AutoField(db_column='FIXID') # Field name made lowercase.
  519. fixams = models.CharField(db_column='FIXAMS', max_length=25, blank=True, null=True) # Field name made lowercase.
  520. fixcust = models.CharField(db_column='FIXCUST', max_length=25, blank=True, null=True) # Field name made lowercase.
  521. fixdescr = models.CharField(db_column='FIXDESCR', max_length=50, blank=True, null=True) # Field name made lowercase.
  522. fixproj = models.IntegerField(db_column='FIXPROJ', blank=True, null=True) # Field name made lowercase.
  523. fixyear = models.CharField(db_column='FIXYEAR', max_length=4, blank=True, null=True) # Field name made lowercase.
  524. fixuser = models.IntegerField(db_column='FIXUSER', blank=True, null=True) # Field name made lowercase.
  525. fixsub = models.NullBooleanField(db_column='FIXSUB') # Field name made lowercase.
  526. fixparent = models.IntegerField(db_column='FIXPARENT', blank=True, null=True) # Field name made lowercase.
  527. fixreq = models.IntegerField(db_column='FIXREQ', blank=True, null=True) # Field name made lowercase.
  528.  
  529. class Meta:
  530. managed = False
  531. db_table = 'FIX_MAIN'
  532.  
  533.  
  534. class FixStatus(models.Model):
  535. statid = models.IntegerField(db_column='STATID') # Field name made lowercase.
  536. status = models.CharField(db_column='STATUS', max_length=20, blank=True, null=True) # Field name made lowercase.
  537.  
  538. class Meta:
  539. managed = False
  540. db_table = 'FIX_STATUS'
  541.  
  542.  
  543. class GenAbsent(models.Model):
  544. id = models.AutoField(db_column='ID') # Field name made lowercase.
  545. uid = models.IntegerField(db_column='UID', blank=True, null=True) # Field name made lowercase.
  546. adate = models.DateTimeField(db_column='ADATE', blank=True, null=True) # Field name made lowercase.
  547. hours = models.TextField(db_column='HOURS', blank=True, null=True) # Field name made lowercase. This field type is a guess.
  548. type = models.IntegerField(db_column='TYPE', blank=True, null=True) # Field name made lowercase.
  549. comment = models.CharField(db_column='COMMENT', max_length=255, blank=True, null=True) # Field name made lowercase.
  550.  
  551. class Meta:
  552. managed = False
  553. db_table = 'GEN_ABSENT'
  554.  
  555.  
  556. class GenAbsentTypes(models.Model):
  557. type_id = models.AutoField(db_column='TYPE_ID') # Field name made lowercase.
  558. description = models.CharField(db_column='DESCRIPTION', max_length=20, blank=True, null=True) # Field name made lowercase.
  559.  
  560. class Meta:
  561. managed = False
  562. db_table = 'GEN_ABSENT_TYPES'
  563.  
  564.  
  565. class GenAccessLevels(models.Model):
  566. alevel = models.IntegerField(db_column='ALEVEL') # Field name made lowercase.
  567. aname = models.CharField(db_column='ANAME', max_length=255, blank=True, null=True) # Field name made lowercase.
  568.  
  569. class Meta:
  570. managed = False
  571. db_table = 'GEN_ACCESS_LEVELS'
  572.  
  573.  
  574. class GenAlerts(models.Model):
  575. alertid = models.AutoField(db_column='ALERTID') # Field name made lowercase.
  576. alertdate = models.DateTimeField(db_column='ALERTDATE') # Field name made lowercase.
  577. alerttype = models.IntegerField(db_column='ALERTTYPE') # Field name made lowercase.
  578. alertdesc = models.CharField(db_column='ALERTDESC', max_length=50, blank=True, null=True) # Field name made lowercase.
  579. alertmsg = models.CharField(db_column='ALERTMSG', max_length=255, blank=True, null=True) # Field name made lowercase.
  580. alertkeycol = models.IntegerField(db_column='ALERTKEYCOL', blank=True, null=True) # Field name made lowercase.
  581. alertchk = models.BooleanField(db_column='ALERTCHK') # Field name made lowercase.
  582.  
  583. class Meta:
  584. managed = False
  585. db_table = 'GEN_ALERTS'
  586.  
  587.  
  588. class GenBanner(models.Model):
  589. banid = models.AutoField(db_column='BANID') # Field name made lowercase.
  590. banstdt = models.DateTimeField(db_column='BANSTDT', blank=True, null=True) # Field name made lowercase.
  591. banendt = models.DateTimeField(db_column='BANENDT', blank=True, null=True) # Field name made lowercase.
  592. banname = models.CharField(db_column='BANNAME', max_length=25, blank=True, null=True) # Field name made lowercase.
  593. banpath = models.CharField(db_column='BANPATH', max_length=255) # Field name made lowercase.
  594.  
  595. class Meta:
  596. managed = False
  597. db_table = 'GEN_BANNER'
  598.  
  599.  
  600. class GenChanges(models.Model):
  601. changeid = models.AutoField(db_column='CHANGEID') # Field name made lowercase.
  602. verid = models.IntegerField(db_column='VERID', blank=True, null=True) # Field name made lowercase.
  603. cat = models.CharField(db_column='CAT', max_length=50, blank=True, null=True) # Field name made lowercase.
  604. title = models.CharField(db_column='TITLE', max_length=50, blank=True, null=True) # Field name made lowercase.
  605. info = models.TextField(db_column='INFO', blank=True, null=True) # Field name made lowercase.
  606.  
  607. class Meta:
  608. managed = False
  609. db_table = 'GEN_CHANGES'
  610.  
  611.  
  612. class GenChat(models.Model):
  613. msgid = models.AutoField(db_column='MSGID') # Field name made lowercase.
  614. type = models.IntegerField(db_column='TYPE', blank=True, null=True) # Field name made lowercase.
  615. item = models.IntegerField(db_column='ITEM', blank=True, null=True) # Field name made lowercase.
  616. cuser = models.IntegerField(db_column='CUSER', blank=True, null=True) # Field name made lowercase.
  617. cdate = models.DateTimeField(db_column='CDATE', blank=True, null=True) # Field name made lowercase.
  618. euser = models.IntegerField(db_column='EUSER', blank=True, null=True) # Field name made lowercase.
  619. edate = models.DateTimeField(db_column='EDATE', blank=True, null=True) # Field name made lowercase.
  620. body = models.CharField(db_column='BODY', max_length=255, blank=True, null=True) # Field name made lowercase.
  621.  
  622. class Meta:
  623. managed = False
  624. db_table = 'GEN_CHAT'
  625.  
  626.  
  627. class GenChatTypes(models.Model):
  628. ctid = models.IntegerField(db_column='CTID') # Field name made lowercase.
  629. ctype = models.CharField(db_column='CTYPE', max_length=25, blank=True, null=True) # Field name made lowercase.
  630. ctbl = models.CharField(db_column='CTBL', max_length=50, blank=True, null=True) # Field name made lowercase.
  631.  
  632. class Meta:
  633. managed = False
  634. db_table = 'GEN_CHAT_TYPES'
  635.  
  636.  
  637. class GenCustomers(models.Model):
  638. custid = models.AutoField(db_column='CUSTID') # Field name made lowercase.
  639. custnum = models.IntegerField(db_column='CUSTNUM', blank=True, null=True) # Field name made lowercase.
  640. customer = models.CharField(db_column='CUSTOMER', max_length=40, blank=True, null=True) # Field name made lowercase.
  641. custactive = models.BooleanField(db_column='CUSTACTIVE') # Field name made lowercase.
  642. custlead = models.IntegerField(db_column='CUSTLEAD', blank=True, null=True) # Field name made lowercase.
  643. custprjmgr = models.IntegerField(db_column='CUSTPRJMGR', blank=True, null=True) # Field name made lowercase.
  644. custshort = models.CharField(db_column='CUSTSHORT', max_length=40, blank=True, null=True) # Field name made lowercase.
  645. custpre = models.CharField(db_column='CUSTPRE', max_length=2, blank=True, null=True) # Field name made lowercase.
  646. custpath = models.CharField(db_column='CUSTPATH', max_length=255, blank=True, null=True) # Field name made lowercase.
  647.  
  648. class Meta:
  649. managed = False
  650. db_table = 'GEN_CUSTOMERS'
  651.  
  652.  
  653. class GenDepts(models.Model):
  654. dept_id = models.AutoField(db_column='DEPT_ID') # Field name made lowercase.
  655. dept_name = models.CharField(db_column='DEPT_NAME', max_length=25, blank=True, null=True) # Field name made lowercase.
  656. dept_prior = models.IntegerField(db_column='DEPT_PRIOR', blank=True, null=True) # Field name made lowercase.
  657. dept_lead = models.IntegerField(db_column='DEPT_LEAD', blank=True, null=True) # Field name made lowercase.
  658. dept_hours = models.IntegerField(db_column='DEPT_HOURS', blank=True, null=True) # Field name made lowercase.
  659. dept_staff = models.DecimalField(db_column='DEPT_STAFF', max_digits=9, decimal_places=5, blank=True, null=True) # Field name made lowercase.
  660. dept_attr = models.DecimalField(db_column='DEPT_ATTR', max_digits=9, decimal_places=5, blank=True, null=True) # Field name made lowercase.
  661. dept_ecr = models.IntegerField(db_column='DEPT_ECR', blank=True, null=True) # Field name made lowercase.
  662.  
  663. class Meta:
  664. managed = False
  665. db_table = 'GEN_DEPTS'
  666.  
  667.  
  668. class GenDrawings(models.Model):
  669. fileid = models.AutoField(db_column='FileID') # Field name made lowercase.
  670. fname = models.CharField(db_column='FName', max_length=50, blank=True, null=True) # Field name made lowercase.
  671. fpath = models.CharField(db_column='FPath', max_length=255, blank=True, null=True) # Field name made lowercase.
  672. datecreated = models.DateTimeField(db_column='DateCreated', blank=True, null=True) # Field name made lowercase.
  673.  
  674. class Meta:
  675. managed = False
  676. db_table = 'GEN_DRAWINGS'
  677.  
  678.  
  679. class GenDrawingsMtl(models.Model):
  680. fileid = models.AutoField(db_column='FileID') # Field name made lowercase.
  681. fname = models.CharField(db_column='FName', max_length=50, blank=True, null=True) # Field name made lowercase.
  682. fpath = models.CharField(db_column='FPath', max_length=255, blank=True, null=True) # Field name made lowercase.
  683. datecreated = models.DateTimeField(db_column='DateCreated', blank=True, null=True) # Field name made lowercase.
  684.  
  685. class Meta:
  686. managed = False
  687. db_table = 'GEN_DRAWINGS_MTL'
  688.  
  689.  
  690. class GenErrors(models.Model):
  691. errid = models.AutoField(db_column='ERRID') # Field name made lowercase.
  692. errdate = models.DateTimeField(db_column='ERRDATE', blank=True, null=True) # Field name made lowercase.
  693. erruser = models.IntegerField(db_column='ERRUSER', blank=True, null=True) # Field name made lowercase.
  694. errnum = models.IntegerField(db_column='ERRNUM', blank=True, null=True) # Field name made lowercase.
  695. errmsg = models.CharField(db_column='ERRMSG', max_length=255, blank=True, null=True) # Field name made lowercase.
  696. errobj = models.CharField(db_column='ERROBJ', max_length=255, blank=True, null=True) # Field name made lowercase.
  697. errchk = models.BooleanField(db_column='ERRCHK') # Field name made lowercase.
  698. errapp = models.CharField(db_column='ERRAPP', max_length=50, blank=True, null=True) # Field name made lowercase.
  699.  
  700. class Meta:
  701. managed = False
  702. db_table = 'GEN_ERRORS'
  703.  
  704.  
  705. class GenFtpSites(models.Model):
  706. ftpid = models.AutoField(db_column='FTPID') # Field name made lowercase.
  707. ftpname = models.CharField(db_column='FTPNAME', max_length=50, blank=True, null=True) # Field name made lowercase.
  708. ftpaddr = models.CharField(db_column='FTPADDR', max_length=255, blank=True, null=True) # Field name made lowercase.
  709. ftpsite = models.CharField(db_column='FTPSITE', max_length=255, blank=True, null=True) # Field name made lowercase.
  710. ftpuser = models.CharField(db_column='FTPUSER', max_length=50, blank=True, null=True) # Field name made lowercase.
  711. ftppass = models.CharField(db_column='FTPPASS', max_length=50, blank=True, null=True) # Field name made lowercase.
  712.  
  713. class Meta:
  714. managed = False
  715. db_table = 'GEN_FTP_SITES'
  716.  
  717.  
  718. class GenM2MCostcode(models.Model):
  719. cstctype = models.CharField(db_column='CSTCTYPE', max_length=1) # Field name made lowercase.
  720. cstcdesc = models.CharField(db_column='CSTCDESC', max_length=20, blank=True, null=True) # Field name made lowercase.
  721.  
  722. class Meta:
  723. managed = False
  724. db_table = 'GEN_M2M_COSTCODE'
  725.  
  726.  
  727. class GenNotfAccounts(models.Model):
  728. accid = models.IntegerField(db_column='ACCID') # Field name made lowercase.
  729. smtpserv = models.CharField(db_column='SMTPSERV', max_length=50, blank=True, null=True) # Field name made lowercase.
  730. smtpport = models.IntegerField(db_column='SMTPPORT', blank=True, null=True) # Field name made lowercase.
  731. smtpuser = models.CharField(db_column='SMTPUSER', max_length=50, blank=True, null=True) # Field name made lowercase.
  732. smtppass = models.CharField(db_column='SMTPPASS', max_length=50, blank=True, null=True) # Field name made lowercase.
  733. smtpussl = models.BooleanField(db_column='SMTPUSSL') # Field name made lowercase.
  734.  
  735. class Meta:
  736. managed = False
  737. db_table = 'GEN_NOTF_ACCOUNTS'
  738.  
  739.  
  740. class GenNotfDate(models.Model):
  741. type = models.IntegerField(db_column='TYPE') # Field name made lowercase.
  742. sent = models.DateTimeField(db_column='SENT', blank=True, null=True) # Field name made lowercase.
  743.  
  744. class Meta:
  745. managed = False
  746. db_table = 'GEN_NOTF_DATE'
  747.  
  748.  
  749. class GenNotfLog(models.Model):
  750. nid = models.AutoField(db_column='NID') # Field name made lowercase.
  751. nto = models.CharField(db_column='NTO', max_length=1000, blank=True, null=True) # Field name made lowercase.
  752. nsub = models.CharField(db_column='NSUB', max_length=255, blank=True, null=True) # Field name made lowercase.
  753. nbody = models.CharField(db_column='NBODY', max_length=1000, blank=True, null=True) # Field name made lowercase.
  754. ntime = models.DateTimeField(db_column='NTIME', blank=True, null=True) # Field name made lowercase.
  755. nsent = models.NullBooleanField(db_column='NSENT') # Field name made lowercase.
  756.  
  757. class Meta:
  758. managed = False
  759. db_table = 'GEN_NOTF_LOG'
  760.  
  761.  
  762. class GenOdometer(models.Model):
  763. id = models.AutoField(db_column='ID') # Field name made lowercase.
  764. userid = models.IntegerField(db_column='USERID', blank=True, null=True) # Field name made lowercase.
  765. funcid = models.IntegerField(db_column='FUNCID', blank=True, null=True) # Field name made lowercase.
  766. odo = models.IntegerField(db_column='ODO', blank=True, null=True) # Field name made lowercase.
  767.  
  768. class Meta:
  769. managed = False
  770. db_table = 'GEN_ODOMETER'
  771.  
  772.  
  773. class GenProviders(models.Model):
  774. id = models.AutoField(db_column='ID') # Field name made lowercase.
  775. proname = models.CharField(db_column='PRONAME', max_length=50, blank=True, null=True) # Field name made lowercase.
  776. prodomain = models.CharField(db_column='PRODOMAIN', max_length=50, blank=True, null=True) # Field name made lowercase.
  777.  
  778. class Meta:
  779. managed = False
  780. db_table = 'GEN_PROVIDERS'
  781.  
  782.  
  783. class GenQueueCoord(models.Model):
  784. crdid = models.AutoField(db_column='CRDID') # Field name made lowercase.
  785. crdtype = models.IntegerField(db_column='CRDTYPE') # Field name made lowercase.
  786. crduser = models.IntegerField(db_column='CRDUSER') # Field name made lowercase.
  787. crdcmt = models.CharField(db_column='CRDCMT', max_length=50, blank=True, null=True) # Field name made lowercase.
  788.  
  789. class Meta:
  790. managed = False
  791. db_table = 'GEN_QUEUE_COORD'
  792.  
  793.  
  794. class GenQueueTypes(models.Model):
  795. qtypid = models.IntegerField(db_column='QTYPID') # Field name made lowercase.
  796. qtypname = models.CharField(db_column='QTYPNAME', max_length=50) # Field name made lowercase.
  797. qtyignore = models.BooleanField(db_column='QTYIGNORE') # Field name made lowercase.
  798.  
  799. class Meta:
  800. managed = False
  801. db_table = 'GEN_QUEUE_TYPES'
  802.  
  803.  
  804. class GenToolsConvUnits(models.Model):
  805. unitid = models.AutoField(db_column='UNITID') # Field name made lowercase.
  806. unitname = models.CharField(db_column='UNITNAME', max_length=50, blank=True, null=True) # Field name made lowercase.
  807. unitabbr = models.CharField(db_column='UNITABBR', max_length=10, blank=True, null=True) # Field name made lowercase.
  808. unitto = models.FloatField(db_column='UNITTO', blank=True, null=True) # Field name made lowercase.
  809. unitfrom = models.FloatField(db_column='UNITFROM', blank=True, null=True) # Field name made lowercase.
  810. unittype = models.IntegerField(db_column='UNITTYPE', blank=True, null=True) # Field name made lowercase.
  811. unitstd = models.IntegerField(db_column='UNITSTD', blank=True, null=True) # Field name made lowercase.
  812. unitdesc = models.CharField(db_column='UNITDESC', max_length=255, blank=True, null=True) # Field name made lowercase.
  813. unitcust1 = models.FloatField(db_column='UNITCUST1', blank=True, null=True) # Field name made lowercase.
  814. unitcust2 = models.NullBooleanField(db_column='UNITCUST2') # Field name made lowercase.
  815.  
  816. class Meta:
  817. managed = False
  818. db_table = 'GEN_TOOLS_CONV_UNITS'
  819.  
  820.  
  821. class GenToolsConvUstd(models.Model):
  822. ustdid = models.AutoField(db_column='USTDID') # Field name made lowercase.
  823. ustdname = models.CharField(db_column='USTDNAME', max_length=50, blank=True, null=True) # Field name made lowercase.
  824. ustdsys = models.IntegerField(db_column='USTDSYS', blank=True, null=True) # Field name made lowercase.
  825.  
  826. class Meta:
  827. managed = False
  828. db_table = 'GEN_TOOLS_CONV_USTD'
  829.  
  830.  
  831. class GenToolsConvUsys(models.Model):
  832. usyid = models.AutoField(db_column='USYID') # Field name made lowercase.
  833. usyname = models.CharField(db_column='USYNAME', max_length=50, blank=True, null=True) # Field name made lowercase.
  834. usyabbr = models.CharField(db_column='USYABBR', max_length=10, blank=True, null=True) # Field name made lowercase.
  835.  
  836. class Meta:
  837. managed = False
  838. db_table = 'GEN_TOOLS_CONV_USYS'
  839.  
  840.  
  841. class GenToolsConvUtypes(models.Model):
  842. utypeid = models.AutoField(db_column='UTYPEID') # Field name made lowercase.
  843. utypename = models.CharField(db_column='UTYPENAME', max_length=50, blank=True, null=True) # Field name made lowercase.
  844. utypebase = models.CharField(db_column='UTYPEBASE', max_length=50, blank=True, null=True) # Field name made lowercase.
  845. utypecust1def = models.CharField(db_column='UTYPECUST1DEF', max_length=255, blank=True, null=True) # Field name made lowercase.
  846. utypecust2def = models.CharField(db_column='UTYPECUST2DEF', max_length=255, blank=True, null=True) # Field name made lowercase.
  847.  
  848. class Meta:
  849. managed = False
  850. db_table = 'GEN_TOOLS_CONV_UTYPES'
  851.  
  852.  
  853. class GenToolsDwgWhtlst(models.Model):
  854. partid = models.IntegerField(db_column='PARTID') # Field name made lowercase.
  855.  
  856. class Meta:
  857. managed = False
  858. db_table = 'GEN_TOOLS_DWG_WHTLST'
  859.  
  860.  
  861. class GenUsers(models.Model):
  862. uid = models.AutoField(db_column='UID') # Field name made lowercase.
  863. username = models.CharField(db_column='USERNAME', max_length=20, blank=True, null=True) # Field name made lowercase.
  864. active = models.NullBooleanField(db_column='ACTIVE') # Field name made lowercase.
  865. first = models.CharField(db_column='FIRST', max_length=15, blank=True, null=True) # Field name made lowercase.
  866. last = models.CharField(db_column='LAST', max_length=15, blank=True, null=True) # Field name made lowercase.
  867. suffix = models.CharField(db_column='SUFFIX', max_length=3, blank=True, null=True) # Field name made lowercase.
  868. initial = models.CharField(db_column='INITIAL', max_length=3, blank=True, null=True) # Field name made lowercase.
  869. dept = models.IntegerField(db_column='DEPT', blank=True, null=True) # Field name made lowercase.
  870. cust1 = models.IntegerField(db_column='CUST1', blank=True, null=True) # Field name made lowercase.
  871. cust2 = models.IntegerField(db_column='CUST2', blank=True, null=True) # Field name made lowercase.
  872. cust3 = models.IntegerField(db_column='CUST3', blank=True, null=True) # Field name made lowercase.
  873. process = models.IntegerField(db_column='PROCESS', blank=True, null=True) # Field name made lowercase.
  874. project = models.IntegerField(db_column='PROJECT', blank=True, null=True) # Field name made lowercase.
  875. access = models.IntegerField(db_column='ACCESS', blank=True, null=True) # Field name made lowercase.
  876. lastwc = models.CharField(db_column='LASTWC', max_length=7, blank=True, null=True) # Field name made lowercase.
  877. email1 = models.CharField(db_column='EMAIL1', max_length=50, blank=True, null=True) # Field name made lowercase.
  878. email2 = models.CharField(db_column='EMAIL2', max_length=50, blank=True, null=True) # Field name made lowercase.
  879. mobile = models.CharField(db_column='MOBILE', max_length=10, blank=True, null=True) # Field name made lowercase.
  880. provider = models.IntegerField(db_column='PROVIDER', blank=True, null=True) # Field name made lowercase.
  881. notf_own_m = models.BooleanField(db_column='NOTF_OWN_M') # Field name made lowercase.
  882. notf_own_e = models.BooleanField(db_column='NOTF_OWN_E') # Field name made lowercase.
  883. notf_sign_m = models.BooleanField(db_column='NOTF_SIGN_M') # Field name made lowercase.
  884. notf_sign_e = models.BooleanField(db_column='NOTF_SIGN_E') # Field name made lowercase.
  885. notf_chat_m = models.BooleanField(db_column='NOTF_CHAT_M') # Field name made lowercase.
  886. notf_chat_e = models.BooleanField(db_column='NOTF_CHAT_E') # Field name made lowercase.
  887. notf_fav_m = models.BooleanField(db_column='NOTF_FAV_M') # Field name made lowercase.
  888. notf_fav_e = models.BooleanField(db_column='NOTF_FAV_E') # Field name made lowercase.
  889. ecr_fwd = models.BooleanField(db_column='ECR_FWD') # Field name made lowercase.
  890. ecr_fwd_user = models.IntegerField(db_column='ECR_FWD_USER', blank=True, null=True) # Field name made lowercase.
  891. opt_folder = models.CharField(db_column='OPT_FOLDER', max_length=255, blank=True, null=True) # Field name made lowercase.
  892. reqfilt = models.IntegerField(db_column='REQFILT', blank=True, null=True) # Field name made lowercase.
  893. gmr = models.IntegerField(db_column='GMR', blank=True, null=True) # Field name made lowercase.
  894.  
  895. class Meta:
  896. managed = False
  897. db_table = 'GEN_USERS'
  898.  
  899.  
  900. class GenUsersFavcst(models.Model):
  901. uc_id = models.AutoField(db_column='UC_ID') # Field name made lowercase.
  902. uc_uid = models.IntegerField(db_column='UC_UID') # Field name made lowercase.
  903. uc_custid = models.IntegerField(db_column='UC_CUSTID') # Field name made lowercase.
  904.  
  905. class Meta:
  906. managed = False
  907. db_table = 'GEN_USERS_FAVCST'
  908.  
  909.  
  910. class GenVersions(models.Model):
  911. verid = models.AutoField(db_column='VERID') # Field name made lowercase.
  912. version = models.FloatField(db_column='VERSION', blank=True, null=True) # Field name made lowercase.
  913. status = models.CharField(db_column='STATUS', max_length=25, blank=True, null=True) # Field name made lowercase.
  914.  
  915. class Meta:
  916. managed = False
  917. db_table = 'GEN_VERSIONS'
  918.  
  919.  
  920. class GenWorkc(models.Model):
  921. wc_id = models.CharField(db_column='WC_ID', max_length=7) # Field name made lowercase.
  922. wc_name = models.CharField(db_column='WC_NAME', max_length=16, blank=True, null=True) # Field name made lowercase.
  923. wc_lead = models.IntegerField(db_column='WC_LEAD', blank=True, null=True) # Field name made lowercase.
  924. wc_mgr1 = models.IntegerField(db_column='WC_MGR1', blank=True, null=True) # Field name made lowercase.
  925. wc_mgr2 = models.IntegerField(db_column='WC_MGR2', blank=True, null=True) # Field name made lowercase.
  926.  
  927. class Meta:
  928. managed = False
  929. db_table = 'GEN_WORKC'
  930.  
  931.  
  932. class LocChildTypes(models.Model):
  933. lctypeid = models.IntegerField(db_column='LCTYPEID') # Field name made lowercase.
  934. lctypedesc = models.CharField(db_column='LCTYPEDESC', max_length=50, blank=True, null=True) # Field name made lowercase.
  935.  
  936. class Meta:
  937. managed = False
  938. db_table = 'LOC_CHILD_TYPES'
  939.  
  940.  
  941. class LocParentTypes(models.Model):
  942. lptypeid = models.IntegerField(db_column='LPTYPEID') # Field name made lowercase.
  943. lptypedesc = models.CharField(db_column='LPTYPEDESC', max_length=50, blank=True, null=True) # Field name made lowercase.
  944.  
  945. class Meta:
  946. managed = False
  947. db_table = 'LOC_PARENT_TYPES'
  948.  
  949.  
  950. class PrcGmrs(models.Model):
  951. gmrid = models.AutoField(db_column='GMRID') # Field name made lowercase.
  952. gmrname = models.CharField(db_column='GMRNAME', max_length=50, blank=True, null=True) # Field name made lowercase.
  953. gmrpart = models.CharField(db_column='GMRPART', max_length=25, blank=True, null=True) # Field name made lowercase.
  954. gmrrev = models.CharField(db_column='GMRREV', max_length=3, blank=True, null=True) # Field name made lowercase.
  955. gmruser = models.IntegerField(db_column='GMRUSER', blank=True, null=True) # Field name made lowercase.
  956.  
  957. class Meta:
  958. managed = False
  959. db_table = 'PRC_GMRS'
  960.  
  961.  
  962. class PrcLabelBlack(models.Model):
  963. blid = models.AutoField(db_column='BLID') # Field name made lowercase.
  964. blpart = models.CharField(db_column='BLPART', max_length=25, blank=True, null=True) # Field name made lowercase.
  965. blrev = models.CharField(db_column='BLREV', max_length=3, blank=True, null=True) # Field name made lowercase.
  966.  
  967. class Meta:
  968. managed = False
  969. db_table = 'PRC_LABEL_BLACK'
  970.  
  971.  
  972. class PrcLabelUl(models.Model):
  973. ulid = models.AutoField(db_column='ULID') # Field name made lowercase.
  974. ulpart = models.CharField(db_column='ULPART', max_length=50, blank=True, null=True) # Field name made lowercase.
  975. amspart = models.CharField(db_column='AMSPART', max_length=25, blank=True, null=True) # Field name made lowercase.
  976. amsrev = models.CharField(db_column='AMSREV', max_length=3, blank=True, null=True) # Field name made lowercase.
  977.  
  978. class Meta:
  979. managed = False
  980. db_table = 'PRC_LABEL_UL'
  981.  
  982.  
  983. class ReqRequests(models.Model):
  984. id = models.AutoField(db_column='ID') # Field name made lowercase.
  985. createdby = models.IntegerField(db_column='CREATEDBY', blank=True, null=True) # Field name made lowercase.
  986. custid = models.IntegerField(db_column='CUSTID', blank=True, null=True) # Field name made lowercase.
  987. itemnum = models.CharField(db_column='ITEMNUM', max_length=40, blank=True, null=True) # Field name made lowercase.
  988. description = models.CharField(db_column='DESCRIPTION', max_length=110, blank=True, null=True) # Field name made lowercase.
  989. lead = models.IntegerField(db_column='LEAD', blank=True, null=True) # Field name made lowercase.
  990. hours = models.TextField(db_column='HOURS', blank=True, null=True) # Field name made lowercase. This field type is a guess.
  991. datedue = models.DateTimeField(db_column='DATEDUE', blank=True, null=True) # Field name made lowercase.
  992. cdate = models.DateTimeField(db_column='CDATE', blank=True, null=True) # Field name made lowercase.
  993. comment = models.CharField(db_column='COMMENT', max_length=255, blank=True, null=True) # Field name made lowercase.
  994. ecr = models.BooleanField(db_column='ECR') # Field name made lowercase.
  995. ecrid = models.SmallIntegerField(db_column='ECRID', blank=True, null=True) # Field name made lowercase.
  996. new = models.BooleanField(db_column='NEW') # Field name made lowercase.
  997. open = models.BooleanField(db_column='OPEN') # Field name made lowercase.
  998. wip = models.BooleanField(db_column='WIP') # Field name made lowercase.
  999. wipid = models.IntegerField(db_column='WIPID', blank=True, null=True) # Field name made lowercase.
  1000. hold = models.BooleanField(db_column='HOLD') # Field name made lowercase.
  1001. datehold = models.DateTimeField(db_column='DATEHOLD', blank=True, null=True) # Field name made lowercase.
  1002. cnc = models.BooleanField(db_column='CNC') # Field name made lowercase.
  1003. m2m = models.BooleanField(db_column='M2M') # Field name made lowercase.
  1004. rel = models.BooleanField(db_column='REL') # Field name made lowercase.
  1005. relid = models.IntegerField(db_column='RELID', blank=True, null=True) # Field name made lowercase.
  1006. relcnt = models.CharField(db_column='RELCNT', max_length=10, blank=True, null=True) # Field name made lowercase.
  1007. completed = models.BooleanField(db_column='COMPLETED') # Field name made lowercase.
  1008. umbid = models.IntegerField(db_column='UMBID', blank=True, null=True) # Field name made lowercase.
  1009. pid = models.IntegerField(db_column='PID', blank=True, null=True) # Field name made lowercase.
  1010. fixid = models.CharField(db_column='FIXID', max_length=25, blank=True, null=True) # Field name made lowercase.
  1011. oldid = models.IntegerField(db_column='OLDID', blank=True, null=True) # Field name made lowercase.
  1012. type = models.IntegerField(db_column='TYPE', blank=True, null=True) # Field name made lowercase.
  1013. filecnt = models.IntegerField(db_column='FILECNT', blank=True, null=True) # Field name made lowercase.
  1014. statid = models.IntegerField(db_column='STATID', blank=True, null=True) # Field name made lowercase.
  1015. fixture = models.IntegerField(db_column='FIXTURE', blank=True, null=True) # Field name made lowercase.
  1016.  
  1017. class Meta:
  1018. managed = False
  1019. db_table = 'REQ_REQUESTS'
  1020.  
  1021.  
  1022. class ReqRequestsPending(models.Model):
  1023. id = models.AutoField(db_column='ID') # Field name made lowercase.
  1024. createdby = models.IntegerField(db_column='CREATEDBY', blank=True, null=True) # Field name made lowercase.
  1025. custid = models.IntegerField(db_column='CUSTID', blank=True, null=True) # Field name made lowercase.
  1026. itemnum = models.CharField(db_column='ITEMNUM', max_length=40, blank=True, null=True) # Field name made lowercase.
  1027. description = models.CharField(db_column='DESCRIPTION', max_length=110, blank=True, null=True) # Field name made lowercase.
  1028. hours = models.TextField(db_column='HOURS', blank=True, null=True) # Field name made lowercase. This field type is a guess.
  1029. datedue = models.DateTimeField(db_column='DATEDUE', blank=True, null=True) # Field name made lowercase.
  1030. cdate = models.DateTimeField(db_column='CDATE', blank=True, null=True) # Field name made lowercase.
  1031. comment = models.CharField(db_column='COMMENT', max_length=255, blank=True, null=True) # Field name made lowercase.
  1032. ecrid = models.SmallIntegerField(db_column='ECRID', blank=True, null=True) # Field name made lowercase.
  1033. status = models.IntegerField(db_column='STATUS', blank=True, null=True) # Field name made lowercase.
  1034. filecnt = models.IntegerField(db_column='FILECNT', blank=True, null=True) # Field name made lowercase.
  1035.  
  1036. class Meta:
  1037. managed = False
  1038. db_table = 'REQ_REQUESTS_PENDING'
  1039.  
  1040.  
  1041. class ReqRequestsStatus(models.Model):
  1042. rsid = models.IntegerField(db_column='RSID') # Field name made lowercase.
  1043. rsname = models.CharField(db_column='RSNAME', max_length=20, blank=True, null=True) # Field name made lowercase.
  1044.  
  1045. class Meta:
  1046. managed = False
  1047. db_table = 'REQ_REQUESTS_STATUS'
  1048.  
  1049.  
  1050. class ReqRequestsTracking(models.Model):
  1051. trk_id = models.AutoField(db_column='TRK_ID') # Field name made lowercase.
  1052. userid = models.IntegerField(db_column='USERID', blank=True, null=True) # Field name made lowercase.
  1053. projid = models.IntegerField(db_column='PROJID', blank=True, null=True) # Field name made lowercase.
  1054. type = models.IntegerField(db_column='TYPE', blank=True, null=True) # Field name made lowercase.
  1055.  
  1056. class Meta:
  1057. managed = False
  1058. db_table = 'REQ_REQUESTS_TRACKING'
  1059.  
  1060.  
  1061. class ReqRequestsTrackingTypes(models.Model):
  1062. ttid = models.IntegerField(db_column='TTID') # Field name made lowercase.
  1063. trktype = models.CharField(db_column='TRKTYPE', max_length=25, blank=True, null=True) # Field name made lowercase.
  1064. trktbl = models.CharField(db_column='TRKTBL', max_length=50, blank=True, null=True) # Field name made lowercase.
  1065.  
  1066. class Meta:
  1067. managed = False
  1068. db_table = 'REQ_REQUESTS_TRACKING_TYPES'
  1069.  
  1070.  
  1071. class ReqRequestsType(models.Model):
  1072. reqtypid = models.IntegerField(db_column='REQTYPID') # Field name made lowercase.
  1073. reqtypname = models.CharField(db_column='REQTYPNAME', max_length=20, blank=True, null=True) # Field name made lowercase.
  1074. reqtypdesc = models.CharField(db_column='REQTYPDESC', max_length=50, blank=True, null=True) # Field name made lowercase.
  1075.  
  1076. class Meta:
  1077. managed = False
  1078. db_table = 'REQ_REQUESTS_TYPE'
  1079.  
  1080.  
  1081. class ReqSubmissions(models.Model):
  1082. subid = models.AutoField(db_column='SUBID') # Field name made lowercase.
  1083. rectype = models.IntegerField(db_column='RECTYPE', blank=True, null=True) # Field name made lowercase.
  1084. recid = models.IntegerField(db_column='RECID', blank=True, null=True) # Field name made lowercase.
  1085. fileid = models.IntegerField(db_column='FILEID', blank=True, null=True) # Field name made lowercase.
  1086.  
  1087. class Meta:
  1088. managed = False
  1089. db_table = 'REQ_SUBMISSIONS'
  1090.  
  1091.  
  1092. class ReqUmbrella(models.Model):
  1093. umbid = models.AutoField(db_column='UMBID') # Field name made lowercase.
  1094. custid = models.IntegerField(db_column='CUSTID') # Field name made lowercase.
  1095. pid = models.IntegerField(db_column='PID') # Field name made lowercase.
  1096. umbname = models.CharField(db_column='UMBNAME', max_length=50) # Field name made lowercase.
  1097. umbreqby = models.IntegerField(db_column='UMBREQBY') # Field name made lowercase.
  1098. umbreqdate = models.DateTimeField(db_column='UMBREQDATE') # Field name made lowercase.
  1099. umbnote = models.CharField(db_column='UMBNOTE', max_length=1000, blank=True, null=True) # Field name made lowercase.
  1100. umbstat = models.IntegerField(db_column='UMBSTAT') # Field name made lowercase.
  1101. umbdue = models.DateTimeField(db_column='UMBDUE', blank=True, null=True) # Field name made lowercase.
  1102. umblead = models.IntegerField(db_column='UMBLEAD', blank=True, null=True) # Field name made lowercase.
  1103. filecnt = models.IntegerField(db_column='FILECNT', blank=True, null=True) # Field name made lowercase.
  1104.  
  1105. class Meta:
  1106. managed = False
  1107. db_table = 'REQ_UMBRELLA'
  1108.  
  1109.  
  1110. class ReqUmbrellaStatus(models.Model):
  1111. usid = models.IntegerField(db_column='USID') # Field name made lowercase.
  1112. ustatus = models.CharField(db_column='USTATUS', max_length=25) # Field name made lowercase.
  1113.  
  1114. class Meta:
  1115. managed = False
  1116. db_table = 'REQ_UMBRELLA_STATUS'
  1117.  
  1118.  
  1119. class SchProcess(models.Model):
  1120. procid = models.IntegerField(db_column='PROCID') # Field name made lowercase.
  1121. process = models.CharField(db_column='PROCESS', max_length=20, blank=True, null=True) # Field name made lowercase.
  1122.  
  1123. class Meta:
  1124. managed = False
  1125. db_table = 'SCH_PROCESS'
  1126.  
  1127.  
  1128. class SchProjects(models.Model):
  1129. pid = models.AutoField(db_column='PID') # Field name made lowercase.
  1130. project = models.CharField(db_column='PROJECT', max_length=10, blank=True, null=True) # Field name made lowercase.
  1131. custid = models.IntegerField(db_column='CUSTID', blank=True, null=True) # Field name made lowercase.
  1132. description = models.CharField(db_column='DESCRIPTION', max_length=30, blank=True, null=True) # Field name made lowercase.
  1133. date_add = models.DateTimeField(db_column='DATE ADD', blank=True, null=True) # Field name made lowercase. Field renamed to remove unsuitable characters.
  1134. has_fixtures = models.BooleanField(db_column='HAS FIXTURES') # Field name made lowercase. Field renamed to remove unsuitable characters.
  1135.  
  1136. class Meta:
  1137. managed = False
  1138. db_table = 'SCH_PROJECTS'
  1139.  
  1140.  
  1141. class SchRecords(models.Model):
  1142. recid = models.AutoField(db_column='RECID') # Field name made lowercase.
  1143. qty = models.DecimalField(db_column='QTY', max_digits=18, decimal_places=2, blank=True, null=True) # Field name made lowercase.
  1144. pdate = models.DateTimeField(db_column='PDATE', blank=True, null=True) # Field name made lowercase.
  1145. pid = models.IntegerField(db_column='PID', blank=True, null=True) # Field name made lowercase.
  1146. procid = models.IntegerField(db_column='PROCID', blank=True, null=True) # Field name made lowercase.
  1147. uid = models.IntegerField(db_column='UID', blank=True, null=True) # Field name made lowercase.
  1148.  
  1149. class Meta:
  1150. managed = False
  1151. db_table = 'SCH_RECORDS'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!