Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AppCategory | Unknown | 0 | null |
|
|
Application category - Business category for grouping related applications |
|||||||||||
| pkAppID | int identity | 4 | √ | null |
|
|
Primary key - Apps unique identifier for each record |
||||||||||
| AppName | varchar | 100 | null |
|
|
Application name - Descriptive name of the application or module |
|||||||||||
| AppDesc | varchar | 500 | √ | null |
|
|
Application description - Detailed description of the application’s functionality and purpose |
||||||||||
| AppStatus | Unknown | 0 | null |
|
|
Application status - Current status of the application (Active, Inactive, Development, etc.) |
|||||||||||
| AppType | Unknown | 0 | null |
|
|
Application type - Classification of the application (Core, Add-on, Premium, etc.) |
|||||||||||
| AppVersion | Unknown | 0 | null |
|
|
Version number - Current version of the application module |
|||||||||||
| DefaultEnabled | Unknown | 0 | null |
|
|
Default enabled flag - Whether this application is enabled by default for new agencies |
|||||||||||
| Documentation | ntext | 1073741823 | √ | null |
|
|
Application documentation - Comprehensive documentation including user guides, technical specifications, and help content for the application |
||||||||||
| AppPackage | varchar | 100 | √ | null |
|
|
Application package - Package or bundle name for application deployment and organization in the marketplace |
||||||||||
| AppOrder | int | 4 | √ | null |
|
|
Application order - Numeric order for displaying applications in menus, catalogs, and user interface lists |
||||||||||
| AppIcon | varchar | 200 | √ | null |
|
|
Application icon - File path or URL to the application’s icon image for visual identification in user interfaces |
||||||||||
| helpURL | varchar | 300 | √ | null |
|
|
Help URL - URL link to online help documentation, user guides, or support resources for this application |
||||||||||
| RequiredLicense | Unknown | 0 | null |
|
|
License requirement - Indicates if special licensing is required for this application |
|||||||||||
| videoURL | varchar | 300 | √ | null |
|
|
Video URL - URL link to training videos, demonstrations, or tutorial content for this application |
||||||||||
| DateCreated | smalldatetime | 16 | (getdate()) |
|
|
Creation date - Date and time when this application record was first created in the system |
|||||||||||
| CreatedBy | int | 4 | √ | null |
|
|
Creator reference - Reference to the user who originally created this application record |
||||||||||
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Last update date - Date and time when this application record was last modified |
||||||||||
| UpdatedBy | int | 4 | √ | null |
|
|
Last updater reference - Reference to the user who last modified this application record |
||||||||||
| Deleted | bit | 1 | √ | null |
|
|
Deletion flag - Whether this application record has been marked as deleted or archived |
||||||||||
| CreateByAgency | int | 4 | √ | ((0)) |
|
|
Creating agency reference - Reference to the agency that created this custom application (for agency-specific apps) |
||||||||||
| IsPublish | bit | 1 | ((1)) |
|
|
Published flag - Whether this application is published and available for agencies to enable and use |
|||||||||||
| Market | nvarchar | 200 | √ | null |
|
|
Target market - Market segment or industry vertical where this application is applicable (Healthcare, Education, etc.) |
||||||||||
| Package | nvarchar | 200 | √ | null |
|
|
Package classification - Classification or tier of the application package (Basic, Professional, Enterprise, etc.) |
||||||||||
| Price | money | 21,4 | √ | null |
|
|
Application price - Cost or pricing information for this application, including subscription or licensing fees |
||||||||||
| RegionIds | nvarchar | 200 | √ | null |
|
|
Region identifiers - Comma-separated list of geographic regions where this application is available |
||||||||||
| TargetUser | nvarchar | 200 | √ | null |
|
|
Target user type - Type of users or roles that this application is designed for (Administrators, Clinicians, Billing Staff, etc.) |
||||||||||
| ContentUpdate | nvarchar | 1073741823 | √ | null |
|
|
Content updates - Information about recent content updates, feature changes, and version release notes |
||||||||||
| ImageUrls | nvarchar | 1073741823 | √ | null |
|
|
Image URLs - URLs to screenshots, promotional images, or visual content for application marketing and documentation |
||||||||||
| SortOrder | Unknown | 0 | null |
|
|
Display order - Numeric order for displaying applications in user interfaces |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Apps | Primary key | Asc | pkAppID |