Test

Tables (9)

ACCOUNT

  • System — int
  • Group — int
  • ID — nvarchar(16)
  • Password — nvarchar(16)
  • Name — nvarchar(64)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

DICOM_MPPS

  • SCPUseType — int — NOT NULL
  • Name — nvarchar(64)
  • Use — int — NOT NULL
  • AETitle — nvarchar(16)
  • IP — nvarchar(15)
  • Port — int — NOT NULL
  • UseMaxPDU — int — NOT NULL
  • MaxPDU — int — NOT NULL
  • Timeout — int — NOT NULL
  • EchoTimeout — int — NOT NULL
  • Language — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

DICOM_PRINT

  • Type — int — NOT NULL
  • SCPUseType — int — NOT NULL
  • Name — nvarchar(64)
  • AETitle — nvarchar(16)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

DICOM_STORAGE

  • SCPUseType — int — NOT NULL
  • Name — nvarchar(64)
  • Use — int — NOT NULL
  • AETitle — nvarchar(16)
  • IP — nvarchar(15)
  • Port — int — NOT NULL
  • UseMaxPDU — int — NOT NULL
  • MaxPDU — int — NOT NULL
  • Timeout — int — NOT NULL
  • EchoTimeout — int — NOT NULL
  • LUT — int — NOT NULL
  • SWCollimation — int — NOT NULL
  • BurnAnno — int — NOT NULL
  • BurnInfo — int — NOT NULL
  • BurnLabel — int — NOT NULL
  • TransferSyntax — int — NOT NULL
  • Language — int — NOT NULL
  • UseCodeExtension — int — NOT NULL
  • Compression — int — NOT NULL
  • Modality — int — NOT NULL
  • ApplyPreviewPosition — int — NOT NULL
  • ImageBit — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

DICOM_WORKLIST

  • Name — nvarchar(64)
  • AETitle — nvarchar(16)
  • Use — int — NOT NULL
  • IP — nvarchar(15)
  • Port — int — NOT NULL
  • UseMaxPDU — int — NOT NULL
  • MaxPDU — int — NOT NULL
  • EchoTimeout — int — NOT NULL
  • RefreshTime — int — NOT NULL
  • CodeMappingTag — int — NOT NULL
  • Timeout — int — NOT NULL
  • FilteringTag — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

INSTANCE

  • StudyKey — int
  • SeriesKey — int
  • StatusRejected — int
  • StatusStorageSent — int
  • StatusCommitmentCheck — int
  • StatusPrinted — int
  • StatusExported — int
  • ImageInstanceUID — nvarchar(64)
  • InstanceNumber — int
  • ContentDate — nvarchar(8)
  • ContentTime — nvarchar(16)
  • AcquisitionDate — nvarchar(8)
  • AcquisitionTime — nvarchar(16)
  • PatientOrientation1 — nvarchar(16)
  • PatientOrientation2 — nvarchar(16)
  • ImageComments — nvarchar(4000)
  • ImageLaterality — nvarchar(16)
  • ViewPositionPresetKey — int
  • ViewPositionName — nvarchar(16)
  • ViewPositionAlias — nvarchar(16)
  • ViewPositionValue — nvarchar(16)
  • ViewPositionDesignator — nvarchar(16)
  • ViewPositionMeaning — nvarchar(64)
  • ViewPositionLaterality — int
  • ViewPositionXIPLParamName — nvarchar(256)
  • ViewPositionPrefix — nvarchar(64)
  • ViewPositionImplant — nvarchar(64)
  • ViewPositionRoll — nvarchar(64)
  • RejectUserName — nvarchar(64)
  • RejectUserID — nvarchar(16)
  • RejectDate — nvarchar(8)
  • RejectTime — nvarchar(16)
  • RejectReason — nvarchar(64)
  • RejectType — int — NOT NULL
  • Rejectorder — int
  • ImageWidth — int — NOT NULL
  • ImageHeight — int — NOT NULL
  • ImageUsingBits — int — NOT NULL
  • ImageDirection — int — NOT NULL
  • ExposureIndex — int — NOT NULL
  • DoseKVP — int — NOT NULL
  • DoseMA — float — NOT NULL
  • DoseMS — float — NOT NULL
  • DoseMAS — float — NOT NULL
  • DoseDAP — float — NOT NULL
  • DetectorSensitivity — float — NOT NULL
  • DetectorDigitalOffset — float — NOT NULL
  • AECMode — int — NOT NULL
  • AECDensity — int — NOT NULL
  • BodyPartThickness — int — NOT NULL
  • CompressionForceUnit — int — NOT NULL
  • CompressionForce — int — NOT NULL
  • DoseComment — nvarchar(1024) — varchar(1024) NUL
  • TargetMaterial — int — NOT NULL
  • FilterMaterial — int — NOT NULL
  • GantryAngle — int — NOT NULL
  • AGDACR — float — NOT NULL
  • AGDEUREF — float — NOT NULL
  • HVL — float — NOT NULL
  • PaddleType — int — NOT NULL
  • … +6

