TicketComments

Columns

Name	Type	References	Description
Id [KEY]	Long		Automatically assigned when the ticket is created.
TicketId	Integer	Tickets.Id	The id of the ticket the comment belongs to.
AuthorId	Long	Users.Id	The id of the comment author.
Type	String		Comment or VoiceComment.
Body	String		The comment string.
CreatedAt	Datetime		The time the comment was created.
HtmlBody	String		The comment formatted as HTML.
PlainBody	String		The comment as plain text.
IsPublic	Boolean		True if a public comment; false if an internal note. The initial value set on ticket creation persists for any additional comment unless you change it.
ViaChannel	String		This tells you how the ticket or event was created. Examples: 'web', 'mobile', 'rule', 'system'.
ViaSource	String		.
MetadataCustom	String		.
MetadataSystemClient	String		.
MetadataSystemIpAddres	String		.
MetadataSystemLatitude	String		.
MetadataSystemLongitude	String		.
MetadataSystemLocation	String		.