```sql
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
```

```sql

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

```

```sql
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
```