This table contains information about a comment created by a user, user's organization, or comment Can be the user, the user's organization, or a customer service representative.
Column Descriptions
| Column Name
| Column Type
| Description
|
| CCOMMENT_ID
| BIGINT NOT NULL
| Primary key.
|
| CUSTOMERID
| BIGINT NOT NULL
| Represents the customer (user) who made the comment, or about whom the comment was placed.
|
| TARGETID
| BIGINT NOT NULL
| Represents the target of the comment. This can be the user, the user's organization, or a CSR with whom the user has communicated.
|
| AUTHDOMAIN
| BIGINT NOT NULL
| The seller organization (authorization domain) owning the comment. By default this will be the organization that owns the store at which the comment was placed. This can be overridden to make the comment more generally applicable.
|
| CREATEDBY
| BIGINT NOT NULL
| Represents the user who created the comment.
|
| LASTUPDATEDBY
| BIGINT NOT NULL
| Represents the user who last modified the comment. On comment creation, this field will be set to the same value as the CREATEDBY field.
|
| CREATETIMESTAMP
| TIMESTAMP NOT NULL
| The time when the comment was first created.
|
| LASTUPDATETSTMP
| TIMESTAMP NOT NULL
| The time when the comment was last updated. On initial creation, the last update timestamp will be set to the same value as the create timestamp.
|
| LANGUAGE_ID
| INTEGER NOT NULL
| The language ID for this comment.
|
| OPTCOUNTER
| SMALLINT NOT NULL DEFAULT 0
| Reserved for IBM internal use.
|
| FIELD1
| VARCHAR(254)
| Customer extension field 1.
|
| FIELD2
| VARCHAR(254)
| Customer extension field 2.
|
| FIELD3
| VARCHAR(254)
| Customer extension field 3.
|
| COMMENTDETAIL
| VARCHAR(2000) NOT NULL
| The comment text.
|