SUBSCPTYPE

This table defines all possible types of subscription a catalog entry can be subscribed to.

Column Descriptions:

NameTypeDescription
SUBSCPTYPE_IDCHAR (32) NOT NULL DEFAULT 'NONE'The identifier of the subscription type that a catalog entry can be subscribed to. The supported types are
  • NONE
  • TIME-BASED
  • EVENT-BASED
  • TIME-EVENT-BASED
DESCRIPTIONVARCHAR (254)An administrative description of the subscription type.
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>SUBSCPTYPE_IDPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3645SUBSCPTYPE_IDCATENTSUBSSUBSCPTYPE_IDCascade
F_3647SUBSCPTYPE_IDSUBSCRIPTIONSUBSCPTYPE_IDCascade