SUBSCRSUSPEND

This table stores the suspend start and end dates of subscriptions or recurring order as specified by the shopper. Multiple suspension periods can be specified for the same subscription or recurring order.

Column Descriptions:

NameTypeDescription
SUSPEND_IDBIGINT NOT NULLGenerated unique key.
SUBSCRIPTION_IDBIGINT NOT NULLThe ID of the subscription or recurring order that needs to be suspended.
SUSPENDSTARTDATETIMESTAMPThe date from which the subscription or recurring order should be suspended, as specified by the shopper.
SUSPENDENDDATETIMESTAMPThe date from which the subscription or recurring order should be resumed, as specified by the shopper
FIELD1INTEGERCustomizable
FIELD2DECIMAL (20,5)Customizable
FIELD3VARCHAR (254)Customizable
TIMEPLACEDTIMESTAMP NOT NULLThe time this suspension 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>SUSPEND_IDPrimary Key
I0001366SUBSCRIPTION_ID+SUSPENDSTARTDATEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3653SUBSCRIPTION_IDSUBSCRIPTIONSUBSCRIPTION_IDCascade