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:
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:
<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:
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 |