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:

NameTypeDescription
CCOMMENT_IDBIGINT NOT NULLPrimary key.
CUSTOMERIDBIGINT NOT NULLRepresents the customer (user) who made the comment, or about whom the comment was placed.
TARGETIDBIGINT NOT NULLRepresents the target of the comment. This can be the user, the user's organization, or a CSR with whom the user has communicated.
AUTHDOMAINBIGINT NOT NULLThe 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.
CREATEDBYBIGINT NOT NULLRepresents the user who created the comment.
LASTUPDATEDBYBIGINT NOT NULLRepresents the user who last modified the comment. On comment creation, this field will be set to the same value as the CREATEDBY field.
CREATETIMESTAMPTIMESTAMP NOT NULLThe time when the comment was first created.
LASTUPDATETSTMPTIMESTAMP NOT NULLThe 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_IDINTEGER NOT NULLThe language ID for this comment.
FIELD1VARCHAR (254)Customer extension field 1.
FIELD2VARCHAR (254)Customer extension field 2.
FIELD3VARCHAR (254)Customer extension field 3.
COMMENTDETAILVARCHAR (2000) NOT NULLThe comment text.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CCOMMENT_IDPrimary Key
I0000911CUSTOMERIDNon-Unique Index
I0000912TARGETIDNon-Unique Index
I0000913AUTHDOMAINNon-Unique Index
I0000914CREATEDBYNon-Unique Index
I0000915LASTUPDATEDBYNon-Unique Index
I0000916LANGUAGE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1160CUSTOMERIDMEMBERMEMBER_IDCascade
F_1161TARGETIDMEMBERMEMBER_IDCascade
F_1162AUTHDOMAINORGENTITYORGENTITY_IDCascade
F_1163CREATEDBYUSERSUSERS_IDCascade
F_1164LASTUPDATEDBYUSERSUSERS_IDCascade
F_1165LANGUAGE_IDLANGUAGELANGUAGE_IDCascade