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 — =