--##审批节点配置表 — YS_SPJDPZ create table SD_MZ.YS_SPJDPZ ( JDID00 number(10) not null, -- 节点ID SPLX00 varchar2(1) default '1' not null, -- 审批类型：1-门诊电子病历回退申请；2-门急诊信息页回退申请；3-抗菌药申请 SPXH00 number(5) default 1 not null, -- 审批序号，从1开始 JSID00 number(10) default 0 not null, -- 角色编码，关联PT_JSB000.JSID00 JDMC00 varchar2(50) not null, -- 节点名称 SFYX00 varchar2(1) default '1' not null -- 是否有效：1-是，0-否 ); comment on table SD_MZ.YS_SPJDPZ is '审批节点配置表'; comment on column SD_MZ.YS_SPJDPZ.JDID00 is '节点ID'; comment on column SD_MZ.YS_SPJDPZ.SPLX00 is '审批类型：1-门诊电子病历回退申请；2-门急诊信息页回退申请；3-抗菌药申请'; comment on column SD_MZ.YS_SPJDPZ.SPXH00 is '审批序号，从1开始'; comment on column SD_MZ.YS_SPJDPZ.JSID00 is '角色编码，关联PT_JSB000.JSID00'; comment on column SD_MZ.YS_SPJDPZ.JDMC00 is '节点名称'; comment on column SD_MZ.YS_SPJDPZ.SFYX00 is '是否有效：1-是，0-否'; alter table SD_MZ.YS_SPJDPZ add constraint PK_YS_SPJDPZ primary key (JDID00); create unique index UK_YS_SPJDPZ on SD_MZ.YS_SPJDPZ (SPLX00, SPXH00); create index IDX_YS_SPJDPZ_JS on SD_MZ.YS_SPJDPZ (JSID00); create synonym YS_SPJDPZ for SD_MZ.YS_SPJDPZ; create sequence SD_MZ.SQ_YS_SPJDPZ_ID0000 start with 1 increment by 1 maxvalue 9999999999 cycle nocache; --##病历审批节点 create table SD_MZ.YS_BLSPJD( SPID00 number(10) not null, -- 审批ID（主键） SQDBH0 number(10) not null, -- 申请单编号，关联YS_BLSQJL.ID0000 SPXH00 number(5) not null, -- 审批序号，从1开始 JSID00 number(10) default 0 not null, -- 角色编码，关联PT_JSB000.JSID00 SPZT00 varchar2(1) default '0' not null-- 审批状态：0-未处理，1-已处理，2-跳过 ); comment on table SD_MZ.YS_BLSPJD is '病历审批节点'; comment on column SD_MZ.YS_BLSPJD.SPID00 is '审批ID（主键）'; comment on column SD_MZ.YS_BLSPJD.SQDBH0 is '申请单编号，关联YS_BLSQJL.ID0000'; comment on column SD_MZ.YS_BLSPJD.SPXH00 is '审批序号，从1开始'; comment on column SD_MZ.YS_BLSPJD.JSID00 is '角色编码，关联PT_JSB000.JSID00'; comment on column SD_MZ.YS_BLSPJD.SPZT00 is '审批状态：0-未处理，1-已处理，2-跳过'; alter table SD_MZ.YS_BLSPJD add constraint PK_YS_BLSPJD primary key (SPID00); create index IDX_YS_BLSPJD_SQ on SD_MZ.YS_BLSPJD (SQDBH0); create index IDX_YS_BLSPJD_ST on SD_MZ.YS_BLSPJD (SPZT00); create unique index UK_YS_BLSPJD on SD_MZ.YS_BLSPJD (SQDBH0, SPXH00); create synonym YS_BLSPJD for SD_MZ.YS_BLSPJD; create sequence SD_MZ.SQ_YS_BLSPJD_ID0000 start with 1 increment by 1 maxvalue 9999999999 cycle nocache; --##审批操作日志表 — YS_SPCZRZ create table SD_MZ.YS_SPCZRZ ( RZID00 number(10) not null, -- 日志ID SPID00 number(10) not null, -- 审批节点ID SPXH00 number(5) not null, -- 审批序号，从1开始 SPRGH0 varchar2(20) not null, -- 审批人工号 SPRXM0 varchar2(50) not null, -- 审批人姓名 CZLX00 varchar2(10) not null, -- 操作类型：1-通过，2-拒绝 CZYJ00 varchar2(2000), -- 操作意见 CZRQQ0 char(8) not null, -- 操作日期，格式YYYYMMDD CZSJ00 char(8) not null -- 操作时间，格式HH:24MI:SS ); comment on table SD_MZ.YS_SPCZRZ is '审批操作日志表'; comment on column SD_MZ.YS_SPCZRZ.RZID00 is '日志ID'; comment on column SD_MZ.YS_SPCZRZ.SPID00 is '审批节点ID'; comment on column SD_MZ.YS_SPCZRZ.SPXH00 is '审批序号，从1开始'; comment on column SD_MZ.YS_SPCZRZ.SPRGH0 is '审批人工号'; comment on column SD_MZ.YS_SPCZRZ.SPRXM0 is '审批人姓名'; comment on column SD_MZ.YS_SPCZRZ.CZLX00 is '操作类型：1-通过，2-拒绝'; comment on column SD_MZ.YS_SPCZRZ.CZYJ00 is '操作意见'; comment on column SD_MZ.YS_SPCZRZ.CZRQQ0 is '操作日期，格式YYYYMMDD'; comment on column SD_MZ.YS_SPCZRZ.CZSJ00 is '操作时间，格式HH:24MI:SS'; alter table SD_MZ.YS_SPCZRZ add constraint PK_YS_SPCZRZ primary key (RZID00); create index IDX_YS_SPCZRZ_SP on SD_MZ.YS_SPCZRZ (SPID00); create index IDX_YS_SPCZRZ_CZSJ on SD_MZ.YS_SPCZRZ (CZSJ00, CZSJ01); create index IDX_YS_SPCZRZ_RGH on SD_MZ.YS_SPCZRZ (SPRGH0); create synonym YS_SPCZRZ for SD_MZ.YS_SPCZRZ; create sequence SD_MZ.SQ_YS_SPCZRZ_ID0000 start with 1 increment by 1 maxvalue 9999999999 cycle nocache; --## 2025.10.10 wjl 新增 病历修改申请记录 for MZYS9-20250911-002 create table SD_MZ.YS_BLSQJL ( ID0000 number(10) primary key , --id流水号 GHID00 number(10) not null , --挂号ID WSID00 number(10) null , --文书ID ZS_BLWS00.WSID00, 如果是合并打印，值为空 WSMC00 varchar2(60) null , --文书名称 ZS_BLWS00.WSMC00, 如果是合并打印，值为门诊记录 SQKS00 number(5) not null , --申请科室编号 BM_BMBM00.BMBH00 SQYS00 number(5) not null , --申请医生编号 BM_YGBM00.YGBH00 SQRQ00 char(8) not null , --申请日期 SQSJ00 char(8) not null , --申请时间 SQYY00 varchar2(50) null , --申请原因 DQZT00 char(1) default '0' not null , --当前状态 0:申请 1：驳回 2：通过 SHR000 number(5) null , --审核人 SHRQ00 char(8) null , --审核日期 SHSJ00 char(8) null , --审核时间 SHYY00 varchar2(50) null --审核原因 ); create sequence SQ_YS_BLSQJL_ID0000 increment by 1 start with 1 maxvalue 9999999999 minvalue 1 cycle nocache; create synonym YS_BLSQJL for SD_MZ.YS_BLSQJL; comment on table SD_MZ.YS_BLSQJL is '病历修改申请记录'; comment on column SD_MZ.YS_BLSQJL.GHID00 is '挂号ID'; comment on column SD_MZ.YS_BLSQJL.WSID00 is '文书IDZS_BLWS00.WSID00,如果是合并打印，值为空'; comment on column SD_MZ.YS_BLSQJL.WSMC00 is '文书名称ZS_BLWS00.WSMC00,如果是合并打印，值为门诊记录'; comment on column SD_MZ.YS_BLSQJL.SQKS00 is '申请科室编号 BM_BMBM00.BMBH00'; comment on column SD_MZ.YS_BLSQJL.SQYS00 is '申请医生编号 BM_YGBM00.YGBH00'; comment on column SD_MZ.YS_BLSQJL.SQRQ00 is '申请日期'; comment on column SD_MZ.YS_BLSQJL.SQSJ00 is '申请时间'; comment on column SD_MZ.YS_BLSQJL.SQYY00 is '申请原因'; comment on column SD_MZ.YS_BLSQJL.DQZT00 is '当前状态 0:申请 1：驳回 2：通过'; comment on column SD_MZ.YS_BLSQJL.SHR000 is '审核人'; comment on column SD_MZ.YS_BLSQJL.SHRQ00 is '审核日期'; comment on column SD_MZ.YS_BLSQJL.SHSJ00 is '审核时间'; comment on column SD_MZ.YS_BLSQJL.SHYY00 is '审核原因';