web_server/update/2025-10-21.md

alter table yz_act_occ add 
    execute_staff varchar(16),execute_time datetime,
    prepare_staff varchar(16),prepare_time datetime

-- auto-generated definition
create table inspection_company
(
    id                varchar(32)  not null
        constraint inspection_company_pk
            primary key,
    pat_no            varchar(32)  not null,
    times             smallint     not null,
    name              nvarchar(32) not null,
    company_staff     varchar(16)   not null,
    company_staff_name nvarchar(32) not null ,
    company_time      datetime     not null,
    dept_code         varchar(32),
    dept_name         nvarchar(32),
    company_item      varchar(32),
    company_item_name nvarchar(128),
    create_time datetime not null default getdate()
)
go

exec sp_addextendedproperty 'MS_Description', N'患者陪检', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company'
go

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

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

exec sp_addextendedproperty 'MS_Description', N'患者姓名', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company', 'COLUMN',
     'name'
go

exec sp_addextendedproperty 'MS_Description', N'陪检员工编码', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company', 'COLUMN',
     'company_staff'
go

exec sp_addextendedproperty 'MS_Description', N'陪检员工姓名', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company', 'COLUMN',
     'company_staff_name'
go

exec sp_addextendedproperty 'MS_Description', N'陪检时间', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company', 'COLUMN',
     'company_time'
go

exec sp_addextendedproperty 'MS_Description', N'陪检科室', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company', 'COLUMN',
     'dept_code'
go

exec sp_addextendedproperty 'MS_Description', N'陪检科室名称', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company', 'COLUMN',
     'dept_name'
go

exec sp_addextendedproperty 'MS_Description', N'陪检项目', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company', 'COLUMN',
     'company_item'
go

exec sp_addextendedproperty 'MS_Description', N'陪检项目名称', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company', 'COLUMN',
     'company_item_name'
go

exec sp_addextendedproperty 'MS_Description', N'记录创建时间', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company', 'COLUMN',
     'create_time'
go

create index inspection_company_pat_no_index
    on inspection_company (pat_no)
go

create index inspection_company_times_index
    on inspection_company (times)
go

create index inspection_company_company_staff_index
    on inspection_company (company_staff)
go

create index inspection_company_company_time_index
    on inspection_company (company_time)
go