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 Descriptions
| 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