金升阳38版本——取替代的关联关系

select * from ma_foundation bb where bb.id='TD18080032'
--guid=895B44E025714639ACB5E2BD3A5DE54F    （第一个页签）           classGUID=118103B793B349F3B21B7EFC381F9ECB--          Batch Substitute Form--- baseTable===BatchRS
--guid=525EFF972A834F67BC6CFCFE4F6F177C   BatchRS-RSRelationship（关系，第三个页签）---classGUID=E4D14EFCF8D54527B3565A894E6DD631 
--guid=B8F673EF583547D18AA67F561FE37536   BatchRS-Master（主件。第二个页签）-----------classGUID=E4D14EFCF8D54527B3565A894E6DD631-- ApproveView  --baseTable==ViewObject
select * from ma_class aa where aa.guid='E4D14EFCF8D54527B3565A894E6DD631'--ApproveView           --baseTable==ViewObject
select * from ma_class aa where aa.guid='118103B793B349F3B21B7EFC381F9ECB'--Batch Substitute Form---   baseTable===BatchRS

--无用的探索
select * from ma_foundation bb where bb.guid='B8F673EF583547D18AA67F561FE37536'
select * from Viewobject_r  dd where dd.foundationfk='B8F673EF583547D18AA67F561FE37536'
select * from Batchrs_i  cc where cc.foundationfk='895B44E025714639ACB5E2BD3A5DE54F'

select * from StructureObject  qq where qq.viewfk='525EFF972A834F67BC6CFCFE4F6F177C'  --关系的关联关系
--guid=A7792495F5634D0D97A1F8A91ACD518B--end2classGUID=8B17AF10E14E42A19267A60E852461A1--end2MASTERGUID=7AE401083D434AB99CE666E324AE607B
--guid=B9658E14E0204963A997D003442A48E0--end2classGUID=0F39FA111289460F9ABA4F4CA6298DDA--end2MASTERGUID=709720706C474BFC93D0B1FD7D74C150
select * from ma_foundation bb where bb.masterfk='7AE401083D434AB99CE666E324AE607B'--ID=53500922--NAME=testEnd1002_2---这两个都是主件
select * from ma_foundation bb where bb.masterfk='709720706C474BFC93D0B1FD7D74C150'--ID=testEnd1002--------------------这两个都是主件

select * from StructureObject  qq where qq.viewfk='B8F673EF583547D18AA67F561FE37536' --主件的关联关系
--guid=5BE553BA56DB48DB89378E81D1836FD8--end2classGUID=FFC20939ECA84043B85B999E5D06E5C1--end2MASTERGUID=1F8E22C7861641E187A52670446466E6
--guid=2DB49C45935E4ADE99C69C6247C8EA52--end2classGUID=FFC20939ECA84043B85B999E5D06E5C1--end2MASTERGUID=F586805AA60C45748314276C7802A4AC
select * from ma_foundation bb where bb.masterfk='1F8E22C7861641E187A52670446466E6'--ID=180831-0007--classGUID==FFC20939ECA84043B85B999E5D06E5C1   
select * from ma_foundation bb where bb.masterfk='F586805AA60C45748314276C7802A4AC'--ID=180831-0008

select * from ma_class aa where aa.guid='FFC20939ECA84043B85B999E5D06E5C1'   --Substitute--Replace/Substitute

TD18080008
select * from ma_foundation bb where bb.id='TD18080008'
--guid=4EE3268A9FF8441FA0358BA07D7ECF66                            classGUID=118103B793B349F3B21B7EFC381F9ECB--    Batch Substitute Form---   baseTable===BatchRS
--guid=09F8AEC54D2F41968152D615BAD9DB86   BatchRS-RSRelationship---classGUID=E4D14EFCF8D54527B3565A894E6DD631 
--guid=ECF4BB1BE98D4F129D03C940313212C4   BatchRS-Master-----------classGUID=E4D14EFCF8D54527B3565A894E6DD631--    ApproveView              --baseTable==ViewObject


select * from StructureObject  qq where qq.viewfk='ECF4BB1BE98D4F129D03C940313212C4'    ----724行--主件

select * from StructureObject  qq where qq.viewfk='09F8AEC54D2F41968152D615BAD9DB86'    ----495行--关系