1、數(shù)據(jù)字典整理3.1源數(shù)據(jù)EapPackage類型表名EapPackage中文名表結(jié)構(gòu)編號(hào)中文名字段名數(shù)據(jù)類型主鍵外鍵允許空備注1IDiduniqueidentifier(16)Y2名稱namenvarchar(100)Y3標(biāo)題titlenvarchar(100)Y4命名空間nsnvarchar(400)Y5idParentidParentuniqueidentifier(16)Y6NULLautoidint(4)7二次開(kāi)發(fā)標(biāo)識(shí)TFlagint(4)Y8vs項(xiàng)目vsprojnvarchar(400)Y9更新者UpdatedBynvarchar(64)Y10更新時(shí)間Updatedchar(19)Y

2、11創(chuàng)建時(shí)間CreatedTimechar(19)Y12分布時(shí)間戳Tstimestamp(8)13編號(hào)Codenvarchar(60)Y14isEndNodeisEndNodetinyint(1)Y15inlDinIDnvarchar(1200)YEapDTO15authtypeauthtypebit(1)Y16NULLautoidint(4)18Tststimestamp(8)19二次開(kāi)發(fā)標(biāo)識(shí)TFlagint(4)Y20更新者UpdatedBynvarchar(64)Y21更新時(shí)間Updatedchar(19)Y22創(chuàng)建時(shí)間CreatedTimechar(19)Y23編號(hào)Codechar(5

3、0)YEapDTORelation類型源數(shù)據(jù)表名eapDTORelation中文名源數(shù)據(jù)關(guān)系表表結(jié)構(gòu)編號(hào)中文名字段名數(shù)據(jù)類型主鍵外鍵允許空備注1主鍵iduniqueidentifier(16)Y2NULLidFromDTOuniqueidentifier(16)3NULLidToDTOuniqueidentifier(16)4NULLrelationTypetinyint5NULLidPropertyuniqueidentifier(16)6NULLidFromPropertyuniqueidentifier(16)7NULLidToPropertyuniqueidentifier(16)8N

4、ULLdependencytinyint9NULLautoidint(4)類型源數(shù)據(jù)表名eapDTOProperty中文名編號(hào)中文名字段名數(shù)據(jù)類型主鍵外鍵允許空備注1主鍵IDuniqueidentifier(16)Y2idDTOidDTOuniqueidentifier(16)3字段名稱Namenvarchar(400)Y4字段標(biāo)題Titlenvarchar(400)Y5表字段FieldNamenvarchar(400)Y6TypeTypenvarchar(100)Y7字段長(zhǎng)度FieldLengthint(4)Y8默認(rèn)值DefaultValuenvarchar(100)Y9不允許為空notNu

5、lltinyint(1)Y10不允許重復(fù)Uniquelytinyint(1)Y11DefineLevelDefineLeveltinyint(1)Y12可選枚舉idEnumuniqueidentifier(16)Y13sortNosortNoint(4)Y14區(qū)分Null和0的數(shù)字類型precisiontinyint(1)Y15memomemonvarchar(400)Y源數(shù)據(jù)屬性表表結(jié)構(gòu)EapDTOProperty202116支持多語(yǔ)supportMutiLanguagtinyint(l)17customusecustompublicNULLcustom_usecustompublicaut

6、oid22Ts字段類型定義級(jí)別2324更新者更新時(shí)間25創(chuàng)建時(shí)間2627編號(hào)關(guān)系DTO28關(guān)系2930來(lái)源字段關(guān)聯(lián)字段tsTypeEmuDefineLevelEmuUpdatedByUpdatedCreatedTimeCodeidToDTOrelationTypeFromPropertyToPropertytinyinttinyintint(4)timestamp(8)uniqueidentifier(16)uniqueidentifier(16)nvarchar(64)char(19)char(19)char(50)uniqueidentifier(16)nvarchar(64)nvarch

7、ar(400)nvarchar(400)YYYYYYYYYY菜單SMVoucherType類型菜單&單據(jù)表名SMVoucherType中文名單據(jù)類型表表結(jié)構(gòu)編號(hào)中文名字段名數(shù)據(jù)類型主鍵外鍵允許空備注1主鍵iduniqueidentifier(16)自動(dòng)生2編號(hào)codenvarchar(60)Y3名稱namenvarchar(400)Y4模塊名稱moduleNamevarchar(20)5審核AuditModulevarchar(20)Y=模塊名6是否自動(dòng)補(bǔ)空號(hào)isautofillbreakpointtinyintY默認(rèn)為7是否可編輯表格iseditabletinyintY默認(rèn)為8是否需要審核i

