Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Id | int identity | 4 | √ | null |
|
|
Data field - Id information for MarketItems business operations |
|
| ItemId | int | 4 | null |
|
|
Item identifier - Reference to the base item or service in the master catalog |
||
| TypeId | nvarchar | 20 | null |
|
|
Type identifier - Reference to the market item type classification |
||
| Market | nvarchar | 200 | √ | null |
|
|
Market name - Name or identifier of the specific market or geographic region |
|
| RegionId | varchar | 100 | √ | null |
|
|
Region identifier - Geographic region code where this market item is available |
|
| Package | nvarchar | 510 | √ | null |
|
|
Package name - Package or bundle name for grouped market items |
|
| Cost | int | 4 | √ | null |
|
|
Item cost - Cost or price for this market item in the specified region |
|
| Name | nvarchar | 510 | √ | null |
|
|
Item name - Descriptive name of the market item or service |
|
| Description | nvarchar | 1000 | √ | null |
|
|
Item description - Detailed description of the market item’s features and benefits |
|
| ProvidedBy | nvarchar | 510 | √ | null |
|
|
Provider information - Name or identifier of the organization providing this market item |
|
| UpdateDate | datetime | 16,3 | √ | null |
|
|
Last update date - Date when this market item record was last modified |
|
| DeleteBy | nvarchar | 500 | √ | null |
|
|
Deletion user - User who marked this market item as deleted |
|
| DeleteDate | date | 20 | √ | null |
|
|
Deletion date - Date when this market item was marked as deleted |
|
| Category | nvarchar | 510 | √ | null |
|
|
Item category - Business category for organizing and grouping related market items |
|
| EffectiveDate | Unknown | 0 | null |
|
|
Effective date - Date when this market pricing becomes effective |
||
| fkItemID | Unknown | 0 | null |
|
|
Item reference - Reference to the base item or service |
||
| ImageUrls | nvarchar | 1073741823 | √ | null |
|
|
Image URLs - URLs to product images, screenshots, or visual content for this market item |
|
| IsAvailable | Unknown | 0 | null |
|
|
Available flag - Whether this item is available in this market |
||
| IsShow | bit | 1 | √ | ((1)) |
|
|
Display flag - Whether this market item is visible and displayed to users |
|
| MarketCode | Unknown | 0 | null |
|
|
Market code - Code identifying the specific market |
||
| MarketItemId | Unknown | 0 | null |
|
|
Primary key - MarketItems unique identifier for each market item |
||
| MarketPrice | Unknown | 0 | null |
|
|
Market price - Price for this item in this market |
||
| VideoUrl | nvarchar | 1073741823 | √ | null |
|
|
Video URL - URL to demonstration videos or promotional content for this market item |
|
| PublishDate | datetime | 16,3 | √ | null |
|
|
Publication date - Date when this market item was published and made available |
|
| TargetUser | varchar | 200 | √ | null |
|
|
Target user type - Type of users or roles that this market item is designed for |
|
| PublishBy | int | 4 | √ | null |
|
|
Publisher reference - Reference to the user who published this market item |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_MarketItems | Primary key | Asc | Id |