IF NOT EXISTS (SELECT * FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.id = SYSCOLUMNS.id 
              WHERE SYSOBJECTS.name = 'HUSS251VERISETI')		   

CREATE TABLE [dbo].[HUSS251VERISETI](
	[HUSS251VERISETIID] [int] NOT NULL,
	[HMUAYENEID] [int] NULL,
	[HDOSYAID] [int] NOT NULL,
	[TEDAVININYAPILDIGIYERID] [int] NULL,
	[YATISINGERCEKLESTIGIHASTANEKODU] [nvarchar](100) NULL,
	[OLUMZAMANI] [datetime] NULL,
	[CIDDIASIEDURUMBILGISIID] [int] NULL,
	[HASTALIKBILGISI] [nvarchar](200) NULL,
	[PANDEMIASIEALERJIBILGISI] [nvarchar](200) NULL,
	[FORMUDOLDURANKISIADI] [varchar](50) NULL,
	[FORMUDOLDURANKISININSOYADI] [varchar](50) NULL,
	[ASILAMASIRASINDABILINENHASTALIGIVARMI] [bit] NULL,
	[ONCESINDEBENZERBIRASIETABLOSUVARLIGIVARMI] [bit] NULL,
	[ALERJIOYKUSUVARMI] [bit] NULL,
	[ASIEORTAYACIKISZAMANI] [datetime] NULL,
	[ASIEMEVCUTDURUMUID] [int] NULL,
	[VAKAYATEDAVIGEREKTIMI] [bit] NULL,
	[VAKAHASTANEYEYATTIMI] [bit] NULL,
	[VAKAOLDUMU] [bit] NULL,
	[CIDDIASIEDURUMVARLIGI] [bit] NULL,
	[ASILAMASIRASINDAKULLANDIGIILACVARMI] [bit] NULL,
	[ASIID] [int] NULL,
	[ILACLARID] [int] NULL,
	[ASIEETKIBILGILERIID] [int] NULL,
	[ISLEMZAMANI] [datetime] NULL,
	[GONDERILDI] [bit] NULL,
 CONSTRAINT [PK_HUSS251VERISETIID] PRIMARY KEY CLUSTERED 
(
	[HUSS251VERISETIID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 70) ON [PRIMARY]
) ON [PRIMARY]
GO


