viw_eptmachinemaintenance.md 6.45 KB

Edit Raw Blame History



viw_eptmachinemaintenance (view)


Updatable: NO


Columns


#
Name
Type
Null


1
sId
varchar(100)
NO


2
sBrandsId
varchar(100)
NO


3
sSubsidiaryId
varchar(100)
NO


4
tCreateDate
datetime
NO


5
sMakePerson
varchar(255)
NO


6
sFormId
varchar(100)
NO


7
iOrder
int
NO


8
sBillNo
varchar(255)
NO


9
sManualNo
varchar(255)
NO


10
sType
varchar(255)
NO


11
sMemo
text
YES


12
bCheck
bit(1)
NO


13
tCheckDate
datetime
YES


14
sCheckPerson
varchar(255)
YES


15
bPrint
bit(1)
NO


16
bCopyLimit
bit(1)
NO


17
sStatus
varchar(255)
YES


18
bInvalid
bit(1)
NO


19
sMReserve1
varchar(255)
YES


20
sMReserve2
varchar(255)
YES


21
sMReserve3
varchar(255)
YES


22
sMReserve4
varchar(255)
YES


23
sMReserve5
varchar(255)
YES


24
sMReserve6
varchar(255)
YES


25
dMReserve1
decimal(18,6)
YES


26
dMReserve2
decimal(18,6)
YES


27
dMReserve3
decimal(18,6)
YES


28
iMReserve1
int
YES


29
iMReserve2
int
YES


30
iMReserve3
int
YES


31
tMReserve1
datetime
YES


32
tMReserve2
datetime
YES


33
tStartDate
datetime
YES


34
tEndDate
datetime
YES


35
sDepreciationMethod
varchar(255)
NO


36
sMachineState
varchar(255)
NO


37
dAssets
decimal(18,6)
NO


38
sDepartId
varchar(100)
NO


39
sDepreciationLimit
varchar(255)
NO


40
sMachineId
varchar(100)
NO


41
sSlaveId
varchar(100)
YES


42
iSlaveOrder
int
YES


43
sParentId
varchar(100)
YES


44
sMaintainContent
varchar(255)
YES


45
sMaintainResult
varchar(255)
YES


46
sMaintainEmployeeId
varchar(100)
YES


47
sMaintenanceCycle
varchar(255)
YES


48
sReplacementCycle
varchar(255)
YES


49
sRepairEmployeeId
varchar(100)
YES


50
sSrcId
varchar(100)
YES


51
sSrcSlaveId
varchar(100)
YES


52
sSrcNo
varchar(100)
YES


53
sSReserve1
varchar(255)
YES


54
sSReserve2
varchar(255)
YES


55
sSReserve3
varchar(255)
YES


56
sSReserve4
varchar(255)
YES


57
sSReserve5
varchar(255)
YES


58
sSReserve6
varchar(255)
YES


59
tSReserve1
datetime
YES


60
tSReserve2
datetime
YES


61
tSReserve3
datetime
YES


62
dSReserve1
decimal(18,6)
YES


63
dSReserve2
decimal(18,6)
YES


64
dSReserve3
decimal(18,6)
YES


65
sSlaveMemo
text
YES


66
dMaterialsQty
decimal(18,6)
YES


67
sMaterialsId
varchar(100)
YES


68
dMaintenanceTime
decimal(18,6)
YES


69
tBDate
datetime
YES


70
tEDate
datetime
YES


71
sMaintenanceCycles
varchar(255)
YES


72
sReplacementCycles
varchar(255)
YES


73
dMinute
bigint
YES


74
sEmployeeId
varchar(100)
YES


75
bCommand
bit(1)
YES


76
bLeader
bit(1)
YES


77
sCommandPerson
varchar(50)
YES


78
tCommandDate
datetime
YES


79
tLeaderDate
datetime
YES


80
sLeaderPerson
varchar(50)
YES


81
sEmployeeName
varchar(255)
YES


