select * from obpm2.tenant_organizations where id='OD6i7ceRbaHXKEOJtJI';
select * from baibaodunflow.tlk_companyinformation where DOMAINID='OD6i7ceRbaHXKEOJtJI';
select * from obpm2.tenant_users where id='0';
select * from baibaodunflow.tlk_attendance_site_base_info where id='04EskW80q5hVVh7Wv3A--__W052b1XNoLmPckF6ch1';

select bi.ID,bi.ITEM_ATTENDANCESITENAME,pi.ITEM_SECURITYNAME,pi.ITEM_SECURITYID,pi.ITEM_SECURITYNAME
from baibaodunflow.tlk_attendance_site_base_info bi join baibaodunflow.tlk_attendance_site_person_info pi
                                                         on bi.ID=pi.ITEM_ATTENDANCESITEID limit 10;

select * from baibaodunflow.tlk_attendance_site_base_info where id='zEr2Dk0I6LveLwjNAhN--__W052b1XNoLmPckF6ch1';



select count(1) from rd_employee_summary;
select count(1) from rd_company_summary;
select count(1) from rd_security_station_summary;

select * from rd_company_summary where id='OD6i7ceRbaHXKEOJtJI';
select * from rd_employee_summary where id='PGrAtu8p';
select * from rd_security_station_summary where id='04EskW80q5hVVh7Wv3A--__W052b1XNoLmPckF6ch1';