mes數(shù)據(jù)庫(kù)表結(jié)構(gòu)說明文檔

1、數(shù)據(jù)庫(kù)表結(jié)構(gòu)說明文檔applay.sn4assembIe.batchnojnfo4assemblePaCk-COnfig5assembIing_hour_Statement5bIrd6r*Im9iSnfbig_CategOry7binning7binning_backups8b i nn i ng_deta i I錯(cuò)誤!未定義書簽。b i nn i ng_deta i I.backups錯(cuò)誤!未定義書簽。boxb inning錯(cuò)誤!未定義書簽。boXbinning_backups8boXbinning_detai I錯(cuò)誤!未定義書簽。錯(cuò)誤!未定義書簽。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錯(cuò)誤！未定義書簽。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錯(cuò)誤!未定義書簽。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錯(cuò)謀！未定義書簽。appIay-sn描述：InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1Idint10,02yearint10,0V3Weekint10r0V4SeriaInllmberint10,0V5SaVeKindVarChar255/7組裝關(guān)鍵性物料綁定assembIepbatchnojnfo描述：InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值A(chǔ)0c0lJUT>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%儲(chǔ)切漁&

12、#165;ouu'dPOSUS£/、f02聃W第usf*.14期漢dtZ0e0TIUXPTT砂9>l808C29S:6049Q0UU|:測(cè)聊yuoEZT3ud"®iqui0sSEAO'SluTXuTLSniBiSSIA0g制:林*王”;IgmQjrz/A00T9dXzBtj9a11A00T回軸刪0TA00TJ9JGdO6A00T0ireu9ou三8A00TiuTaWPrFL戶SSSWdldt9戶0*01iuT再躲出刑iunoo9snS戶O'OTiuT再Q(mào)UTKXjiqxgqV戶001XBqoJBAou"qoa'q&#

13、163;戶SS2XBqoJBA0UJ9pJ0Z00TiuTPTI9target-amount目標(biāo)量int10,0V10input-section.amount投入本節(jié)int10,0J11input-tOtaI.amount投入累計(jì)int10,0V12OUtPUt-SeCtion.amount產(chǎn)出本節(jié)int10,0V13OUtPUt-total_amount產(chǎn)出累計(jì)int10,0V14difference-amount差異數(shù)量int10,0V15FPY直通率VarChar20V16remark備注VarChar300J17dates日期VarChar30V18CUStO客戶名稱V

14、arChar100A,JJ配置大工單號(hào)段的詳W-bigorderjmeis.conf描述：配置大工單號(hào)段的詳情InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10,02PrOdUCtorder_no工單號(hào)VarChar50V3Imeil-PrefiXIM臼1前綴VarChar17V4ImeiI-StartIMEII起始編號(hào)VarChar17V5ImeiI-endIMEII終止編VarChar17V6Imeil.laSt下一個(gè)IMEIVarChar17V7Imei2-prefixIMEI2前綴VarChar17VSImei2.startIMEI2開

15、始VarChar17V9Imei2_endIMEI2結(jié)束VarChar17V10Imei2-last一個(gè)IMEI2VarChar17V11once-imeI-COUntIMEI的數(shù)量int10,0V12Imei-Strategy分配方法int10,0V13Wifi-PrefiXWIFI前綴VarChar32V14Wifi-StartWIFI開始號(hào)VarChar32V15Wifi.endWIFI結(jié)束號(hào)VarChar32V16Wifi.laSt下一個(gè)WIFIVarChar32V17btprefixBT前綴VarChar32VISbt-startBT開始號(hào)VarChar32V19bt-endBT結(jié)束

16、號(hào)VarChar32V20bt0last下一個(gè)BTVarChar32V21meid-prefixMEID前綴VarChar32J22meid-startMEID開始VarChar32V23meid-endMEID結(jié)束VarChar32V24meid-last一個(gè)MEIDVarChar32V25meid-SCaIe0代表十進(jìn)制，1是十六進(jìn)制int10,0V26meid-ischeck0是需要有CheCk彳立，1不需要CheCk位int10,0V27remarkVarChar100V28state狀態(tài)（0,可用）保留字段Char1V0維修策略大類表bigpcategory描述：InnODBfree

