mes数据库表结构说明文档

1、数据库表结构说明文档applay.sn4assembIe.batchnojnfo4assemblePaCk-COnfig5assembIing_hour_Statement5bIrd6r*Im9iSnfbig_CategOry7binning7binning_backups8b i nn i ng_deta i I错误!未定义书签。b i nn i ng_deta i I.backups错误!未定义书签。boxb inning错误!未定义书签。boXbinning_backups8boXbinning_detai I错误!未定义书签。错误!未定义书签。boxbinning_detaiI_bac

2、kupsCategOry-OPtiOn9CheCkdatabase-cOnn9COIOUrbOX9COnfigUration.parameters9COnneCtiOnnumber'pn10COnnbatchPart_no10CUStOmerSn_config10CUStOmereemaiI11day-statement11dccmojndex11dcc_Sendrecord12del_binningdetaiIjog12department12department_purview13department_purview_item13error-data13factory-work-t

3、ime13inspectionsheet14inspection.box14inspection_box_temp14inspec廿On_daiIy_report15inspection.Order.SCOPe15inspection.record16inspection-record-temp16inspection-report17inspection'State18inspection'Unit18ipconfig18iqc_smt_biII18iqc_smt_biIl_defect19iqc_smt_biILrePOrt19IinedS20IIneJnfO20machi

4、nepackboXinfo20machinepackinfo21machinepackbbaIing21machinepackIabaIingtm21machinepackstanceinfo22machine'PrOdUCtOrder22modeIpurview23mytask23new-smt.workspace23noWtime-hoursJnfo23noWtimeJnfo24noWtime-Smt-hoursjnfo24noWtime-Smt_info250ern_Pr0dUCte0rder25PaCkbOXinfO26PaCkindex26PaCkinfo26PaCkingc

5、onfig27PaCkingJine27PaCkingJine_stance_reIation28PaCkIabaIing28PaCkIabaIingtm28PaCkStanCeinfO29PaCk.ClearJOg29PaCk_report29PagePUrVieW30PaIIetCOnfig30Pdata31POSitiOn31POSition_binningjog31POSitiOn-CheCkCOIOrbOX-10g32POSitiOn_CheCkPhOnebodyJ0g32POSiti0n_C0l0rb0X.I0g32POSiti0neC0nfigJnfo33POSitiOnfix3

6、3POSitiOn-fiX-resolve34POSitiOn-OrderS34POSitiOn_PaCktOtle.IOg34POSitiOnPaCktOtIeJOg'backups35POSitiOn_PalletjOg错误！未定义书签。POSitiOnPartnOCOnfig35POSitiOn_tabIe_reIevance35POSitiOnWeigh_IOg36POSition_WriteimeiJOg36PrOdeCtOrderJmei-COnf36PrOdeCtOrderJmei-COnfJnfO37PrOdeCtOrder_Sn_conf37PrOdUCtiVity3

7、8PrOdUCtOrder39pquaIity39recycleJmei39rework.Sheet40role40SCraPbOard40SeCOnd_CategOry41SGnd_faiI41SenaInumber41SerViCe-record41ShiPment-Primary42ShiPment-Primary-detaiI42SmtPrOCeSS43SmtteSt-PUtinto43Smt-batchnumber_conn_number43Smt-COnnection-number44Smt-data44Smt-WOrkmanship44Sn_camera_tabIe45Sn-Ce

8、lI-tabIe45Sn-Charger_table45SClatawire_tabIe46sn.earphonestable46sn_frontease-tabIe47SnJmeistable47SnJmeLtabIe-backups错误!未定义书签。snnetmark-table47sn_nUmber48Sn-OrderereIatiOn48Sn_order_reIatiOnebaCkUPS48Sn_PnChangesn_tabIe4848SnPOSitiOn-PUtsn_rearcase_tabIe49Sn-SUCCeSS.info49Sn_toUChSCree.t9bIe49Sn_tp

