thc_业务积累

查询医生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'