---元数据所做的工作
发布元数据会导致以下表中产生数据
执行脚本即执行建表语句
下面只介绍发布元数据所产生的数据
--先根据表名查出发布的元数据的组件id ,之后的查询都是通过compentid来查询数据
componentid 指得是点击空白处的组件ID
假设表名是pt_app_account
select componentid from md_class where defaulttablename='pt_app_account';
--f1d9ad1e-70ff-428e-a58b-67a0fb8bdbdf
---md_table
select * from md_table where id in
(select defaulttablename from md_class where id in
(select id from md_class where componentid='f1d9ad1e-70ff-428e-a58b-67a0fb8bdbdf'));
---枚举
select * from MD_ENUMVALUE where id in
(select id from md_class where componentid='f1d9ad1e-70ff-428e-a58b-67a0fb8bdbdf');
----列数据
select * from md_column where tableid in
(select defaulttablename from md_class where id in
(select id from md_class where componentid='f1d9ad1e-70ff-428e-a58b-67a0fb8bdbdf'));
--主子表关联关系表
select * from md_db_relation where startattrid in
(select id from md_property where classid in
(select id from md_class where componentid='f1d9ad1e-70ff-428e-a58b-67a0fb8bdbdf'));
--属性表
select * from md_property where classid in
(select id from md_class where componentid='f1d9ad1e-70ff-428e-a58b-67a0fb8bdbdf');
select * from md_association where componentid='f1d9ad1e-70ff-428e-a58b-67a0fb8bdbdf';
--
select * from MD_ACCESSORPARA where id in
(select id from md_class where componentid='f1d9ad1e-70ff-428e-a58b-67a0fb8bdbdf');
---class表
select * from md_bizitfmap where classid in
(select id from md_class where componentid='f1d9ad1e-70ff-428e-a58b-67a0fb8bdbdf');
--
select * from md_ormap where classid in
(select id from md_class where componentid='f1d9ad1e-70ff-428e-a58b-67a0fb8bdbdf');
---class表
select * from md_class where componentid='f1d9ad1e-70ff-428e-a58b-67a0fb8bdbdf';
---组件 select * from md_component where id='f1d9ad1e-70ff-428e-a58b-67a0fb8bdbdf';
---------------------
作者:wqy123123wqy
来源:CSDN
原文:/wqy123123wqy/article/details/53897991
版权声明:本文为博主原创文章,转载请附上博文链接!
如果觉得《UAP元数据》对你有帮助,请点赞、收藏,并留下你的观点哦!