9、_tabIe50Sn_wifi_table50StanCeinfO50StanCetyPe51SUbPagePUrVieW51tabs51tab_anritu_info51tab_btjnfo52tab_C0UPIing_info52tab_pn_connectnumber52tab-write-pn53tab_Write-Pn_log53task-config53UPlOaddata-bonding54UPI0addata-bt54UPlOaddata-COUPIing55UPlOaddatadownIoad56UPIOaddatamachine57UPlOaddata.mmi58UPIOa

10、ddata_PaCking58UPlOaddataPCba59USerinfO60WifibtCOnfig错谋！未定义书签。appIay-sn描述：InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1Idint10,02yearint10,0V3Weekint10r0V4SeriaInllmberint10,0V5SaVeKindVarChar255/7组装关键性物料绑定assembIepbatchnojnfo描述：InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值A0c0lJUT>wlUnOUreqDi八q8AOyx&

11、quot;uoraojut6pjoLAOSx"uoraO"onPOJd9AOZx"uora9dXi"9Ttqoa9AOVJre1PjreA涓回利""onq-QUiIAQZJre1PjreAJ0p"9*dnoj3£AOSJre1PjreAOUH乙0c0lIUTP!瞻*PYT鬲坯第砂)U9UilfgSrnolri! qui9SSE茎事嫌茎罄第科尊焉9>l808£29S:964QCIoUUI聊rjIdWIS9UJTi9intZiUGJjno9OS贡工筋蒸J9pj9"9qi口9ssSOS%储切渔&

12、#165;ouu'dPOSUS£/、f02聃W第usf*.14期汉dtZ0e0TIUXPTT砂9>l808C29S:6049Q0UU|:测聊yuoEZT3ud"®iqui0sSEAO'SluTXuTLSniBiSSIA0g制:林*王”;IgmQjrz/A00T9dXzBtj9a11A00T回轴删0TA00TJ9JGdO6A00T0ireu9ou三8A00TiuTaWPrFL户SSSWdldt9户0*01iuT再躲出刑iunoo9snS户O'OTiuT再QUTKXjiqxgqV户001XBqoJBAou"qoa'q&#

13、163;户SS2XBqoJBA0UJ9pJ0Z00TiuTPTI9target-amount目标量int10,0V10input-section.amount投入本节int10,0J11input-tOtaI.amount投入累计int10,0V12OUtPUt-SeCtion.amount产出本节int10,0V13OUtPUt-total_amount产出累计int10,0V14difference-amount差异数量int10,0V15FPY直通率VarChar20V16remark备注VarChar300J17dates日期VarChar30V18CUStO客户名称V

14、arChar100A,JJ配置大工单号段的详W-bigorderjmeis.conf描述：配置大工单号段的详情InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1idint10,02PrOdUCtorder_no工单号VarChar50V3Imeil-PrefiXIM臼1前缀VarChar17V4ImeiI-StartIMEII起始编号VarChar17V5ImeiI-endIMEII终止编VarChar17V6Imeil.laSt下一个IMEIVarChar17V7Imei2-prefixIMEI2前缀VarChar17VSImei2.startIMEI2开

15、始VarChar17V9Imei2_endIMEI2结束VarChar17V10Imei2-last一个IMEI2VarChar17V11once-imeI-COUntIMEI的数量int10,0V12Imei-Strategy分配方法int10,0V13Wifi-PrefiXWIFI前缀VarChar32V14Wifi-StartWIFI开始号VarChar32V15Wifi.endWIFI结束号VarChar32V16Wifi.laSt下一个WIFIVarChar32V17btprefixBT前缀VarChar32VISbt-startBT开始号VarChar32V19bt-endBT结束

16、号VarChar32V20bt0last下一个BTVarChar32V21meid-prefixMEID前缀VarChar32J22meid-startMEID开始VarChar32V23meid-endMEID结束VarChar32V24meid-last一个MEIDVarChar32V25meid-SCaIe0代表十进制，1是十六进制int10,0V26meid-ischeck0是需要有CheCk彳立，1不需要CheCk位int10,0V27remarkVarChar100V28state状态（0,可用）保留字段Char1V0维修策略大类表bigpcategory描述：InnODBfree

