viw_filfilemanage.md 9.21 KB

Edit Raw Blame History Permalink



viw_filfilemanage（视图）


是否可更新： YES

定义者： xlyprint@%


字段


#
名称
类型
可空


1
sId
varchar(100)
NO


2
sBrandsId
varchar(100)
NO


3
sSubsidiaryId
varchar(100)
NO


4
sMakePerson
varchar(255)
NO


5
iOrder
int
NO


6
sPicturePath
varchar(255)
NO


7
bDefault
bit(1)
NO


8
sFileName
varchar(255)
NO


9
sSrcSlaveId
varchar(100)
NO


10
sSrcId
varchar(100)
NO


11
sSrcNo
varchar(255)
NO


12
sSrcFormId
varchar(100)
NO


13
bCheck
bit(1)
NO


14
sType
varchar(255)
NO


15
tCheckDate
datetime
YES


16
sCheckPerson
varchar(255)
YES


17
bPrint
bit(1)
NO


18
bCopyLimit
bit(1)
NO


19
sStatus
varchar(255)
YES


20
bInvalid
bit(1)
NO


21
sMemo
text
YES


22
tCreateDate
datetime
NO


23
sMReserve1
varchar(255)
YES


24
sMReserve2
varchar(255)
YES


25
sMReserve3
varchar(255)
YES


26
sMReserve4
varchar(255)
YES


27
sMReserve5
varchar(255)
YES


28
sMReserve6
varchar(255)
YES


29
dMReserve1
decimal(18,6)
YES


30
dMReserve2
decimal(18,6)
YES


31
dMReserve3
decimal(18,6)
YES


32
iMReserve1
int
YES


33
iMReserve2
int
YES


34
iMReserve3
int
YES


35
tMReserve1
datetime
YES


36
tMReserve2
datetime
YES


37
sImportance
varchar(255)
NO


38
sBillNo
varchar(255)
NO


39
iIncrement
int
NO


40
sSlaveId
varchar(100)
NO


41
sSlaveBrandsId
varchar(100)
NO


42
sSlaveSubsidiaryId
varchar(100)
NO


43
sSlaveMakePerson
varchar(255)
NO


44
iSlaveOrder
int
NO


45
sParentId
varchar(100)
NO


46
sSlavePicturePath
varchar(255)
YES


47
bSlaveDefault
bit(1)
NO


48
sSlaveFileName
varchar(255)
NO


49
sFormId
varchar(100)
NO


50
sParentName
varchar(255)
YES


51
sChildName
varchar(255)
YES


52
sDepartName
varchar(1000)
YES


53
tStartDate
datetime
YES


54
tEndDate
datetime
YES


55
sFormatPerson
varchar(255)
YES


56
sFormatPersonId
varchar(255)
YES


57
sSupplyId
varchar(255)
YES


58
sMakeSupply
varchar(255)
YES


59
sMechanism
varchar(255)
YES


60
sCertificateNo
varchar(255)
YES


61
sClassParentName
varchar(255)
YES


62
sClassChildName
varchar(255)
YES


63
tTestDate
datetime
YES


64
tTestEndDate
datetime
YES


65
sMaterialComposition
varchar(255)
YES


66
sCASNumber
varchar(255)
YES


67
sMaterialConcentration
varchar(255)
YES


68
sMaterialsId
varchar(255)
YES


69
iDay
int
YES


70
sShowDay
varchar(2)
NO


71
sServeName
varchar(255)
YES


72
sVersion
varchar(255)
YES


73
sContract
varchar(255)
YES


74
sContractMobile
varchar(255)
YES


75
iYear
int
YES


76
iBetweenDay
int
YES


