This table defines the relationship between a
customer service representative or team of representatives, and the
customer or customer group that they are assigned to.
Column Descriptions:
Name | Type | Description |
REP_ID | BIGINT NOT NULL | The member id of the customer service
representative or service represenatative group that the
relationship is for. |
CUST_ID | BIGINT NOT NULL | The member id of the customer or customer group
that the service representative is related to. |
SEQUENCE | DOUBLE NOT NULL DEFAULT 0 | This determines the lookup sequence for
relationships. |
OPTCOUNTER | SMALLINT | 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> | REP_ID+CUST_ID | Primary Key |
I0000965 | CUST_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_1230 | CUST_ID | MEMBER | MEMBER_ID | Cascade |
F_1231 | REP_ID | MEMBER | MEMBER_ID | Cascade |