CNTRNAME

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


Column Descriptions:

Name 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 NOT NULL DEFAULT 0 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
I0000076 NAME+MEMBER_ID+ORIGIN Unique Index
I0000537 MEMBER_ID Non-Unique Index


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_247 MEMBER_ID MEMBER MEMBER_ID Cascade


Related reference
Contract data model