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
