IF NOT EXISTS (SELECT * FROM SYSOBJECTS WHERE SYSOBJECTS.name = 'HYHEMSIREONDEGERLENDIRME')
CREATE TABLE [dbo].[HYHEMSIREONDEGERLENDIRME](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[TARIH] [datetime] NULL,
	[HYATISID] [int] NULL,
	[BGY] [int] NULL,
	[BGYNOT] NVARCHAR(50) NULL,
	[BGS] [int] NULL,
	[BGSNOT] NVARCHAR(50) NULL,

    [FMSIKAYET] NVARCHAR(150) NULL,	
	[FMHKP1] int  null,
	[FMHKP1-1] int  null,
	[FMHKP2] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FMHKP2 DEFAULT 0,
	[FMHKP3] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FMHKP3 DEFAULT 0,
	[FMHKP4] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FMHKP4 DEFAULT 0,
	

	[FMSA1] int  null ,
	[FMSANOT] NVARCHAR(50) NULL,			

	[FMBA1] int  null,
	[FMBANOT] NVARCHAR(50) NULL,			

	[FMKH1] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FMKH1 DEFAULT 0,
	[FMKH2] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FMKH2 DEFAULT 0,
	[FMKH3] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FMKH3 DEFAULT 0,
	[FMKH4] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FMKH4 DEFAULT 0,
	[FMKH5] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FMKH5 DEFAULT 0,
	[FMKHDIGER] NVARCHAR(50) NULL,

	[FMDOKT1] int  null,
	[FMDOKTNOT] NVARCHAR(50) NULL,

	[FMGHO1] int  null,
	[FMGHONOT] NVARCHAR(50) NULL,	

/*FİZİKSEL FAKTORLER*/

	/*SOLUNUM SİSTEMİ*/
	[FFSS1] int  null ,
	[FFSS2] int  null ,
	[FFSS3] int  null ,
	[FFSS4] int  null ,
	[FFSS4NOT] NVARCHAR(50) NULL,	
	/*ÜROGEİTAL SİSTEMİ*/
	[FFUS1] int  null ,
	[FFUS1NOT] NVARCHAR(50) NULL,
	[FFUS2] int  null ,
	[FFUS2NOT] NVARCHAR(50) NULL,
	[FFUS3] int  null ,
	[FFUS3NOT] NVARCHAR(50) NULL,
	[FFUS3TARIH] DATETIME NULL,
	[FFUS4] int  null ,
	[FFUS4NOT] NVARCHAR(50) NULL,
	/*DOLASIM SİSTEMİ*/
	[FFDS1] int  null ,
	[FFDS2] int  null ,
	[FFDS3] int  null ,
	[FFDS4] int  null ,
	[FFDS5] int  null ,
	[FFDS6] int  null ,
	[FFDS7] int  null ,
	[FFDS8] int  null ,
	/*NÖROLOJİK SİSTEM*/
	[FFNS1] int  null ,
	[FFNS2] int  null ,
	[FFNS3] int  null ,
	[FFNS4] int  null ,

    [FFCILT1] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFCILT1 DEFAULT 0,
	[FFCILT2] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFCILT2 DEFAULT 0,
	[FFCILT3] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFCILT3 DEFAULT 0,
	[FFCILT4] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFCILT4 DEFAULT 0,
	[FFCILT5] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFCILT5 DEFAULT 0,
	[FFCILT6] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFCILT6 DEFAULT 0,
	[FFCILT7NOT] NVARCHAR(20) NULL,
	[FFCILT8NOT] NVARCHAR(20) NULL,
	[FFCILT9NOT] NVARCHAR(20) NULL,

	[FFAGIZ1] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFAGIZ1 DEFAULT 0,
	[FFAGIZ2] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFAGIZ2 DEFAULT 0,
	[FFAGIZ3] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFAGIZ3 DEFAULT 0,
	[FFAGIZ4] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFAGIZ4 DEFAULT 0,
	[FFAGIZ5] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFAGIZ5 DEFAULT 0,
	[FFAGIZNOT] NVARCHAR(20) NULL,


	[FFGAST1] int  null ,
	[FFGAST2] int  null ,
	[FFGAST3] int  null ,
	[FFGAST4] int  null ,
	[FFGAST5] int  null ,
	[FFGAST6] int  null ,
	[FFGAST7] int  null ,
	[FFGAST8] int  null ,	
	[FFGAST8NOT] NVARCHAR(20) NULL,	
	[FFGAST9] int  null ,	
	[FFGAST9NOT] NVARCHAR(20) NULL,	
	[FFGAST10] int  null ,	
	[FFGAST11NOT] NVARCHAR(20) NULL,	

	[FFILET1] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFILET1 DEFAULT 0,
	[FFILET2] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFILET2 DEFAULT 0,
	[FFILET3] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFILET3 DEFAULT 0,
	[FFILET4] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFILET4 DEFAULT 0,
	[FFILET5] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFILET5 DEFAULT 0,
	[FFILET6] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFILET6 DEFAULT 0,
	[FFILET7] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFILET7 DEFAULT 0,
	[FFILET8] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFILET8 DEFAULT 0,
	[FFILET9] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFILET9 DEFAULT 0,
	[FFILET10] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFILET10 DEFAULT 0,

	[FFPSIKO1] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFPSIKO1 DEFAULT 0,
	[FFPSIKO2] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFPSIKO2 DEFAULT 0,
	[FFPSIKO3] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFPSIKO3 DEFAULT 0,
	[FFPSIKO4] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFPSIKO4 DEFAULT 0,
	[FFPSIKO5] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFPSIKO5 DEFAULT 0,
	[FFPSIKO6] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFPSIKO6 DEFAULT 0,
	[FFPSIKO7] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFPSIKO7 DEFAULT 0,
	[FFPSIKO8] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFPSIKO8 DEFAULT 0,
	[FFPSIKO9] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFPSIKO9 DEFAULT 0,
	[FFPSIKO10] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFPSIKO10 DEFAULT 0,

	[FFFONK1] int  null ,	
	[FFFONK2] int  null ,	
	[FFFONK3] int  null ,	
	[FFFONK4] int  null ,	
	[FFFONK5] int  null ,	
	[FFFONK6] int  null ,	
	[FFFONK7] int  null ,	
	[FFFONK8] int  null ,	
	[FFFONK9] int  null ,	


	[FFTGO1] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFTGO1 DEFAULT 0,
	[FFTGO2] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFTGO2 DEFAULT 0,
	[FFTGO3] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFTGO3 DEFAULT 0,
	[FFTGO4] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFTGO4 DEFAULT 0,
	[FFTGO5] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_FFTGO5 DEFAULT 0,


	[FFTGOD6] int  null ,	
	[FFTGOD7] int  null ,	
	[FFTGOD8] int  null ,	
	[FFTGOD9] int  null ,


	[HYSO1] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYSO1 DEFAULT 0,
	[HYSO2] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYSO2 DEFAULT 0,
	[HYSO3] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYSO3 DEFAULT 0,
	[HYSO4] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYSO4 DEFAULT 0,
	[HYSO5] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYSO5 DEFAULT 0,
	[HYSO6] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYSO6 DEFAULT 0,
	[HYSO7] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYSO7 DEFAULT 0,
	[HYSO8] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYSO8 DEFAULT 0,
	[HYSO9] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYSO9 DEFAULT 0,
	[HYSO10] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYSO10 DEFAULT 0,
	[HYSO11] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYSO11 DEFAULT 0,
	[HYSO12] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYSO12 DEFAULT 0,
	[HYSO13] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYSO13 DEFAULT 0,
	[HYSO14] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYSO14 DEFAULT 0,

	[HYTO1] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYTO1 DEFAULT 0,
	[HYTO2] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYTO2 DEFAULT 0,
	[HYTO3] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYTO3 DEFAULT 0,
	[HYTO4] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYTO4 DEFAULT 0,
	[HYTO5] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYTO5 DEFAULT 0,
	[HYTO6] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYTO6 DEFAULT 0,
	[HYTO7] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYTO7 DEFAULT 0,
	[HYTO8] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYTO8 DEFAULT 0,
	[HYTO9] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYTO9 DEFAULT 0,
	[HYTO10] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYTO10 DEFAULT 0,
	[HYTO11] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYTO11 DEFAULT 0,
	[HYTO12] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYTO12 DEFAULT 0,
	[HYTO13] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYTO13 DEFAULT 0,
	[HYTO14] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_HYTO14 DEFAULT 0,

	[SOSHIZ] int  null ,
	[SOSHIZ1] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_SOSHIZ1 DEFAULT 0,
	[SOSHIZ2] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_SOSHIZ2 DEFAULT 0,
	[SOSHIZ3] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_SOSHIZ3 DEFAULT 0,
	[SOSHIZ4] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_SOSHIZ4 DEFAULT 0,
	[SOSHIZ5] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_SOSHIZ5 DEFAULT 0,
	[SOSHIZ6] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_SOSHIZ6 DEFAULT 0,
	[SOSHIZ7] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_SOSHIZ7 DEFAULT 0,
	[SOSHIZ8] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_SOSHIZ8 DEFAULT 0,
	[SOSHIZ9] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_SOSHIZ9 DEFAULT 0,
	[SOSHIZ10] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_SOSHIZ10 DEFAULT 0,
	[SOSHIZ11] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_SOSHIZ11 DEFAULT 0,
	[SOSHIZ12] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_SOSHIZ12 DEFAULT 0,
	[SOSHIZ13] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_SOSHIZ13 DEFAULT 0,
	[SOSHIZNOT] NVARCHAR(20) NULL,
	
	[SOSFAK1] int  null ,	
	[SOSFAK1NOT] NVARCHAR(20) NULL,
	[SOSFAK2] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_SOSFAK2 DEFAULT 0,
	[SOSFAK2NOT] NVARCHAR(20) NULL,
	[SOSFAK3] int  null ,/*MEDENİ HALİ*/
	[SOSFAK4] int  null ,	
	[SOSFAK4NOT] NVARCHAR(20) NULL,
	
	ULASILACAKHASTAYAKINI NVARCHAR(50) NULL,
	ULASILACAKHASTAYAKINITEL NVARCHAR(30) NULL,
	ULASILACAKHASTAYAKINIADRES NVARCHAR(250) NULL,

	[GENELHASTAHAKLARI] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_GENELHASTAHAKLARI DEFAULT 0,
	[GENELSOSYALHIZMET] bit not null CONSTRAINT DF_HYHEMSIREONDEGERLENDIRME_GENELSOSYALHIZMET DEFAULT 0,
	[GENELTARIH] DATETIME NULL,
	[GENELYETKILI] NVARCHAR(50) NULL,
	
		
	[SPID] [int] NULL,
	[KYUSER] [nvarchar](25) NULL,
	[KYTTARIHI] [datetime] NULL,
 CONSTRAINT [PK_HYHEMSIREONDEGERLENDIRME] 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