8、sneedaudittinyintY默認(rèn)為9前綴1varchar(20)prefixion丄10前綴1長(zhǎng)度prefixion1length11前綴1內(nèi)容prefixion1contentvarchar(30)12前綴1曰否做編刖綴1是否做編碼依據(jù)iscreatorderbypreTixi1on1tinyint(1)13前綴2prefixion2varchar(20)14前綴2內(nèi)容prefixionzcontentvarchar(30)15曲儷9HFh=前綴2長(zhǎng)度prefixion2length16前綴2是否做流水依據(jù)isc【eato【de【byp【eiixicon2tinyint(1)17前綴

9、3va【cha【(20)prefixion318前綴3內(nèi)容prefixion3contentvarchar(3U)19202122232425262728293233343536373839404142434445前綴3長(zhǎng)度前綴3是否做流水依據(jù)分隔符流水號(hào)長(zhǎng)度初始流水號(hào)是否停用系統(tǒng)標(biāo)志是否在單據(jù)編碼設(shè)置中可見(jiàn)是否在單據(jù)審核設(shè)置中可見(jiàn)單據(jù)/檔案代碼是否自動(dòng)編號(hào)DTO系統(tǒng)宇段DTO系統(tǒng)字段顯示丿I順序DTO名稱單據(jù)名稱類型消息中心是否可見(jiàn)單據(jù)查詢是否可見(jiàn)前綴1截取方式前綴2截取方式前綴3截取方式是否需要審批流前綴1是否只讀系統(tǒng)屬性后置名稱EapVoucherModuleprefixion3leng

10、thiscreatorderbyprefixica2113separatorserialnolengthstartordenalnumberdisabledissystemisCodingVisibleisAudingVisiblevouchertypealiasisautocreateupdatedupdatedByDisplayOrderDtoNameVoucherNameDataTypeisMessageCenterVisibleisVoucherSearchVisibleprefixion1InterceptTy樣prefixion2InterceptTyprefixion3Inter

