gdsconfigformslavemasterview.md 6.81 KB

Edit Raw Blame History



gdsconfigformslavemasterview（视图）


是否可更新： YES

定义者： xlyprint@%


字段


#
名称
类型
可空


1
sId
varchar(100)
NO


2
sBrandsId
varchar(100)
NO


3
sSubsidiaryId
varchar(100)
NO


4
iOrder
int
NO


5
sParentId
varchar(100)
NO


6
sName
varchar(255)
NO


7
sRelation
text
YES


8
sChinese
varchar(255)
YES


9
sEnglish
varchar(255)
YES


10
sBig5
varchar(255)
YES


11
sControlName
varchar(255)
NO


12
bVisible
bit(1)
NO


13
bNotEmpty
bit(1)
NO


14
bSum
bit(1)
NO


15
iFitWidth
int
YES


16
sActiveId
varchar(100)
YES


17
sActiveKey
varchar(255)
YES


18
sDropDownType
varchar(255)
YES


19
sChineseDropDown
text
YES


20
sEnglishDropDown
text
YES


21
sBig5DropDown
text
YES


22
sAssignField
text
YES


23
bCanInput
bit(1)
NO


24
iTag
int
YES


25
bReadonly
bit(1)
NO


26
sNotRepeatColumn
varchar(255)
YES


27
bIsOther
bit(1)
NO


28
sKeyUpFilter
longtext
YES


29
iVisCount
int
YES


30
bNewRecord
bit(1)
NO


31
bFirstEmpty
bit(1)
NO


32
sSqlCondition
text
YES


33
sDefault
varchar(255)
YES


34
bNotRepeat
bit(1)
NO


35
bTree
bit(1)
NO


36
bFilter
bit(1)
NO


37
sFilterSql
longtext
YES


38
_sId
varchar(100)
NO


39
_sBrandsId
varchar(100)
NO


40
_sSubsidiaryId
varchar(100)
NO


41
_tCreateDate
datetime
NO


42
_sMakePerson
varchar(255)
NO


43
_iOrder
int
NO


44
_sParentId
varchar(100)
NO


45
sTbName
varchar(255)
NO


46
_sChinese
varchar(255)
YES


47
_sEnglish
varchar(255)
YES


48
_sBig5
varchar(255)
YES


49
sType
varchar(255)
NO


50
sSqlStr
text
YES


51
sWhere
text
YES


52
sOrder
text
YES


53
sConfigSqlStr
text
YES


54
sConfigWhere
text
YES


55
sConfigOrder
text
YES


56
iFreezeColumn
int
YES


57
bGrd
bit(1)
NO


58
sGrd
varchar(255)
YES


59
sMergeTableName
varchar(255)
YES


60
bNotSort
bit(1)
NO


61
sModelId
varchar(100)
NO


62
sChineseModelName
varchar(255)
NO


63
sBig5ModelName
varchar(255)
YES


64
sEnglishModelName
varchar(255)
YES


65
sTableAlias
varchar(255)
NO


66
sSelectRelation
text
YES


67
sMaxValue
varchar(255)
NO


68
sMinValue
varchar(255)
NO


69
iColValue
int
NO


70
sChildTableName
varchar(255)
NO


71
sChildTableCondition
varchar(255)
NO


72
bMultipleChoice
bit(1)
NO


73
sButtonParam
text
YES


74
sButtonEnabled
text
YES


75
sFieldToContent
text
YES


76
bMergeCell
bit(1)
NO


77
sDateFormat
varchar(255)
YES


78
bEntireLine
bit(1)
NO


79
sColor
varchar(255)
YES


80
sColorTerms
text
YES


81
bFind
bit(1)
NO


82
iPageSize
int
NO


83
sConfigTableAlias
varchar(255)
YES


84
sCompareColor
varchar(255)
NO


85
sCharType
varchar(255)
NO


86
sTableType
varchar(255)
NO


87
sTableSelect
longtext
YES


88
bNotCanEmpty
bit(1)
NO


89
sIcon
varchar(500)
NO


