Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Id | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each ticket comment, auto-incrementing integer |
|
| TicketId | int | 4 | √ | null |
|
|
Ticket reference - Foreign key linking to CentralizedTicket.TicketID for the ticket this comment belongs to |
|
| Content | varchar | 2147483647 | √ | null |
|
|
Comment content - Rich HTML content of the comment including text, formatting, and embedded media |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When the comment was first posted |
|
| CreatedBy | int | 4 | √ | null |
|
|
Author user ID - Reference to user who posted this comment |
|
| CreatedByName | varchar | 255 | √ | null |
|
|
Author name - Display name of the comment author for user interface |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last modification timestamp - When the comment was most recently edited |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Last editor user ID - Reference to user who made the most recent edit |
|
| UpdatedByName | varchar | 255 | √ | null |
|
|
Editor name - Display name of the user who last edited this comment |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - When the comment was logically deleted |
|
| UserEmail | varchar | 100 | √ | null |
|
|
Author email - Email address of the comment author for communication |
|
| CompanyId | int | 4 | √ | null |
|
|
Company reference - Reference to company for multi-tenant comment management |
|
| Company | varchar | 200 | √ | null |
|
|
Company name - Display name of the company associated with this comment |
|
| ContentWithOutHtml | varchar | 2147483647 | √ | null |
|
|
Plain text content - Clean text version of comment content without HTML formatting |
|
| IsInternal | bit | 1 | √ | null |
|
|
Internal flag - Boolean indicating if comment is internal-only or customer-visible |
|
| IsAutoComment | bit | 1 | √ | null |
|
|
Auto-generated flag - Boolean indicating if comment was automatically generated by the system |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| IX_TicketComments_Id | Must be unique | Asc | Id |