Columns of DICOMImages table

  • Which columns are needed in the DICOMImages table? I wanted to remove some columns to save space in the database.


    CREATE TABLE [dbo].[DICOMImages](

    [SOPInstanc] [varchar](64) NOT NULL,

    [SOPClassUI] [varchar](64) NULL,

    [ImageNumbe] [varchar](12) NULL,

    [ImageDate] [char](8) NULL,

    [ImageTime] [varchar](16) NULL,

    [EchoNumber] [varchar](64) NULL,

    [NumberOfFr] [varchar](12) NULL,

    [AcqDate] [char](8) NULL,

    [AcqTime] [varchar](16) NULL,

    [ReceivingC] [varchar](16) NULL,

    [AcqNumber] [varchar](12) NULL,

    [SliceLocat] [varchar](16) NULL,

    [SamplesPer] [varchar](5) NULL,

    [PhotoMetri] [varchar](16) NULL,

    [Rows] [varchar](5) NULL,

    [Colums] [varchar](5) NULL,

    [BitsStored] [varchar](5) NULL,

    [ImageType] [varchar](128) NULL,

    [ImageID] [varchar](16) NULL,

    [ImagePat] [varchar](64) NULL,

    [SeriesInst] [varchar](64) NULL,

    [AccessTime] [int] NULL,

    [qTimeStamp] [int] NULL,

    [qFlags] [int] NULL,

    [qSpare] [varchar](64) NULL,

    [ObjectFile] [varchar](255) NULL,

    [DeviceName] [varchar](32) NULL,

    )

  • Hi,


    You can delete a few but e.g the web viewer may stop working. Are you sure the columns define the database use. Many will be mostly empty and take little space.


    I think you can delete these:


    [EchoNumber] [varchar](64) NULL,

    [NumberOfFr] [varchar](12) NULL, (maybe)

    [AcqDate] [char](8) NULL,

    [AcqTime] [varchar](16) NULL,

    [ReceivingC] [varchar](16) NULL,

    [AcqNumber] [varchar](12) NULL,

    [SliceLocat] [varchar](16) NULL, (maybe)

    [SamplesPer] [varchar](5) NULL,

    [PhotoMetri] [varchar](16) NULL,

    [Rows] [varchar](5) NULL,

    [Colums] [varchar](5) NULL,

    [BitsStored] [varchar](5) NULL,

    [ImageType] [varchar](128) NULL, (maybe)

    [ImageID] [varchar](16) NULL, (maybe)

    [qSpare] [varchar](64) NULL,


    But I cannot guarantee it does not break certain functionality.


    Marcel

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!