# `gdsconfigformcustomslavemasterview` (view)


- **Updatable:** YES

## 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)` | NO |
| 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` | `varchar(255)` | 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` | `varchar(255)` | 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 | `bNotSort` | `bit(1)` | NO |
| 60 | `sChineseModelName` | `varchar(255)` | NO |
| 61 | `sBig5ModelName` | `varchar(255)` | YES |
| 62 | `sEnglishModelName` | `varchar(255)` | YES |
| 63 | `sTableAlias` | `varchar(255)` | NO |
| 64 | `sSelectRelation` | `text` | YES |
| 65 | `sMaxValue` | `varchar(255)` | NO |
| 66 | `sMinValue` | `varchar(255)` | NO |
| 67 | `iColValue` | `int` | NO |
| 68 | `sChildTableName` | `varchar(255)` | NO |
| 69 | `sChildTableCondition` | `varchar(255)` | NO |
| 70 | `bMultipleChoice` | `bit(1)` | NO |
| 71 | `bFind` | `bit(1)` | NO |
| 72 | `sButtonParam` | `text` | YES |
| 73 | `sButtonEnabled` | `varchar(255)` | YES |
| 74 | `sFieldToContent` | `text` | YES |
| 75 | `bMergeCell` | `bit(1)` | NO |
| 76 | `sDateFormat` | `varchar(255)` | YES |
| 77 | `iPageSize` | `int` | NO |
| 78 | `sConfigTableAlias` | `varchar(255)` | YES |

## Definition

```sql
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`.`bNotSort` AS `bNotSort`,`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`.`bFind` AS `bFind`,`s`.`sButtonParam` AS `sButtonParam`,`s`.`sButtonEnabled` AS `sButtonEnabled`,`s`.`sFieldToContent` AS `sFieldToContent`,`s`.`bMergeCell` AS `bMergeCell`,`s`.`sDateFormat` AS `sDateFormat`,`m`.`iPageSize` AS `iPageSize`,`m`.`sConfigTableAlias` AS `sConfigTableAlias` from ((`gdsconfigformcustomslave` `s` join `gdsconfigformmaster` `m` on((`s`.`sParentId` = `m`.`sId`))) join `gdsmodule` `g` on((`g`.`sId` = `m`.`sParentId`)))
```

## Narrative

_No human-written narrative yet._
