固定资产管理系统数据库文档

1、固定资产管理系统数据库文档河南众景信息技术有限公司2014年12月数据库属性3数据库表说明32.1 assets_in表32.2 assets_out表32.3 assets表42.4 assets_jxc表52.5 check_Assets表52.6 check_Renwu表52.7 factory表62.8 history表62.9 historyBorrow表62.10 nassets表72.11 pandian表82.12 privateType表92.13 rfidInfo表92.14 state表92.15 type表92.16 UniversalType表7 Upd

2、ateLog表1.0.可编辑数据库属性数据库系统：SQLServer2005数据库名称：assetsManager数据库账号：sa数据库密码：123:、数据库表说明assetsManager库中的表2.1assets_in表入库登记表，结构如下图所示名任莒tWJWnullELiirtt00(Z户1kit00jingbanrenvarchairso0jxc-nuniiint00匚jj(e_danjiavarchar500inTTimiedatetime00口bozhuvardhar2000匚2.2assets_out表出库登记表，结构如下图所示5jifC-idlingycngrnn吴型鹏比例K是

3、皿IIintCO|7int00Odrchar0numin。口autTimehe；#"dietiine0Q时TOO0可编辑2.3 assets 表设备台账表，结构如下图所示idint00NOvarchar500faulitiesihlO¥司4Id5C0numberint00int00scrapTimedatetimea0deoitAddressvarchar5Q0uldint30buyDepartmentvarchar500itemvarchar540usersvarchar500EDnuyTimudnatctinieJ0addTvpeint00isCampute"

4、int00Ff>markvarchar250QtypeldiniJ0ueDepartmpnftdint0modelvarchar2500pricevarchar500imgvdruhdr1000unitvarchar500makefvarchar500uldNarnievarchar500quTimedatetime00土h二4口缶varchar500chjchangJim?datetime00gengyingsvardhar500chjchangNovarchar500caiwijNovarchar500gudiviglMoYdrchar500albilrt'varchar50

5、0EutorNumvarchar500motoCapaciiyvarchar500ineePricevarchar500weibaovarchar500可编辑2.4assets_jxc表设备信息表，结构如下图所示名Txrn.tiffl7nullidht007二1varchisr50011shebe_itinghaovarclhar500l_varchar500varclhar2W0匚2.5check_Assets表设备盘点表，结构如下图所示名费W切nullidint00回户1r#nwuldintD0niiarkldint00assetsldiniD0cvrTmeratf+

6、inre00pandiinldint002.6check_Renwu表盘点任务管理表，结构如下图所示名比例K是向|re-nidintQ0EplcheckNamewarchar500dieckStateint00erlTiroedntetim-c00make-/airdhar2000endTimedatetime00pdPeopI*warebar500可编辑2.7factory表专用设备生产厂家表，结构如下图所示名移向1idinE00Plnamevarrhar500klcodenvarchmr5灯002.8history表设备转移信息表，结构如下图所示名酬VnjIIhioryTdint00klc

7、ldDepartnnentvarchit500newDupoirtmentvarchar500updteTimecdtetirneD0aldUwrvarchar500ne-MJ5ervarcnar50fl“mdint302.9historyBorrow表设备借出信息表，结构如下图所示若建7ttffl不是RUIIidint00irt00bcrrcwTimcditltlFTie00backlimeOnedatetime00backlimelwcdatetime00hcrrovwDepartmentldint00userBorrowvorcho1-500ubeiPzVdll+ld'500re

8、markvarcha"500邙p*int0D2.10 nassets 表设备对比信息表，结构如下图所示名比例7nullidrr4000NO/archw500facilitisshlOvarebar500numberint00nirrt00sr-ap_imcdat"tinle00dmsitAddr，vardhar5口0uldirrt00buyDupertEunttfdrchigr500itemairdhar500u&ere17-arebsr500umone/Tirniedatetime00addlypeint00lECcHTipjrte-int00ure-mfliid

9、k.Vdrchar2500typeldint0QrimpriitdintDfacilidssNomcyardher500mode!wir匚卜ar2500一口一prirpmh附50Dimgvirchair50Qnuratvjirrhar500makervarchar500luldNarnevarchar500nguTimfrdatMiirw00zhizaoEvsrehar500chtjcharigTimedatetime00gcng/ingvarchar500cnuicF-angNovarchar500ca'v*uNovarchar5。0gudingf%口varchar500abilit

10、yvarchar5。0jmotQH'Num5。0motoCapacityvarchar50nnetPricpV-Rrrhar500j可编辑2.11pandian表盘点记录表，结构如下图所示宕越短不息null|intQc0户1NOvarchar500facilitissblOwarchar50numberint00stat?int0cscr-sp-!meE-aaetirne0tdeootitAddre5svarenar500uldmt00bu/DcpartEEtvarchar5Qcitenvarchsr500nusersvarchar500口rnone/Tim>edatetirne

11、00口addfypeint00isConTpLite-ut0c口re-mairlk.varthflr25C0typelcint00usDFparirmAntTdFirt口0facilitisiNfiamcvarcher500modevarchar250cprirpvarchar100uimq匚卜ar500unit'/arrlhsr500口imalwrvarclbor500uldNdmewarchaff500guTifredatetime0Qnzhizaeswarebar500口chuchargTmedatTtiime00gongiyirgsvarchar500chuchrgNowarr

12、har500口cak/vuNovarcber500gidingNovdrchar5。0resultwardhar500pdfatprt口D口rm柳udHintQ0可编辑2.12privateType表专用设备类型表，结构如下图所示名典3不是nullidint00引产1vaiE.hfr500codevsrchar0meinTypeint002.13rfidInfo表设备地图信息表，结构如下图所示名装短idint0CRfidldvarchar200RfiidMdkevjrchar100tirreC*f=tiEL00Ectddlipt00不思null团户12.14state表设备状态表，结构如下图所示名比例FTidint00用户1slatewarrhar5。02.15type表设备类型表，结构如下图所示名谓比例K是nutypcldint00回typcNflirie<.lar5。0mainypcrint00tcde,iarchar500口2.16UniversalType表通用设备类型表，结构如下图所示名出敌ttffl不是nullidint00M户1ca<T«giorN3rn«varcha5000vartlha-500mediumCstecor