STRINGMAP 和 EntityLogicalView表
需要介绍这两张表。
STRINGMAP :
表结构如下:
其中介绍几个关键字段的意义:
ObjectTypeCode: 是每个实体对应的值,具体查询方式可以在EntityLogicalView中取得。
AttributeName: 具体是哪个字段(架构名称)。
AttributeValue: 具体的哪个字段对应的值。
Value: 代表具体的意义。
EntityLogicalView:
具体表结构如下:
select new_aaaaId, statuscode,
(select Value from StringMap
where AttributeName='statuscode'
and ObjectTypeCode=(select ObjectTypeCode from EntityLogicalView where Name='new_aaaa')
and AttributeValue=statuscode ) 名称,
statecode,
(select Value from StringMap where AttributeName='statecode' and ObjectTypeCode=(select ObjectTypeCode from EntityLogicalView where Name='new_flowapprovalcrf') and AttributeValue=statecode )
from new_aaaa as A order by A.statuscode desc