alter table yz_act_occ add execute_ca_sign_id varchar(32)
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
