web_server/update/2025-06-11.md

把update taobao 下面的文件夹放到maven的本地仓库中 路径为 ${你的maven存放位置}/com/tao

新增医生提示表

-- auto-generated definition
create table send_docker_prompt
(
    id          varchar(18)   not null
        constraint send_docker_prompt_pk
            primary key,
    pat_no      varchar(8)    not null,
    times       tinyint       not null,
    prompt      nvarchar(500) not null,
    prompt_time date          not null,
    doctor_code varchar(8)
)
go

exec sp_addextendedproperty 'MS_Description', N'医生消息提示表', 'SCHEMA', 'dbo', 'TABLE', 'send_docker_prompt'
go

exec sp_addextendedproperty 'MS_Description', N'主键', 'SCHEMA', 'dbo', 'TABLE', 'send_docker_prompt', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', N'患者的住院号', 'SCHEMA', 'dbo', 'TABLE', 'send_docker_prompt', 'COLUMN',
     'pat_no'
go

exec sp_addextendedproperty 'MS_Description', N'住院次数', 'SCHEMA', 'dbo', 'TABLE', 'send_docker_prompt', 'COLUMN',
     'times'
go

exec sp_addextendedproperty 'MS_Description', N'提示的东西', 'SCHEMA', 'dbo', 'TABLE', 'send_docker_prompt', 'COLUMN',
     'prompt'
go

exec sp_addextendedproperty 'MS_Description', N'什么时候提示', 'SCHEMA', 'dbo', 'TABLE', 'send_docker_prompt', 'COLUMN',
     'prompt_time'
go

create index send_docker_prompt_pat_no_times_index
    on send_docker_prompt (pat_no, times)
go

create index send_docker_prompt_prompt_time_index
    on send_docker_prompt (prompt_time)
go

医生提示阅读表

-- auto-generated definition
create table send_docker_read
(
    id          varchar(18)                not null
        constraint send_docker_read_pk
            primary key,
    send_id     varchar(18)                not null,
    doctor_code varchar(8)                 not null,
    create_time datetime default getdate() not null
)
go

exec sp_addextendedproperty 'MS_Description', N'医生已经看了那些消息，看了的话就不显示了', 'SCHEMA', 'dbo', 'TABLE',
     'send_docker_read'
go

create index send_docker_read_doctor_code_index
    on send_docker_read (doctor_code)
go

create index send_docker_read_create_time_index
    on send_docker_read (create_time)
go