alter table yz_act_occ
add execute_ca_sign_id varchar(32)
exec sp_addextendedproperty 'MS_Description', N'对应 ca_sign_log 的id', 'SCHEMA', 'dbo', 'TABLE', 'yz_act_occ',
'COLUMN',
'execute_ca_sign_id'
go
create table t_nurse_printer
(
id varchar(32) not null
constraint t_nurse_printer_pk
primary key,
ip_address varchar(32) not null,
bottle_card varchar(64),
infusion_card varchar(64),
spare_column_1 varchar(64),
spare_column_2 varchar(64),
spare_column_3 varchar(64),
spare_column_4 varchar(64),
spare_column_5 varchar(64),
spare_column_6 varchar(64),
spare_column_7 varchar(64),
spare_column_8 varchar(64),
spare_column_9 varchar(64),
spare_column_10 varchar(64),
spare_column_11 varchar(64),
spare_column_12 varchar(64),
creator varchar(12) not null,
create_time datetime not null default getdate(),
modifier varchar(12),
modify_time datetime
)
go
exec sp_addextendedproperty 'MS_Description', N'护士站打印机设置', 'SCHEMA', 'dbo', 'TABLE', 't_nurse_printer'
go
exec sp_addextendedproperty 'MS_Description', N'护士站电脑IP', 'SCHEMA', 'dbo', 'TABLE', 't_nurse_printer', 'COLUMN',
'ip_address'
go
exec sp_addextendedproperty 'MS_Description', N'瓶贴打印机', 'SCHEMA', 'dbo', 'TABLE', 't_nurse_printer', 'COLUMN',
'bottle_card'
go
exec sp_addextendedproperty 'MS_Description', N'输液卡打印机', 'SCHEMA', 'dbo', 'TABLE', 't_nurse_printer', 'COLUMN',
'infusion_card'
go
create index t_nurse_printer_ip_address_index
on t_nurse_printer (ip_address)
go
create index t_nurse_printer_creator_index
on t_nurse_printer (creator)
go
alter table zy_bed_mi
add electronic_screen varchar(10)
go
exec sp_addextendedproperty 'MS_Description', N'患者旁边的电子屏幕', 'SCHEMA', 'dbo', 'TABLE', 'zy_bed_mi', 'COLUMN',
'electronic_screen'
go
