WebSphere Commerce database table: REPCUSTREL

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

Column Name	Column Type	Description
REP_ID	BIGINT NOT NULL	The customer service representative id or service representative group id.
CUST_ID	BIGINT NOT NULL	The customer id or customer group id.
SEQUENCE	DOUBLE NOT NULL DEFAULT 0	This determines the lookup sequence for relationships.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
SQL060903235242360	REP_ID+CUST_ID	Primary Key
I0000965	CUST_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1230	CUST_ID	MEMBER	MEMBER_ID	Cascade
F_1231	REP_ID	MEMBER	MEMBER_ID	Cascade