alter table ysh_yj_req add sample_check_staff varchar(32),sample_check_time datetime
-- auto-generated definition
create table ward_rounds
(
id varchar(32) not null
constraint ward_rounds_pk
primary key,
room_no varchar(32),
ward_code varchar(32) not null,
ward_name nvarchar(32) not null,
bed_no varchar(16) not null,
round_content nvarchar(512) not null,
staff_id varchar(32) not null,
staff_name nvarchar(32) not null,
create_time datetime default getdate() not null
)
go
exec sp_addextendedproperty 'MS_Description', N'病房巡查', 'SCHEMA', 'dbo', 'TABLE', 'ward_rounds'
go
exec sp_addextendedproperty 'MS_Description', N'病房二维码内容', 'SCHEMA', 'dbo', 'TABLE', 'ward_rounds', 'COLUMN',
'room_no'
go
exec sp_addextendedproperty 'MS_Description', N'病房编码', 'SCHEMA', 'dbo', 'TABLE', 'ward_rounds', 'COLUMN',
'ward_code'
go
exec sp_addextendedproperty 'MS_Description', N'病房名称', 'SCHEMA', 'dbo', 'TABLE', 'ward_rounds', 'COLUMN',
'ward_name'
go
exec sp_addextendedproperty 'MS_Description', N'床位号', 'SCHEMA', 'dbo', 'TABLE', 'ward_rounds', 'COLUMN', 'bed_no'
go
exec sp_addextendedproperty 'MS_Description', N'巡查内容', 'SCHEMA', 'dbo', 'TABLE', 'ward_rounds', 'COLUMN',
'round_content'
go
exec sp_addextendedproperty 'MS_Description', N'巡查人', 'SCHEMA', 'dbo', 'TABLE', 'ward_rounds', 'COLUMN', 'staff_id'
go
exec sp_addextendedproperty 'MS_Description', N'巡查人姓名', 'SCHEMA', 'dbo', 'TABLE', 'ward_rounds', 'COLUMN',
'staff_name'
go
exec sp_addextendedproperty 'MS_Description', N'巡查时间', 'SCHEMA', 'dbo', 'TABLE', 'ward_rounds', 'COLUMN',
'create_time'
go
create index ward_rounds_room_no_index
on ward_rounds (room_no)
go
-- auto-generated definition
create table patient_health_education_record
(
id varchar(32) not null
constraint patient_health_education_record_pk
primary key,
pat_no varchar(32) not null,
times smallint not null,
pat_name nvarchar(32) not null,
education_code varchar(16) not null,
education_name nvarchar(64) not null,
create_staff varchar(16) not null,
create_staff_name nvarchar(32),
create_time datetime default getdate() not null
)
go
exec sp_addextendedproperty 'MS_Description', N'患者健康教育记录', 'SCHEMA', 'dbo', 'TABLE',
'patient_health_education_record'
go
exec sp_addextendedproperty 'MS_Description', N'住院号', 'SCHEMA', 'dbo', 'TABLE', 'patient_health_education_record',
'COLUMN', 'pat_no'
go
exec sp_addextendedproperty 'MS_Description', N'住院次数', 'SCHEMA', 'dbo', 'TABLE', 'patient_health_education_record',
'COLUMN', 'times'
go
exec sp_addextendedproperty 'MS_Description', N'患者姓名', 'SCHEMA', 'dbo', 'TABLE', 'patient_health_education_record',
'COLUMN', 'pat_name'
go
exec sp_addextendedproperty 'MS_Description', N'健康教育编码', 'SCHEMA', 'dbo', 'TABLE',
'patient_health_education_record', 'COLUMN', 'education_code'
go
exec sp_addextendedproperty 'MS_Description', N'健康教育名称', 'SCHEMA', 'dbo', 'TABLE',
'patient_health_education_record', 'COLUMN', 'education_name'
go
exec sp_addextendedproperty 'MS_Description', N'记录创建人', 'SCHEMA', 'dbo', 'TABLE',
'patient_health_education_record', 'COLUMN', 'create_staff'
go
exec sp_addextendedproperty 'MS_Description', N'记录创建人姓名', 'SCHEMA', 'dbo', 'TABLE',
'patient_health_education_record', 'COLUMN', 'create_staff_name'
go
exec sp_addextendedproperty 'MS_Description', N'记录创建时间', 'SCHEMA', 'dbo', 'TABLE',
'patient_health_education_record', 'COLUMN', 'create_time'
go
create index patient_health_education_record_pat_no_index
on patient_health_education_record (pat_no)
go
create index patient_health_education_record_education_code_index
on patient_health_education_record (education_code)
go
