viw_plc_machine1.md 2.06 KB

Edit Raw Blame History



viw_plc_machine1（视图）


是否可更新： 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
iSemens
int
NO


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


说明

暂无人工说明。