林業(yè)項(xiàng)目管理系統(tǒng)-數(shù)據(jù)庫(kù)設(shè)計(jì)說明書

1、編號(hào)：xx-ts-05-yymmdd-nn密級(jí)：內(nèi)部財(cái)政資金監(jiān)控管理系統(tǒng)數(shù)據(jù)庫(kù)設(shè)計(jì)說明書編制人李春東編制日期2015-10-12審核人審核日期批準(zhǔn)人批準(zhǔn)日期運(yùn)龍圖軟件深圳市龍圖軟件有限公司版權(quán)所有不得翻錄文件更改記錄版本號(hào)狀 態(tài)修改內(nèi)容概要/引見說明修訂日期修訂人批準(zhǔn)人v1.0n新建文檔結(jié)構(gòu)2015-10-12李春東v1.1m2015-10-13吳鳳權(quán)注：初始版木號(hào)：v1.0；每次修訂批準(zhǔn)后，版木號(hào)加“1” ；狀態(tài)包括：n新建，a增加，m修改，d刪除。目錄1引言11.1編寫口的11.2背景11.3定義21.4參考資料22外部設(shè)計(jì)22.1標(biāo)識(shí)符和約定22.2使用它的程序32.3約定32.4專門指

2、導(dǎo)32.5支持軟件33結(jié)構(gòu)設(shè)計(jì)43.1邏輯結(jié)構(gòu)設(shè)計(jì)43.2物理結(jié)構(gòu)設(shè)計(jì)44運(yùn)用設(shè)計(jì)（按下列框架結(jié)構(gòu)進(jìn)行描述）54數(shù)據(jù)庫(kù)參數(shù)54.2表空間54.3用戶54.4數(shù)據(jù)字典54.4.1 表54.4.2 視圖604.4.3存儲(chǔ)過程614.4.4 函數(shù)624.4.5觸發(fā)器624.5安全保密設(shè)計(jì)641引言1-1編寫目的林業(yè)項(xiàng)目管理系統(tǒng)系統(tǒng)數(shù)據(jù)庫(kù)設(shè)計(jì)說明書（以下使用簡(jiǎn)稱：林業(yè)項(xiàng)目管 理數(shù)據(jù)設(shè)計(jì)）是用于對(duì)”林業(yè)項(xiàng)目管理系統(tǒng)”在開發(fā)和后續(xù)維護(hù)過程屮對(duì)系統(tǒng)使用 的表，觸發(fā)器，存儲(chǔ)過程，定時(shí)任務(wù)，序列等數(shù)據(jù)庫(kù)工具進(jìn)行規(guī)范和記錄，方便 對(duì)開發(fā)過程屮產(chǎn)生的表，觸發(fā)器，存儲(chǔ)過程，定吋任務(wù)，序列等進(jìn)行管理和登記。在開發(fā)和維護(hù)

3、過程中產(chǎn)生的表，觸發(fā)器，存儲(chǔ)過程，定時(shí)任務(wù)，序列等 均需耍加入到本文檔（林業(yè)項(xiàng)冃管理數(shù)據(jù)設(shè)計(jì)），如有修改，需要及時(shí)更新木文 檔（林業(yè)項(xiàng)目管理數(shù)據(jù)設(shè)計(jì)），以便保持本文檔（林業(yè)項(xiàng)目管理數(shù)據(jù)設(shè)計(jì)）與系 統(tǒng)同步并一致。林業(yè)項(xiàng)口管理數(shù)據(jù)設(shè)計(jì)可能涉及的讀者包括開發(fā)人員、用戶方技術(shù)人員、 數(shù)據(jù)庫(kù)維護(hù)人員等。1.2背景林業(yè)項(xiàng)目管理數(shù)據(jù)設(shè)計(jì)是在開發(fā)”林業(yè)項(xiàng)目管理系統(tǒng)”屮為方便記錄先關(guān)的 表，觸發(fā)器，存儲(chǔ)過程，定時(shí)任務(wù)，序列等數(shù)據(jù)庫(kù)工具產(chǎn)物而生成的一份數(shù)據(jù)庫(kù) 設(shè)計(jì)文檔，應(yīng)用本文檔可以很好的管理產(chǎn)品開發(fā)，運(yùn)維階段產(chǎn)生的各種表，觸發(fā) 器，存儲(chǔ)過程，定時(shí)任務(wù)，序列等數(shù)據(jù)庫(kù)產(chǎn)物。資金監(jiān)管數(shù)據(jù)設(shè)計(jì)的編寫是建立在：1. 數(shù)據(jù)

