WebSphere Commerce database table: CNTRNAME

This table contains name information for a Contract. The Contract name is used to force serialization on contract management.


Column Description(s):
Column NameColumn TypeDescription
NAME VARCHAR(200) NOT NULL Contract name.
MEMBER_ID BIGINT NOT NULL Owner of the Contract.
ORIGIN INTEGER NOT NULL Contract origin.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000076 NAME+MEMBER_ID+ORIGIN Unique Index
I0000537 MEMBER_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_247 MEMBER_ID MEMBER MEMBER_ID Cascade

Feedback