Tables [dbo].[Result_External_Storage]
Links Image results to their external storage system
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Key IX_RES_ItemID: ActivityHeaderIDIndexes IX_RES_StorageID, TWstat_Result_External_Storage_ExternalStorageID_ActivityHeaderID, TWstat_Result_External_Storage_ExternalStorageIDType_ActivityHeaderID, TWstat_Result_External_Storage_ExternalStorageSytem_ActivityHeaderID(4)Foreign Keys FK_Result_External_Storage_ActivityHeaderID_Act_Hdr_Result_ID: [dbo].[Act_Hdr_Result].ActivityHeaderIDActivityHeaderID[dbo].[uniqueid]9NOT NULLResult. Link to Act_Hdr_Result.ID
Indexes IX_RES_StorageID, TWstat_Result_External_Storage_ExternalStorageSytem_ActivityHeaderID(2)ExternalStorageSytemvarchar(255)255NOT NULLExternal System
Indexes TWstat_Result_External_Storage_ExternalStorageID_ActivityHeaderIDExternalStorageIDvarchar(255)255NOT NULLIdentifier in the external system. (ex. PACS accession number)
Indexes IX_RES_StorageID, TWstat_Result_External_Storage_ExternalStorageIDType_ActivityHeaderID(2)ExternalStorageIDTypevarchar(255)255NOT NULLType of storage Identifier. (ex. StudyID)