固定資產(chǎn)管理系統(tǒng)數(shù)據(jù)庫文檔

1、固定資產(chǎn)管理系統(tǒng)數(shù)據(jù)庫文檔河南眾景信息技術(shù)2022 年 12 月數(shù)據(jù)庫屬性 3.數(shù)據(jù)庫表說明 3.2.1 assets_ir表3.2.2 assets_ou表3.2.3 assets表4.2.4 assets_jxc表5.2.5 check_Assets表5.2.6 check_Re nwu 表5.2.7 factory 表6.2.8 history 表6.2.9 historyBorrow 表6.2.10 n assets表7.2.11 pan dia n 表8.2.12 privateType 表9.2.13 rfidInfo 表9.2.14 state表9.2.15 type 表9.2.

2、16 Uni versalType 表102.17 UpdateLog 表104、數(shù)據(jù)庫屬性數(shù)據(jù)庫系統(tǒng)：SQL Server2005數(shù)據(jù)庫名稱：assetsMa nager數(shù)據(jù)庫賬號：sa數(shù)據(jù)庫密碼：1231、數(shù)據(jù)庫表說明assetsManager 庫中的表2.1 assets表入庫登記表，結(jié)構(gòu)如以下圖所示名丘琴曲K孚 rull int00(ZJ3*111kjdint00jingbanrenvarchar5C0jic_nurnht00jic.danjiavarchar500inlirrwdatftinTip00be±:hLivarchar20002.2 assets_out 表出庫登

3、記表，結(jié)構(gòu)如以下圖所示地不晝nullid.iintcDirt00lingycngrenwarchar500numint00ciitTirnedatetiine00nbeizhuwarehar200Du2.3 assets 表設(shè)備臺賬表，結(jié)構(gòu)如以下圖所示idNOintvarchar05000滬1fdtilitjesNOvarthdr500匚numberint00stateintD0匚rrapTimpdatftimp0D匚deootilAd dressvarchar500匚uldint00buyDepartmeritvarchar500itemvarchar500usersVigrchair500

4、irnoheyTuinicd dlr tuneJ0匚addTypeint00isComputErini70匚remairkvarchar2500int00u£eDepa rtm &nfdint00m-odelvarchar2500pricevarchar500imgvarchar100Qunitvarthsr500makervarchar50DuTdNamcvorchar500quTiniedatetiime00zhbdOSvarchar500chjthangTitnedatetime00gcngyingsvarchar500chujchangNovorchor500cawu

5、Novarchar500gudiiigNowchar500abilityvarchar500rriiOtorNlurn陶char500m*to<apa<iiyvarchar500neePricevarchar500vreibovarchar500設(shè)備信息表，結(jié)構(gòu)如以下圖所示假設(shè)tiffl楂rulidfritD0硬varchar5011varc'ha丸0匚vardhir500behuvarchair20002.5 check_Assets 表設(shè)備盤點(diǎn)表，結(jié)構(gòu)如以下圖所示假設(shè)杭度ttW不呈njllid諭t00renwiJdlirt0m-arUdiniD0a

6、ssetIdint00cvrTmedptinripD0Upjndlianldint002.6 check_Renwu 表盤點(diǎn)任務(wù)管理表，結(jié)構(gòu)如以下圖所示容煩比例Srxillr&nidint00EZic+iPckNmp/arrbar500ch*ckt3t»int00MurlT inncdatetinc00Tnakewarchar妙0endliinedatetime00口pdlPeoplewarclbar5042.7 factory 表專用設(shè)備生產(chǎn)廠家表，結(jié)構(gòu)如以下圖所示假設(shè)tes檯恤IIidine00Pl戸1n?mevarclhar50flcodertvarchaf15002.

7、8 history 表設(shè)備轉(zhuǎn)移信息表，結(jié)構(gòu)如以下圖所示不走njllhistoryldint00c 1 d Depa rtnnentvarcharflne-iMDcpe rtm entvardiar500upUdteTirneddletinwD0cldUservarchair500nneithervarchar5D0irt002.9 historyBorrow 表設(shè)備借出信息表，結(jié)構(gòu)如以下圖所示名耀KS不是nullidint00園戸1a&etldlint00bcirrcwTimcdatetime00backTlmeOnedaTenme00backlimeTwcdatetime00nb e

8、 rrevyDp a rtmrrtldint00ussrEtorrowvorchar500userPivarchai500remarkvarchar500ntypeint00u2.10 nassets 表設(shè)備比照信息表，結(jié)構(gòu)如以下圖所示ttfflK呈 nullidint000NOarclhar500fodlHeshlOVdiulhdf刃0numberint00nstateint00dialctiiTiic,00deooitAddres舊匚卜ar5Q0nufdint00buy Du pa rtrnenlvjf Jbe500item50Pnucertvarchir-500moneyTiirnrda

9、fetioe-00addTspeint00nisConriputerint00re-markVair 匚 IliBr2500typedirrt00nD 電 pa rttn&ntdirt00ufacilitirsNameVQITlZ卜 or500modevarcbar2500nprice-500uimgvarchar500nunitV4rE"h3F50aJmakervarchfir50auldNarne¥3 re hair50ongwTim*datFtimpc0varchar500chuchanqTimedatetime00gong/ing?vrchAir500chu

10、icb-angNovarch 白 it500cauNovarchar50QgcdirgNovarchar500natilriyvairchar500_imctorNumvarchflr500motortapacityvarchar乂0re+PriCBvarchar5fl0_i2.11 pandian 表盤點(diǎn)記錄表，結(jié)構(gòu)如以下圖所示雄不導(dǎo)null|int0SpiNOvarchar50chdlltifr&Havarchar500numberint00n£tat 昏int00iLrapirrncdalrfirtie00ceoDitAd dressvarchar刃Qnufdint00

11、buy Diepartmentvarthar500itemvarc+iar50打nvarchar500moneyTiimeUi3"Etime00addTspeintQ0nisCoHnputeint00re-inairkvs rc hairZSOtypeldIPt00us.eD#partmiefitrdint00facilitissNarnevarchar500mod?varchar2兀0pricevarchar50ciingwarthar500unit/arrbar500Umoke ifairdhar500uldNmevarchar500QuTirmedatetime00nzhiza

12、es-/a rebar500uchuch a r gTt m edattiime00gocgyirgsvarcbar500chuchargKovarrhar500cwulNovarhar500gud inNovdudbar500r&sultvar匚卜ar500口pcfctafprl"訂Ducnuld.ink002.12 privateType 表專用設(shè)備類型表，結(jié)構(gòu)如以下圖所示名比劌禍 nullIdinf00typeNalfiirvatchor500codevarcharaa0meinTypeint002.13 rfidlnfo 表設(shè)備地圖信息表，結(jié)構(gòu)如以下圖所示老雄城不曇n

13、ullidint0ca pRfidldvarchar20cRfidMdkevcirthar100timedatetime0ca&setddlint002.14 state 表設(shè)備狀態(tài)表，結(jié)構(gòu)如以下圖所示購1rullidintQ05002.15 type 表設(shè)備類型表，結(jié)構(gòu)如以下圖所示比例不長nulltjrprldint000typ&Namevarchar500maifliTjpeint00vdrehar5002.16 UniversalType 表通用設(shè)備類型表，結(jié)構(gòu)如以下圖所示題tm不是nullidint00Pl妙ca<T«gorNarn«varc'har5000liargrCfltrgiarvarchzaiT500ime<