```
-----------------------------------------------------------
-- 1.查询患者档案表 查询档案号 --
-----------------------------------------------------------
--姓名查询（可能重复）
select * from foundation.com_patientinfo pa where pa.name = '王书';
--身份证查询（唯一）
select * from foundation.com_patientinfo pa where pa.ide_no = '410521196006096511';
-----------------------------------------------------------
-- 2.查询卡类型表（一个档案号对应两个卡类型，卡号和身份证）找到出错的档案号 --
-----------------------------------------------------------
select * from foundation.com_medical_card ca where ca.patient_id in ('PN00178004','PN00178005') order by ca.patient_id;
-----------------------------------------------------------
-- 查询账户表 --
-----------------------------------------------------------
select * from opo.fin_opb_account ac where ac.patient_id in ('PN00178004','PN00178005') order by ac.patient_id;
-----------------------------------------------------------
-- 3.查询就诊信息（确认无门诊或住院就诊信息） --
-----------------------------------------------------------
--门诊
select * from opo.cdr_opr_radt_register re where re.patient_id in ('PN00178004','PN00178005');
--住院
select * from ipo.cdr_ipr_register ire where ire.patient_id in ('PN00178004','PN00178005');
--4.信息修改 （3个表分别点击解锁、删除、确认->F10或运行按钮右边提交修改事务）
select pa.*,rowid from foundation.com_patientinfo pa where pa.patient_id = 'PN00178004';
select ca.*,rowid from foundation.com_medical_card ca where ca.patient_id = 'PN00178004';
select ac.*,rowid from opo.fin_opb_account ac where ac.patient_id = 'PN00178004';
```
