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.
OPTCOUNTERSMALLINTThe 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