viw_sismaterialsclassify.md 1.02 KB

Edit Raw Blame History Permalink



viw_sismaterialsclassify (view)


Updatable: NO


Columns


#
Name
Type
Null


1
sMaterialsType
varchar(100)
YES


2
sName
varchar(100)
NO


3
sNo
varchar(50)
YES


4
sId
varchar(50)
YES


5
sParentNo
varchar(50)
YES


6
sBrandsId
varchar(50)
YES


7
sSubsidiaryId
varchar(50)
YES


8
bInvalid
bit(1)
NO


9
iOrder
int
NO


Definition
select (select `b`.`sName` from `sismaterialsclassify` `b` where (`b`.`sId` = `a`.`sParentId`)) AS `sMaterialsType`,`a`.`sName` AS `sName`,`a`.`sNo` AS `sNo`,`a`.`sId` AS `sId`,(select `b`.`sNo` from `sismaterialsclassify` `b` where (`b`.`sId` = `a`.`sParentId`)) AS `sParentNo`,`a`.`sBrandsId` AS `sBrandsId`,`a`.`sSubsidiaryId` AS `sSubsidiaryId`,`a`.`bInvalid` AS `bInvalid`,`a`.`iOrder` AS `iOrder` from `sismaterialsclassify` `a` where ((`a`.`bInvalid` = 0) and (ifnull(`a`.`sParentId`,'') <> ''))


Narrative

No human-written narrative yet.