查询医生SQL：
select aa.id staffid,bb.property_value staffname from thc_warehouse.staff_record aa
inner join thc_warehouse.staff_record_property bb on bb.property_code = 'SXX000083' and aa.id = bb.staff_record_id
查询部门
select id as deptid,name as deptname from thc_sob.bpm_serv_provider
查值集(国家)
select b.code,b.name,b.value
from `thc_warehouse`.`sys_type` a
join `thc_warehouse`.`sys_type_info` b on a.id = b.sys_type_id
where a.code = 'htc_00000009'
order by value
-- 机构查询
select clinic_id,property_value from `thc_warehouse`.`clinic_property` where property_code = 'SXX000055'