CATCNTR

Each row of this table associates a catalog with a contract.

Column Descriptions:

NameTypeDescription
CATALOG_IDBIGINT NOT NULLThe identifier of the catalog.
CONTRACT_IDBIGINT NOT NULLThe identifier of the contract.
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
<SYSTEM-GENERATED>CONTRACT_ID+CATALOG_IDPrimary Key
I0000513CATALOG_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_187CATALOG_IDCATALOGCATALOG_IDCascade
F_188CONTRACT_IDCONTRACTCONTRACT_IDCascade