--## 2024.03.25 liyanni 输血疗效评价回写 --PROMPT 输血疗效评价回写 create table SD_ZS.ZS_SXLXPJ ( ID0000 number(16) primary key , --主键ID SQ_ZS_SXLXPJ_ID0000 ZYID00 number(10) not null , --zyid00 ZYH000 varchar2(20) not null , --住院号 BRXM00 varchar2(50) not null , --病人姓名(ZY_BRXXB0.XM0000) XYCFSL varchar2(200) null , --患者输血的血液成分及量 XHJYZB varchar2(200) null , --输血后复查的检验指标 SXXGPJ varchar2(200) null , --输血效果评价 SXKSSJ char(17) null , --输血开始时间 CZRQ00 char(8) null , --回写日期 CZSJ00 char(8) null --回写时间 ); create synonym ZS_SXLXPJ for SD_ZS.ZS_SXLXPJ; create sequence SQ_ZS_SXLXPJ_ID0000 increment by 1 start with 1 maxvalue 999999999999 minvalue 1 cycle nocache; -- Add comments to the table comment on table SD_ZS.ZS_SXLXPJ is '输血系统_输血疗效评价回写表'; -- Add comments to the columns comment on column SD_ZS.ZS_SXLXPJ.ID0000 is 'ID(SQ_ZS_SXLXPJ_ID0000)'; comment on column SD_ZS.ZS_SXLXPJ.ZYID00 is 'zyid00'; comment on column SD_ZS.ZS_SXLXPJ.ZYH000 is '住院号'; comment on column SD_ZS.ZS_SXLXPJ.BRXM00 is '病人姓名(ZY_BRXXB0.XM0000)'; comment on column SD_ZS.ZS_SXLXPJ.XYCFSL is '患者输血的血液成分及量'; comment on column SD_ZS.ZS_SXLXPJ.XHJYZB is '输血后复查的检验指标'; comment on column SD_ZS.ZS_SXLXPJ.SXXGPJ is '输血效果评价'; comment on column SD_ZS.ZS_SXLXPJ.SXKSSJ is '输血开始时间'; comment on column SD_ZS.ZS_SXLXPJ.CZRQ00 is '回写日期'; comment on column SD_ZS.ZS_SXLXPJ.CZSJ00 is '回写时间'; --## 2024.03.25 liyanni 输血病程记录回写 --PROMPT 输血病程记录回写 create table SD_ZS.ZS_SXBCJL ( ID0000 number(16) primary key , --主键ID SQ_ZS_SXLXPJ_ID0000 ZYID00 number(10) not null , --zyid00 ZYH000 varchar2(12) not null , --住院号 WSID00 number(10) not null , --ZS_BLWS00.WSID00 CZRQ00 char(8) null , --回写日期 CZSJ00 char(8) nuLL --回写时间 ); create synonym ZS_SXBCJL for SD_ZS.ZS_SXBCJL; create sequence SQ_ZS_SXBCJL_ID0000 increment by 1 start with 1 maxvalue 999999999999 minvalue 1 cycle nocache; create index INDEX_ZS_SXBCJL_ZYID00 on SD_ZS.ZS_SXBCJL(ZYID00) tablespace ts_yy_index; -- Add comments to the table comment on table SD_ZS.ZS_SXBCJL is '输血系统_输血病程记录回写表'; -- Add comments to the columns comment on column SD_ZS.ZS_SXBCJL.ID0000 is 'ID(SQ_ZS_SXBCJL_ID0000)'; comment on column SD_ZS.ZS_SXBCJL.ZYID00 is 'zyid00'; comment on column SD_ZS.ZS_SXBCJL.ZYH000 is '住院号'; comment on column SD_ZS.WSID00.WSID00 is '病程记录WSID00'; comment on column SD_ZS.ZS_SXBCJL.CZRQ00 is '回写日期'; comment on column SD_ZS.ZS_SXBCJL.CZSJ00 is '回写时间'; --## 2024.03.25 liyanni 输血前评估回写 --PROMPT 输血前评估回写 create table SD_ZS.ZS_SXQPG0 ( ID0000 NUMBER(16) primary key , --主键ID SQ_ZS_SXLXPJ_ID0000 ZYID00 number(10) not null , --zyid00 ZYH000 varchar2(12) not null , --住院号 zxjyjg varchar2(500) null , --患者最新检验结果（血常规中红细胞计数、血红蛋白值、红细胞压积、血小板计数。凝血功能检查中PT、APTT、fib等） sxmd00 varchar2(500) null , --输血目的 hlly00 varchar2(500) null , --合理理由 xycfsl varchar2(500) null , --申请的血液成分及量 czrq00 char(8) null , --回写日期 czsj00 char(8) nuLL --回写时间 ); create synonym ZS_SXQPG0 for SD_ZS.ZS_SXQPG0; create SEQUENCE SQ_ZS_SXQPG0_ID0000 increment by 1 start with 1 maxvalue 999999999999 minvalue 1 cycle nocache; create index INDEX_ZS_SXQPG0_ZYID00 on SD_ZS.ZS_SXQPG0(ZYID00) tablespace ts_yy_index; -- Add comments to the table comment on table SD_ZS.ZS_SXQPG0 is '输血系统_输血前评估回写表'; -- Add comments to the columns comment on column SD_ZS.ZS_SXQPG0.ID0000 is 'ID(SQ_ZS_SXQPG0_ID0000)'; comment on column SD_ZS.ZS_SXQPG0.ZYID00 is 'zyid00'; comment on column SD_ZS.ZS_SXQPG0.BRXM00 is '病人姓名(ZY_BRXXB0.XM0000)'; comment on column SD_ZS.ZS_SXQPG0.ZXJYJG is '患者最新检验结果（血常规中红细胞计数、血红蛋白值、红细胞压积、血小板计数。凝血功能检查中PT、APTT、fib等）'; comment on column SD_ZS.ZS_SXQPG0.SXMD00 is '输血目的'; comment on column SD_ZS.ZS_SXQPG0.HLLY00 is '合理理由'; comment on column SD_ZS.ZS_SXQPG0.XYCFSL is '申请的血液成分及量'; comment on column SD_ZS.ZS_SXQPG0.CZRQ00 is '回写日期'; comment on column SD_ZS.ZS_SXQPG0.CZSJ00 is '回写时间';