web_server/update/2025-10-28.md

-- auto-generated definition
create table hi_frontsheet_upload_record
(
    id             varchar(32)                   not null
        constraint hi_frontsheet_upload_record_pk
            primary key,
    pat_no         varchar(16)                   not null,
    times          smallint                      not null,
    result_code    int                           not null,
    result_message nvarchar(500),
    upload_staff   varchar(12) default '99999'   not null,
    upload_time    datetime    default getdate() not null
)
go

exec sp_addextendedproperty 'MS_Description', N'住院号', 'SCHEMA', 'dbo', 'TABLE', 'hi_frontsheet_upload_record', 'COLUMN',
     'pat_no'
go

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

exec sp_addextendedproperty 'MS_Description', N'上传结果（200-成功，其他-失败）', 'SCHEMA', 'dbo', 'TABLE',
     'hi_frontsheet_upload_record', 'COLUMN', 'result_code'
go

exec sp_addextendedproperty 'MS_Description', N'上传结果描述', 'SCHEMA', 'dbo', 'TABLE', 'hi_frontsheet_upload_record',
     'COLUMN', 'result_message'
go

exec sp_addextendedproperty 'MS_Description', N'上传人', 'SCHEMA', 'dbo', 'TABLE', 'hi_frontsheet_upload_record', 'COLUMN',
     'upload_staff'
go

exec sp_addextendedproperty 'MS_Description', N'上传时间', 'SCHEMA', 'dbo', 'TABLE', 'hi_frontsheet_upload_record', 'COLUMN',
     'upload_time'
go

create index hi_frontsheet_upload_record_pat_no_index
    on hi_frontsheet_upload_record (pat_no)
go

create index hi_frontsheet_upload_record_times_index
    on hi_frontsheet_upload_record (times)
go

-- auto-generated definition
create table hi_emr_upload_record
(
    id             varchar(32)                   not null
        constraint hi_emr_upload_record_pk
            primary key,
    pat_no         varchar(16)                   not null,
    times          smallint                      not null,
    result_code    int                           not null,
    result_message nvarchar(500),
    upload_staff   varchar(12) default '99999'   not null,
    upload_time    datetime    default getdate() not null
)
go

exec sp_addextendedproperty 'MS_Description', N'住院号', 'SCHEMA', 'dbo', 'TABLE', 'hi_emr_upload_record', 'COLUMN',
     'pat_no'
go

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

exec sp_addextendedproperty 'MS_Description', N'上传结果（200-成功，其他-失败）', 'SCHEMA', 'dbo', 'TABLE',
     'hi_emr_upload_record', 'COLUMN', 'result_code'
go

exec sp_addextendedproperty 'MS_Description', N'上传结果描述', 'SCHEMA', 'dbo', 'TABLE', 'hi_emr_upload_record',
     'COLUMN', 'result_message'
go

exec sp_addextendedproperty 'MS_Description', N'上传人', 'SCHEMA', 'dbo', 'TABLE', 'hi_emr_upload_record', 'COLUMN',
     'upload_staff'
go

exec sp_addextendedproperty 'MS_Description', N'上传时间', 'SCHEMA', 'dbo', 'TABLE', 'hi_emr_upload_record', 'COLUMN',
     'upload_time'
go

create index hi_emr_upload_record_pat_no_index
    on hi_emr_upload_record (pat_no)
go

create index hi_emr_upload_record_times_index
    on hi_emr_upload_record (times)
go