Updated: 2016-04-15
Version: Control 5.7
Table Purpose, Usage, and Notes
This table stores the text and graphing data for all artwork comments made by employees and contacts.
Information on Table Data
- CommentTypeIDs in Table:
- 0 - Undefined
- 1 - Text
- 2 - Pin
- 3 - Box
- 4 - Line
Table Structure
| ~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
| ArtworkComment.Annotations | XML | An XML metadata field for the comment. This contains the geometric information necessary to draw the comment, and any other properties of the comment other than text. | |||||
| ArtworkComment.ArtworkItemID | Int | ID of the ArtworkItem associated with this comment. | ArtworkItem.ID | ||||
| ArtworkComment.ClassTypeID | SmallInt | ||||||
| ArtworkComment.CommentDT | Smalldatetime | The local server datetime the comment was made. | |||||
| ArtworkComment.CommentHTML | Varchar(max) | The html version of the users comments, if supplied. If the comment is only text, this field is left NULL to prevent duplicating storage. | |||||
| ArtworkComment.CommentText | Varchar(max) | The plain text version of the users comments. If the comment includes HTML formatting, this version has all such formatting stripped out. | |||||
| ArtworkComment.CommentTypeID | Tinyint | The type of comment made. Defaults to 1, text comment. See TArtworkCommentType for valid values. | _ArtworkCommentType.ID | ||||
| ArtworkComment.ID | int | ID of the comment | |||||
| ArtworkComment.IsPublic | Bit | Boolean field indicating if the comments are public (1 visible to contacts) or private (0 only visible to employees). All customer comments are public. All employee comments are private by default. | |||||
| ArtworkComment.PlayerID | Int | ID of the player making this comment. If the employee making the comment is not already a player on this order, an adhoc player record is created for her or him. | ArtworkPlayer.ID | ||||
| ArtworkComment.ProofFileID | Int | ID of the ProofFile associated with this comment. This field allows NULLs for compatibility with future plans. The current implementation of Artwork Approval requires this field to be supplied. | ArtworkProofFile.ID | ||||
| ArtworkComment.SeqID | Smallint | The number of times a record has been updated. | |||||
| ArtworkComment.SortIndex | Smallint | Stores the sorting of the items as added. |
Related Tables
You could leave a comment if you were logged in.