17、:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1id主键int10,02CategOry-desc描述VarChar50箱号信息表binning描述：箱号信息表InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1idint10,02PrOdUCtOrder-1dPrOdUCtOrder表IDint10,0V3PaCkingCOnfig-ld包装箱(PaCkingCOnfig)表IDint10,0V4PaCkingNO包装箱号VarChar50V5CreateTime建创时间timestampV6OPeratOr创建人VarChar20V7We

18、IghtVarChar30V箱号详情表binningpdetaiI描述：箱号详情表InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1idint10,02PaCkingNO和Binning表中PaCkingNO关联VarChar50V3SnSNVarChar50V4ImeiIMEI号VarChar50J5OrderBy序号intIOtOV6Weight重量VarChar50V木戋板表boxbinning描述：栈板表InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1idint10,02PrOdUCtOrder.idPrOdUC

19、tOrder表IDint10,0V3PaIIetCOnfig_id栈板(PaIletCOnfig)表IDint10r0V4PalletCOnfigNO栈板号VarChar50V5CreateTime建创时间dateV6OPeratOr创建人VarChar20V栈板详情表boxbinningbdetaiI描述：栈板详情表InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1idint10,02PalletCOnfIgNO和boxbinning表中PaIIetCOnfigNO芋胖VarChar50V3PaCkingNO包装箱号VarChar50V4Weight重量d

20、ouble50,2V维修代码表CategOryeOPtiOn描述：InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1idint10,02CategOry_desc描述VarChar503CategOry.COde维修代码VarChar504SeCOnd-Category-id大类IDint10,0CheCkedatabaSeeCOnn彩盒重量维护表COIOUrbOX描述：InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1idint10,00描述：彩盒重量维护表InnODBfree:5623808kB序号字段名称字段描述字段

21、类型长度允许空缺省值1idint10,02PrOdllCtOrder-ld包装工单idint10,0V3StandardWelght标准重量VarChar10V4errorScopeMax误差最大值VarChar10V5errorScopeMin误差最小VarChar10V参数配置数据表COnfigUratiO/ParameterS描述：InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1id主键idint10,02type-name参数名称VarChar50V3ConteXt参数内容VarChar500V4ConteXt-explain参数说明VarChar

22、50V连版和PN绑定信息表COnneCtiOnnUmberePn描述：InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1idintIOiO2COnneCtlon-number连版号VarChar50V3PNPN号VarChar50V4IPIP地址VarChar50V5StanCeName站位名称VarChar50V6I线体名称VarChar50V7OPerater操作人VarChar50V8CUrrenttlme操作时间VarChar50V9StatUS状态tinyint3,0V10remark预留字段VarChar50/7光板和贴片机物料批

23、次绑定关系表COnnebatCheParLnO客户SN信息维护CUStOmerS I I-COnfig描述:InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1Id主键intI0Q2COnneCtiOnNUmber连版号VarChar50J3batch.no物料批次号VarChar50V4part.no料号VarChar50J5USe-COUnt使用数量intI0QJ6bord-type版面类型VarChar30J7StanC站位名称VarChar30J描述：客户SN信息维护表InnODBfree:5623808kB序号字段名称字段描述字段类型长度

24、允许空缺省值1idint10,02order-no包装工单号VarChar1003PrefixSN前缀VarChar504Snleng序列号长度int10,0报表发送人维护表C11StOmer-emaiI描述：报表发送人维护表InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1idint10,02CUStOmer客户名称VarChar303emaiI要接收的邮VarChar1000daybstatement（已废弃）描述:InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1idint10,02moVarChar503IineV