定义
select `xlyweberp_saas_ai`.`filfilemanagemaster`.`sId` AS `sId`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sMakePerson` AS `sMakePerson`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`iOrder` AS `iOrder`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sPicturePath` AS `sPicturePath`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`bDefault` AS `bDefault`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sFileName` AS `sFileName`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sSrcSlaveId` AS `sSrcSlaveId`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sSrcId` AS `sSrcId`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sSrcNo` AS `sSrcNo`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sSrcFormId` AS `sSrcFormId`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`bCheck` AS `bCheck`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sType` AS `sType`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`tCheckDate` AS `tCheckDate`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sCheckPerson` AS `sCheckPerson`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`bPrint` AS `bPrint`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`bCopyLimit` AS `bCopyLimit`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sStatus` AS `sStatus`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`bInvalid` AS `bInvalid`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sMemo` AS `sMemo`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`tCreateDate` AS `tCreateDate`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sMReserve1` AS `sMReserve1`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sMReserve2` AS `sMReserve2`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sMReserve3` AS `sMReserve3`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sMReserve4` AS `sMReserve4`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sMReserve5` AS `sMReserve5`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sMReserve6` AS `sMReserve6`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`dMReserve1` AS `dMReserve1`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`dMReserve2` AS `dMReserve2`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`dMReserve3` AS `dMReserve3`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`iMReserve1` AS `iMReserve1`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`iMReserve2` AS `iMReserve2`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`iMReserve3` AS `iMReserve3`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`tMReserve1` AS `tMReserve1`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`tMReserve2` AS `tMReserve2`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sImportance` AS `sImportance`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sBillNo` AS `sBillNo`,`xlyweberp_saas_ai`.`filfilemanageslave`.`iIncrement` AS `iIncrement`,`xlyweberp_saas_ai`.`filfilemanageslave`.`sId` AS `sSlaveId`,`xlyweberp_saas_ai`.`filfilemanageslave`.`sBrandsId` AS `sSlaveBrandsId`,`xlyweberp_saas_ai`.`filfilemanageslave`.`sSubsidiaryId` AS `sSlaveSubsidiaryId`,`xlyweberp_saas_ai`.`filfilemanageslave`.`sMakePerson` AS `sSlaveMakePerson`,`xlyweberp_saas_ai`.`filfilemanageslave`.`iOrder` AS `iSlaveOrder`,`xlyweberp_saas_ai`.`filfilemanageslave`.`sParentId` AS `sParentId`,`xlyweberp_saas_ai`.`filfilemanageslave`.`sPicturePath` AS `sSlavePicturePath`,`xlyweberp_saas_ai`.`filfilemanageslave`.`bDefault` AS `bSlaveDefault`,`xlyweberp_saas_ai`.`filfilemanageslave`.`sFileName` AS `sSlaveFileName`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sFormId` AS `sFormId`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sParentName` AS `sParentName`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sChildName` AS `sChildName`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sDepartName` AS `sDepartName`,`xlyweberp_saas_ai`.`filfilemanageslave`.`tStartDate` AS `tStartDate`,`xlyweberp_saas_ai`.`filfilemanageslave`.`tEndDate` AS `tEndDate`,`xlyweberp_saas_ai`.`filfilemanageslave`.`sFormatPerson` AS `sFormatPerson`,`xlyweberp_saas_ai`.`filfilemanageslave`.`sFormatPersonId` AS `sFormatPersonId`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sSupplyId` AS `sSupplyId`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sMakeSupply` AS `sMakeSupply`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sMechanism` AS `sMechanism`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sCertificateNo` AS `sCertificateNo`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sClassParentName` AS `sClassParentName`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sClassChildName` AS `sClassChildName`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`tTestDate` AS `tTestDate`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`tTestEndDate` AS `tTestEndDate`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sMaterialComposition` AS `sMaterialComposition`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sCASNumber` AS `sCASNumber`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sMaterialConcentration` AS `sMaterialConcentration`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sMaterialsId` AS `sMaterialsId`,(to_days(`xlyweberp_saas_ai`.`filfilemanagemaster`.`tTestEndDate`) - to_days(now())) AS `iDay`,(case when ((to_days(`xlyweberp_saas_ai`.`filfilemanagemaster`.`tTestEndDate`) - to_days(now())) < 0) then '超期' when (((to_days(`xlyweberp_saas_ai`.`filfilemanagemaster`.`tTestEndDate`) - to_days(now())) >= 0) and ((to_days(`xlyweberp_saas_ai`.`filfilemanagemaster`.`tTestEndDate`) - to_days(now())) < 31)) then '预警' else '正常' end) AS `sShowDay`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sServeName` AS `sServeName`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sVersion` AS `sVersion`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sContract` AS `sContract`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`sContractMobile` AS `sContractMobile`,`xlyweberp_saas_ai`.`filfilemanagemaster`.`iYear` AS `iYear`,(to_days(`xlyweberp_saas_ai`.`filfilemanagemaster`.`tTestEndDate`) - to_days(now())) AS `iBetweenDay` from (`xlyweberp_saas_ai`.`filfilemanagemaster` join `xlyweberp_saas_ai`.`filfilemanageslave` on((`xlyweberp_saas_ai`.`filfilemanagemaster`.`sId` = `xlyweberp_saas_ai`.`filfilemanageslave`.`sParentId`)))


说明

暂无人工说明。