--分类对象定义
select * from infodba.picm0 where pid='000023/A';
--分类的定义
select * from infodba.PSMLB0;
--分类与属性关系
SELECT b0.pcid,b0.pname,att.punct,att.pname ,att.psname,b1.PATTR_INDEX
FROM PSMLB0 b0, PSMLB1 b1 , PUNCT_DICT att
WHERE b0.PUID=b1.RTAG_TO_HEADERU and b1.punct = att.punct and b0.pcid='ICM0101' ORDER BY PATTR_INDEX;
--属性定义
select PSM01 "长",PSM02 "宽" from infodba.picm0 where pid='000023/A';
--属性字典名称
SELECT att.puid,att.pname,att.psname,att.punct FROM PUNCT_DICT att
--父项
SELECT * FROM PPARENT;
--分类节点定义
SELECT * FROM PSMLB0;
--父项 pval_0 父项 ;PUID 子项的 puid ;
SELECT * FROM PPARENT p inner join PSMLB0 b0 on p.puid =b0.puid;
--分类节点定义
SELECT * FROM PSMLB0;