subscription_plan_schedule_item
A plan schedule item represents an entry in a subscription's plan schedule. A plan schedule is ordered by start date & start time and specifies the plan (and options) which is active for a subscription at a time. To find the accounting plan schedule item entry active at a given timestamp use the psiattime(integer, timestamp) function. Plan schedule items can be considered instances of plans.
| Column name | Description | Data type |
|---|---|---|
| plan_schedule_item | Primary key. | integer * |
| plan_schedule | Reference to subscription_plan_schedule. | integer * |
| plan_schedule_type | integer | |
| subscription | Reference to subscription. | integer * |
| plan | character varying (8) * | |
| start_time | The start of this plan. This can be null if the subscription isn't activated yet, so we don't know the start date. | timestamp with time zone * |
| end_time | timestamp with time zone * |