17、:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1id主鍵int10,02CategOry-desc描述VarChar50箱號(hào)信息表binning描述：箱號(hào)信息表InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10,02PrOdUCtOrder-1dPrOdUCtOrder表IDint10,0V3PaCkingCOnfig-ld包裝箱(PaCkingCOnfig)表IDint10,0V4PaCkingNO包裝箱號(hào)VarChar50V5CreateTime建創(chuàng)時(shí)間timestampV6OPeratOr創(chuàng)建人VarChar20V7We

18、IghtVarChar30V箱號(hào)詳情表binningpdetaiI描述：箱號(hào)詳情表InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10,02PaCkingNO和Binning表中PaCkingNO關(guān)聯(lián)VarChar50V3SnSNVarChar50V4ImeiIMEI號(hào)VarChar50J5OrderBy序號(hào)intIOtOV6Weight重量VarChar50V木戔板表boxbinning描述：棧板表InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10,02PrOdUCtOrder.idPrOdUC

19、tOrder表IDint10,0V3PaIIetCOnfig_id棧板(PaIletCOnfig)表IDint10r0V4PalletCOnfigNO棧板號(hào)VarChar50V5CreateTime建創(chuàng)時(shí)間dateV6OPeratOr創(chuàng)建人VarChar20V棧板詳情表boxbinningbdetaiI描述：棧板詳情表InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10,02PalletCOnfIgNO和boxbinning表中PaIIetCOnfigNO芋胖VarChar50V3PaCkingNO包裝箱號(hào)VarChar50V4Weight重量d

20、ouble50,2V維修代碼表CategOryeOPtiOn描述：InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10,02CategOry_desc描述VarChar503CategOry.COde維修代碼VarChar504SeCOnd-Category-id大類IDint10,0CheCkedatabaSeeCOnn彩盒重量維護(hù)表COIOUrbOX描述：InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10,00描述：彩盒重量維護(hù)表InnODBfree:5623808kB序號(hào)字段名稱字段描述字段

21、類型長(zhǎng)度允許空缺省值1idint10,02PrOdllCtOrder-ld包裝工單idint10,0V3StandardWelght標(biāo)準(zhǔn)重量VarChar10V4errorScopeMax誤差最大值VarChar10V5errorScopeMin誤差最小VarChar10V參數(shù)配置數(shù)據(jù)表COnfigUratiO/ParameterS描述：InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1id主鍵idint10,02type-name參數(shù)名稱VarChar50V3ConteXt參數(shù)內(nèi)容VarChar500V4ConteXt-explain參數(shù)說明VarChar

22、50V連版和PN綁定信息表COnneCtiOnnUmberePn描述：InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idintIOiO2COnneCtlon-number連版號(hào)VarChar50V3PNPN號(hào)VarChar50V4IPIP地址VarChar50V5StanCeName站位名稱VarChar50V6I線體名稱VarChar50V7OPerater操作人VarChar50V8CUrrenttlme操作時(shí)間VarChar50V9StatUS狀態(tài)tinyint3,0V10remark預(yù)留字段VarChar50/7光板和貼片機(jī)物料批

23、次綁定關(guān)系表COnnebatCheParLnO客戶SN信息維護(hù)CUStOmerS I I-COnfig描述:InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1Id主鍵intI0Q2COnneCtiOnNUmber連版號(hào)VarChar50J3batch.no物料批次號(hào)VarChar50V4part.no料號(hào)VarChar50J5USe-COUnt使用數(shù)量intI0QJ6bord-type版面類型VarChar30J7StanC站位名稱VarChar30J描述：客戶SN信息維護(hù)表InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度

24、允許空缺省值1idint10,02order-no包裝工單號(hào)VarChar1003PrefixSN前綴VarChar504Snleng序列號(hào)長(zhǎng)度int10,0報(bào)表發(fā)送人維護(hù)表C11StOmer-emaiI描述：報(bào)表發(fā)送人維護(hù)表InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10,02CUStOmer客戶名稱VarChar303emaiI要接收的郵VarChar1000daybstatement（已廢棄）描述:InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10,02moVarChar503IineV

25、arChar104StanCenameVarChar205PrOdUCe-COUntint10,06defect-COUntint10,07errorReasonsVarChar5008StartDatetimestamp0000-00-0000:00:009endDatetimestamp0000-00-0000:00:00dccmoJndex（已廢棄）描述:InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10,02Order-numVarChar50V3moVarChar50V4SUbPrOjeCtVarChar30V5CUStomerVar

