Plans [WIP]

This table contains the value selected for subscription plans.

NameData TypeDescription
plan_idINTEGERPrimary key, unique ID for the plan
country_idINTEGERID of the country
operator_idINTEGERID of the operator
parent_operator_idINTEGERID of the parent operator, or NULL if the operator itself is a parent operator
plan_nameSTRINGName of the plan
support_emailSTRINGSupport email
identifierSTRINGIdentifying string typically
serviceSTRING
modelsSTRINGWhere 'all' or 'selected' charge point models are included in plan
plan_forSTRINGIntended target for the plan - 'charge_point' , 'team', or 'operator'
price_modelSTRINGType of price model
min_unitsINTEGER
contract_urlSTRINGURL to the contract
active_subscription_countINTEGER
prices_with_vatBOOLEANTrue if prices include VAT
deleted_atTIMESTAMPNull if plan is not deleted