CNTRNAME

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

Column Descriptions:

NameTypeDescription
NAMEVARCHAR (200) NOT NULLContract name.
MEMBER_IDBIGINT NOT NULLOwner of the Contract.
ORIGININTEGER NOT NULLContract origin.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
I0000076NAME+MEMBER_ID+ORIGINUnique Index
I0000537MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_247MEMBER_IDMEMBERMEMBER_IDCascade