# `viw_plc_machine`（视图）


- **是否可更新：** YES
- **定义者：** `xlyprint@%`

## 字段

| # | 名称 | 类型 | 可空 |
|---|---|---|---|
| 1 | `iIncrement` | `int` | NO |
| 2 | `sId` | `varchar(100)` | NO |
| 3 | `sBrandsId` | `varchar(100)` | NO |
| 4 | `sSubsidiaryId` | `varchar(100)` | NO |
| 5 | `sPlcsStatusName` | `varchar(255)` | NO |
| 6 | `iPlcsStatusAdd` | `int` | NO |
| 7 | `sPlcsStatusValue` | `varchar(255)` | NO |
| 8 | `iType` | `int` | NO |
| 9 | `iOrder` | `int` | NO |
| 10 | `dMax` | `decimal(18,1)` | NO |
| 11 | `dMin` | `decimal(18,1)` | NO |
| 12 | `sParentId` | `varchar(255)` | NO |
| 13 | `iPlcNo` | `int` | NO |
| 14 | `sOffWork` | `varchar(50)` | YES |
| 15 | `sShiftsWork` | `varchar(50)` | NO |
| 16 | `sWorkType` | `varchar(50)` | YES |
| 17 | `iSemens` | `bigint` | YES |

## 定义

```sql
select `xlyweberp_saas_ai`.`plc_currentmachinevalue`.`iIncrement` AS `iIncrement`,`xlyweberp_saas_ai`.`plc_currentmachinevalue`.`sId` AS `sId`,`xlyweberp_saas_ai`.`plc_currentmachinevalue`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`plc_currentmachinevalue`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`plc_currentmachinevalue`.`sPlcsStatusName` AS `sPlcsStatusName`,`xlyweberp_saas_ai`.`plc_currentmachinevalue`.`iPlcsStatusAdd` AS `iPlcsStatusAdd`,`xlyweberp_saas_ai`.`plc_currentmachinevalue`.`sPlcsStatusValue` AS `sPlcsStatusValue`,`xlyweberp_saas_ai`.`plc_currentmachinevalue`.`iType` AS `iType`,`xlyweberp_saas_ai`.`plc_currentmachinevalue`.`iOrder` AS `iOrder`,`xlyweberp_saas_ai`.`plc_currentmachinevalue`.`dMax` AS `dMax`,`xlyweberp_saas_ai`.`plc_currentmachinevalue`.`dMin` AS `dMin`,`xlyweberp_saas_ai`.`plc_currentmachinevalue`.`sParentId` AS `sParentId`,`xlyweberp_saas_ai`.`elemachine`.`iPlcNo` AS `iPlcNo`,`xlyweberp_saas_ai`.`elemachine`.`sOffWork` AS `sOffWork`,`xlyweberp_saas_ai`.`elemachine`.`sShiftsWork` AS `sShiftsWork`,`xlyweberp_saas_ai`.`elemachine`.`sWorkType` AS `sWorkType`,ceiling((`xlyweberp_saas_ai`.`elemachine`.`iPlcNo` / 14)) AS `iSemens` from (`xlyweberp_saas_ai`.`elemachine` join `xlyweberp_saas_ai`.`plc_currentmachinevalue` on((`xlyweberp_saas_ai`.`elemachine`.`sId` = `xlyweberp_saas_ai`.`plc_currentmachinevalue`.`sParentId`)))
```

## 说明

_暂无人工说明。_
