Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | null |
|
|
Primary key - Comment unique identifier for each ticket comment record |
||
| TicketID | int | 4 | √ | null |
|
|
Ticket reference - Links to the support ticket this comment belongs to (foreign key to CentralizedTicket.TicketID) |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Comment date - Date and time when the comment was posted |
|
| CreatedByName | varchar | 255 | √ | null |
|
|
Comment author - Name of the person who posted the comment |
|
| UserEmail | varchar | 100 | √ | null |
|
|
Author email - Email address of the comment author for contact and identification |
|
| Company | varchar | 200 | √ | null |
|
|
Author company - Company or organization the comment author belongs to |
|
| ContentWithOutHtml | varchar | 2147483647 | √ | null |
|
|
Comment content - Text content of the comment with HTML formatting removed for analysis |
|
| IsInternal | varchar | 3 | null |
|
|
Internal flag - Showing Yes/ No |
||
| IsAutoComment | varchar | 3 | null |
|
|
Auto-generated flag - Showing Yes/ No |
Relationships
Close relationships within degrees of separation
