CATENTSUBS

Each row in this table represents the subscription related information for a catalog entry.

Column Descriptions:

NameTypeDescription
CATENTRY_IDBIGINT NOT NULLThe catalog entry ID
SUBSCPTYPE_IDCHAR (32) NOT NULL DEFAULT 'NONE'The type of the subscription this catalog entry can be subscribed to.
DISALLOW_REC_ORDERINTEGER NOT NULL DEFAULT 0Indicates whether this catalog entry is prohibited from being purchased through recurring order. Default value is 0.
0
No
1
Yes
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>CATENTRY_IDPrimary Key
I0001358SUBSCPTYPE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3644CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_3645SUBSCPTYPE_IDSUBSCPTYPESUBSCPTYPE_IDCascade