INSRULECATENT

The relationship between an installment rule and a catalog entry.

Column Descriptions:

NameTypeDescription
INSRULECATENT_IDBIGINT NOT NULLThe relationship id.
INSRULE_IDBIGINT NOT NULLThe related installment rule id.
CATENTRY_IDBIGINTThe related catalog entry id.
ASSOCTYPESMALLINT NOT NULL DEFAULT 0The association type. 0 = Inclusion 1 = Exclusion
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>INSRULECATENT_IDPrimary Key
I0001330INSRULE_ID+CATENTRY_IDNon-Unique Index
I0001331CATENTRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3621INSRULE_IDINSRULEINSRULE_IDCascade
F_3622CATENTRY_IDCATENTRYCATENTRY_IDCascade