Expand All Collapse All

IR_ArchiveVolumeDescriptor Table

  • Table Type - Lookup
  • Last Changed Version - 4.0.106.453
  • Last Changed Reason - 4.0 Release

Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
ArchiveId uniqueidentifier False No

4.0.106.453 4.0 Release
VolumeName nvarchar (128) False Depends on customer usage

4.0.106.453 4.0 Release
VolumeDT datetime2 False No

4.0.106.453 4.0 Release
VolumeDTOffset int False No

4.0.106.453 4.0 Release
ArchiveStartDT datetime2 True No

4.0.106.453 4.0 Release
ArchiveEndDT datetime2 True No

4.0.106.453 4.0 Release
MediaURI nvarchar (1024) True Depends on customer usage

4.0.106.453 4.0 Release
Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
ArchiveId raw (16) False No

4.0.106.453 4.0 Release
VolumeName nvarchar2 (128) False Depends on customer usage

4.0.106.453 4.0 Release
VolumeDT timestamp False No

4.0.106.453 4.0 Release
VolumeDTOffset integer False No

4.0.106.453 4.0 Release
ArchiveStartDT timestamp True No

4.0.106.453 4.0 Release
ArchiveEndDT timestamp True No

4.0.106.453 4.0 Release
MediaURI nvarchar2 (1024) True Depends on customer usage

4.0.106.453 4.0 Release

Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_ArchiveVolumeDescriptor Clustered ArchiveId (Ascending)

Primary Key Name Column Name (sort order)
PK_IR_ArchiveVolumeDescriptor ArchiveId (Ascending)