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 |
|
|
Version identifier - Alternative version ID for external system integration |
|||||||
| ItemMarketId | int | 4 | √ | null |
|
|
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 |