4、庫(kù)系統(tǒng)：oracle 10g2. 數(shù)據(jù)庫(kù)宿主環(huán)境：xp,win7, linux,unix等。1.3定義fpms： forestry project management system,林業(yè)項(xiàng)目管理系統(tǒng)cdm： conceptual data model,概念數(shù)據(jù)模型pdm： physical data model,物理數(shù)據(jù)模型1.4參考資料基于平臺(tái)的林業(yè)項(xiàng)目管理系統(tǒng)規(guī)劃方案書.docx基于平臺(tái)的林業(yè)項(xiàng)目管理系統(tǒng)需求規(guī)格說明書.doc林業(yè)項(xiàng)h管理系統(tǒng)系統(tǒng)概要設(shè)計(jì)說明書林業(yè)項(xiàng)目管理系統(tǒng)系統(tǒng)詳細(xì)設(shè)計(jì)說明書林業(yè)項(xiàng)口管理系統(tǒng)產(chǎn)品需求規(guī)格說明書等2外部設(shè)計(jì)2.1標(biāo)識(shí)符和約定本數(shù)據(jù)庫(kù)約定如卜：本數(shù)據(jù)庫(kù)中的所

5、有表均以“t_fpms”為前綴，如項(xiàng)目主表名稱為 t_fpmsprojectmain對(duì)于表示實(shí)體間對(duì)應(yīng)關(guān)系的表以“fpins_”前綴加兩個(gè)實(shí)體名組成，如 果項(xiàng)fi主表為t_fpmsprojectmain,單位表為t_pubagency,其他約束 條件以具體業(yè)務(wù)表為準(zhǔn)。本數(shù)據(jù)庫(kù)的表中的字段均不加前綴本數(shù)據(jù)庫(kù)的視圖均以“v_fpms”為前綴本數(shù)據(jù)庫(kù)優(yōu)化表均以_v_fpms”為前綴本數(shù)據(jù)庫(kù)同義詞/dblink均以“fpms"為前綴本數(shù)據(jù)庫(kù)小的存儲(chǔ)均以“pkg_fpms_”為前綴本數(shù)據(jù)庫(kù)中的參數(shù)均以前綴木數(shù)據(jù)庫(kù)約定所有要求概念數(shù)據(jù)模型(cdm)中的實(shí)體所對(duì)應(yīng)的表以billid為主鍵，其它表以

6、int自增類型字段為主鍵。本數(shù)據(jù)庫(kù)中的序列均以“s_”為前綴22使用它的程序fpms系統(tǒng)2.3約定按功能來說，該數(shù)據(jù)庫(kù)表可分可以下兒種類型：數(shù)據(jù)接收使用的表和視圖：這些是項(xiàng)目主表用于接收數(shù)據(jù)并進(jìn)行數(shù)據(jù)處 理的表，主要有數(shù)據(jù)接收表、數(shù)據(jù)接收志表，接收數(shù)據(jù)處理表，接收 數(shù)據(jù)處理日志表等。優(yōu)化表：按照口徑視圖生成的優(yōu)化表，主要為提高展示界面查詢速度。用戶錄入的表：主要用于財(cái)政項(xiàng)目或基建項(xiàng)目的項(xiàng)目申報(bào)、資金下達(dá)等 功能的數(shù)據(jù)采集。圖表展示配置表：主要用戶界面圖形和表格展示配置便用2.4專門指導(dǎo)向準(zhǔn)備從事此數(shù)據(jù)庫(kù)的生成、從事此數(shù)拯庫(kù)的測(cè)試、維護(hù)人員提供專門的指 導(dǎo)，例如將被送入數(shù)據(jù)庫(kù)的數(shù)據(jù)的格式和標(biāo)準(zhǔn)、

7、送入數(shù)據(jù)庫(kù)的操作規(guī)程和步驟， 用于產(chǎn)生、修改、更新或使用這些數(shù)據(jù)文卷的操作指導(dǎo)。如果這些指導(dǎo)的內(nèi)容篇 幅很長(zhǎng)，列出可參閱的文件資料的名稱和章條。2.5支持軟件本數(shù)據(jù)庫(kù)支持oracle數(shù)拯庫(kù),plsql等。sare魚 行政區(qū)劃©code pk3結(jié)構(gòu)設(shè)計(jì)3.1邏輯結(jié)構(gòu)設(shè)計(jì)3.2物理結(jié)構(gòu)設(shè)計(jì)本數(shù)據(jù)庫(kù)物理數(shù)據(jù)模型（fpms）如下:t£mm saudi審核結(jié)果t fmmsbudetinci市級(jí)預(yù)算t_£mm s gathervoucherbdgop ©x一記錄操 1 乍 鶴id fkt£mm sb dg2 i nddep.中管理處室關(guān)系sfil 上傳文件