25、arChar104StanCenameVarChar205PrOdUCe-COUntint10,06defect-COUntint10,07errorReasonsVarChar5008StartDatetimestamp0000-00-0000:00:009endDatetimestamp0000-00-0000:00:00dccmoJndex（已废弃）描述:InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1idint10,02Order-numVarChar50V3moVarChar50V4SUbPrOjeCtVarChar30V5CUStomerVar

26、Char20V6WeektimeVarChar20V7COUntint10,0V8fiIeTypeVarChar255V9VerSiOnVarChar255V10rolIbackint10,0011Stateint10,0012CreateDatetimestampdecPsendPrecord（已废弃）描述：InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1idint10r02moVarChar50V3SUbPrOjeCtVarChar30V4CUStOmerVarChar20V5StanCVarChar20V6COmPUter-numVarC

27、har255V7creater-datetimestampV8OPeratOrSVarChar20V9Sn-Start_noVarChar50V10sn-end-noVarChar50V删除箱号详情记录CIeLbinningdetaiLlog描述：删除箱号详情记录InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1idint10。2PaCkingnO已删除的箱VarChar100V3imeis箱号中所有的IMEI号VarChar1000V4IOgtInle记录时间timestampV5OPeratOr操作人VarChar50VDePartment（系统设置相关

28、表）描述:InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1idint10,02nameVarChar3503PUrVieWtext65535V4discriptionVarChar500VdepartmeTTLpurview彳系统设置相关表）描述：InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1idint10r02HameVarChar3503discnptionVarChar500departmenLpurviewJtem（系统设置相关表）描述：InnODBfree:5623808kB;CdePartmentPUrV

29、ieWJd'）REFER'dmasg2/departmentPU序号字段名称字段描述字段类型长度允许空缺省值1idint10,02nameVarChar3003discriptionVarChar50074department-PUrVIeW-1dint10,0Jerror,data（已废弃）描述：InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1idint10,02SnVarChar50J3StanCeVarChar504StanCe_idint10,05enddatetimestampoooo-oo-oo00:00:006errorRea

30、sonVarChar1000上班班次记录表factoryBworktime描述：InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1idint10,02type站位VarChar103data-type班次VarChar101Start-time上班时间VarChar300000-00-0000:00:005end-time下班时间VarChar30oooo-oo-oo00:00:00送检单信息表inspectionsheet送检单中的信息详情inspection-box描述：送检单信息表InnODBfree:5623808kB序号字段名称字段描述字段类型长度

31、允许空缺省值1Idint10,02inspection.no送检单号VarChar503order.no工单号VarChar504PrOdUCt-COde产品编号VarChar505remark产品描述VarChar50V6COUnt送检数量int10,07CUrrenttlme送检时间timestampoooo-oo-oo00:00:008qaremarkAQ描述VarChar300V9qaresuItQA判定VarChar300J10OqCremarkOQC描述VarChar300J11OqCreSUItOQC判定结果VarChar300V12State态状int10,0130bIigat

32、eIVarChar300V140bIigate2VarChar300V描述：送检单中的信息详情InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1idint10,02inspection.no送检单号VarChar503box.noSN号VarChar5040bIigateIVarChar500J未生成送检单临时详情表inspection.box-temp序号字段名称字段描述字段类型长度允许空缺省值1idint10,02IP录记IPVarChar203box-no箱号VarChar504order-noSN号VarChar505ObIigateIVarChar

33、200jV包装抽检记录报表inspeCtion-daiIyjreport品质部配置I ME I号段信息表i nspect i on0rdereSC0Pe描述：包装抽检记录报表InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1Idint10,02mobile-type机型VarChar203Pline线另IJVarChar10jV4ClaSSeS班别VarChar10V5inspect-date送检日期date6order-no工单号VarChar507inspect-no送检单VarChar508inspect-batch送检批次int10.09quaIif

34、ired_batch合格批次int10,010bad.batch不良批次int10,011batch-PaSS.rate批合格率doubleI0,212inspect.num送检数量int10,013SamPIing_num抽检数量int10,014bad.num不良数int10,015bad-rate不良率doubleI0.216baddesc不良现象描述VarChar500417Judgment判定VarChar10V18rework-no返工工单VarChar50V19inspection_unit_id预留字段1VarChar10V200bIigate2预留字段2VarChar10JV

