Apps


Description

Application marketplace and software catalog managing all software applications, tools, and services available within the iCentral platform. This is the CENTRAL AUTHORITY table for application definitions referenced across all client databases. Client databases like Sandbox reference this table through views such as CaseListing_VW via CategoryApp relationships to link cases with their associated billing applications for cross-system integration. Each app represents a distinct software module, third-party integration, or custom tool that can be deployed, licensed, and managed for agencies and users. The system supports comprehensive app lifecycle management including versioning, pricing, deployment, user access control, and marketplace presentation with rich metadata for discovery and management.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkAppID int identity 4 √ null
AppLayers.fkAppID FK_AppLayers_AppID R
AppUpdatesContent.AppId FK_AppUpdatesContent_Apps R

Primary key - Unique identifier for each application in the marketplace, auto-incrementing integer used throughout the system and referenced by client databases for billing application integration
AppName varchar 100 null

Application name - Display name of the application for marketplace presentation and user identification (required field), displayed in cross-database views like Sandbox.dbo.CaseListing_VW for billing application identification
AppDesc nvarchar 1073741823 √ null

Application description - Detailed description of app functionality, features, and benefits for marketplace listing and cross-system documentation
Documentation ntext 1073741823 √ null

Application documentation - Comprehensive documentation including user guides, API documentation, and technical specifications shared across all integrated systems
AppPackage varchar 100 √ null

Package identifier - Technical package name or identifier used for deployment and version management across the multi-tenant platform
AppOrder int 4 √ null

Display order - Numeric order for sorting applications in marketplace and user interfaces
AppIcon varchar 200 √ null

Application icon - URL or path to application icon image for visual identification in marketplace
helpURL varchar 300 √ null

Help documentation URL - Link to external help documentation, user guides, or support resources
videoURL varchar 300 √ null

Demo video URL - Link to demonstration or tutorial videos for user education and marketing
DateCreated smalldatetime 16 (getdate())

Creation timestamp - When the application was first added to the marketplace (defaults to current date)
CreatedBy int 4 √ null

Creator user ID - Reference to user who added the application to the marketplace for accountability
DateUpdated smalldatetime 16 √ null

Last modification timestamp - Most recent update to application metadata for change tracking
UpdatedBy int 4 √ null

Last modifier user ID - Reference to user who made the most recent update for audit trail
Deleted bit 1 √ null

Soft delete flag - Boolean indicating if application is logically deleted but retained for audit and dependency management
Price money 21,4 √ null

Application price - Monetary cost for application licensing or subscription in system currency
CreateByAgency int 4 √ ((0))

Creating agency ID - Reference to agency that developed or contributed the application for attribution
IsPublish bit 1 ((1))

Publication status - Boolean indicating if application is published and available in marketplace (defaults to true)
RegionIds nvarchar 200 √ null

Geographic regions - Comma-separated list of region IDs where application is available for geographic licensing
Package nvarchar 200 √ null

Package classification - Business package or bundle classification for grouping and pricing strategies
Market nvarchar 200 √ null

Target market - Intended market segment or industry vertical for application positioning
TargetUser nvarchar 200 √ null

Target user type - Intended user roles or personas for application marketing and access control
ImageUrls nvarchar 1073741823 √ null

Marketing images - JSON or comma-separated URLs to screenshots, promotional images, and marketing materials
ContentUpdate nvarchar 1073741823 √ null

Update content - Rich text description of recent updates, new features, and version changes
IsDefault bit 1 ((0))

Default application flag - Boolean indicating if this is a default/core application installed for all users
isLocked bit 1 ((0))

Lock status - Boolean indicating if application configuration is locked to prevent unauthorized changes
AppColor varchar 20 √ null

Theme color - Hex color code for application theming and visual consistency in user interface
IsDesign bit 1 ((0))

Design application flag - Boolean indicating if this is a design/layout application for UI customization
Label varchar 10 √ null

Application label - Short label or tag for quick identification and categorization
Category nvarchar 100 √ null

Application category - Business category for marketplace organization and filtering (e.g., Reporting, Communication, Productivity)

Indexes

Constraint Name Type Sort Column(s)
PK_Apps Primary key Asc pkAppID

Relationships

Close relationships within degrees of separation