IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'HMUAYENEKDBIRINCITRIMASTER')
BEGIN
CREATE TABLE [dbo].[HMUAYENEKDBIRINCITRIMASTER](
	[BIRINCITRIMASTERID] [int] NOT NULL,
	HKDGEBELIKID [int] NULL,
	[HMUAYENEID] [int] NULL,
	[HKIMLIKID] [int] NULL,
	[HDOSYAID] [int] NULL,
	TARIH [datetime] NULL,
	FETUSNO [int] NULL,
	CRL [int] NULL,
	NT FLOAT NULL,
	FHR [int] NULL,
	SKULLBRAIN nvarchar (10) NULL, --İzlendi, Kontrol, Anomali
	SKULLBRAINNOT nvarchar (20) NULL,
	SPEIN nvarchar (10) NULL,      --İzlendi, Kontrol, Anomali
	SPEINNOT nvarchar (20) NULL, 
	HEART nvarchar (10) NULL,      --İzlendi, Kontrol, Anomali
	HEARTNOT nvarchar (20) NULL,
	ABDOMEN nvarchar (10) NULL,      --İzlendi, Kontrol, Anomali
	ABDOMENNOT nvarchar (20) NULL,
	STOMACH nvarchar (10) NULL,      --İzlendi, Kontrol, Anomali
	STOMACHNOT nvarchar (20) NULL,
	BLADDER nvarchar (10) NULL,      --İzlendi, Kontrol, Anomali
	BLADDERNOT nvarchar (20) NULL,
	EXTREMITES nvarchar (10) NULL,      --İzlendi, Kontrol, Anomali
	EXTREMITESNOT nvarchar (20) NULL,
	DIGER nvarchar (20) NULL,  
	TAMAM nvarchar (20) NULL, --Yapılmadı, Tamam, Kontrol, Anomali
	DOKTORID [int] NULL,
	
 CONSTRAINT [PK_HMUAYENEKDBIRINCITRIMASTER] PRIMARY KEY CLUSTERED 
(
	[BIRINCITRIMASTERID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
END

