2025-07-11.md 1.3 KB

-- 修改门诊电子病历表
alter table mz_emr_patient_data
    drop column refer_physician
go

alter table mz_emr_patient_data
    drop column consult_physician
go

alter table mz_emr_patient_data
    drop column dept_director
go

alter table mz_emr_patient_data
    drop column submit_id
go

alter table mz_emr_patient_data
    drop column review_doctors
go

alter table mz_emr_patient_data
    drop column review_time
go

alter table mz_emr_patient_data
    drop column submit_time
go

alter table mz_emr_patient_data
    drop constraint DF__mz_emr_pa__submi__78A1D894
go

alter table mz_emr_patient_data
    drop column submit
go

-- 新增打印标志
alter table mz_emr_patient_data
    add emr_print int default 0 not null
go

exec sp_addextendedproperty 'MS_Description', '门诊电子病历是否打印', 'SCHEMA', 'dbo', 'TABLE', 'mz_emr_patient_data',
     'COLUMN',
     'emr_print'
go


alter table mz_emr_patient_data
    add sign_complete bit default 0 not null
go

exec sp_addextendedproperty 'MS_Description', N'签名是否完成', 'SCHEMA', 'dbo', 'TABLE', 'mz_emr_patient_data',
     'COLUMN', 'sign_complete'
go

alter table mz_emr_patient_data
    add emr_data_element text
go

exec sp_addextendedproperty 'MS_Description', N'患者的数据源', 'SCHEMA', 'dbo', 'TABLE', 'mz_emr_patient_data',
     'COLUMN', 'emr_data_element'
go