Charge Points

Name	Data Type	Description
cp_id	INTEGER	id of the charge point
user_id	INTEGER	the id of the user that the charge point is assigned to
serial_number	VARCHAR	Serial number of charge point
powerbank_id	INTEGER	Grid service provider's id
team_id	INTEGER	ID of the team
operator_id	INTEGER	Unique ID of the operator
operator_name	VARCHAR	Name of the operator
parent_operator_id	INTEGER	Unique ID of the parent operator
active_at	TIMESTAMP	timestamp on which the charge point was active
created_at	TIMESTAMP	timestamp when the charge point was created
updated_at	TIMESTAMP	timestamp of latest update
last_active_at	TIMESTAMP	timestamp of the last time the charging point was active
first_active_at	TIMESTAMP	timestamp of the first time charging point was active
deleted_at	TIMESTAMP	time of deletion of charge point
site_name	VARCHAR	Name of the site where charge point is located
address1	VARCHAR	1st address line of the cp location
address2	VARCHAR	2nd address line of the cp location
address3	VARCHAR	3rd address line of the cp location
zip	VARCHAR	zip code of the cp location
city	VARCHAR	city of cp location
country	VARCHAR	country of cp location
longitude	FLOAT	Longitude of the charge point's location
latitude	FLOAT	Latitude of the charge point's location
cp_name	VARCHAR	Name of the charge point
identifier	VARCHAR	Identifier of the charge point
state	VARCHAR	State of the charge point - can be available, passive and busy
visibility	VARCHAR	Visibility of the charge point - can be public or private
type	VARCHAR	Type of the charge point - can be ac or dc
external_id	VARCHAR	external id of the charge point
cp_model_name	VARCHAR	Model of the brand manufacturer of charge point
cp_brand_name	VARCHAR	Brand name of the charge point
smart_charge_setting	VARCHAR	Setting for the smart charge
smart_charge_priority_price	FLOAT	Price priority for smart charge
smart_charge_priority_co2	FLOAT	CO2 priority for smart charge
smart_charge_priority_renewable	FLOAT	Renewable priority for smart charge
is_roaming_charge_point	BOOLEAN	Boolean for whether the charge point is a roaming one
sponsor_operator_id	INTEGER	ID of the sponsor
parent_operator_id	INTEGER	ID of the parent operator