Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each custom ticket record, auto-incrementing integer |
|
| fkTicketID | int | 4 | null |
|
|
Ticket reference - Foreign key linking to CentralizedTicket.TicketID establishing one-to-one relationship (required field) |
||
| DateCreated | datetime | 16,3 | √ | null |
|
|
Custom record creation - When this extended record was first created, may differ from main ticket creation |
|
| CreatedBy | int | 4 | √ | null |
|
|
Custom record creator - User ID who created this extended record for audit purposes |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Custom record modification - Most recent update to any field in this extended record |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Custom record modifier - User ID who made the most recent update to extended fields |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Soft delete timestamp - When this custom record was logically deleted while preserving audit trail |
|
| AppName | nvarchar | 1073741823 | √ | null |
|
|
Associated application - Name of the software application related to this ticket for categorization and routing |
|
| Feedback | nvarchar | 1073741823 | √ | null |
|
|
Customer feedback - Detailed customer input, satisfaction ratings, and experience feedback for quality improvement |
|
| WhatWasChanged | nvarchar | 1073741823 | √ | null |
|
|
Change description - Detailed explanation of what was modified, added, or fixed in response to the ticket |
|
| TeamSupportAssigned | int | 4 | √ | null |
|
|
Assigned team member - ID of support team member responsible for resolution for workload management |
|
| UpdatedTo | nvarchar | 510 | √ | null |
|
|
Update target - Description of what the system/application was updated to include |
|
| PermanentlyFixed | nvarchar | 510 | √ | null |
|
|
Permanent solution flag - Indicator of whether the solution is a permanent fix or temporary workaround |
|
| Solution | nvarchar | 1073741823 | √ | null |
|
|
Resolution description - Detailed explanation of how the issue was resolved for knowledge base and future reference |
|
| TechnicalSolution | nvarchar | 1073741823 | √ | null |
|
|
Technical implementation details - Specific technical steps, code changes, or system modifications made |
|
| SupportExperience | nvarchar | 510 | √ | null |
|
|
Support quality rating - Customer evaluation of support experience for service improvement |
|
| TestFieldDemo | nvarchar | 510 | √ | null |
|
|
Testing and demonstration - Information about testing performed and demonstrations provided to customer |
|
| Summary | nvarchar | 1073741823 | √ | null |
|
|
Executive summary - High-level overview of the ticket, resolution, and business impact for reporting |
|
| ClosedDate | datetime | 16,3 | √ | null |
|
|
Closure timestamp - When the ticket was officially closed and marked complete |
|
| PublicTicket | nvarchar | 510 | √ | null |
|
|
Public visibility setting - Configuration for customer-facing visibility and communication preferences |
|
| Whyithappened | nvarchar | 1073741823 | √ | null |
|
|
Root cause analysis - Detailed explanation of why the issue occurred for prevention and process improvement |
|
| Happenedbefore | nvarchar | 510 | √ | null |
|
|
Recurrence indicator - Whether this type of issue has occurred previously for pattern analysis |
|
| ChangeSummary | nvarchar | 510 | √ | null |
|
|
Change overview - Brief summary of changes made for quick reference and communication |
|
| ChangeDetails | nvarchar | 1073741823 | √ | null |
|
|
Detailed change log - Comprehensive documentation of all changes made during resolution |
|
| SQLUpdateScript | nvarchar | 1073741823 | √ | null |
|
|
Database update script - SQL commands executed to resolve database-related issues for deployment tracking |
|
| SQLRollbackScript | nvarchar | 1073741823 | √ | null |
|
|
Database rollback script - SQL commands to reverse changes if rollback is needed for risk management |
|
| CodeChange | nvarchar | 1073741823 | √ | null |
|
|
Source code modifications - Description of code changes made to resolve the issue for version control |
|
| EstimatedTime | decimal | 20 | √ | null |
|
|
Time estimate - Projected hours required for completion used for resource planning and customer communication |
|
| TimeSpent | decimal | 20,2 | √ | null |
|
|
Actual time invested - Real hours spent on resolution for productivity analysis and billing |
|
| SolvedBy | int | 4 | √ | null |
|
|
Resolution team member - ID of person who provided the final solution for recognition and expertise tracking |
|
| WhyItHappenedSummary | nvarchar | 510 | √ | null |
|
|
Root cause summary - Brief explanation of why the issue occurred for quick reference |
|
| HowWasThisSolvedTechnically | nvarchar | 1073741823 | √ | null |
|
|
Technical solution summary - Concise description of technical approach used for resolution |
|
| RollBackInstructions | nvarchar | 1073741823 | √ | null |
|
|
Rollback procedures - Step-by-step instructions for reversing changes if needed for risk management |
|
| TicketFeedback | nvarchar | 510 | √ | null |
|
|
Overall ticket feedback - General feedback about the entire ticket experience and resolution |
|
| Functionality | nvarchar | 510 | √ | null |
|
|
Functional area - Business function or system area affected by this ticket for categorization |
|
| TypeOfEffort | nvarchar | 510 | √ | null |
|
|
Effort classification - Type of work required (e.g., Development, Configuration, Support) for resource allocation |
|
| LevelOfEffort | nvarchar | 510 | √ | null |
|
|
Effort magnitude - Scale of work required (e.g., Small, Medium, Large, Complex) for planning |
|
| TargetWeek | nvarchar | 510 | √ | null |
|
|
Planned delivery week - Target week for completion used for sprint planning and customer communication |
|
| Assigned | nvarchar | 510 | √ | null |
|
|
Assignment details - Information about who is assigned and assignment status |
|
| SolutionType | nvarchar | 510 | √ | null |
|
|
Solution category - Type of solution provided (e.g., Code Fix, Configuration, Process Change) |
|
| ServerLocation | nvarchar | 510 | √ | null |
|
|
Deployment target - Server or environment where changes need to be deployed |
|
| MultiApps | nvarchar | 510 | √ | null |
|
|
Multi-application impact - Indicator if changes affect multiple applications for coordination |
|
| EstimatedDeliveryWeek | int | 4 | √ | null |
|
|
Delivery week estimate - Projected week number for delivery planning and scheduling |
|
| InternalStatus | nvarchar | 1073741823 | √ | null |
|
|
Internal workflow status - Detailed internal status for team coordination and project management |
|
| DevelopmentFee | nvarchar | 510 | √ | null |
|
|
Development cost - Associated development costs for billing and budget tracking |
|
| PublicTitle | nvarchar | 510 | √ | null |
|
|
Customer-facing title - Public version of ticket title suitable for customer communication |
|
| PublicSolution | nvarchar | 6000 | √ | null |
|
|
Customer-facing solution - Public description of solution provided to customer |
|
| SystemUpdated | datetime | 16,3 | √ | null |
|
|
System update timestamp - When system changes were applied for deployment tracking |
|
| LoggedDate | datetime | 16,3 | √ | null |
|
|
Logging timestamp - When the ticket was officially logged in the system |
|
| ClosedBy | int | 4 | √ | null |
|
|
Closure user ID - User who officially closed the ticket for accountability |
|
| Resolution | nvarchar | 1073741823 | √ | null |
|
|
Final resolution - Complete description of final resolution provided |
|
| SolvedDate | datetime | 16,3 | √ | null |
|
|
Solution timestamp - When the solution was completed and verified |
|
| SolveOrder | int | 4 | √ | null |
|
|
Solution sequence - Order in which this ticket was solved relative to others |
|
| SolvePriority | nvarchar | 510 | √ | null |
|
|
Solution priority - Priority level assigned for solution development and deployment |
|
| AttachVideoorScreenshots | nvarchar | 510 | √ | null |
|
|
Media attachments - Indicator of video or screenshot attachments for documentation |
|
| BETAUpdated | datetime | 16,3 | √ | null |
|
|
Beta update timestamp - When beta environment was updated with solution |
|
| BranchInfo | nvarchar | 1073741823 | √ | null |
|
|
Source control branch - Git branch or version control information for code deployment |
|
| StandardDatabaseChange | nvarchar | 510 | √ | null |
|
|
Database change flag - Indicator if standard database changes are required |
|
| AssignedPerson | nvarchar | 510 | √ | null |
|
|
Assigned individual - Specific person assigned to work on this ticket |
|
| NonPublicInfo | nvarchar | 510 | √ | null |
|
|
Internal information - Sensitive information not suitable for customer visibility |
|
| DeploymentNeeded | bit | 1 | √ | null |
|
|
Deployment requirement - Boolean flag indicating if deployment is required for resolution |
|
| SystemUpdateTicket | nvarchar | 1073741823 | √ | null |
|
|
System update reference - Reference to related system update tickets for coordination |
|
| Tags | varchar | 500 | √ | null |
|
|
Ticket tags - Comma-separated list of tags for categorization and filtering |
|
| Category | varchar | 100 | √ | null |
|
|
Business category - High-level business category for reporting and organization |
|
| Order | int | 4 | √ | null |
|
|
Display order - Numeric order for sorting and prioritization in lists |
|
| Pin | bit | 1 | √ | null |
|
|
Pinned status - Boolean flag for pinning important tickets to top of lists |
|
| ExplanationOfReoccurringTicket | nvarchar | 6000 | √ | null |
|
|
Recurrence explanation - Detailed explanation for tickets that represent recurring issues |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| CentralizedTicketCustom_pkID | Primary key | Asc | pkID |
| IX_TicketcusTom_Ticket | Performance | Asc | fkTicketID |