數(shù)字體化平臺(tái)電子證照數(shù)據(jù)匯聚規(guī)范（知識(shí)研究參考模版）

數(shù)字一體化數(shù)據(jù)匯聚規(guī)范范圍本方案適用于數(shù)字一體化臺(tái)XX子xx數(shù)據(jù)匯聚。規(guī)范性引用文件下列文件對(duì)于本文件的應(yīng)用是必不可少的。凡是注日期的引用文件，僅注日期的版本及其勘誤的內(nèi)容適用于本文件。凡是不注日期的引用文件，其最新版本（包括所有的修改單）適用于本文件。GB/T369xx-2xx8XX子xx總體技術(shù)架構(gòu)GB/T36902-2xx8XX子xx目錄XX息規(guī)范GB/T36903-2xx8XX子xx元數(shù)據(jù)規(guī)范GB/T36904-2xx8XX子xx標(biāo)識(shí)規(guī)范GB/T36905-2xx8XX子xx文件技術(shù)要求GB11714-1997全XX組織機(jī)構(gòu)代碼編制規(guī)則GB32100-2xx5法人和其他組織統(tǒng)一社會(huì)XX用代碼編碼規(guī)則XX關(guān)于在辦理相關(guān)業(yè)務(wù)XX使用統(tǒng)一社會(huì)XX用代碼的通知xx數(shù)據(jù)匯聚各行業(yè)XX子xx分庫系統(tǒng)應(yīng)按照XX子xxXX家標(biāo)準(zhǔn)進(jìn)行建設(shè)、改造，將XX子xx數(shù)據(jù)匯聚至XX子xx總庫。3.1xx數(shù)據(jù)匯聚流程各行業(yè)XX子xx分庫系統(tǒng)使用數(shù)據(jù)庫（Mysql）的方式，通過數(shù)據(jù)共享交換臺(tái)將xx數(shù)據(jù)匯聚到XX子xx總庫（XX子外網(wǎng)）。xx數(shù)據(jù)匯聚包括xx類型數(shù)據(jù)、xxXX息以及xx文件匯聚過程，其XXxx類型數(shù)據(jù)與xxXX息數(shù)據(jù)通過xx類型業(yè)務(wù)主鍵（各行業(yè)分庫維護(hù)的業(yè)務(wù)主鍵，32位UUID）進(jìn)行關(guān)聯(lián)，各分庫必須先將xx類型數(shù)據(jù)上報(bào)，總庫采集xx類型數(shù)據(jù)入庫之后，才會(huì)采集分庫上報(bào)的xxXX息數(shù)據(jù)。即正常流程為：分庫上報(bào)xx類型數(shù)據(jù)、總庫采集xx類型數(shù)據(jù)入庫、分庫上報(bào)已入總庫的xx類型所關(guān)聯(lián)的xxXX息數(shù)據(jù)、總庫采集xxXX息數(shù)據(jù)入庫。分庫數(shù)據(jù)匯聚流程圖如下：3.2數(shù)據(jù)匯聚頻率各行業(yè)XX子xx分庫系統(tǒng)應(yīng)以增量更新的方式將數(shù)據(jù)匯聚到XX子xx總庫，原則上應(yīng)實(shí)時(shí)匯聚增量數(shù)據(jù)，匯聚頻率應(yīng)不低于15分鐘/次。數(shù)據(jù)匯聚表數(shù)據(jù)匯聚涉及5個(gè)表：xx類型數(shù)據(jù)表、xxXX息數(shù)據(jù)表、xx文件數(shù)據(jù)表、xx類型異常數(shù)據(jù)表、xxXX息異常數(shù)據(jù)表。若無特別說明，各表XX的“數(shù)據(jù)規(guī)范”指《數(shù)字一體化臺(tái)XX子xx標(biāo)準(zhǔn)規(guī)范》。表名的*由xx總庫統(tǒng)一分配。4.1xx類型數(shù)據(jù)xx類型數(shù)據(jù)表：*_xxificate_xx字段說明字段名稱字段類型備注主鍵idbigInt非空自增長主鍵xx類型名稱xxificatexxxxmevaxxchaxx(256)非空見數(shù)據(jù)規(guī)范xx類型代碼xxificatexxCoXXvaxxchaxx(128)非空見數(shù)據(jù)規(guī)范xx定義機(jī)構(gòu)xxificateXXfineAuthoxxityxxmevaxxchaxx(128)非空見數(shù)據(jù)規(guī)范xx定義機(jī)構(gòu)代碼xxificateXXfineAuthoxxityCoXXvaxxchaxx(128)非空見數(shù)據(jù)規(guī)范xx定義機(jī)構(gòu)級(jí)別xxificateXXfineAuthoxxityLevelvaxxchaxx(50)允許空值見數(shù)據(jù)規(guī)范關(guān)聯(lián)事項(xiàng)名稱xxelatedItemxxmevaxxchaxx(512)允許空值見數(shù)據(jù)規(guī)范關(guān)聯(lián)事項(xiàng)代碼xxelatedItemCoXXvaxxchaxx(128)允許空值見數(shù)據(jù)規(guī)范持xx主體類別xxificateHolXXxxCategoxxyvaxxchaxx(50)非空見數(shù)據(jù)規(guī)范有效期限范圍validityxxangevaxxchaxx(512)允許空值見數(shù)據(jù)規(guī)范xx頒發(fā)機(jī)構(gòu)xxificateIssuingAuthoxxityxxmetext非空見數(shù)據(jù)規(guī)范xx頒發(fā)機(jī)構(gòu)代碼xxificateIssuingAuthoxxityCoXXtext非空見數(shù)據(jù)規(guī)范xx頒發(fā)機(jī)構(gòu)所屬地XXxx劃代碼xxificateIssuingAxxeaCoXXtext非空見數(shù)據(jù)規(guī)范類別categoxxyvaxxchaxx(10)非空1：xx0：批文xx類型業(yè)務(wù)主鍵xxificatexxIdvaxxchaxx(32)非空各分庫維護(hù)的32位UUID，如af5a9145cd0845c48608b117b722b4e7推送類型pushxxvaxxchaxx(1)非空I：新增U：更新D:刪除推送時(shí)間pushTimedatetime非空數(shù)據(jù)推送至前置庫的時(shí)間采集狀態(tài)fetchStatusvaxxchaxx(2)非空0：待采集1：已采集2：數(shù)據(jù)異常采集時(shí)間fetchTimedatetime允許空值總庫數(shù)據(jù)匯聚程序采集時(shí)間4.2xxXX息數(shù)據(jù)xxXX息數(shù)據(jù)表：*_xxificate字段說明字段名稱字段類型備注主鍵idbigInt非空自增長主鍵xx名稱xxificatexxmevaxxchaxx(512)非空見數(shù)據(jù)規(guī)范xx編號(hào)xxificateNumbexxvaxxchaxx(128)非空見數(shù)據(jù)規(guī)范xx標(biāo)識(shí)xxificateIXXntifiexxvaxxchaxx(128)非空見數(shù)據(jù)規(guī)范xx頒發(fā)日期xxificateIssuedDatevaxxchaxx(32)非空見數(shù)據(jù)規(guī)范持xx主體xxificateHolXXxxxxmetext非空見數(shù)據(jù)規(guī)范持xx主體代碼xxificateHolXXxxCoXXtext非空見數(shù)據(jù)規(guī)范持xx主體代碼類型xxificateHolXXxxxxxxmevaxxchaxx(500)非空見數(shù)據(jù)規(guī)范持xx主體代碼類型代碼xxificateHolXXxxxxCoXXvaxxchaxx(1000)非空見數(shù)據(jù)規(guī)范xx有效期起始日期xxificateEffectiveDatevaxxchaxx(32)非空見數(shù)據(jù)規(guī)范xx有效期截止日期xxificateExpixxingDatevaxxchaxx(32)非空見數(shù)據(jù)規(guī)范xx類型業(yè)務(wù)主鍵xxificatexxIdvaxxchaxx(32)非空各分庫維護(hù)的32位UUID，如af5a9145cd0845c48608b117b722b4e7持xx主體類別xxificateHolXXxxCategoxxyvaxxchaxx(50)非空“自然人”、“法人或其他組織”、“其他”照面擴(kuò)展數(shù)據(jù)xxificateSuxxfacetext允許空值見4.2.1明細(xì)擴(kuò)展數(shù)據(jù)xxificateXXtailtext允許空值見4.2.2批文擴(kuò)展數(shù)據(jù)appxxovalSuxxfacetext允許空值見4.2.3xx狀態(tài)xxificateStatusvaxxchaxx(2)非空0：有效1：暫時(shí)失效2：已過期3：已作廢xx文件類型xxificateFilexxvaxxchaxx(1)非空0：暫無文件1：ofd2：pdfxx文件有無XX子簽章hasSigxxtuxxevaxxchaxx(1)非空0：無XX子簽章1：有XX子簽章推送類型pushxxvaxxchaxx(1)非空I：新增U：更新D:刪除推送時(shí)間pushTimedatetime非空數(shù)據(jù)推送至前置庫的時(shí)間采集狀態(tài)fetchStatusvaxxchaxx(2)非空0：待采集1：已采集2：數(shù)據(jù)異常采集時(shí)間fetchTimedatetime允許空值總庫數(shù)據(jù)匯聚程序采集時(shí)間4.2.1照面擴(kuò)展數(shù)據(jù)格式[{ "xxme":"照面XX息1名稱", "value":"照面XX息1值", "valuexx":"值類型(pictuxxe/stxxing/datetime)", "columnxxme":"照面XX息1名稱的英文/拼音縮寫"},{ "xxme":"業(yè)務(wù)范圍", "value":"學(xué)術(shù)研究、采訪報(bào)道、交流聯(lián)系、組織比賽", "valuexx":"stxxing", "columnxxme":"KZ_YWFW"}]pictuxxe：base64編碼的字符串；datetime：格式化為yyyyMMddHHmmss，即2xx903xx91000。4.2.2明細(xì)擴(kuò)展數(shù)據(jù)格式[{ "gxxoup":"分組名稱1", "datalist":[{ "xxme":"明細(xì)XX息1名稱", "valuexx":"值類型(pictuxxe/stxxing/datetime)", "value":"明細(xì)XX息1值", "columnxxme":"照面XX息1名稱的英文/拼音縮寫", "oxxXXxxNum":"序號(hào)1" }]},{ "gxxoup":"年檢記錄", "datalist":[{ "xxme":"日期", "valuexx":"stxxing", "value":"2xx7年", "columnxxme":"KZ_xxQ", "oxxXXxxNum":"1" },{ "xxme":"年檢記錄", "valuexx":"stxxing", "value":"", "columnxxme":"KZ_NJJL", "oxxXXxxNum":"1" },{ "xxme":"日期", "valuexx":"stxxing", "value":"2xx8年", "columnxxme":"KZ_xxQ", "oxxXXxxNum":"2" },{ "xxme":"年檢記錄", "valuexx":"stxxing", "value":"", "columnxxme":"KZ_NJJL", "oxxXXxxNum":"2"}]}]pictuxxe：base64編碼的字符串；datetime：格式化為yyyyMMddHHmmss，即2xx903xx91000。4.2.3批文擴(kuò)展數(shù)據(jù)格式{ "title":"批文標(biāo)題，必填。如：關(guān)于XXX的批復(fù)" "mainSend":"主送，非必填。如：XXXxxx", "seSend":"抄送，非必填。如：XX,XXXxxx", "pxxojectxxme":"項(xiàng)目名稱，非必填。如：XXX工程", "pxxojectCoXX":"項(xiàng)目代碼，非必填。如：XXXX"}4.3xx文件數(shù)據(jù)xx文件數(shù)據(jù)表：*_xxificate_file字段說明字段名稱字段類型備注主鍵idbigInt非空自增長主鍵xx標(biāo)識(shí)xxificateIXXntifiexxvaxxchaxx(128)非空見數(shù)據(jù)規(guī)范xx文件xxificateFilemediumBlob非空XX子xx文件推送時(shí)間pushTimedatetime非空數(shù)據(jù)推送至前置庫的時(shí)間采集狀態(tài)fetchStatusvaxxchaxx(2)非空0：待采集

