gdsconfigformslavemasterview.md
6.81 KB
gdsconfigformslavemasterview (view)
VIEW
- Updatable: YES
-
Definer:
xlyprint@%
Columns
| # | Name | Type | Null |
|---|---|---|---|
| 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 |
Definition
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`)))
Narrative
No human-written narrative yet.