26、Char20V6WeektimeVarChar20V7COUntint10,0V8fiIeTypeVarChar255V9VerSiOnVarChar255V10rolIbackint10,0011Stateint10,0012CreateDatetimestampdecPsendPrecord（已廢棄）描述：InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10r02moVarChar50V3SUbPrOjeCtVarChar30V4CUStOmerVarChar20V5StanCVarChar20V6COmPUter-numVarC

27、har255V7creater-datetimestampV8OPeratOrSVarChar20V9Sn-Start_noVarChar50V10sn-end-noVarChar50V刪除箱號(hào)詳情記錄CIeLbinningdetaiLlog描述：刪除箱號(hào)詳情記錄InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10。2PaCkingnO已刪除的箱VarChar100V3imeis箱號(hào)中所有的IMEI號(hào)VarChar1000V4IOgtInle記錄時(shí)間timestampV5OPeratOr操作人VarChar50VDePartment（系統(tǒng)設(shè)置相關(guān)

28、表）描述:InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10,02nameVarChar3503PUrVieWtext65535V4discriptionVarChar500VdepartmeTTLpurview彳系統(tǒng)設(shè)置相關(guān)表）描述：InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10r02HameVarChar3503discnptionVarChar500departmenLpurviewJtem（系統(tǒng)設(shè)置相關(guān)表）描述：InnODBfree:5623808kB;CdePartmentPUrV

29、ieWJd'）REFER'dmasg2/departmentPU序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10,02nameVarChar3003discriptionVarChar50074department-PUrVIeW-1dint10,0Jerror,data（已廢棄）描述：InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10,02SnVarChar50J3StanCeVarChar504StanCe_idint10,05enddatetimestampoooo-oo-oo00:00:006errorRea

30、sonVarChar1000上班班次記錄表factoryBworktime描述：InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10,02type站位VarChar103data-type班次VarChar101Start-time上班時(shí)間VarChar300000-00-0000:00:005end-time下班時(shí)間VarChar30oooo-oo-oo00:00:00送檢單信息表inspectionsheet送檢單中的信息詳情inspection-box描述：送檢單信息表InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度

31、允許空缺省值1Idint10,02inspection.no送檢單號(hào)VarChar503order.no工單號(hào)VarChar504PrOdUCt-COde產(chǎn)品編號(hào)VarChar505remark產(chǎn)品描述VarChar50V6COUnt送檢數(shù)量int10,07CUrrenttlme送檢時(shí)間timestampoooo-oo-oo00:00:008qaremarkAQ描述VarChar300V9qaresuItQA判定VarChar300J10OqCremarkOQC描述VarChar300J11OqCreSUItOQC判定結(jié)果VarChar300V12State態(tài)狀int10,0130bIigat

32、eIVarChar300V140bIigate2VarChar300V描述：送檢單中的信息詳情InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10,02inspection.no送檢單號(hào)VarChar503box.noSN號(hào)VarChar5040bIigateIVarChar500J未生成送檢單臨時(shí)詳情表inspection.box-temp序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10,02IP錄記IPVarChar203box-no箱號(hào)VarChar504order-noSN號(hào)VarChar505ObIigateIVarChar

33、200jV包裝抽檢記錄報(bào)表inspeCtion-daiIyjreport品質(zhì)部配置I ME I號(hào)段信息表i nspect i on0rdereSC0Pe描述：包裝抽檢記錄報(bào)表InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1Idint10,02mobile-type機(jī)型VarChar203Pline線另IJVarChar10jV4ClaSSeS班別VarChar10V5inspect-date送檢日期date6order-no工單號(hào)VarChar507inspect-no送檢單VarChar508inspect-batch送檢批次int10.09quaIif

34、ired_batch合格批次int10,010bad.batch不良批次int10,011batch-PaSS.rate批合格率doubleI0,212inspect.num送檢數(shù)量int10,013SamPIing_num抽檢數(shù)量int10,014bad.num不良數(shù)int10,015bad-rate不良率doubleI0.216baddesc不良現(xiàn)象描述VarChar500417Judgment判定VarChar10V18rework-no返工工單VarChar50V19inspection_unit_id預(yù)留字段1VarChar10V200bIigate2預(yù)留字段2VarChar10JV

35、描述：品質(zhì)部配置IMEI號(hào)段信息表InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10,02order.no包裝工單號(hào)VarChar2003imeiLstartIIVI臼1號(hào)段VarChar20開始4imeiLendHVIDi號(hào)段結(jié)束VarChar20V5imei20startIIvl臼2號(hào)段開始值VarChar20J6imei2eendIIvl臼2號(hào)段結(jié)束值VarChar20V7bt-startBT開始值VarChar20J8bt-endBT結(jié)束值VarChar20J9Wifl-StartWIFI開始值VarChar20J10wifi-endW

36、IFI結(jié)束值VarChar20J11ObiigateIVarChar50V包裝抽檢詳情inspectionjrecord描述：包裝抽檢詳情InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10,02inspect_no送檢單號(hào)VarChar203CartOn_noMEID號(hào)VarChar204SnSN號(hào)VarChar205ImeiIVarChar206lmei2VarChar207judgement-：TeSUIt判定結(jié)果VarChar20V8inspect-time檢驗(yàn)時(shí)間timestampJCURRENTTIMESTAMP9inspector檢

37、驗(yàn)員VarChar20V10inspection_unit_id抽檢單位IDint10,0V11bad-type不良類型：錯(cuò)"1»漏混3,其他不良.4VarChar2V12ObiigateI機(jī)型VarChar50V130bIigate2預(yù)留字段2VarChar20V包裝抽檢臨時(shí)保存表inspeCtiOnJreCOrd-temp序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1Idint10,02inspect-no送檢單號(hào)VarChar203Cart0n_noMEID號(hào)VarChar204SnVarChar205ImeiIVarChar206lmei2VarChar207jud

38、gement.:TeSUIt判定結(jié)果VarChar208inspect-time檢驗(yàn)時(shí)間timestampCURRENTTIMESTAMP9inspector檢驗(yàn)員VarChar2010inspection-unit-id抽檢單位IDint10,011bad-type不良類型：錯(cuò)-1»<%-2*混3,其他不良.4VarChar2V12ObiigateI機(jī)型VarChar50V13Obiigate2預(yù)留字段2VarChar20VinspectionjrepolI描述：InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10,02insp

39、ect-no送檢單號(hào)VarChar203order-no工單號(hào)VarChar504inspection_type_id抽檢類型IDint10,05inspeCtiOn-StyIe-id抽檢方式IDint10,06inspeCtOr.OqCOQC檢驗(yàn)員VarChar20J7rework通知返工：0否，1是intIOiO08SPeCiaI-PiCk特采。否，1是int10,009inspection-unit-id抽檢單位int10,0J10ObiigateI送檢時(shí)間VarChar50J11Obiigate2VarChar10Vinspectionpstate描述：InnODBfree:56238

40、08kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1idint10,02StaxenameVarChar50inspectionisunit描述:InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1Idint10,02mark標(biāo)記VarChar103description描述VarChar100過濾登陸權(quán)限配置一ipconfig描述：InnODBfree:5623808kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1IdintI0.02IPIPVarChar303State狀態(tài)int10,0iqC-Smt-biII描述:InnODBfree:5623808

41、kB序號(hào)字段名稱字段描述字段類型長(zhǎng)度允許空缺省值1Idint10,02biII-no檢驗(yàn)單號(hào)VarChar32V3ip.flag標(biāo)識(shí)VarChar15V4State狀態(tài)int10,0V5leVel驗(yàn)收等級(jí)(OneztWOAhree)VarChar10V6rank等級(jí)水準(zhǔn)(B,N,I)VarChar10V7Standar驗(yàn)收水準(zhǔn)VarChar10VTA0c0TIUT丑脩VD和£2Eb譏AO'OTZUTtraSTAOoTZUTVinZXA00g護(hù)頁(yè)廠2。尸PIIAOoTZUT辭業(yè)iunooi6j9pOTAOoTZUTIllnOUxo9dsut6A9inti91Bp%I,9atixo9dsu8AOITZUT再ZUnOO"pudsLAQUnVPUBS9AOS工Eip工EA0uj9pj09AOT工Eip工EAXGPOInPAOS工Eip工EAQUHSAOS工Eip工EAOUFgZO'OTIUTPyI