PATIENT

  • PatientID — nvarchar(64)
  • PatientName — nvarchar(64)
  • PatientBirthDate — nvarchar(8)
  • PatientSex — nvarchar(16)
  • OtherPatientID — nvarchar(64)
  • OtherPatientName — nvarchar(64)
  • PatientComments — nvarchar(4000)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

SERIES

  • StudyKey — int
  • SeriesNumber — int
  • SeriesInstanceUID — nvarchar(128)
  • SeriesDate — nvarchar(8)
  • SeriesTime — nvarchar(16)
  • SeriesDescription — nvarchar(1024)
  • BodypartExamined — nvarchar(192)
  • Laterality — nvarchar(16)
  • ProtocolName — nvarchar(64)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

STUDY

  • PatientKey — int
  • StudyStatus — int
  • StudyDate — nvarchar(8)
  • StudyTime — nvarchar(16)
  • StudyInstanceUID — nvarchar(128)
  • StudyID — nvarchar(16)
  • AccessionNumber — nvarchar(64)
  • StudyDescription — nvarchar(1024)
  • PatientAge — nvarchar(4)
  • UnitType — int
  • PatientSize — float
  • PatientWeight — float
  • RejectUserName — nvarchar(64)
  • RejectUserID — nvarchar(16)
  • RejectDate — nvarchar(8)
  • RejectTime — nvarchar(16)
  • RejectReason — nvarchar(64)
  • RejectType — int — NOT NULL
  • InstitutionName — nvarchar(64)
  • InstitutionAddress — nvarchar(1024)
  • InstitutionalDepartmentName — nvarchar(64)
  • PhysicianOfRecord — nvarchar(64)
  • NameOfPhysicianReadingStudy — nvarchar(64)
  • ReferringPhysicianName — nvarchar(64)
  • OperatorName — nvarchar(64)
  • RequestedProcedureID — nvarchar(64)
  • RequestedProcedureDescription — nvarchar(64)
  • RPCodeValue — nvarchar(16)
  • RPCodeSchemeDesignator — nvarchar(16)
  • RPCodeSchemeVersion — nvarchar(16)
  • RPCodeMeaning — nvarchar(64)
  • SPStepID — nvarchar(16)
  • SPStationAETitle — nvarchar(16)
  • SPStationName — nvarchar(16)
  • SPStartDate — nvarchar(8)
  • SPStartTime — nvarchar(16)
  • SPStepDescription — nvarchar(64)
  • SPModality — nvarchar(16)
  • SPPerformingPhysicianName — nvarchar(64)
  • ProcedureKey — int
  • Lock — int
  • SeriesType — int
  • OriginalStudyInstanceUID — nvarchar(128)
  • HospitalCode — nvarchar(128)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =