CCOMMENT

This table stores customer comments. These are notes about interactions that a customer service representative has with a particular customer, or notes that the customer requests be recorded as part of their profile.

Column Descriptions:

Name	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.
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.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	CCOMMENT_ID	Primary Key
I0000911	CUSTOMERID	Non-Unique Index
I0000912	TARGETID	Non-Unique Index
I0000913	AUTHDOMAIN	Non-Unique Index
I0000914	CREATEDBY	Non-Unique Index
I0000915	LASTUPDATEDBY	Non-Unique Index
I0000916	LANGUAGE_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_1160	CUSTOMERID	MEMBER	MEMBER_ID	Cascade
F_1161	TARGETID	MEMBER	MEMBER_ID	Cascade
F_1162	AUTHDOMAIN	ORGENTITY	ORGENTITY_ID	Cascade
F_1163	CREATEDBY	USERS	USERS_ID	Cascade
F_1164	LASTUPDATEDBY	USERS	USERS_ID	Cascade
F_1165	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade