viw_gdsconfigchar.md
2.68 KB
viw_gdsconfigchar（视图）
- 是否可更新： NO
-
定义者：
xlyprint@%
字段
| # | 名称 | 类型 | 可空 |
|---|---|---|---|
| 1 | iIncrement |
int |
NO |
| 2 | sId |
varchar(100) |
NO |
| 3 | sFormId |
varchar(100) |
NO |
| 4 | sBrandsId |
varchar(100) |
NO |
| 5 | sSubsidiaryId |
varchar(100) |
NO |
| 6 | tCreateDate |
datetime |
NO |
| 7 | sMakePerson |
varchar(255) |
NO |
| 8 | sParentId |
varchar(100) |
NO |
| 9 | iOrder |
int |
NO |
| 10 | sChinese |
varchar(255) |
NO |
| 11 | sEnglish |
varchar(255) |
YES |
| 12 | sBig5 |
varchar(255) |
YES |
| 13 | sCharType |
varchar(100) |
NO |
| 14 | sProcedureName |
varchar(255) |
NO |
| 15 | sProcedureParam |
longtext |
YES |
| 16 | iWidth |
int |
NO |
| 17 | iHeight |
int |
NO |
| 18 | sActiveId |
varchar(1000) |
NO |
| 19 | sCharParentId |
varchar(255) |
NO |
| 20 | sStyle |
longtext |
NO |
| 21 | dRefreshTime |
decimal(18,6) |
NO |
| 22 | bInvalid |
bit(1) |
NO |
| 23 | sSlaveId |
varchar(100) |
YES |
| 24 | sSrcSlaveId |
varchar(100) |
YES |
| 25 | sSrcId |
varchar(255) |
YES |
| 26 | iSlaveId |
int |
YES |
| 27 | sSlaveParentId |
varchar(255) |
YES |
| 28 | sSlaveChinese |
varchar(255) |
YES |
| 29 | sSlaveEnglish |
varchar(255) |
YES |
| 30 | sSlaveBig5 |
varchar(255) |
YES |
| 31 | sSlaveName |
varchar(255) |
YES |
| 32 | sType |
varchar(255) |
YES |
| 33 | sTypeValue |
varchar(255) |
YES |
定义
select `m`.`iIncrement` AS `iIncrement`,`m`.`sId` AS `sId`,`m`.`sId` AS `sFormId`,`m`.`sBrandsId` AS `sBrandsId`,`m`.`sSubsidiaryId` AS `sSubsidiaryId`,`m`.`tCreateDate` AS `tCreateDate`,`m`.`sMakePerson` AS `sMakePerson`,`m`.`sParentId` AS `sParentId`,`m`.`iOrder` AS `iOrder`,`m`.`sChinese` AS `sChinese`,`m`.`sEnglish` AS `sEnglish`,`m`.`sBig5` AS `sBig5`,`m`.`sCharType` AS `sCharType`,`m`.`sProcedureName` AS `sProcedureName`,`m`.`sProcedureParam` AS `sProcedureParam`,`m`.`iWidth` AS `iWidth`,`m`.`iHeight` AS `iHeight`,`m`.`sActiveId` AS `sActiveId`,`m`.`sCharParentId` AS `sCharParentId`,`m`.`sStyle` AS `sStyle`,`m`.`dRefreshTime` AS `dRefreshTime`,`m`.`bInvalid` AS `bInvalid`,`s`.`sId` AS `sSlaveId`,`s`.`sId` AS `sSrcSlaveId`,`s`.`sParentId` AS `sSrcId`,`s`.`iOrder` AS `iSlaveId`,`s`.`sParentId` AS `sSlaveParentId`,`s`.`sChinese` AS `sSlaveChinese`,`s`.`sEnglish` AS `sSlaveEnglish`,`s`.`sBig5` AS `sSlaveBig5`,`s`.`sName` AS `sSlaveName`,`s`.`sType` AS `sType`,`s`.`sTypeValue` AS `sTypeValue` from (`xlyweberp_saas_ai`.`gdsconfigcharmaster` `m` left join `xlyweberp_saas_ai`.`gdsconfigcharslave` `s` on((`m`.`sId` = `s`.`sParentId`)))
说明
暂无人工说明。