648 lines
20 KiB
Plaintext
648 lines
20 KiB
Plaintext
ts_kh xsczy这个列的类型长度不够， 改为varchar(20)
|
||
ts_khlxr xsczy这个列的类型长度不够， 改为varchar(20)
|
||
ts_dd xsczy 这个列的类型长度不够， 改为varchar(20)
|
||
ts_dd xsshczy这个列的类型长度不够， 改为varchar(20)
|
||
ts_dd cwshczy这个列的类型长度不够， 改为varchar(20)
|
||
--套餐加分店代码
|
||
alter table t_tc add fddm smallint
|
||
|
||
--俊强 2015/7/13 9:11:12
|
||
|
||
--修改套餐名称varcha(50)
|
||
alter table t_tc ALTER column tcmc varchar(50)
|
||
|
||
|
||
--修改t_ks加入分店代码
|
||
|
||
alter table t_ks add fddm int
|
||
|
||
--添加lis对照列
|
||
alter table t_jcxm add lis varchar(50)
|
||
--添加化验大类
|
||
alter table t_zhxm add jydl int
|
||
|
||
|
||
--lis大类表
|
||
USE [bodycheck]
|
||
GO
|
||
/****** Object: Table [dbo].[lis_jydl] Script Date: 08/25/2015 22:28:51 ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
SET ANSI_PADDING ON
|
||
GO
|
||
CREATE TABLE [dbo].[lis_jydl](
|
||
[id] [int] NOT NULL,
|
||
[lisdl] [varchar](50) NULL,
|
||
CONSTRAINT [PK_lis] PRIMARY KEY CLUSTERED
|
||
(
|
||
[id] ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
||
) ON [PRIMARY]
|
||
GO
|
||
SET ANSI_PADDING OFF
|
||
GO
|
||
SET IDENTITY_INSERT [dbo].[lis_jydl] ON
|
||
INSERT [dbo].[lis_jydl] ([id], [lisdl]) VALUES (3, N'CRP')
|
||
INSERT [dbo].[lis_jydl] ([id], [lisdl]) VALUES (4, N'PCR')
|
||
INSERT [dbo].[lis_jydl] ([id], [lisdl]) VALUES (5, N'电解质')
|
||
INSERT [dbo].[lis_jydl] ([id], [lisdl]) VALUES (6, N'化学发光')
|
||
INSERT [dbo].[lis_jydl] ([id], [lisdl]) VALUES (7, N'酶标仪')
|
||
INSERT [dbo].[lis_jydl] ([id], [lisdl]) VALUES (8, N'酶免仪')
|
||
INSERT [dbo].[lis_jydl] ([id], [lisdl]) VALUES (9, N'尿沉渣')
|
||
INSERT [dbo].[lis_jydl] ([id], [lisdl]) VALUES (10, N'尿分仪')
|
||
INSERT [dbo].[lis_jydl] ([id], [lisdl]) VALUES (11, N'其他')
|
||
INSERT [dbo].[lis_jydl] ([id], [lisdl]) VALUES (12, N'生化仪')
|
||
INSERT [dbo].[lis_jydl] ([id], [lisdl]) VALUES (13, N'糖化血红蛋')
|
||
INSERT [dbo].[lis_jydl] ([id], [lisdl]) VALUES (14, N'特定蛋白')
|
||
INSERT [dbo].[lis_jydl] ([id], [lisdl]) VALUES (15, N'文字报告')
|
||
INSERT [dbo].[lis_jydl] ([id], [lisdl]) VALUES (16, N'细菌仪')
|
||
INSERT [dbo].[lis_jydl] ([id], [lisdl]) VALUES (17, N'血流变')
|
||
INSERT [dbo].[lis_jydl] ([id], [lisdl]) VALUES (18, N'血凝仪')
|
||
INSERT [dbo].[lis_jydl] ([id], [lisdl]) VALUES (19, N'血气仪')
|
||
INSERT [dbo].[lis_jydl] ([id], [lisdl]) VALUES (20, N'血球仪')
|
||
SET IDENTITY_INSERT [dbo].[lis_jydl] OFF
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
if exists (select * from dbo.sysobjects where id = object_id(N'jy_yhxx') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
|
||
drop table jy_yhxx
|
||
go
|
||
|
||
create table jy_yhxx (
|
||
jytm VARCHAR(20) NOT NULL ,
|
||
tm INT NULL ,
|
||
xm VARCHAR(10) NULL ,
|
||
xb VARCHAR(4) NULL ,
|
||
cxsj DATETIME NULL ,
|
||
cxyy VARCHAR(20) NULL ,
|
||
shsj DATETIME NULL ,
|
||
shyy VARCHAR(20) NULL ,
|
||
nl INT NULL ,
|
||
state TINYINT NULL ,
|
||
csrq DATETIME NULL ,
|
||
yqbh VARCHAR(20) NULL ,
|
||
bbh VARCHAR(20) NULL ,
|
||
jyrq DATETIME NULL
|
||
)
|
||
go
|
||
|
||
alter table jy_yhxx add
|
||
CONSTRAINT pk_jy_yhxx PRIMARY KEY CLUSTERED
|
||
(
|
||
jytm
|
||
)
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'检验用户信息'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yhxx', NULL, NULL
|
||
go
|
||
|
||
DECLARE @v sql_variant
|
||
SET @v = N'检验条码'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yhxx', N'column', N'jytm'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'条码'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yhxx', N'column', N'tm'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'姓名'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yhxx', N'column', N'xm'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'性别'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yhxx', N'column', N'xb'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'抽血时间'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yhxx', N'column', N'cxsj'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'抽血医生'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yhxx', N'column', N'cxyy'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'审核时间'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yhxx', N'column', N'shsj'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'审核医生'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yhxx', N'column', N'shyy'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'年龄'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yhxx', N'column', N'nl'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'状态'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yhxx', N'column', N'state'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'出生日期'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yhxx', N'column', N'csrq'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'仪器编号'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yhxx', N'column', N'yqbh'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'标本号'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yhxx', N'column', N'bbh'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'检验日期'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yhxx', N'column', N'jyrq'
|
||
go
|
||
|
||
|
||
|
||
|
||
|
||
if exists (select * from dbo.sysobjects where id = object_id(N'jy_yssj') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
|
||
drop table jy_yssj
|
||
go
|
||
|
||
create table jy_yssj (
|
||
yqbh VARCHAR(20) NULL ,
|
||
jysj DATETIME NULL ,
|
||
jssj DATETIME NULL ,
|
||
tdh VARCHAR(20) NULL ,
|
||
bbh VARCHAR(20) NULL ,
|
||
jg VARCHAR(20) NULL ,
|
||
xm VARCHAR(20) NULL
|
||
)
|
||
go
|
||
|
||
DECLARE @v sql_variant
|
||
SET @v = N'检验原始数据'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yssj', NULL, NULL
|
||
go
|
||
|
||
DECLARE @v sql_variant
|
||
SET @v = N'仪器编号'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yssj', N'column', N'yqbh'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'检验日期'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yssj', N'column', N'jysj'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'接收时间'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yssj', N'column', N'jssj'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'标本号'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yssj', N'column', N'tdh'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'通道号'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yssj', N'column', N'bbh'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'结果'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yssj', N'column', N'jg'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'项目编码'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yssj', N'column', N'xm'
|
||
go
|
||
|
||
|
||
|
||
|
||
|
||
|
||
if exists (select * from dbo.sysobjects where id = object_id(N'jy_sqd_jg') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
|
||
drop table jy_sqd_jg
|
||
go
|
||
|
||
create table jy_sqd_jg (
|
||
jytm VARCHAR(20) NOT NULL ,
|
||
xh INT NOT NULL ,
|
||
xmbm VARCHAR(10) NULL ,
|
||
xmmc VARCHAR(20) NULL ,
|
||
jg VARCHAR(10) NULL ,
|
||
flag VARCHAR(6) NULL ,
|
||
dw VARCHAR(10) NULL ,
|
||
ckss VARCHAR(10) NULL ,
|
||
ckxx VARCHAR(10) NULL ,
|
||
yqbh VARCHAR(20) NULL ,
|
||
bbh NVARCHAR(128) NULL ,
|
||
bgrq DATETIME NULL ,
|
||
state TINYINT NULL ,
|
||
gxsj DECIMAL(18,4) NULL ,
|
||
shsj DATETIME NULL ,
|
||
shyy VARCHAR(20) NULL ,
|
||
bgsj DATETIME NULL ,
|
||
bgys VARCHAR(20) NULL
|
||
)
|
||
go
|
||
|
||
alter table jy_sqd_jg add
|
||
CONSTRAINT pk_jy_sqd_jg PRIMARY KEY CLUSTERED
|
||
(
|
||
jytm,
|
||
xh
|
||
)
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'检验申请单结果'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_jg', NULL, NULL
|
||
go
|
||
|
||
DECLARE @v sql_variant
|
||
SET @v = N'条码号'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_jg', N'column', N'jytm'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'序号'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_jg', N'column', N'xh'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'项目编号'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_jg', N'column', N'xmbm'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'项目名称'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_jg', N'column', N'xmmc'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'结果'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_jg', N'column', N'jg'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'状态'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_jg', N'column', N'flag'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'单位'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_jg', N'column', N'dw'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'参考上限'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_jg', N'column', N'ckss'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'参考下限'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_jg', N'column', N'ckxx'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'仪器编号'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_jg', N'column', N'yqbh'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'标本号'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_jg', N'column', N'bbh'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'报告日期'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_jg', N'column', N'bgrq'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'状态'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_jg', N'column', N'state'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'更新时间'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_jg', N'column', N'gxsj'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'审核时间'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_jg', N'column', N'shsj'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'审核医生'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_jg', N'column', N'shyy'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'报告时间'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_jg', N'column', N'bgsj'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'报告医生'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_jg', N'column', N'bgys'
|
||
go
|
||
|
||
|
||
|
||
|
||
|
||
if exists (select * from dbo.sysobjects where id = object_id(N'jy_sqd_mx') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
|
||
drop table jy_sqd_mx
|
||
go
|
||
|
||
create table jy_sqd_mx (
|
||
jytm NVARCHAR(128) NOT NULL ,
|
||
jyxh INT NOT NULL ,
|
||
zhxmbm INT NULL ,
|
||
zhxmmc VARCHAR(50) NULL
|
||
)
|
||
go
|
||
|
||
alter table jy_sqd_mx add
|
||
CONSTRAINT pk_jy_sqd_mx PRIMARY KEY CLUSTERED
|
||
(
|
||
jytm,
|
||
jyxh
|
||
)
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'检验申请单明细'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_mx', NULL, NULL
|
||
go
|
||
|
||
DECLARE @v sql_variant
|
||
SET @v = N'检验条码'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_mx', N'column', N'jytm'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'检验序号'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_mx', N'column', N'jyxh'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'组合项目编码'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_mx', N'column', N'zhxmbm'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'组合项目名称'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd_mx', N'column', N'zhxmmc'
|
||
go
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
if exists (select * from dbo.sysobjects where id = object_id(N'jy_sqd') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
|
||
drop table jy_sqd
|
||
go
|
||
|
||
create table jy_sqd (
|
||
jytm VARCHAR(20) NOT NULL ,
|
||
tm INT NULL ,
|
||
xm VARCHAR(10) NULL ,
|
||
xb VARCHAR(4) NULL ,
|
||
cxsj DATETIME NULL ,
|
||
cxyy VARCHAR(20) NULL ,
|
||
shsj DATETIME NULL ,
|
||
shyy VARCHAR(20) NULL ,
|
||
nl INT NULL ,
|
||
state TINYINT NULL ,
|
||
csrq DATETIME NULL
|
||
)
|
||
go
|
||
|
||
alter table jy_sqd add
|
||
CONSTRAINT pk_jy_sqd PRIMARY KEY CLUSTERED
|
||
(
|
||
jytm
|
||
)
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'检验申请单'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd', NULL, NULL
|
||
go
|
||
|
||
DECLARE @v sql_variant
|
||
SET @v = N'检验条码'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd', N'column', N'jytm'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'条码'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd', N'column', N'tm'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'姓名'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd', N'column', N'xm'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'性别'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd', N'column', N'xb'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'抽血时间'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd', N'column', N'cxsj'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'抽血医生'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd', N'column', N'cxyy'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'审核时间'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd', N'column', N'shsj'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'审核医生'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd', N'column', N'shyy'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'年龄'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd', N'column', N'nl'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'状态'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd', N'column', N'state'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'出生日期'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_sqd', N'column', N'csrq'
|
||
go
|
||
|
||
|
||
|
||
|
||
if exists (select * from dbo.sysobjects where id = object_id(N'jy_yiqi') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
|
||
drop table jy_yiqi
|
||
go
|
||
|
||
create table jy_yiqi (
|
||
yq VARCHAR(50) NOT NULL ,
|
||
yqmc VARCHAR(50) NULL ,
|
||
yqlb INT NULL ,
|
||
dnname VARCHAR(50) NULL ,
|
||
azrq DATETIME NULL ,
|
||
yqxh VARCHAR(50) NULL ,
|
||
zhuxiao SMALLINT NULL
|
||
)
|
||
go
|
||
|
||
alter table jy_yiqi add
|
||
CONSTRAINT pk_jy_yiqi PRIMARY KEY CLUSTERED
|
||
(
|
||
yq
|
||
)
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'检验仪器'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi', NULL, NULL
|
||
go
|
||
|
||
DECLARE @v sql_variant
|
||
SET @v = N'仪器编码'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi', N'column', N'yq'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'仪器名称'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi', N'column', N'yqmc'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'仪器类别'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi', N'column', N'yqlb'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'仪器安装电脑名称'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi', N'column', N'dnname'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'安装日期'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi', N'column', N'azrq'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'仪器型号'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi', N'column', N'yqxh'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'注销状态'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi', N'column', N'zhuxiao'
|
||
go
|
||
|
||
|
||
|
||
|
||
if exists (select * from dbo.sysobjects where id = object_id(N'jy_yiqi_xm') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
|
||
drop table jy_yiqi_xm
|
||
go
|
||
|
||
create table jy_yiqi_xm (
|
||
yq VARCHAR(50) NULL ,
|
||
tdh VARCHAR(50) NULL ,
|
||
xmdm VARCHAR(50) NULL ,
|
||
xmmc VARCHAR(50) NULL ,
|
||
cksx VARCHAR(50) NULL ,
|
||
ckxx VARCHAR(50) NULL ,
|
||
dyckz VARCHAR(50) NULL ,
|
||
dysx INT NULL ,
|
||
dw VARCHAR(50) NULL
|
||
)
|
||
go
|
||
|
||
DECLARE @v sql_variant
|
||
SET @v = N'仪器项目'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi_xm', NULL, NULL
|
||
go
|
||
|
||
DECLARE @v sql_variant
|
||
SET @v = N'仪器编码'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi_xm', N'column', N'yq'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'通道号'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi_xm', N'column', N'tdh'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'项目代号'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi_xm', N'column', N'xmdm'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'项目名称'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi_xm', N'column', N'xmmc'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'参考上线'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi_xm', N'column', N'cksx'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'参考下线'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi_xm', N'column', N'ckxx'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'打印参考值'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi_xm', N'column', N'dyckz'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'打印顺序'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi_xm', N'column', N'dysx'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'单位'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi_xm', N'column', N'dw'
|
||
go
|
||
|
||
|
||
|
||
if exists (select * from dbo.sysobjects where id = object_id(N'jy_yiqi_xm_calc') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
|
||
drop table jy_yiqi_xm_calc
|
||
go
|
||
|
||
create table jy_yiqi_xm_calc (
|
||
yq VARCHAR(50) NULL ,
|
||
jsxm VARCHAR(50) NULL ,
|
||
jsgs VARCHAR(100) NULL ,
|
||
xmmc VARCHAR(50) NULL ,
|
||
bz VARCHAR(128) NULL ,
|
||
cksx VARCHAR(50) NULL ,
|
||
ckxx VARCHAR(50) NULL ,
|
||
dyckz VARCHAR(50) NULL ,
|
||
dysx INT NULL ,
|
||
dw VARCHAR(50) NULL
|
||
)
|
||
go
|
||
|
||
DECLARE @v sql_variant
|
||
SET @v = N'自动计算项目'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi_xm_calc', NULL, NULL
|
||
go
|
||
|
||
DECLARE @v sql_variant
|
||
SET @v = N'仪器编号'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi_xm_calc', N'column', N'yq'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'计算项目'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi_xm_calc', N'column', N'jsxm'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'计算公式'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi_xm_calc', N'column', N'jsgs'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'项目名称'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi_xm_calc', N'column', N'xmmc'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'备注'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi_xm_calc', N'column', N'bz'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'参考上线'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi_xm_calc', N'column', N'cksx'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'参考下线'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi_xm_calc', N'column', N'ckxx'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'打印参考值'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi_xm_calc', N'column', N'dyckz'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'打印顺序'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi_xm_calc', N'column', N'dysx'
|
||
go
|
||
DECLARE @v sql_variant
|
||
SET @v = N'单位'
|
||
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'table', N'jy_yiqi_xm_calc', N'column', N'dw'
|
||
go
|
||
|
||
|
||
|
||
|