# `viw_plc_machine` (view)


- **Updatable:** YES

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 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 |

## Definition

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

## Narrative

_No human-written narrative yet._