8、t fmmsbdgallotwarnrule f$ 規(guī)則qbillid pktfmmsbdgrulei gnoreb§,則qbillid pkt£mm sb dgall o tw ar nr uledetai 預(yù)警規(guī)則明細(xì)qbillid pkt_fmmsgatherbdgrelati on_ 推送©id fkt£mm sb dgi-ulei gnor el o g 忽略規(guī)則明細(xì)t fmm s gatherl o g 推送表0pk integer (22)t.fmm shui m x ndat民預(yù)算支付t£mmsglbdgrelati on 系表

9、t£唄s t ask 預(yù)警查詢按核實(shí)任務(wù)qbillid pkt_fmmshqdaiweibi ao_華青單位表districtid pkt fmm s gatherrecordb dgjn odi £y 修改后實(shí)際數(shù) isqbillid pkt v fmm sbudge t i n jej(府預(yù)尊數(shù)據(jù) 收入預(yù)算t fmmsgatherbdgrelati onmodi £y彥改后數(shù)據(jù)t fmm s glvoucherbdgop ex記錄操作qid pktfmmsmoni torruledetail m控規(guī)則一明細(xì) ruleid pkt£mm soptimi

10、 zati one onfi 優(yōu)化表生成t fmmsplaitprogress計(jì)劃執(zhí)行進(jìn)度qid fkqid pkt_fmmsprojec tp © oplebenefi 逐itwmid pkt_fmmsmonitorruletype m控類型t fmm ssrzsj hb 華青年初預(yù)算q,billid pkidatakey pkt-jfmm seightrealp ayj u頁(yè)支出考核表t fmmsdatari ght權(quán)限t fmm si as tye ar 1 nc om e 年收入sb dgall o t dat ade tai 1-分那明細(xì)t_£mm si aw匚法

11、律法規(guī)qbillid pkt_£mm寸 j &t i onpr o j pr o gj頁(yè)目工程關(guān)系 itemid pki t ffmnsauesti ontype 問題類型t_£mmsmoni torrule則xrs-一一pkqruleid pkt£mm sthi-ee本預(yù)算年初t fmms three fundci tybudget 市縣-本預(yù)算t fmm s s angongdat 2 公經(jīng)費(fèi)qdatakey fkgo vid pksarea.re alp區(qū)劃預(yù)算支付t.fmmsparamsetjk 程調(diào)用蚩數(shù)sallotedgdgp gdo j按文號(hào)

12、統(tǒng)計(jì)預(yù)算支付i.fmm sp e opl el i veho o d r ealp 包 y 民生工程t £mm spr ogres sw ar 幾出進(jìn)度監(jiān)控sincomedetailthi sye ar 收入分析監(jiān)控按月數(shù)拡qid pksexebalancep矽負(fù)算支出蟲余結(jié)轉(zhuǎn)上行t v fmmsexepay預(yù)算支出頂行s them e t e chnol o gy ©xp 科技經(jīng)費(fèi)支出si e addat j領(lǐng)導(dǎo)界面w code_區(qū)劃 string(50)t v fmmsei ghtrealpayj u頁(yè)支出考核克t.v.fmm s govbudge t ©xp

13、 jjj府預(yù)算戈出賴算4運(yùn)用設(shè)計(jì)4.1數(shù)據(jù)庫(kù)參數(shù)4.2表空間blobsbj,busidatasbj,busidxsbj,ltlobdata01 ,ltsysdata01, ltsys data02 ,ltsys data04 ,ltsys data074.3用戶省本級(jí)用戶、數(shù)據(jù)中心庫(kù)用戶4.4數(shù)據(jù)字典4.4.1 表4.4.1.1 t-fpmsprojectmain 表數(shù)據(jù)庫(kù)字段名稱數(shù)據(jù)類型是否為空備注billidnumbernfpmsbdgagencynumberylastupdatetimenumberyvchtypeidnumberycreatetimevarchar2ywfidnumbe

14、rybillstatusnumberycreaternumberywfstatusvarchar2ybillcodevarchar2yuseridnumberyspecialfundsnumberyprojectnamevarchar2yprojectcodevarchar2yimplementagencyvarchar2yprojectpropertiesnumberyprojecttypenumberydeclaredatevarchar2ydeclarationnumbervarchar2ysitevarchar2ylocationvarchar2ycontentvarchar2ysca

15、levarchar2ystartdatevarchar2yenddatevarchar2yfilenamevarchar2yfilenameurlvarchar2yamt01numberyamt02numberybdgagencynumberyissuededamtnumberyissuednumberyprojectpropertynumberyanalysisvarchar2ycapitalsource_mcodevarchar2ycapitalsource.mvalvarchar2ycategorycodevarchar2ycategorynamevarchar2ycategoryidn

16、umberyconditionvarchar2ynecessaryvarchar2ycenternumberylocalnumberyplannumberycategorytypenumberyfilenumnumberyaplacenumberyacenternumberyissplacenumberyisscenternumberyselfnumberycapitalsourcevarchar2ybalancefundnumberynewnamevarchar2y4-4-1.2 t_fpmsprojectmainlog 表數(shù)據(jù)庫(kù)字段名稱rj-i 、比 irii 數(shù)據(jù)類型是否為空備注logn

17、onumbernbillidnumberyfpmsbdgagencynumberylastupdatetimenumberyvchtypeidnumberycreatetimevarchar2ywfidnumberybillstatusnumberycreaternumberywfstatusvarchar2ybillcodevarchar2yuseridnumberyspecialfundsnumberyprojectnamevarchar2yprojectcodevarchar2yimplementagencyvarchar2yprojectpropertiesnumberyproject

18、typenumberydeclaredatevarchar2ydeclarationnumbervarchar2ysitevarchar2ylocationvarchar2ycontentvarchar2yscalevarchar2ystartdatevarchar2yenddatevarchar2yfilenamevarchar2yfilenameurlvarchar2yamt01numberyamt02numberybdgagencynumberyissuededamtnumberyissuednumberyprojectpropertynumberyanalysisvarchar2yca

19、pitalsource_mcodevarchar2ycapitalsource_mvalvarchar2ycategorycodevarchar2ycategorynamevarchar2ycategoryidnumberyconditionvarchar2ynecessaryvarchar2ycenternumberylocalnumberyplannumberycategorytypenumberyfilenumnumberyaplacenumberyacenternumberyissplacenumberyisscenternumberyselfnumberycapitalsourcev

20、archar2ybalancefundnumberynewnamevarchar2y4.4.1.3 t.fpmscategory 表數(shù)據(jù)庫(kù)字段名稱數(shù)據(jù)類型是否為空備注billidnumbernfpmsbdgagencynumberylastupdatetimenumberyvchtypeidnumberycreatetimevarchar2ywfidnumberybillstatusnumberycreaternumberywfstatusvarchar2ybillcodevarchar2yuseridnumberycategorycodevarchar2ycategorynamevarcha

21、r2yremarkvarchar2ycategorytypevarchar2ycapitalsource_mcodevarchar2yyearnumberycapitalsourcevarchar2ycapitalsource_mvalvarchar2ycomcatenamevarchar2yisshownumbery4.4.1.4 t_fpmsauditmsg 表數(shù)據(jù)庫(kù)字段名稱數(shù)據(jù)類型是否為空備注billidnumberycreaternumberybdgagencynumberycreatetimevarchar2yvchcodevarchar2yauditmsgvarchar2yproj

22、ectidnumberywfstatusvarchar2y4.4.1.5 t.fpmschange 表數(shù)據(jù)庫(kù)字段名稱數(shù)據(jù)類型是否為空備注billidnumbernfpmsbdgagencynumberylastupdatetimenumberyvchtypeidnumberycreatetimevarchar2ywfidnumberybillstatusnumberycreaternumberywfstatusvarchar2ybillcodevarchar2yuseridnumberycapitalsourcevarchar2ycapitalsource_mvalvarchar2ycapit

23、alsource_mcodevarchar2yyearvarchar2yprojectnamevarchar2yreplydatevarchar2yplanvarchar2ycentervarchar2ylocalnumberysitevarchar2ycontentvarchar2yfilenamevarchar2yfilenameurlvarchar2yprojectcodevarchar2yprojectidnumberybdgagencynumberyfpmsbdgagencynumberychangereasonvarchar2yfilenumnumberyselfnumberyca

24、tegoryidnumberyspecialfundsnumberycategorytypenumberychangenumvarchar2ychangefilevarchar2ychangefileurlvarchar2ynewnamevarchar2y4.4.1.6 t_changelog 表數(shù)據(jù)庫(kù)字段名稱數(shù)據(jù)類型是否為空備注lognonumbernbillidnumberyfpmsbdgagencynumberylastupdatetimenumberyvchtypeidnumberycreatetimevarchar2ywfidnumberybillstatusnumberycreat

25、ernumberywfstatusvarchar2ybillcodevarchar2yuseridnumberycapitalsourcevarchar2ycapitalsource_mvalvarchar2ycapitalsource_mcodevarchar2yyearvarchar2yprojectnamevarchar2yreplydatevarchar2yplanvarchar2ycentervarchar2ylocalnumberysitevarchar2ycontentvarchar2yfilenamevarchar2yfilenameurlvarchar2yprojectcod

26、evarchar2yprojectidnumberybdgagencynumberyfpmsbdgagencynumberychangereasonvarchar2yfilenumnumberyselfnumberycategory1dnumberyspecialfundsnumberycategorytypenumberychangenumvarchar2ychangefilevarchar2ychangefileurlvarchar2ynewnamevarchar2y4-4-1.7 t.fpmscheck 表數(shù)據(jù)庫(kù)字段名稱rj-i 、比 irii 數(shù)據(jù)類型是否為空備注billidnumbe

27、rnfpmsbdgagencynumberylastupdatetimenumberyvchtypeidnumberycreatetimevarchar2ywfidnumberybillstatusnumberycreaternumberywfstatusvarchar2ybillcodevarchar2yuseridnumberycapitalsourcevarchar2ycapitalsource_mvalvarchar2ycapitalsource_mcodevarchar2yyearvarchar2yprojectnamevarchar2ystartdatevarchar2yendda

28、tevarchar2yunitvarchar2yconstructionunitvarchar2ycheckdatevarchar2ycheckunitvarchar2ycheckeresultvarchar2ycheckervarchar2ysurveyvarchar2yauditreportvarchar2yengineeringreportvarchar2ydatavarchar2yvchtypeidnumberyprojectcodevarchar2yprojectidnumberycategoryidnumberyengineeringreporturlvarchar2yauditr

29、eporturlvarchar2ydataurlvarchar2yfilenamevarchar2yfilenameurlvarchar2ynewnamevarchar2yissueddatevarchar2ybatchvarchar2yisscenternumberyissplacenumberybalancefundnumberyissuededamtnumberyissuednumberybdgagencynumberycategorytypenumberyspecialfundsnumberycategoryidnumberyfilenumnumbery4.4.1.8 t_fpmsch

30、ecklog 表數(shù)據(jù)庫(kù)字段名稱數(shù)據(jù)類型是否為空備注billidnumberyfpmsbdgagencynumberylastupdatetimenumberyvchtypeidnumberycreatetimevarchar2ywhdnumberybillstatusnumberycreaternumberywfstatusvarchar2ybillcodevarchar2yuseridnumberylognonumberncapitalsourcevarchar2ycapitalsource_mvalvarchar2ycapitalsource_mcodevarchar2yyearvarch

31、ar2yprojectnamevarchar2ystartdatevarchar2yenddatevarchar2yunitvarchar2yconstructionunitvarchar2ycheckdatevarchar2ycheckunitvarchar2ycheckeresultvarchar2ycheckervarchar2ysurveyvarchar2yauditreportvarchar2yengineeringreportvarchar2ydatavarchar2yvchtypeidnumberyprojectcodevarchar2yprojectidnumberycateg

32、oryidnumberyengineeringreporturlvarchar2yauditreporturlvarchar2ydataurlvarchar2yfilenamevarchar2yfilenameurlvarchar2ynewnamevarchar2yissueddatevarchar2ybatchvarchar2yisscenternumberyissplacenumberybalancefundnumberyissuededamtnumberyissuednumberybdgagencynumberycategorytypenumberyspecialfundsnumbery

33、categoryidnumberyfilenumnumbery4.4.1.9 t.fpmscheckapply 表數(shù)據(jù)庫(kù)字段名稱數(shù)據(jù)類型是否為空備注billidnumbernfpmsbdgagencynumberylastupdatetimenumberyvchtypeidnumberycreatetimevarchar2ywfidnumberybillstatusnumberycreaternumberywfstatusvarchar2ybillcodevarchar2yuseridnumberycapitalsourcevarchar2ycapitalsource_mvalvarchar2

34、ycapitalsource_mcodevarchar2yyearvarchar2yprojectnamevarchar2ystartdatevarchar2yenddatevarchar2yunitvarchar2yconstructionunitvarchar2ycheckdatevarchar2ycheckunitvarchar2ycheckeresultvarchar2ycheckervarchar2ysurveyvarchar2yauditreportvarchar2yengineeringreportvarchar2ydatavarchar2yvchtypeidnumberypro

35、jectcodevarchar2yprojectidnumberycategoryidnumberyengineeringreporturlvarchar2yauditreporturlvarchar2ydataurlvarchar2yfilenamevarchar2yfilenameurlvarchar2ynewnamevarchar2yaccvarchar2yaccurlvarchar2ybdgagencynumberyfilenumnumberyspecialfundsnumberycategorytypenumbery4.4.1.10 t_fpmscheckapplylog 表數(shù)據(jù)庫(kù)字

36、段名稱數(shù)據(jù)類型是否為空備注billidnumbernfpmsbdgagencynumberylastupdatetimenumberyvchtypeidnumberycreatetimevarchar2ywhdnumberybillstatusnumberycreaternumberywfstatusvarchar2ybillcodevarchar2yuseridnumberycapitalsourcevarchar2ycapitalsource_mvalvarchar2ycapitalsource_mcodevarchar2yyearvarchar2yprojectnamevarchar2y

37、startdatevarchar2yenddatevarchar2yunitvarchar2yconstructionunitvarchar2ycheckdatevarchar2ycheckunitvarchar2ycheckeresultvarchar2ycheckervarchar2ysurveyvarchar2yauditreportvarchar2yengineeringreportvarchar2ydatavarchar2yvchtypeidnumberyprojectcodevarchar2yprojectidnumberycategoryidnumberyengineeringr

38、eporturlvarchar2yauditreporturlvarchar2ydataurlvarchar2yfilenamevarchar2yfilenameurlvarchar2ynewnamevarchar2yaccvarchar2yaccurlvarchar2ybdgagencynumberyfilenumnumberyspecialfundsnumberycategorytypenumberylognonumbern4.4.1.11 t.fpmscitycheck 表billidnumbernmainidnumberycheckunitvarchar2yisthroughnumbe

39、rycheckeresultvarchar2ycheckdatevarchar2ycheckervarchar2yfilenameurlvarchar2yfilenamevarchar2yprojectidnumberycreaternumberycreatetimenumberyuseridnumberymainwfstatusvarchar2yfilenumnumberybdgagencynumbery4.4.1.12 t_fpmscitychecklog 表lognonumbernbillidnumberymainidnumberycheckunitvarchar2yisthroughn

40、umberycheckeresultvarchar2ycheckdatevarchar2ycheckervarchar2yfilenameurlvarchar2yfilenamevarchar2yprojectidnumberycreaternumberycreatetimenumberyuseridnumberymainwfstatusvarchar2yfilenumnumberybdgagencynumbery4.4.1.13 t.fpmsprovincecheck 表billidnumbernmainidnumberycheckunitvarchar2yisthroughnumberyc

41、heckeresultvarchar2ycheckdatevarchar2ycheckervarchar2yfilenameurlvarchar2yfilenamevarchar2yprojectidnumberycreaternumberycreatetimenumberyuseridnumberymainwfstatusvarchar2yfilenumnumberybdgagencynumbery4.4.1.14 t_fpmsprovincechecklog 表lognonumbernbillidnumberymainidnumberycheckunitvarchar2yisthrough

42、numberycheckeresultvarchar2ycheckdatevarchar2ycheckervarchar2yfilenameurlvarchar2yfilenamevarchar2yprojectidnumberycreaternumberycreatetimenumberyuseridnumberymainwfstatusvarchar2yfilenumnumberybdgagencynumbery4-4-1.15 t.fpmsdesign 表數(shù)據(jù)庫(kù)字段名稱rj-i 、比 irii 數(shù)據(jù)類型是否為空備注billidnumbernfpmsbdgagencynumberylast

43、updatetimenumberyvchtypeidnumberycreatetimevarchar2ywfidnumberybillstatusnumberycreaternumberywfstatusvarchar2ybillcodevarchar2yuseridnumberycapitalsourcevarchar2ycapitalsource_mvalvarchar2ycapitalsource_mcodevarchar2yyearnumberyprojectnamevarchar2yagencyvarchar2yrepresentvarchar2yengineervarchar2yleadervarchar2ydirectorvarchar2yqualitypersonvarchar2ypersonnellistvarchar2ycertificatevarchar2yconditionvarchar2ynecessaryvarchar2ytargetvarchar2ycon