---元數據所做的工作
發布元數據會導致以下表中產生數據
執行腳本即執行建表語句
下面只介紹發布元數據所產生的數據
--先根據表名查出發布的元數據的組件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
原文：https://blog.csdn.net/wqy123123wqy/article/details/53897991
版權聲明：本文為博主原創文章，轉載請附上博文鏈接！

總結

以上是生活随笔為你收集整理的UAP元数据的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。