USE [Patient_data]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tbDBImage](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[TableName] [varchar](50) NULL,
	[FieldName] [varchar](50) NULL,
	[IDKEY] [varchar](15) NULL,
	[DBImage] [image] NULL,
	[FileType] [varchar](15) NULL,
	[FileName] [varchar](30) NULL,
	[FileSize] [int] NULL,
	[ImgNote] [text] NULL,
	[Confidential] [varchar](1) NULL,
	[TransDATE] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


create index byTableFieldID on Patient_data.dbo.tbDBImage(TableName,FieldName,IDKEY) 
GO


create index byIDKey on Patient_data.dbo.tbDBImage(IDKEY) 
GO