```sql
alter table ysh_yj_req add sample_check_staff varchar(32),sample_check_time datetime
```
```sql
-- 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


```

```sql

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

```