Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| TicketID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each support ticket, auto-incrementing integer used throughout the system for ticket references and cross-database reporting |
||||
| Status | nvarchar | 1073741823 | √ | null |
|
|
Current ticket state - Workflow status indicating processing stage controlling visibility and business rules across all integrated systems |
||||
| Issue | nvarchar | 1073741823 | null |
|
|
Ticket title/summary - Brief description of the problem, request, or issue for quick identification and categorization (required field) displayed in cross-system reports |
|||||
| Description | nvarchar | 1073741823 | √ | null |
|
|
Detailed explanation - Complete description of the issue, steps to reproduce, business impact, and customer requirements for comprehensive support documentation |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to the user who created the ticket (foreign key to user system) for accountability and communication across all client systems |
||||
| CreatedDate | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When the ticket was first submitted by customer or created by staff, used for SLA calculations and cross-system reporting |
||||
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last modification timestamp - Most recent update to any ticket field, used for activity tracking and notification triggers across all integrated systems |
||||
| IsPublic | bit | 1 | ((0)) |
|
|
Visibility flag - Boolean indicating if ticket is visible to customers (true) or internal only (false), controlling access and communication across all client databases |
|||||
| CreatedByCompany | int | 4 | null |
|
|
Company association - Reference to the company/agency that created the ticket (foreign key) for multi-tenant data segregation and agency-specific ticket filtering |
|||||
| UpdatedBy | int | 4 | √ | null |
|
|
Last modifier user ID - Reference to the user who made the most recent update for audit trail and accountability across all systems |
||||
| TicketContent | nvarchar | 1073741823 | √ | null |
|
|
Rich content body - HTML-formatted detailed content including formatted text, images, and attachments for comprehensive issue documentation shared across systems |
||||
| URLReference | nvarchar | 400 | √ | null |
|
|
Related URL - Web address related to the issue (e.g., page where bug occurred, feature location) for context and reproduction across integrated applications |
||||
| CreateByName | nvarchar | 400 | √ | null |
|
|
Creator display name - Human-readable name of ticket creator for display purposes and communication in cross-system interfaces |
||||
| IsDelete | bit | 1 | ((0)) |
|
|
Soft delete flag - Boolean indicating if ticket is logically deleted (true) but retained for audit purposes across all integrated systems |
|||||
| BetaDate | datetime | 16,3 | √ | null |
|
|
Beta release date - When the solution was deployed to beta/testing environment for validation across all affected systems |
||||
| CompletedDate | datetime | 16,3 | √ | null |
|
|
Resolution completion date - When the ticket was marked as fully resolved and delivered to customer for SLA tracking |
||||
| EstHours | decimal | 20,2 | √ | null |
|
|
Estimated effort - Projected hours required for resolution, used for resource planning and project management across development teams |
||||
| LiveDate | datetime | 16,3 | √ | null |
|
|
Production release date - When the solution was deployed to live/production environment across all affected client systems |
||||
| Priority | nvarchar | 100 | √ | null |
|
|
Business priority level - Urgency classification affecting response time requirements and resource allocation across all support teams |
||||
| TargetDate | datetime | 16,3 | √ | null |
|
|
Planned completion date - Expected resolution date for customer communication and SLA management across all integrated systems |
||||
| Type | nvarchar | 100 | √ | null |
|
|
Ticket category - Classification of ticket type for routing and reporting across all client databases |
||||
| LastChat | datetime | 16,3 | √ | null |
|
|
Most recent chat timestamp - When the last customer communication occurred for activity tracking across all support channels |
||||
| LastChatName | nvarchar | 1073741823 | √ | null |
|
|
Last chat participant - Name of person who sent the most recent chat message for communication tracking |
||||
| UnreadChatUsers | nvarchar | 1073741823 | √ | null |
|
|
Unread message tracking - List of users with unread chat messages for notification management |
||||
| LastInternalChat | datetime | 16,3 | √ | null |
|
|
Internal communication timestamp - Most recent internal team discussion for collaboration tracking |
||||
| LastInternalChatName | varchar | 100 | √ | null |
|
|
Internal chat participant - Name of team member who sent the last internal message |
||||
| LastChatCompany | int | 4 | √ | null |
|
|
Chat company context - Company ID associated with the last chat message for multi-tenant communication |
||||
| LastComment | datetime | 16,3 | √ | null |
|
|
Comment timestamp - When the most recent comment was added for activity tracking |
||||
| LastCommentBy | int | 4 | √ | null |
|
|
Comment author ID - User who added the most recent comment for accountability |
||||
| LastCommentName | varchar | 200 | √ | null |
|
|
Comment author name - Display name of the person who added the last comment |
||||
| LatestCommentId | int | 4 | √ | null |
|
|
Current comment reference - ID of the most recent comment for quick access and threading |
||||
| LatestComment | varchar | 2147483647 | √ | null |
|
|
Current comment text - Content of the most recent comment for preview and notification purposes |
||||
| LatestInternalCommentId | int | 4 | √ | null |
|
|
Internal comment reference - ID of the most recent internal team comment |
||||
| LatestInternalComment | varchar | 2147483647 | √ | null |
|
|
Internal comment text - Content of the most recent internal comment for team collaboration |
||||
| LastCommentCompany | int | 4 | √ | null |
|
|
Comment company context - Company ID associated with the last comment for multi-tenant tracking |
||||
| DeletedBy | int | 4 | √ | null |
|
|
Deletion user ID - Reference to user who performed soft delete operation for audit trail |
||||
| LegacyArticleId | int | 4 | √ | null |
|
|
Legacy system reference - ID from previous article/knowledge base system for data migration tracking |
||||
| DescriptionWithoutHTML | nvarchar | 1073741823 | √ | null |
|
|
Plain text description - Clean text version of description without HTML formatting for search and reporting |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_CentralizedTicket | Primary key | Asc | TicketID |