--## gaoyj 2021.08.30 by 
create table SD_MZ.YS_BRZQTP
(
    ID0000  number(12) not null,         --ID 取SQ_YS_BRZQTP_ID0000.NextVal 
    BRBLH0  char(30) not null,           --病人卡号
    PHOTO0  blob,                        --图片数据(base64串)
    TPLX00  char(1) not null,            --图片类型 0病历 1检查报告 2检验报告
    CZRQ00  char(8),                     --操作日期
    CZSJ00  char(8),                     --操作时间
    CZY000  number(5,0),                 --操作人
    BZ0000  varchar2(200)                --备注
);

alter table SD_MZ.YS_BRZQTP add constraint PK_YS_BRZQTP_ID0000 primary key (ID0000);
    
-- Create synonym YS_BRZQTP
create synonym YS_BRZQTP for SD_MZ.YS_BRZQTP;

-- Indexes for SD_MZ.YS_BRZQTP
create index INDEX_YS_BRZQTP_BRBLH0 on SD_MZ.YS_BRZQTP(BRBLH0);
create index INDEX_YS_BRZQTP_CZRQ00 on SD_MZ.YS_BRZQTP(CZRQ00);

comment on table SD_MZ.YS_BRZQTP is '病人病情图片【门诊医生_门诊医嘱】';
comment on column SD_MZ.YS_BRZQTP.ID0000 is 'ID 取SQ_YS_BRZQTP_ID0000.NextVal';
comment on column SD_MZ.YS_BRZQTP.BRBLH0 is '病人卡号';
comment on column SD_MZ.YS_BRZQTP.PHOTO0 is '图片数据(base64串)';
comment on column SD_MZ.YS_BRZQTP.TPLX00 is '图片类型 0病历 1检查报告 2检验报告';
comment on column SD_MZ.YS_BRZQTP.CZRQ00 is '操作日期';
comment on column SD_MZ.YS_BRZQTP.CZSJ00 is '操作时间';
comment on column SD_MZ.YS_BRZQTP.CZY000 is '操作人';
comment on column SD_MZ.YS_BRZQTP.BZ0000 is '备注';
    
create sequence SQ_YS_BRZQTP_ID0000  increment by 1  start with 1  minvalue 1  maxvalue 999999999999  nocycle noorder cache 20;
commit;
--%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%