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:
| Name | Type | Description |
| SUSPEND_ID | BIGINT NOT NULL | Generated unique key. |
| SUBSCRIPTION_ID | BIGINT NOT NULL | The ID of the subscription or recurring order
that needs to be suspended. |
| SUSPENDSTARTDATE | TIMESTAMP | The date from which the subscription or recurring
order should be suspended, as specified by the shopper. |
| SUSPENDENDDATE | TIMESTAMP | The date from which the subscription or recurring
order should be resumed, as specified by the shopper |
| FIELD1 | INTEGER | Customizable |
| FIELD2 | DECIMAL (20,5) | Customizable |
| FIELD3 | VARCHAR (254) | Customizable |
| TIMEPLACED | TIMESTAMP NOT NULL | The time this suspension record was created. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | SUSPEND_ID | Primary Key |
| I0001366 | SUBSCRIPTION_ID+SUSPENDSTARTDATE | Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3653 | SUBSCRIPTION_ID | SUBSCRIPTION | SUBSCRIPTION_ID | Cascade |