元数据发布涉及的所有表

–ID元数据主件ID（元数据内点空白处属性页签显示的ID）------
select * from md_association where ( componentid in (‘cdac3d61-ae6c-429e-95a1-b793fa7b59f1’) and (dr=0 or dr is null) );

–元数据主实体与子实体的ID----
select * from md_property where ( classid in (‘279eee1e-1876-4923-8ea8-963eb6b952c9’, ‘3cf63aed-49b1-4d11-af69-f37965ae517e’) and (dr=0 or dr is null) );

–元数据主实体与子实体的(表名)—
select * from md_db_relation where ( endtableid in (‘levm_deliverybill’, ‘levm_deliverybill_b’) and (dr=0 or dr is null) );

–元数据主实体与子实体的(表名)–
select * from md_db_relation where ( starttableid in (‘levm_deliverybill’, ‘levm_deliverybill_b’) and (dr=0 or dr is null) );

–元数据主实体与子实体的表名----
select * from md_column where ( tableid in (‘levm_deliverybill’, ‘levm_deliverybill_b’) and (dr=0 or dr is null) );

–元数据主实体与子实体的表名----
select * from md_table where ( id in (‘levm_deliverybill’, ‘levm_deliverybill_b’) and (dr=0 or dr is null) );

–元数据主实体与子实体的ID----
select * from md_ormap where ( classid in (‘279eee1e-1876-4923-8ea8-963eb6b952c9’, ‘3cf63aed-49b1-4d11-af69-f37965ae517e’) and (dr=0 or dr is null) );

–元数据主实体与子实体的ID----
select * from md_bizitfmap where ( classid in (‘279eee1e-1876-4923-8ea8-963eb6b952c9’, ‘3cf63aed-49b1-4d11-af69-f37965ae517e’) and (dr=0 or dr is null) );

–元数据主实体与子实体的ID----
select * from md_accessorpara where ( id in (‘279eee1e-1876-4923-8ea8-963eb6b952c9’, ‘3cf63aed-49b1-4d11-af69-f37965ae517e’) and (dr=0 or dr is null) );

–ID元数据主件ID（元数据内点空白处属性页签显示的ID）------
select * from md_class where ( componentid in (‘cdac3d61-ae6c-429e-95a1-b793fa7b59f1’) and (dr=0 or dr is null) );

–ID元数据主件ID（元数据内点空白处属性页签显示的ID）------
select * from md_component where ( ID=‘cdac3d61-ae6c-429e-95a1-b793fa7b59f1’ and (versiontype=‘0’) and (dr=0 or dr is null) );

– 查询是否原始组件 以及componentid，即根据名称空间和实体名称无法查询到相应的组件! 需要检查模型查看是否此类型已被删除!名称空间:wa，实体名称:payfileimport
select id, fromSourceBmf from md_component where namespace = ‘wa’ and id in (select distinct componentID from md_class where name = ‘payfileimport’)

– 查询是否原始组件 以及componentid，即根据名称空间和实体名称无法查询到相应的组件! 需要检查模型查看是否此类型已被删除!名称空间:wa，业务活动名称:payfileimportActivity
select id, fromSourceBmf from md_component where namespace = ‘wa’ and id in (select distinct * from md_busiactivity where name = ‘payfileimportActivity’)