--用户
select * from dbo.[User]
--角色
select * from [Role]
--关系表
select * from dbo.Relevance t order by t.OperateTime desc
----key=RoleOrg Firstid是角色id，secondid是机构id
select * from dbo.Relevance t where t.[Key]='RoleOrg' order by t.OperateTime desc
select * from [Role] t where t.Id='68d08599-2989-41e4-a0fa-51207beaf8de'
select * from [Org] t where t.Id='543a9fcf-4770-4fd9-865f-030e562be238'
----key=UserRole Firstid是用户id，secondid是角色id
select * from dbo.Relevance t where t.[Key]='UserRole' order by t.OperateTime desc
select * from [User] t where t.Id='362a6cd1-fd7e-42e6-a33f-fa0286399521'
select * from [Role] t where t.Id='68d08599-2989-41e4-a0fa-51207beaf8de'

select * from dbo.Relevance t where t.[Key]='RoleModule'
and t.FirstId='68d08599-2989-41e4-a0fa-51207beaf8de'
 order by t.OperateTime desc
select * from [Role] t where t.Id='68d08599-2989-41e4-a0fa-51207beaf8de'
select * from [Module] t where t.Id='6a9e1346-0c01-44d2-8eb1-f929fdab542a'

select * from dbo.Relevance t where t.[Key]='UserResource'
and t.FirstId='362a6cd1-fd7e-42e6-a33f-fa0286399521'
 order by t.OperateTime desc
select * from [Role] t where t.Id='68d08599-2989-41e4-a0fa-51207beaf8de'
select * from [Module] t where t.Id='6a9e1346-0c01-44d2-8eb1-f929fdab542a'

----模块与模块元素表
select * from Module m where m.Name='部门管理'
select * from ModuleElement me where me.ModuleId='6a9e1346-0c01-44d2-8eb1-f929fdab542a'

select * from dbo.[Resource]

SELECT * FROM dbo.CategoryType;
SELECT * FROM dbo.Category

SELECT * FROM dbo.[Application];