alter table yz_act_occ add
execute_staff varchar(16),execute_time datetime,
prepare_staff varchar(16),prepare_time datetime
-- auto-generated definition
create table inspection_company
(
id varchar(32) not null
constraint inspection_company_pk
primary key,
pat_no varchar(32) not null,
times smallint not null,
name nvarchar(32) not null,
company_staff varchar(16) not null,
company_staff_name nvarchar(32) not null ,
company_time datetime not null,
dept_code varchar(32),
dept_name nvarchar(32),
company_item varchar(32),
company_item_name nvarchar(128),
create_time datetime not null default getdate()
)
go
exec sp_addextendedproperty 'MS_Description', N'患者陪检', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company'
go
exec sp_addextendedproperty 'MS_Description', N'住院号', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company', 'COLUMN',
'pat_no'
go
exec sp_addextendedproperty 'MS_Description', N'住院次数', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company', 'COLUMN',
'times'
go
exec sp_addextendedproperty 'MS_Description', N'患者姓名', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company', 'COLUMN',
'name'
go
exec sp_addextendedproperty 'MS_Description', N'陪检员工编码', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company', 'COLUMN',
'company_staff'
go
exec sp_addextendedproperty 'MS_Description', N'陪检员工姓名', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company', 'COLUMN',
'company_staff_name'
go
exec sp_addextendedproperty 'MS_Description', N'陪检时间', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company', 'COLUMN',
'company_time'
go
exec sp_addextendedproperty 'MS_Description', N'陪检科室', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company', 'COLUMN',
'dept_code'
go
exec sp_addextendedproperty 'MS_Description', N'陪检科室名称', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company', 'COLUMN',
'dept_name'
go
exec sp_addextendedproperty 'MS_Description', N'陪检项目', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company', 'COLUMN',
'company_item'
go
exec sp_addextendedproperty 'MS_Description', N'陪检项目名称', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company', 'COLUMN',
'company_item_name'
go
exec sp_addextendedproperty 'MS_Description', N'记录创建时间', 'SCHEMA', 'dbo', 'TABLE', 'inspection_company', 'COLUMN',
'create_time'
go
create index inspection_company_pat_no_index
on inspection_company (pat_no)
go
create index inspection_company_times_index
on inspection_company (times)
go
create index inspection_company_company_staff_index
on inspection_company (company_staff)
go
create index inspection_company_company_time_index
on inspection_company (company_time)
go