Definition
select `m`.`sId` AS `sId`,`m`.`sBrandsId` AS `sBrandsId`,`m`.`sSubsidiaryId` AS `sSubsidiaryId`,`m`.`tCreateDate` AS `tCreateDate`,`m`.`sMakePerson` AS `sMakePerson`,`m`.`sFormId` AS `sFormId`,`m`.`iOrder` AS `iOrder`,`m`.`sBillNo` AS `sBillNo`,`m`.`sManualNo` AS `sManualNo`,`m`.`sType` AS `sType`,`m`.`sMemo` AS `sMemo`,`m`.`bCheck` AS `bCheck`,`m`.`tCheckDate` AS `tCheckDate`,`m`.`sCheckPerson` AS `sCheckPerson`,`m`.`bPrint` AS `bPrint`,`m`.`bCopyLimit` AS `bCopyLimit`,`m`.`sStatus` AS `sStatus`,`m`.`bInvalid` AS `bInvalid`,`m`.`sMReserve1` AS `sMReserve1`,`m`.`sMReserve2` AS `sMReserve2`,`m`.`sMReserve3` AS `sMReserve3`,`m`.`sMReserve4` AS `sMReserve4`,`m`.`sMReserve5` AS `sMReserve5`,`m`.`sMReserve6` AS `sMReserve6`,`m`.`dMReserve1` AS `dMReserve1`,`m`.`dMReserve2` AS `dMReserve2`,`m`.`dMReserve3` AS `dMReserve3`,`m`.`iMReserve1` AS `iMReserve1`,`m`.`iMReserve2` AS `iMReserve2`,`m`.`iMReserve3` AS `iMReserve3`,`m`.`tMReserve1` AS `tMReserve1`,`m`.`tMReserve2` AS `tMReserve2`,`m`.`tStartDate` AS `tStartDate`,`m`.`tEndDate` AS `tEndDate`,`m`.`sDepreciationMethod` AS `sDepreciationMethod`,`m`.`sMachineState` AS `sMachineState`,`m`.`dAssets` AS `dAssets`,`m`.`sDepartId` AS `sDepartId`,`m`.`sDepreciationLimit` AS `sDepreciationLimit`,`m`.`sMachineId` AS `sMachineId`,`s`.`sId` AS `sSlaveId`,`s`.`iOrder` AS `iSlaveOrder`,`s`.`sParentId` AS `sParentId`,`s`.`sMaintainContent` AS `sMaintainContent`,`s`.`sMaintainResult` AS `sMaintainResult`,`s`.`sMaintainEmployeeId` AS `sMaintainEmployeeId`,`s`.`sMaintenanceCycle` AS `sMaintenanceCycle`,`s`.`sReplacementCycle` AS `sReplacementCycle`,`s`.`sRepairEmployeeId` AS `sRepairEmployeeId`,`s`.`sSrcId` AS `sSrcId`,`s`.`sSrcSlaveId` AS `sSrcSlaveId`,`s`.`sSrcNo` AS `sSrcNo`,`s`.`sSReserve1` AS `sSReserve1`,`s`.`sSReserve2` AS `sSReserve2`,`s`.`sSReserve3` AS `sSReserve3`,`s`.`sSReserve4` AS `sSReserve4`,`s`.`sSReserve5` AS `sSReserve5`,`s`.`sSReserve6` AS `sSReserve6`,`s`.`tSReserve1` AS `tSReserve1`,`s`.`tSReserve2` AS `tSReserve2`,`s`.`tSReserve3` AS `tSReserve3`,`s`.`dSReserve1` AS `dSReserve1`,`s`.`dSReserve2` AS `dSReserve2`,`s`.`dSReserve3` AS `dSReserve3`,`s`.`sSlaveMemo` AS `sSlaveMemo`,`s`.`dMaterialsQty` AS `dMaterialsQty`,`s`.`sMaterialsId` AS `sMaterialsId`,`s`.`dMaintenanceTime` AS `dMaintenanceTime`,`s`.`tBeginDate` AS `tBDate`,`s`.`tEndDate` AS `tEDate`,`m`.`sMaintenanceCycles` AS `sMaintenanceCycles`,`m`.`sReplacementCycles` AS `sReplacementCycles`,timestampdiff(MINUTE,`s`.`tBeginDate`,`s`.`tEndDate`) AS `dMinute`,`m`.`sEmployeeId` AS `sEmployeeId`,`m`.`bCommand` AS `bCommand`,`m`.`bLeader` AS `bLeader`,`m`.`sCommandPerson` AS `sCommandPerson`,`m`.`tCommandDate` AS `tCommandDate`,`m`.`tLeaderDate` AS `tLeaderDate`,`m`.`sLeaderPerson` AS `sLeaderPerson`,`m`.`sEmployeeName` AS `sEmployeeName` from (`eptmachinemaintenancemaster` `m` left join `eptmachinemaintenanceslave` `s` on((`m`.`sId` = `s`.`sParentId`)))


Narrative

No human-written narrative yet.