11、ceptTyIsNeedWorkFlowIsPrefix1ReadOnlySysPropFieldsExpressionNameIsEnableWFEmailint(4)iinyini(丄丿tir-rwlivarchar(丄丿numeric(17)tinyint(1)tinyint(1)tinyint(1)tinyint(1)默認(rèn)為默認(rèn)為varchar(20)tinyint(1)har(19)nvarchar(64)int(4)nvarchar(120)nvarchar(400)nvarchar(20)tinyint(1)默認(rèn)為0/1/默認(rèn)為默認(rèn)為tinyint(1)妁nvarchar(600

12、)nvarchar(200)tinyint(1)類型菜單表名eapvouchermodule中文名編號(hào)中文名字段名數(shù)據(jù)類型主鍵外鍵允許空備注1主鍵IDuniqueidentifier(16)Y2模塊名稱ModuleNamenvarchar(100)3模塊標(biāo)題ModuleTitlenvarchar(100)單據(jù)模塊表表結(jié)構(gòu)4父IDNodeParentuniqueidentifier(16)Y5級(jí)別NodeLevelint(4)6排序NodelndexOrderint(4)7模塊編碼codenvarchar(16)YEapMenuTreeEapMenuTreeRelation類型菜單表名EapMe

13、nuTreeRelation中文名菜單關(guān)系表表結(jié)構(gòu)編號(hào)中文名字段名數(shù)據(jù)類型主鍵外鍵允許空備注6主鍵IDuniqueidentifier(16)Y3菜單號(hào)MenuCodenvarchar(100)4名稱Namenvarchar(200)Y5樹(shù)編號(hào)TreeIDuniqueidentifier(16)Y系統(tǒng)默認(rèn)字段7是否系統(tǒng)項(xiàng)isSystembit(1)Y8顯示丿1順序showIndexint(4)Y9總部標(biāo)示Categoryint(4)Y0/1/210是否控制顯示個(gè)數(shù)IsControlShowNumtinyintY11控制個(gè)數(shù)ControlNumint(4)Y12控制頁(yè)面ControlPagenv

14、archar(400)Y13控制頁(yè)面驗(yàn)證ControlJSnvarchar(400)Y14編號(hào)Codenvarchar(200)Y15表達(dá)式ExpressionNamenvarchar(120)Y16無(wú)用TriIFlag17創(chuàng)建日期CreatedTimedatetime(8)Y18MenuTree主鍵IdEapMenuTreeuniqueidentifier(16)YEAPMenu類型菜單表名EAPMenu中文名菜單表表結(jié)構(gòu)編號(hào)中文名字段名數(shù)據(jù)類型主鍵外鍵允許空備注23主鍵IDuniqueidentifier(16)Y1自動(dòng)編碼AutoID2編號(hào)Codenvarchar(100)Y3名稱Nam

15、envarchar(200)Y4快捷鍵Shortcutchar(1)Y5模塊Dc.ihTDSubIDnvaichai(4)Y6級(jí)次Gradesmallint(2)0/1/220級(jí)次IDinIDnvarchar(100)Y7上級(jí)菜單IDSupMenuIDnvarchar(24)Y8是否未級(jí)EndGradebit(1)Y12是否有下級(jí)IsItemGroupbit(1)Y13是否控制權(quán)限IsControlbit(1)21權(quán)限IDPrivilegeIDnvarchar(60)Y9顯示丿1順序Orderint(4)Y10鏈接地址RequestUrlnvarchar(1000)Y11GroupFlownv

16、archar(40)14版本號(hào)Versionvarchar(12)15科目類型AccountTypesmallint(2)Y0/116是否顯示Visibilitybit(1)17更新時(shí)間Updateddatetime(8)18更新者UpdatedByvarchar(32)19tstimestamp(8)22表達(dá)式ExpressionNamenvarchar(120)Y24支持條碼InvBarCodeVoucherint(4)25flag標(biāo)志lFlagint(4)26創(chuàng)建時(shí)間CreatedTimedatetime(8)27顯示丿1順序1order1in(4)工具條類型工具條表名EAPBusOpe

17、ration中文名EAPBusOperation編號(hào)中文名字段名數(shù)據(jù)類型主鍵外鍵允許空備注1主鍵iduniqueidentifier(16)工具條表表結(jié)構(gòu) 34567891011121314151718名稱功能編號(hào)描述編號(hào)視圖類型Tab鍵的索引是否是分隔符欄目的鍵值是否權(quán)限控制標(biāo)題Visibility父操作ID快捷鍵提示NULLOperationNameFunctionCodeDescriptionCodeViewTypeTabIndexIsSplitSourceKeyIsAuthControlTitleVisibilityParentIDShortCutToolTipidfunctionau

18、th192021222324是否toolbar可見(jiàn)IsHasActionIsEndissystemIsHasActionIsEndviewidviewidentityidentityfuncidExpressionNaentityidentityfuncidExpressionNameme25Idbusoperationidbusoperationmainmain2627282930分布時(shí)間戳更新時(shí)間更新者CreatedTimetsupdatedupdatedByCreatedTime名稱Namenvarchar(100)varchar(20)nvarchar(200)nvarchar(100

19、)smallint(2)int(4)bitnvarchar(60)bitnvarchar(100)bituniqueidentifier(16)char(1)nvarchar(100)uniqueidentifier(16)bitbit(1)tinyint(1)uniqueidentifier(16)uniqueidentifier(16)uniqueidentifier(16)nvarchar(120)uniqueidentifier(16)timestamp(8)char(19)nvarchar(64)datetime(8)nvarchar(400)YYYYYYYYYYYYYYY單據(jù)SMC

20、odingRuleRelationWithPrefixion類型單據(jù)表名SM_CodingRuleRelationWith中文名e據(jù)編碼編彌則Prefixion表結(jié)構(gòu)編號(hào)中文名字段名數(shù)據(jù)類型主健外1主鍵iduniqueidentifier(16)2編號(hào)codenvarchar(60)Y3名稱namenvarchar(400)Y4分布時(shí)間戳tstimestamp(8)5更新時(shí)間updatedchar(19)Y6更新者updatedBynvarchar(64)Y7NULLidvouchertypeuniqueidentifier(16)Y8NULLidcodingprefixionuniqueid

21、entifier(16)Y系統(tǒng)固定字段9前綴排序ddlOrderint(4)Y10是否系統(tǒng)字段IsSystemtinyint11NULLAutoIDint(4)12NULLExpressionNamenvarchar(120)YEapVoucherTree類型單據(jù)&菜單表名eapVoucherTree中文名單據(jù)樹(shù)表表結(jié)構(gòu)編號(hào)中文名字段名數(shù)據(jù)類型主鍵外鍵允許空備注1主鍵IDuniqueidentifier(16)Y2父IDParentIDuniqueidentifier(16)Y系統(tǒng)固定自段3排序numint(4)4單據(jù)名稱Namenvarchar(100)Y5單據(jù)標(biāo)題Titlenvarchar

22、(100)Y6/ii11VouciieiIDuniqueidentifier(16)7TablelDuniqueidentifier(16)EapVoucherDesignTree類型單據(jù)表名eapVoucherDesignTree中文名單據(jù)設(shè)計(jì)樹(shù)表表結(jié)構(gòu)編號(hào)中文名字段名數(shù)據(jù)類型主鍵外鍵允許空備注1主鍵IDuniqueidentifier(16)Y2單據(jù)IDVoucherInfoIDuniqueidentifier(16)eap_Voucher3單據(jù)模塊IDModuleIDuniqueidentifier(16)eap_Voucherdule4排序indexOrderint(4)5是否系統(tǒng)字段

23、isSystembit(1)默認(rèn)為0EapVoucher 891011121415161821222324252628PrintTemplatelDTitleHeightHeadHeightBodyHeightFootHeightLeftTiopWidthHeightOrderIndexCode動(dòng)態(tài)屬性NULL是否允許復(fù)制單據(jù)模版是否允許刪除單據(jù)模版是否允許編輯頁(yè)簽信息是否允許單據(jù)修改標(biāo)題是否需要進(jìn)行自定義項(xiàng)設(shè)置是否允許自定義項(xiàng)適用于表頭多頁(yè)簽設(shè)置二次開(kāi)發(fā)標(biāo)識(shí)ts創(chuàng)建時(shí)間PrintTemplatelDTitleHeightHeadHeightBodyHeightFootHeightLeftTi

24、opWidthHeightOrderIndexCodeDynPropertyStringrI；XautoidIsAllowCopyIsAllowDelIsAllowEditTabsIsAllowEditTitleIsAllowUDIIsAllowUDIForMultiTabsTFagTsCreatedTimeuniqueidentifier(16)int(4)int(4)int(4)in(4)int(4)int(4)int(4)nvarchar(400)nvarchar(4000)厲bitbitbitbitbitbittimestamp(8)datetime(8)默認(rèn)為0默認(rèn)為0默認(rèn)為0默認(rèn)為

25、0默認(rèn)為1默認(rèn)為0EapVoucherTab9TabindexTabIndexint(4)Y10AutoReDeployAutoReDeploybit(1)Y11CodeCodenvarchar(400)Y12DynPropertyStringDynPropertyStringnvarchar(4000)Y13NULLautoidint(4)14OriginalTitleOriginalTitlenvarchar(100)Y15是否允許使用自定義項(xiàng)IsAllowUDIbit(1)Y16創(chuàng)建時(shí)間CreatedTimedatetime(8)YEapVoucherControls類型單據(jù)表名eapV

26、oucherControls中文名單據(jù)控件表表結(jié)構(gòu)編號(hào)中文名字段名數(shù)據(jù)類型主鍵外鍵允許空備注1主鍵IDuniqueidentifier(16)Y2名稱Namenvarchar(100)3標(biāo)題Titlenvarchar(100)4單據(jù)編號(hào)VoucherIDuniqueidentifier(16)5頁(yè)簽名稱TabPageNamenvarchar(100)Y6標(biāo)簽編號(hào)LabelIDnvarchar(100)Y7控件編號(hào)ControlIDnvarchar(100)Y8是否顯示Visiblebit(1)Y9AddReadOnlyAddReadOnlybit(1)Y10EditReadOnlyEditRe

27、adOnlybit(1)Y11ControlTypeControlTypenvarchar(60)Y12FieldNameFieldNamenvarchar(100)13FieldTypeFieldTypevarchar(50)Y14IsI18NFieldIsI18NFieldbit(1)Y15LeftLeftint(4)Y16TopTopint(4)Y17WidthWidthint(4)Y18HeightHeightint(4)Y19TabIndexTabIndexint(4)Y20CtlIndexCtlIndexint(4)Y21AllowZeroAllowZerobit(1)Y22All

28、owNoneAllowNonebit(1)Y23DefaultValueDefaultValuenvarchar(100)Y24FormatFormatnvarchar(100)Y25ExpressionExpressionnvarchar(1200)Y26MaxLengthMaxLengthsmallint(2)Y27PrecisionPrecisionsmallint(2)Y28MaxShowLenMaxShowLensmallint(2)Y29EnumNameEnumNamevarchar(50)Y30RefPageRefPagevarchar(50)Y31RefDTONameRefDT

29、ONamevarchar(50)Y32RefShowFieldRefShowFieldvarchar(50)Y33RefLinkFieldRefLinkFieldvarchar(50)Y34UserCheckUserChecknvarchar(200)Y35UserPromptUserPromptnvarchar(400)Y36IsUserDefIsUserDefbit(1)Y37AllowUserDefAllowUserDefbit(1)Y38AllowUserDeleteAllowUserDeletebit(1)Y39DefineLevelDefineLevelsmallint(2)Y40

30、FixedValueFixedValuenvarchar(100)Y41RefDataSourceRefDataSourcevarchar(50)Y42ShowSysFieldShowSysFieldbit(1)Y43DropDownStyleDropDownStylenvarchar(20)Y44DropDownPanelIDDropDownPanelIDnvarchar(100)Y45OriginalTitleOriginalTitlenvarchar(100)Y46SysPropValueSysPropValuevarchar(200)Y47MustShowMustshowsmallin

31、t(2)Y48AutoReDeployAutoReDeploysmallint(2)Y49CodeCodenvarchar(400)Y50DynPropertyStringDynPropertyStringnvarchar(4000)Y51NULLautoidint(4)52NULLVoucherFieldTypeuniqueidentifier(16)Y53RecordValueRecordValuebit(1)Y54NULLTStimestamp(8)55NULLExpressionNamenvarchar(120)Y56創(chuàng)建時(shí)間CreatedTimedatetime(8)57TabIDT

32、abIDuniqueidentifier(16)Y58ControlTypeEnuControlTypeEnuuniqueidentifier(16)59FieldTypeEnuFieldTypeEnuuniqueidentifier(16)60FormatEnuFormatEnuuniqueidentifier(16)61NULLDropDownStyleEnuuniqueidentiTier(16)EapVoucherTable類型單據(jù)表名eapVoucherTable中文名單據(jù)表體表表結(jié)構(gòu)編號(hào)中文名字段名數(shù)據(jù)類型主鍵外鍵允許空備注1主鍵IDuniqueidentifier(16)Y2Na

33、meNamenvarchar(100)3TitleTitlenvarchar(100)4DtoNameDtoNamenvarchar(100)Y5VoucherIDVoucherIDuniqueidentifier(16)6ParentFieldNameParentFieldNamenvarchar(100)7ChildFieldNameChildFieldNamenvarchar(100)Y8TabIndexTabIndexint(4)Y9VisibleVisiblebit(1)Y10AllowAddAllowAddbit(1)Y11AllowDeleteAllowDeletebit(1)Y

34、12ReadOnlyReadOnlybit(1)Y13AllowSorttingAllowSorttingbit(1)Y14ColumnMoveableColumnMoveablebit(1)Y15ColumnSizeableColumnSizeablebit(1)Y16RowHeaderVisibleRowHeaderVisiblebit(1)Y17TotalRowVisibleTotalRowVisiblebit(1)Y18StatusBarVisibleStatusBarVisiblebit(1)Y19TableTypeTableTypenvarchar(100)Y20ParentTab

35、leParentTablenvarchar(100)Y21CodeCodenvarchar(400)Y22DynPropertyStringDynPropertyStringnvarchar(4000)Y23NULLautoidint(4)24OriginalTitleOriginalTitlenvarchar(100)Y25創(chuàng)建時(shí)間CreatedTimedatetime(8)Y26TableTypeEnuTableTypeEnuuniqueidentifier(16)YEapVoucherTableColumnGroup類型單據(jù)表名eapVoucherTableColumnGroup中文名單

36、據(jù)表體列分組表表結(jié)構(gòu)編號(hào)中文名字段名數(shù)據(jù)類型主鍵外鍵允許空備注TablelDTablelD1Yuniqueidentifier(16)uniqueidentifier(16)2主鍵ID3NameNamenvarchar(100)Y4TitleTitlenvarchar(100)Y5CollndexColIndexintY6VisibleVisibletinyint(1)Y7NULLideap_edittablecolumnuniqueidentifier(16)Y8ColumnLevelColumnLevelintY9ParentGroupIDParentGroupIDuniqueidenti

37、fier(16)Y10CodeCodenvarchar(400)Y11DynPropertyStringDynPropertyStringnvarchar(4000)Y12ColumnIDColumnIDuniqueidentifier(16)Y13NULLautoidintEapVoucherTableColumn類型單據(jù)表名eapVoucherTableColumn中文名單據(jù)表體列表表結(jié)構(gòu)編號(hào)中文名字段名數(shù)據(jù)類型主鍵外鍵允許空備注1主鍵IDuniqueidentifier(16)Y2NameNamenvarchar(100)3TitleTitlenvarchar(100)4VoucherI

38、DVoucherIDuniqueidentifier(16)5TableIDTableIDuniqueidentifier(16)6ColIndexColIndexsmallint(2)Y7WidthWidthint(4)Y8FieldNameFieldNamevarchar(50)9FieldTypeFieldTypenvarchar(30)Y10IsI18NFieldIsI18NFieldbit(1)Y11ColumnTypeColumnTypenvarchar(60)Y12VisibleVisiblebit(1)Y13ReadOnlyReadOnlybit(1)Y14AllowNullA

39、llowNullbit(1)Y15AllowZeroAllowZerobit(1)Y16MaxLengthMaxLengthsmallint(2)Y17PrecisionPrecisionsmallint(2)Y18AllowTotalAllowTotalbit(1)Y19FormatFormatnvarchar(100)Y20ExpressionExpressionnvarchar(1200)Y21MonetaryAmountInWordsMonetaryAmountInWordsbit(1)Y22AllowSortingAllowSortingbit(1)Y23SortDirectionS

40、ortDirectionsmallint(2)Y24SizeableSizeablebitY25AddCopyDataAddCopyDatabitY26DefaultvalueDefaultValuenvarchar(100)Y27EnumNameEnumNamevarchar(50)Y28RefPageRefPagevarchar(110)Y29RefDtoNameRefDtoNamevarchar(50)Y30RefShowFieldRefShowFieldvarchar(50)Y31RefLinkFieldRefLinkFieldvarchar(50)Y32UserCheckUserCh

41、ecknvarchar(200)Y33UserPromptUserPromptnvarchar(400)Y34IsUserDefIsUserDefbit(1)Y35AllowUserDefAllowUserDefbit(1)Y36AllowUserDeleteAllowUserDeletebit(1)Y37DefineLevelDefineLevelsmallint(2)Y38FixedValueFixedValuenvarchar(100)Y39refDataSourcerefDataSourcevarchar(50)Y40ShowSysFieldShowSysFieldbit(1)Y41D

42、ropDownStyleDropDownStylenvarchar(20)Y42DropDownPanelIDDropDownPanelIDnvarchar(100)Y43SysPropValueSysPropValuevarchar(200)Y44MustShowMustshowsmallint(2)Y45OriginalTitleOriginalTitlenvarchar(100)Y46CodeCodenvarchar(400)Y47DynPropertyStringDynPropertyStringnvarchar(4000)Y48NULLautoidint(4)49NULLVouche

43、rFieldTypeuniqueidentifier(16)Y50NULLTStimestamp(8)51NULLExpressionNamenvarchar(120)Y52創(chuàng)建時(shí)間CreatedTimedatetime(8)Y53ColumnTypeEnuColumnTypeEnuuniqueidentifier(16)Y54FieldTypeEnuFieldTypeEnuuniqueidentifier(16)Y55FormatEnuFormatEnuuniqueidentifier(16)Y56DropDownStyleEnuDropDownStyleEnuuniqueidentifie

44、r(16)YEapVoucherWebControls類型單據(jù)表名eapVoucherWebControls中文名單據(jù)靜態(tài)控件表表結(jié)構(gòu)編號(hào)中文名字段名數(shù)據(jù)類型主鍵外鍵允許空備注1主鍵IDuniqueidentifier(16)Y12VoucherlDVoucherIDuniqueidentifier(16)Y23NameNamenvarchar(100)Y34TextTextnvarchar(1000)Y45LeftLeftint(4)Y56TopTopint(4)Y67WidthWidthint(4)Y78HeightHeightint(4)Y89ControlTypeControlType

45、nvarchar(100)Y910ImageUrlImageUrlnvarchar(500)Y1011FontNameFontNamenvarchar(100)Y1112FontSizeFontSizeint(4)Y1213BackColorBackColorvarchar(50)Y1314ForeColorForeColorvarchar(20)Y1415LineWidthLineWidthint(4)Y1516ParentParentnvarchar(100)Y1617CodeCodenvarchar(400)Y1718DynPropertyStringDynPropertyStringn

46、varchar(4000)Y1819NULLautoidint(4)1920TabIDTabIDuniqueidentifier(16)Y20查詢EAP_SearchInfo_Ext類型查詢表名EAPSearchInfoExt中文名表結(jié)構(gòu)編號(hào)中文名字段名數(shù)據(jù)類型主鍵外鍵允許空備注1主鍵Iduniqueidentifier(16)Y2編號(hào)Codenvarchar(100)3名稱Namenvarchar(100)4TitleTitlenvarchar(200)5SearchTypeSearchTypeint(4)6NULLautoidint(4)7分布時(shí)間戳tstimestamp(8)8更新時(shí)間u

47、pdatedchar(19)Y9更新者updatedBynvarchar(64)Y11NULLCreatedTimedatetime(8)Y12NULLsearchtypenamenvarchar(200)Y13NULLEndGradebit(1)Y14NULLTFlagint(4)YEAP_SearchItem_Ext類型查詢表名EAPSearchItemExt中文名表結(jié)構(gòu)編號(hào)中文名字段名數(shù)據(jù)類型主鍵外鍵允許空備注1主鍵Iduniqueidentifier(16)Y2查詢IdSearchIduniqueidentifier(16)3字段名FieldNamenvarchar(400)4字段別名

48、ColumnNamenvarchar(400)5字段標(biāo)題FieldTitlenvarchar(400)Y6字段類型FieldTypenvarchar(100)Y7是否為區(qū)間IsBetweenbit(1)Y8連接關(guān)鍵字LinkSignnvarchar(100)9邏輯符CompareSignnvarchar(600)10可否分組小記CanGroupSumbit(1)Y11開(kāi)始默認(rèn)值BeginDefaultnvarchar(800)Y12結(jié)束默認(rèn)值EndDefaultnvarchar(800)Y13排序號(hào)OrderNumint(4)Y14字段標(biāo)題2FieldTitle2nvarchar(100)Y1

49、5開(kāi)始默認(rèn)文本BeginDefaultTextnvarchar(200)Y16結(jié)束默認(rèn)文本EndDefaultTextnvarchar(200)Y17可過(guò)濾查詢CanFilterSearchbit(1)Y18是否顯示IsSystembit(1)19互拆組名RepelGroupnvarchar(100)Y20并接SQLWhere的排序號(hào)WhereOrderint(4)Y21拼接SqlWhere的字段名whereNamenvarchar(100)Y22互斥的查詢項(xiàng)ID集合RepelItemsvarchar(400)Y23是否允許為空值isNotNullValuebit(1)Y24依賴的查詢項(xiàng)ID集

50、合DependItemsvarchar(400)Y25DTO屬性DTOPropnvarchar(600)Y26參照DTO屬性RefDtoPropnvarchar(800)Y27NULLautoidint(4)28Codecodenvarchar(60)Y29Namenamenvarchar(400)Y30Tststimestamp(8)31Updatedupdatedchar(19)Y32UpdatedByupdatedBynvarchar(64)Y33idSearchlnfoidSearchInfouniqueidentifier(16)Y34idcontorlinfoidcontorlin

51、founiqueidentifier(16)Y35ExpressionNameExpressionNamenvarchar(120)Y36CreatedTimeCreatedTimedatetime(8)Y37DTO名稱DtoNamenvarchar(100)Y38參照頁(yè)RefPagenvarchar(200)Y39RefAddPageRefAddPagenvarchar(100)Y40RefWhereRefWherenvarchar(600)Y41枚舉名稱EnumNamenvarchar(100)Y42狀態(tài)Statusint(4)Y43值類型ValueTypenvarchar(100)Y44

52、是否允許編輯AllowEdittinyintY45下拉樣式DropDownStylenvarchar(100)Y46下拉模板IDDropDownPanelIDnvarchar(100)Y47控件類型ControlTypenvarchar(100)Y48下拉面板參照過(guò)濾條件DropDownWherenvarchar(600)Y49參照欄目數(shù)據(jù)源RefDataSourcenvarchar(100)Y50輸入最大長(zhǎng)度MaxLengthint(4)Y51PropTitleCanChangePropTitleCanChangetinyintY52選擇按鈕列表SelectButtonItemsnvarch

53、ar(2000)Y53onClientClickonClientClicknvarchar(200)Y54查詢項(xiàng)控件刖置控件類型PrefixCheckCtrlStyleint(4)Y55RefShowFieldRefShowFieldnvarchar(400)Y56PrefixCheckCtrlStylenamePrefixCheckCtrlStylenamenvarchar(200)Y57精度Precisionint(4)YEAP_SearchItemCtrlInfo_Ext類型查詢表名EAPSearchItemCtrlInfoExt中文名表結(jié)構(gòu)編號(hào)中文名字段名數(shù)據(jù)類型主鍵外鍵允許空備注1主

54、鍵Iduniqueidentifier(16)Y2查詢項(xiàng)idItemIduniqueidentifier(16)3Dto名稱DtoNamenvarchar(100)4參照頁(yè)RefPagenvarchar(200)5RefAddPageRefAddPagenvarchar(100)6RefWhereRefWherenvarchar(600)7枚舉名稱EnumNamenvarchar(100)Y8NULLStatusint(4)Y9值類型ValueTypenvarchar(100)10是否允許編輯AllowEditbit(1)Y11下拉樣式DropDownStylenvarchar(100)Y12

55、下拉面板IDDropDownPanelIDnvarchar(100)Y13控件類型ControlTypenvarchar(100)Y14下來(lái)面板參照過(guò)濾條件DropDownWherenvarchar(600)Y15參照欄目數(shù)據(jù)源RefDataSourcenvarchar(100)Y16精度Precisionint(4)Y17輸入最大長(zhǎng)度MaxLengthint(4)Y18PropTitleCanChangePropTitleCanChangebit(1)Y19選擇按鈕列表SelectButtonItemsnvarchar(2000)Y20onClientClickonClientClicknv

56、archar(200)Y21查詢項(xiàng)控件刖置控件類型PrefixCheckCtrlStyleint(4)Y22RefShowFieldRefShowFieldnvarchar(400)Y23NULLautoidint(4)24Codecodenvarchar(60)Y25Namenamenvarchar(400)Y26Tststimestamp(8)27Updatedupdatedchar(19)Y28UpdatedByupdatedBynvarchar(64)Y29ExpressionNameExpressionNamenvarchar(120)Y30CreatedTimeCreatedTim

57、edatetime(8)Y31idSearchInfoidSearchInfouniqueidentifier(16)Y32PrefixCheckCtrlStylenamePrefixCheckCtrlStylenamenvarchar(200)YEAP_SearchPlanInfo_Ext類型查詢表名EAPSearchPlanInfoExt中文名表結(jié)構(gòu)編號(hào)中文名字段名數(shù)據(jù)類型主鍵外鍵允許空備注1主鍵Iduniqueidentifier(16)Y2查詢IdSearchIduniqueidentifier(16)3查詢名稱SearchNamenvarchar(100)4查詢方案風(fēng)格SearchS

58、tyleint(4)5是否默認(rèn)IsDefaultbit(1)Y6是否相同IsSystembit(1)Y7方案名稱PlanNamenvarchar(100)Y8用戶idUserIduniqueidentifier(16)Y9最大查詢項(xiàng)個(gè)數(shù)MaxItemCountint(4)Y10是否直接進(jìn)入報(bào)表IsDirectSearchbit(1)Y11是否公共IsPublicPIanbit(1)Y12布局風(fēng)格LayoutStyleint(4)Y13布局列數(shù)LayoutColumnCountint(4)Y14NULLautoidint(4)15codecodenvarchar(60)Y16namenamenv

59、archar(400)Y17tststimestamp(8)18updatedupdatedchar(19)Y19updatedByupdatedBynvarchar(64)Y20idSearchlnfoidSearchInfouniqueidentifier(16)Y21idgroupiteminfoidgroupiteminfouniqueidentifier(16)Y22IsShowExpressionIsShowExpressionbit(1)Y23ExpressionExpressionnvarchar(800)Y24NULLIsdisplaybit(1)Y25CreatedTime

60、CreatedTimedatetime(8)Y26EndGradeEndGradebit(1)Y27LayoutStylenameLayoutStylenamenvarchar(200)Y28SearchStylenameSearchStylenamenvarchar(200)Y29二次開(kāi)發(fā)標(biāo)識(shí)TFlagint(4)YEAP_SearchPlanItem_Ext類型查詢表名EAPSearchPlanItemExt中文名表結(jié)構(gòu)編號(hào)中文名字段名數(shù)據(jù)類型主鍵外鍵允許空備注1主鍵Iduniqueidentifier(16)Y2查詢項(xiàng)IdSearchItemIduniqueidentifier(16)3