ItemMarketVersion


Description

Marketplace item version control managing different versions of marketplace items including version history, compatibility, and deployment tracking. This system supports item lifecycle management and version-specific deployments.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ChecksumHash Unknown 0 null

Checksum hash - Hash value for version integrity verification

ItemMarketVersionId int identity 4 null
ItemMarketVersion.ItemMarketVersionId FK_ItemMarketVersion_ItemMarketVersion R
ItemMarketVersion.ItemMarketVersionId FK_ItemMarketVersion_ItemMarketVersion R

Version identifier - Alternative version ID for external system integration

ItemMarketId int 4 null
MarketItems.Id FK_ItemMarketVersion_MarketItems R

Item market identifier - Reference to the marketplace where this item version is available

VersionNumber float 8 null

Version number - Version identifier (e.g., 1.0, 2.1, 3.0.1)

ItemResourceId int 4 null

Resource identifier - Reference to associated resources or assets for this version

ContentUpdate nvarchar 1000 null

Content update information - Details about content changes and updates in this version

IsPublishForEveryOne bit 1 null

Global publication flag - Boolean indicating if version is published for all users

UpdateBy int 4 null

Update user - User who performed the most recent update to this version

UpdateDate datetime 16,3 null

Update timestamp - When this version was most recently updated

ClientItemId int 4 null

Client item identifier - Client-specific identifier for the marketplace item

CompatibilityInfo Unknown 0 null

Compatibility information - Compatibility details with other system components

CreatedBy Unknown 0 null

Creator user ID - Reference to user who created this version

DateCreated Unknown 0 null

Creation timestamp - When this version was first created

DateUpdated Unknown 0 null

Last modification timestamp - When this version was most recently updated

DeletedDate Unknown 0 null

Deletion timestamp - When this version was logically deleted

DownloadCount Unknown 0 null

Download count - Number of times this version has been downloaded

FileSize Unknown 0 null

File size - Size of the version package in bytes

ID Unknown 0 null

Primary key - Unique identifier for each item version, auto-incrementing integer

IsCurrent Unknown 0 null

Current version flag - Boolean indicating if this is the current active version

IsStable Unknown 0 null

Stability flag - Boolean indicating if this is a stable release

ItemId Unknown 0 null

Item reference - Reference to the marketplace item

MinimumRequirements Unknown 0 null

Minimum requirements - System requirements for this version

ReleaseDate Unknown 0 null

Release date - When this version was released

ReleaseNotes Unknown 0 null

Release notes - Description of changes and improvements in this version

UpdatedBy Unknown 0 null

Last modifier - User ID who made the most recent update

VersionName Unknown 0 null

Version name - Descriptive name for this version

Indexes

Constraint Name Type Sort Column(s)
PK_ItemMarketVersion Primary key Asc ItemMarketVersionId

Relationships