INSRULECATGRP

Each row in this table represents a relationship between an installment rule and a catalog group.

Column Descriptions:

NameTypeDescription
INSRULECATGRP_IDBIGINT NOT NULLThe relationship id.
INSRULE_IDBIGINT NOT NULLThe related installment rule id of this relationship.
CATGROUP_IDBIGINTThe related catalog group id of this relasionship.
ASSOCTYPESMALLINT NOT NULL DEFAULT 0The association type between a catalog group and an installment rule. 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>INSRULECATGRP_IDPrimary Key
I0001327INSRULECATGRP_ID+INSRULE_IDNon-Unique Index
I0001328INSRULE_IDNon-Unique Index
I0001329CATGROUP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3619INSRULE_IDINSRULEINSRULE_IDCascade
F_3620CATGROUP_IDCATGROUPCATGROUP_IDCascade