viw_plc_machine.md
1.78 KB
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
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.