IF NOT EXISTS (SELECT * FROM SYSOBJECTS WHERE SYSOBJECTS.name = 'HYKATATERDEGISIM')
CREATE TABLE [dbo].[HYKATATERDEGISIM](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[TARIH] [datetime] NULL,
	[HYATISID] [int] NULL,

	[K1] bit not null CONSTRAINT DF_HYKATATERDEGISIM_K1 DEFAULT 0,
	[K1TAKTARIH] [datetime] NULL,
	[K1DEG1TARIH] [datetime] NULL,
	[K1DEG2TARIH] [datetime] NULL,
	[K1DEG3TARIH] [datetime] NULL,

	[K2] bit not null CONSTRAINT DF_HYKATATERDEGISIM_K2 DEFAULT 0,
	[K2TAKTARIH] [datetime] NULL,
    [K2DEG1TARIH] [datetime] NULL,
	[K2DEG2TARIH] [datetime] NULL,
	[K2DEG3TARIH] [datetime] NULL,


	[K3] bit not null CONSTRAINT DF_HYKATATERDEGISIM_K3 DEFAULT 0,
	[K3TAKTARIH] [datetime] NULL,
    [K3DEG1TARIH] [datetime] NULL,
	[K3DEG2TARIH] [datetime] NULL,
	[K3DEG3TARIH] [datetime] NULL,


	
	[K4] bit not null CONSTRAINT DF_HYKATATERDEGISIM_K4 DEFAULT 0,
	[K4TAKTARIH] [datetime] NULL,
	[K4DEG1TARIH] [datetime] NULL,
	[K4DEG2TARIH] [datetime] NULL,
	[K4DEG3TARIH] [datetime] NULL,

	
	[K5] bit not null CONSTRAINT DF_HYKATATERDEGISIM_K5 DEFAULT 0,
	[K5TAKTARIH] [datetime] NULL,
	[K5DEG1TARIH] [datetime] NULL,
	[K5DEG2TARIH] [datetime] NULL,
	[K5DEG3TARIH] [datetime] NULL,

	
	[K6] bit not null CONSTRAINT DF_HYKATATERDEGISIM_K6 DEFAULT 0,
	[K6TAKTARIH] [datetime] NULL,
	[K6DEG1TARIH] [datetime] NULL,
	[K6DEG2TARIH] [datetime] NULL,
	[K6DEG3TARIH] [datetime] NULL,

	
	[K7] bit not null CONSTRAINT DF_HYKATATERDEGISIM_K7 DEFAULT 0,
	[K7TAKTARIH] [datetime] NULL,
	[K7DEG1TARIH] [datetime] NULL,
	[K7DEG2TARIH] [datetime] NULL,
	[K7DEG3TARIH] [datetime] NULL,

	
	[K8] bit not null CONSTRAINT DF_HYKATATERDEGISIM_K8 DEFAULT 0,
	[K8TAKTARIH] [datetime] NULL,
	[K8DEG1TARIH] [datetime] NULL,
	[K8DEG2TARIH] [datetime] NULL,
	[K8DEG3TARIH] [datetime] NULL,

	
	
	[K9] bit not null CONSTRAINT DF_HYKATATERDEGISIM_K9 DEFAULT 0,
	[K9TAKTARIH] [datetime] NULL,
	[K9DEG1TARIH] [datetime] NULL,
	[K9DEG2TARIH] [datetime] NULL,
	[K9DEG3TARIH] [datetime] NULL,

	
	[K10] bit not null CONSTRAINT DF_HYKATATERDEGISIM_K10 DEFAULT 0,
	[K10TAKTARIH] [datetime] NULL,
	[K10DEG1TARIH] [datetime] NULL,
	[K10DEG2TARIH] [datetime] NULL,
	[K10DEG3TARIH] [datetime] NULL,


	[K11] bit not null CONSTRAINT DF_HYKATATERDEGISIM_K11 DEFAULT 0,
	[K11TAKTARIH] [datetime] NULL,
	[K11DEG1TARIH] [datetime] NULL,
	[K11DEG2TARIH] [datetime] NULL,
	[K11DEG3TARIH] [datetime] NULL,

	
	[K12] bit not null CONSTRAINT DF_HYKATATERDEGISIM_K12 DEFAULT 0,
	[K12TAKTARIH] [datetime] NULL,
	[K12DEG1TARIH] [datetime] NULL,
	[K12DEG2TARIH] [datetime] NULL,
	[K12DEG3TARIH] [datetime] NULL,

	
	[K13] bit not null CONSTRAINT DF_HYKATATERDEGISIM_K13 DEFAULT 0,
	[K13TAKTARIH] [datetime] NULL,
	[K13DEG1TARIH] [datetime] NULL,
	[K13DEG2TARIH] [datetime] NULL,
	[K13DEG3TARIH] [datetime] NULL,

	
	[K14] bit not null CONSTRAINT DF_HYKATATERDEGISIM_K14 DEFAULT 0,
    [K14TAKTARIH] [datetime] NULL,
	[K14DEG1TARIH] [datetime] NULL,
	[K14DEG2TARIH] [datetime] NULL,
	[K14DEG3TARIH] [datetime] NULL,
	
	[K15] bit not null CONSTRAINT DF_HYKATATERDEGISIM_K15 DEFAULT 0,
	[K15TAKTARIH] [datetime] NULL,
	[K15DEG1TARIH] [datetime] NULL,
	[K15DEG2TARIH] [datetime] NULL,
	[K15DEG3TARIH] [datetime] NULL,

	
	
	[K16] bit not null CONSTRAINT DF_HYKATATERDEGISIM_K16 DEFAULT 0,
	[K16TAKTARIH] [datetime] NULL,
	[K16DEG1TARIH] [datetime] NULL,
	[K16DEG2TARIH] [datetime] NULL,
	[K16DEG3TARIH] [datetime] NULL,



	[K17] bit not null CONSTRAINT DF_HYKATATERDEGISIM_K17 DEFAULT 0,
	[K17TAKTARIH] [datetime] NULL,
	[K17DEG1TARIH] [datetime] NULL,
	[K17DEG2TARIH] [datetime] NULL,
	[K17DEG3TARIH] [datetime] NULL,

	
	[K18] bit not null CONSTRAINT DF_HYKATATERDEGISIM_K18 DEFAULT 0,
	[K18TAKTARIH] [datetime] NULL,
	[K18DEG1TARIH] [datetime] NULL,
	[K18DEG2TARIH] [datetime] NULL,
	[K18DEG3TARIH] [datetime] NULL,

	
	[K19] bit not null CONSTRAINT DF_HYKATATERDEGISIM_K19 DEFAULT 0,
	[K19TAKTARIH] [datetime] NULL,
	[K19DEG1TARIH] [datetime] NULL,
	[K19DEG2TARIH] [datetime] NULL,
	[K19DEG3TARIH] [datetime] NULL,


	[GENELNOT]  NVARCHAR(250) NULL,
	[SPID] [int] NULL,
	[KYUSER] [nvarchar](25) NULL,
	[KYTTARIHI] [datetime] NULL,
 CONSTRAINT [PK_HYKATATERDEGISIM] 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
