Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PackageDescription | Unknown | 0 | null |
|
|
Package description - Detailed description of package contents and features |
||
| PackageId | int identity | 4 | √ | null |
|
|
Package identifier - Alternative package ID or external reference |
|
| PackageName | nvarchar | 200 | √ | null |
|
|
Package name - Display name of the package |
|
| PackageDesc | nvarchar | 1073741823 | √ | null |
|
|
Package description - Alternative description field for package details |
|
| VideoURL | nvarchar | 1073741823 | √ | null |
|
|
Video URL - URL to promotional or instructional video for the package |
|
| DateCreated | smalldatetime | 16 | (getdate()) |
|
|
Creation timestamp - When the package was created |
||
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - User who created the package |
|
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Last modification timestamp - When the package was last updated |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Last modifier - User who last updated the package |
|
| Deleted | bit | 1 | √ | null |
|
|
Deletion flag - Boolean indicating if package has been logically deleted |
|
| Price | money | 21,4 | √ | null |
|
|
Package price - Cost or pricing information |
|
| CreateByAgency | int | 4 | √ | ((0)) |
|
|
Creating agency - Reference to agency that created this package |
|
| Features | Unknown | 0 | null |
|
|
Package features - List of features included in the package |
||
| ID | Unknown | 0 | null |
|
|
Primary key - Unique identifier for each package |
||
| IsActive | Unknown | 0 | null |
|
|
Active status - Boolean indicating if package is currently available |
||
| IsPublish | bit | 1 | ((1)) |
|
|
Publication status - Boolean indicating if package is published and available |
||
| RegionIds | nvarchar | 200 | √ | null |
|
|
Region identifiers - Comma-separated list of region IDs where package is available |
|
| Market | nvarchar | 200 | √ | null |
|
|
Target market - Market or marketplace where this package is available |
|
| TargetUser | nvarchar | 200 | √ | null |
|
|
Target user type - Classification of intended users for this package |
|
| ImageUrls | nvarchar | 1073741823 | √ | null |
|
|
Image URLs - URLs to images and visual assets for the package |
|
| ContentUpdate | nvarchar | 1073741823 | √ | null |
|
|
Content update information - Details about content updates and changes in the package |
|
| Details | nvarchar | 1073741823 | √ | null |
|
|
Package details - Extended details and specifications for the package |
|
| PackageType | Unknown | 0 | null |
|
|
Package type - Classification of the package |
||
| StartUpFee | money | 21,4 | √ | null |
|
|
Startup fee - Initial fee required for package activation or setup |
|
| Version | Unknown | 0 | null |
|
|
Package version - Current version of the package |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Package | Primary key | Asc | PackageId |