1：已采集采集時(shí)間fetchTimedatetime允許空值總庫數(shù)據(jù)匯聚程序采集時(shí)間數(shù)據(jù)推送表5.1xx類型異常數(shù)據(jù)xx類型異常數(shù)據(jù)表：*_xxificate_xx_exxxxoxx字段說明字段名稱字段類型備注主鍵idbigInt非空自增長主鍵xx類型名稱xxificatexxxxmevaxxchaxx(256)非空見數(shù)據(jù)規(guī)范xx類型代碼xxificatexxCoXXvaxxchaxx(128)非空見數(shù)據(jù)規(guī)范xx定義機(jī)構(gòu)xxificateXXfineAuthoxxityxxmevaxxchaxx(128)非空見數(shù)據(jù)規(guī)范xx定義機(jī)構(gòu)代碼xxificateXXfineAuthoxxityCoXXvaxxchaxx(128)非空見數(shù)據(jù)規(guī)范xx定義機(jī)構(gòu)級(jí)別xxificateXXfineAuthoxxityLevelvaxxchaxx(50)允許空值見數(shù)據(jù)規(guī)范關(guān)聯(lián)事項(xiàng)名稱xxelatedItemxxmevaxxchaxx(512)允許空值見數(shù)據(jù)規(guī)范關(guān)聯(lián)事項(xiàng)代碼xxelatedItemCoXXvaxxchaxx(128)允許空值見數(shù)據(jù)規(guī)范持xx主體類別xxificateHolXXxxCategoxxyvaxxchaxx(50)非空見數(shù)據(jù)規(guī)范有效期限范圍validityxxangevaxxchaxx(512)允許空值見數(shù)據(jù)規(guī)范xx頒發(fā)機(jī)構(gòu)xxificateIssuingAuthoxxityxxmetext非空見數(shù)據(jù)規(guī)范xx頒發(fā)機(jī)構(gòu)代碼xxificateIssuingAuthoxxityCoXXtext非空見數(shù)據(jù)規(guī)范xx頒發(fā)機(jī)構(gòu)所屬地XXxx劃代碼xxificateIssuingAxxeaCoXXtext非空見數(shù)據(jù)規(guī)范類別categoxxyvaxxchaxx(10)非空1：xx0：批文xx類型業(yè)務(wù)主鍵xxificatexxIdvaxxchaxx(32)非空32位UUID推送類型pushxxvaxxchaxx(1)非空I：新增U：更新D:刪除推送時(shí)間pushTimedatetime非空數(shù)據(jù)推送至前置庫的時(shí)間異常說明exxxxoxxxxemaxxkvaxxchaxx(1000)非空5.2xxXX息異常數(shù)據(jù)xxXX息異常數(shù)據(jù)表：*_xxificate_exxxxoxx字段說明字段名稱字段類型備注主鍵idbigInt非空自增長主鍵xx名稱xxificatexxmevaxxchaxx(512)非空見數(shù)據(jù)規(guī)范xx編號(hào)xxificateNumbexxvaxxchaxx(128)非空見數(shù)據(jù)規(guī)范xx標(biāo)識(shí)xxificateIXXntifiexxvaxxchaxx(128)非空見數(shù)據(jù)規(guī)范xx頒發(fā)日期xxificateIssuedDatevaxxchaxx(32)非空見數(shù)據(jù)規(guī)范持xx主體xxificateHolXXxxxxmetext非空見數(shù)據(jù)規(guī)范持xx主體代碼xxificateHolXXxxCoXXtext非空見數(shù)據(jù)規(guī)范持xx主體代碼類型xxificateHolXXxxxxxxmevaxxchaxx(500)非空見數(shù)據(jù)規(guī)范持xx主體代碼類型代碼xxificateHolXXxxxxCoXXvaxxchaxx(1000)非空見數(shù)據(jù)規(guī)范xx