Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Id | int identity | 4 | √ | null |
|
|
Item identifier - Alternative identifier for the marketplace item |
||||
| Market | nvarchar | 200 | √ | null |
|
|
Target market - Market or marketplace where this item is available |
||||
| RegionId | varchar | 100 | √ | null |
|
|
Region identifier - Reference to region where item is available |
||||
| Package | nvarchar | 510 | √ | null |
|
|
Package information - Package details or grouping information |
||||
| Cost | int | 4 | √ | null |
|
|
Item cost - Cost information for the marketplace item |
||||
| CreatedBy | Unknown | 0 | null |
|
|
Creator user ID - User who added the item to marketplace |
|||||
| DateCreated | Unknown | 0 | null |
|
|
Creation timestamp - When the item was added |
|||||
| DateUpdated | Unknown | 0 | null |
|
|
Last modification timestamp - When the item was last updated |
|||||
| Name | nvarchar | 510 | √ | null |
|
|
Item name - Name of the marketplace item |
||||
| Description | nvarchar | 1073741823 | √ | null |
|
|
Item description - Detailed description of the marketplace item |
||||
| ProvidedBy | nvarchar | 510 | √ | null |
|
|
Provider information - Information about who provides this item |
||||
| DeleteBy | nvarchar | 500 | √ | null |
|
|
Deletion user - User who deleted or deactivated the item |
||||
| DeleteDate | date | 20 | √ | null |
|
|
Deletion timestamp - When the item was deleted or deactivated |
||||
| Category | nvarchar | 510 | √ | null |
|
|
Item category - Category classification for organizing marketplace items |
||||
| IsActive | Unknown | 0 | null |
|
|
Active status - Boolean indicating if item is currently available |
|||||
| ItemName | Unknown | 0 | null |
|
|
Item name - Display name of the marketplace item |
|||||
| ItemType | Unknown | 0 | null |
|
|
Item type - Classification of the marketplace item |
|||||
| VideoUrl | nvarchar | 1073741823 | √ | null |
|
|
Video URL - URL to promotional or instructional video for the item |
||||
| ImageUrls | nvarchar | 1073741823 | √ | null |
|
|
Image URLs - URLs to images and visual assets for the item |
||||
| PublishDate | datetime | 16,3 | √ | null |
|
|
Publication date - When the item was published to marketplace |
||||
| TargetUser | varchar | 200 | √ | null |
|
|
Target user type - Classification of intended users for this item |
||||
| PublishBy | int | 4 | √ | null |
|
|
Publisher user - User who published the item to marketplace |
||||
| IsShow | bit | 1 | √ | ((1)) |
|
|
Display flag - Boolean indicating if item should be shown in marketplace |
||||
| CreateByAgencyId | int | 4 | √ | null |
|
|
Creating agency ID - Reference to agency that created this marketplace item |
||||
| CurrentVersionNumber | float | 8 | √ | null |
|
|
Current version number - Version number of the currently active version |
||||
| ItemDescription | Unknown | 0 | null |
|
|
Item description - Detailed description of the item |
|||||
| Price | Unknown | 0 | null |
|
|
Item price - Cost or pricing information for the item |
|||||
| TypeId | nchar | 20 | √ | null |
|
|
Type identifier - Reference to item type classification |
||||
| UpdatedBy | Unknown | 0 | null |
|
|
Last modifier - User who last updated the item |
|||||
| Version | Unknown | 0 | null |
|
|
Item version - Current version of the marketplace item |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_MarketItems | Primary key | Asc | Id |