viw_plc_machine.md 2.22 KB

Edit Raw Blame History



viw_plc_machine (view)


VIEW


Updatable: YES

Definer: xlyprint@%


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 `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`)))


Narrative

No human-written narrative yet.