Reference > Database > WebSphere Commerce database tables > C


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 Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
I0000076 NAME+MEMBER_ID+ORIGIN Unique Index
I0000537 MEMBER_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_247 MEMBER_ID MEMBER MEMBER_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search