定义
select `s`.`sId` AS `sId`,`s`.`sBrandsId` AS `sBrandsId`,`s`.`sSubsidiaryId` AS `sSubsidiaryId`,`s`.`iOrder` AS `iOrder`,`s`.`sParentId` AS `sParentId`,`s`.`sName` AS `sName`,`s`.`sRelation` AS `sRelation`,`s`.`sChinese` AS `sChinese`,`s`.`sEnglish` AS `sEnglish`,`s`.`sBig5` AS `sBig5`,`s`.`sControlName` AS `sControlName`,`s`.`bVisible` AS `bVisible`,`s`.`bNotEmpty` AS `bNotEmpty`,`s`.`bSum` AS `bSum`,`s`.`iFitWidth` AS `iFitWidth`,`s`.`sActiveId` AS `sActiveId`,`s`.`sActiveKey` AS `sActiveKey`,`s`.`sDropDownType` AS `sDropDownType`,`s`.`sChineseDropDown` AS `sChineseDropDown`,`s`.`sEnglishDropDown` AS `sEnglishDropDown`,`s`.`sBig5DropDown` AS `sBig5DropDown`,`s`.`sAssignField` AS `sAssignField`,`s`.`bCanInput` AS `bCanInput`,`s`.`iTag` AS `iTag`,`s`.`bReadonly` AS `bReadonly`,`s`.`sNotRepeatColumn` AS `sNotRepeatColumn`,`s`.`bIsOther` AS `bIsOther`,`s`.`sKeyUpFilter` AS `sKeyUpFilter`,`s`.`iVisCount` AS `iVisCount`,`s`.`bNewRecord` AS `bNewRecord`,`s`.`bFirstEmpty` AS `bFirstEmpty`,`s`.`sSqlCondition` AS `sSqlCondition`,`s`.`sDefault` AS `sDefault`,`s`.`bNotRepeat` AS `bNotRepeat`,`s`.`bTree` AS `bTree`,`s`.`bFilter` AS `bFilter`,`s`.`sFilterSql` AS `sFilterSql`,`m`.`sId` AS `_sId`,`m`.`sBrandsId` AS `_sBrandsId`,`m`.`sSubsidiaryId` AS `_sSubsidiaryId`,`m`.`tCreateDate` AS `_tCreateDate`,`m`.`sMakePerson` AS `_sMakePerson`,`m`.`iOrder` AS `_iOrder`,`m`.`sParentId` AS `_sParentId`,`m`.`sTbName` AS `sTbName`,`m`.`sChinese` AS `_sChinese`,`m`.`sEnglish` AS `_sEnglish`,`m`.`sBig5` AS `_sBig5`,`m`.`sType` AS `sType`,`m`.`sSqlStr` AS `sSqlStr`,`m`.`sWhere` AS `sWhere`,`m`.`sOrder` AS `sOrder`,`m`.`sConfigSqlStr` AS `sConfigSqlStr`,`m`.`sConfigWhere` AS `sConfigWhere`,`m`.`sConfigOrder` AS `sConfigOrder`,`m`.`iFreezeColumn` AS `iFreezeColumn`,`m`.`bGrd` AS `bGrd`,`m`.`sGrd` AS `sGrd`,`m`.`sMergeTableName` AS `sMergeTableName`,`m`.`bNotSort` AS `bNotSort`,`g`.`sId` AS `sModelId`,`g`.`sChinese` AS `sChineseModelName`,`g`.`sBig5` AS `sBig5ModelName`,`g`.`sEnglish` AS `sEnglishModelName`,`m`.`sTableAlias` AS `sTableAlias`,`s`.`sSelectRelation` AS `sSelectRelation`,`s`.`sMaxValue` AS `sMaxValue`,`s`.`sMinValue` AS `sMinValue`,`s`.`iColValue` AS `iColValue`,`m`.`sChildTableName` AS `sChildTableName`,`m`.`sChildTableCondition` AS `sChildTableCondition`,`s`.`bMultipleChoice` AS `bMultipleChoice`,`s`.`sButtonParam` AS `sButtonParam`,`s`.`sButtonEnabled` AS `sButtonEnabled`,`s`.`sFieldToContent` AS `sFieldToContent`,`s`.`bMergeCell` AS `bMergeCell`,`s`.`sDateFormat` AS `sDateFormat`,`s`.`bEntireLine` AS `bEntireLine`,`s`.`sColor` AS `sColor`,`s`.`sColorTerms` AS `sColorTerms`,`s`.`bFind` AS `bFind`,`m`.`iPageSize` AS `iPageSize`,`m`.`sConfigTableAlias` AS `sConfigTableAlias`,`s`.`sCompareColor` AS `sCompareColor`,`m`.`sCharType` AS `sCharType`,`m`.`sTableType` AS `sTableType`,`s`.`sTableSelect` AS `sTableSelect`,`m`.`bNotCanEmpty` AS `bNotCanEmpty`,`s`.`sIcon` AS `sIcon` from ((`xlyweberp_saas_ai`.`gdsconfigformslave` `s` join `xlyweberp_saas_ai`.`gdsconfigformmaster` `m` on((`s`.`sParentId` = `m`.`sId`))) join `xlyweberp_saas_ai`.`gdsmodule` `g` on((`g`.`sId` = `m`.`sParentId`)))


说明

暂无人工说明。