SUBSCRRENEW

This table is used to record the list of subscriptions that were created after renewal of existing subscriptions

Column Descriptions:

NameTypeDescription
RENEWEDSUBSCR_IDBIGINT NOT NULLThe ID of the new subscription that was created when another subscription renewed.
SUBSCRIPTION_IDBIGINT NOT NULLThe id of the subscription that was renewed.
TIMEPLACEDTIMESTAMP NOT NULLThe time this subscription renew record was created
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>RENEWEDSUBSCR_ID+SUBSCRIPTION_IDPrimary Key
I0001372SUBSCRIPTION_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3660RENEWEDSUBSCR_IDSUBSCRIPTIONSUBSCRIPTION_IDCascade
F_3661SUBSCRIPTION_IDSUBSCRIPTIONSUBSCRIPTION_IDCascade