plan
Represents a plan, which is a header record for rating rules, recurring charges and more.
| Column name | Description | Data type |
|---|---|---|
| plan | Primary key. | character varying (8) |
| company | Primary key.
Reference to company. |
smallint |
| service | Reference to service. | integer * |
| name | text | |
| user_description | text * | |
| operator_description | text * | |
| is_suspension_plan | If true, then when a Subscription suspends their service they will end up on this plan. | boolean |
| first_available_date | Subscriptions are unable to switch to this plan before this date. | date * |
| last_available_date | Subscriptions are unable to switch to this plan after this date. | date * |