35、描述：品质部配置IMEI号段信息表InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1idint10,02order.no包装工单号VarChar2003imeiLstartIIVI臼1号段VarChar20开始4imeiLendHVIDi号段结束VarChar20V5imei20startIIvl臼2号段开始值VarChar20J6imei2eendIIvl臼2号段结束值VarChar20V7bt-startBT开始值VarChar20J8bt-endBT结束值VarChar20J9Wifl-StartWIFI开始值VarChar20J10wifi-endW

36、IFI结束值VarChar20J11ObiigateIVarChar50V包装抽检详情inspectionjrecord描述：包装抽检详情InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1idint10,02inspect_no送检单号VarChar203CartOn_noMEID号VarChar204SnSN号VarChar205ImeiIVarChar206lmei2VarChar207judgement-：TeSUIt判定结果VarChar20V8inspect-time检验时间timestampJCURRENTTIMESTAMP9inspector检

37、验员VarChar20V10inspection_unit_id抽检单位IDint10,0V11bad-type不良类型：错"1»漏混3,其他不良.4VarChar2V12ObiigateI机型VarChar50V130bIigate2预留字段2VarChar20V包装抽检临时保存表inspeCtiOnJreCOrd-temp序号字段名称字段描述字段类型长度允许空缺省值1Idint10,02inspect-no送检单号VarChar203Cart0n_noMEID号VarChar204SnVarChar205ImeiIVarChar206lmei2VarChar207jud

38、gement.:TeSUIt判定结果VarChar208inspect-time检验时间timestampCURRENTTIMESTAMP9inspector检验员VarChar2010inspection-unit-id抽检单位IDint10,011bad-type不良类型：错-1»<%-2*混3,其他不良.4VarChar2V12ObiigateI机型VarChar50V13Obiigate2预留字段2VarChar20VinspectionjrepolI描述：InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1idint10,02insp

39、ect-no送检单号VarChar203order-no工单号VarChar504inspection_type_id抽检类型IDint10,05inspeCtiOn-StyIe-id抽检方式IDint10,06inspeCtOr.OqCOQC检验员VarChar20J7rework通知返工：0否，1是intIOiO08SPeCiaI-PiCk特采。否，1是int10,009inspection-unit-id抽检单位int10,0J10ObiigateI送检时间VarChar50J11Obiigate2VarChar10Vinspectionpstate描述：InnODBfree:56238

40、08kB序号字段名称字段描述字段类型长度允许空缺省值1idint10,02StaxenameVarChar50inspectionisunit描述:InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1Idint10,02mark标记VarChar103description描述VarChar100过滤登陆权限配置一ipconfig描述：InnODBfree:5623808kB序号字段名称字段描述字段类型长度允许空缺省值1IdintI0.02IPIPVarChar303State状态int10,0iqC-Smt-biII描述:InnODBfree:5623808

41、kB序号字段名称字段描述字段类型长度允许空缺省值1Idint10,02biII-no检验单号VarChar32V3ip.flag标识VarChar15V4State状态int10,0V5leVel验收等级(OneztWOAhree)VarChar10V6rank等级水准(B,N,I)VarChar10V7Standar验收水准VarChar10VTA0c0TIUT丑脩VD和£2Eb讥AO'OTZUTtraSTAOoTZUTVinZXA00g护页厂2。尸PIIAOoTZUT辞业iunooi6j9pOTAOoTZUTIllnOUxo9dsut6A9inti91Bp%I,9atixo9dsu8AOITZUT再ZUnOO"pudsLAQUnVPUBS9AOS工Eip工EA0uj9pj09AOT工Eip工EAXGPOInPAOS工Eip工EAQUHSAOS工Eip工EAOUFgZO'OTIUTPyI