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 |