viw_plc_machine1.md 2.06 KB

Edit Raw Blame History



viw_plc_machine1 (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
iSemens
int
NO


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`,1 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.