仿医院体检表+数据库

USE [Mytest1] GO /****** Object: Table [dbo].[my_yiyuan] Script Date: 04/24/2012 08:07:45 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[my_yiyuan]( [id] [int] IDENTITY(1,1) NOT NULL, [name] [varchar](50) NULL, [sex] [bit] NULL, [brithday] [datetime] NULL, [idcard] [varchar](50) NULL, [ishf] [bit] NULL, [workdw] [varchar](50) NULL, [chushengdi] [varchar](50) NULL, [mingzu] [varchar](50) NULL, [jiwangbingshi] [varchar](50) NULL, [jiazushi] [varchar](50) NULL, [zls] [varchar](50) NULL, [zjx] [varchar](50) NULL, [zjj] [varchar](50) NULL, [yls] [varchar](50) NULL, [yjx] [varchar](50) NULL, [yjj] [varchar](50) NULL, [sejue] [varchar](50) NULL, [ztl] [varchar](50) NULL, [zej] [varchar](50) NULL, [zbd] [varchar](50) NULL, [ytl] [varchar](50) NULL, [yej] [varchar](50) NULL, [ybd] [varchar](50) NULL, [xj] [varchar](50) NULL, [y] [varchar](50) NULL, [h] [varchar](50) NULL, [nm] [varchar](50) NULL, [yyin] [varchar](50) NULL, [she] [varchar](50) NULL, [huxi] [float] NULL, [maibo] [float] NULL, [xueya] [float] NULL, [fayue] [varchar](50) NULL, [shenjing] [varchar](50) NULL, [feihuxidao] [varchar](50) NULL, [xinzangxueguan] [varchar](50) NULL, [ganpishen] [varchar](50) NULL, [fubobaokuai] [varchar](50) NULL, [neiqita] [varchar](50) NULL, [shengao] [float] NULL, [tizhong] [float] NULL, [pifu] [varchar](50) NULL, [libajie] [varchar](50) NULL, [toujing] [varchar](50) NULL, [jiazhuangxian] [varchar](50) NULL, [jizhu] [varchar](50) NULL, [sizhi] [varchar](50) NULL, [gangmen] [varchar](50) NULL, [shengzhiqi] [varchar](50) NULL, [waiqita] [varchar](50) NULL, [xiongpian] [varchar](50) NULL, [xindiantu] [varchar](50) NULL, [gangongneng] [varchar](50) NULL, [yiganliandiuban] [varchar](50) NULL, [xuechanggui] [varchar](50) NULL, [xuexing] [varchar](50) NULL, [niaochanggui] [varchar](50) NULL, CONSTRAINT [PK_my_yiyuan] 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