test
Tables (13)
addresses
- id — integer — NOT NULL
- display_name — character
- latitude — numeric(8,6)
- longitude — numeric(9,6)
- name — character
- house_number — character
- road — character
- neighbourhood — character
- city — character
- county — character
- postcode — character
- state — character
- state_district — character
- country — character
- raw — jsonb
- inserted_at — timestamp(0) — NOT NULL
- updated_at — timestamp(0) — NOT NULL
- osm_id — bigint
- osm_type — text
car_settings
- id — bigint — NOT NULL
- suspend_min — integer — NOT NULL
- suspend_after_idle_min — integer — NOT NULL
- req_not_unlocked — boolean — NOT NULL
- free_supercharging — boolean — NOT NULL
- use_streaming_api — boolean — NOT NULL
- enabled — boolean — NOT NULL
- lfp_battery — boolean — NOT NULL
cars
- id — smallint — NOT NULL
- eid — bigint — NOT NULL
- vid — bigint — NOT NULL
- model — character
- efficiency — double
- inserted_at — timestamp(0) — NOT NULL
- updated_at — timestamp(0) — NOT NULL
- vin — text
- name — text
- trim_badging — text
- settings_id — bigint — NOT NULL
- exterior_color — text
- spoiler_type — text
- wheel_type — text
- display_priority — smallint — NOT NULL
- marketing_name — character
charges
- id — integer — NOT NULL
- date — timestamp — NOT NULL
- battery_heater_on — boolean
- battery_level — smallint
- charge_energy_added — numeric(8,2) — NOT NULL
- charger_actual_current — smallint
- charger_phases — smallint
- charger_pilot_current — smallint
- charger_power — smallint — NOT NULL
- charger_voltage — smallint
- fast_charger_present — boolean
- conn_charge_cable — character
- fast_charger_brand — character
- fast_charger_type — character
- ideal_battery_range_km — numeric(6,2) — NOT NULL
- not_enough_power_to_heat — boolean
- outside_temp — numeric(4,1)
- charging_process_id — integer — NOT NULL
- battery_heater — boolean
- battery_heater_no_power — boolean
- rated_battery_range_km — numeric(6,2)
- usable_battery_level — smallint
charging_processes
- id — integer — NOT NULL
- start_date — timestamp — NOT NULL
- end_date — timestamp
- charge_energy_added — numeric(8,2)
- start_ideal_range_km — numeric(6,2)
- end_ideal_range_km — numeric(6,2)
- start_battery_level — smallint
- end_battery_level — smallint
- duration_min — smallint
- outside_temp_avg — numeric(4,1)
- car_id — smallint — NOT NULL
- position_id — integer — NOT NULL
- address_id — integer
- start_rated_range_km — numeric(6,2)
- end_rated_range_km — numeric(6,2)
- geofence_id — integer
- charge_energy_used — numeric(8,2)
- cost — numeric(6,2)
drives
- id — integer — NOT NULL
- start_date — timestamp — NOT NULL
- end_date — timestamp
- outside_temp_avg — numeric(4,1)
- speed_max — smallint
- power_max — smallint
- power_min — smallint
- start_ideal_range_km — numeric(6,2)
- end_ideal_range_km — numeric(6,2)
- start_km — double
- end_km — double
- distance — double
- duration_min — smallint
- car_id — smallint — NOT NULL
- inside_temp_avg — numeric(4,1)
- start_address_id — integer
- end_address_id — integer
- start_rated_range_km — numeric(6,2)
- end_rated_range_km — numeric(6,2)
- start_position_id — integer
- end_position_id — integer
- start_geofence_id — integer
- end_geofence_id — integer
geofences
- id — integer — NOT NULL
- name — character — NOT NULL
- latitude — numeric(8,6) — NOT NULL
- longitude — numeric(9,6) — NOT NULL
- radius — smallint — NOT NULL
- inserted_at — timestamp(0) — NOT NULL
- updated_at — timestamp(0) — NOT NULL
- cost_per_unit — numeric(6,4)
- session_fee — numeric(6,2)
- billing_type — public.billing_type — NOT NULL
positions
- id — integer — NOT NULL
- date — timestamp — NOT NULL
- latitude — numeric(8,6) — NOT NULL
- longitude — numeric(9,6) — NOT NULL
- speed — smallint
- power — smallint
- odometer — double
- ideal_battery_range_km — numeric(6,2)
- battery_level — smallint
- outside_temp — numeric(4,1)
- elevation — smallint
- fan_status — integer
- driver_temp_setting — numeric(4,1)
- passenger_temp_setting — numeric(4,1)
- is_climate_on — boolean
- is_rear_defroster_on — boolean
- is_front_defroster_on — boolean
- car_id — smallint — NOT NULL
- drive_id — integer
- inside_temp — numeric(4,1)
- battery_heater — boolean
- battery_heater_on — boolean
- battery_heater_no_power — boolean
- est_battery_range_km — numeric(6,2)
- rated_battery_range_km — numeric(6,2)
- usable_battery_level — smallint
- tpms_pressure_fl — numeric(4,1)
- tpms_pressure_fr — numeric(4,1)
- tpms_pressure_rl — numeric(4,1)
- tpms_pressure_rr — numeric(4,1)
schema_migrations
- version — bigint — NOT NULL
- inserted_at — timestamp(0)
settings
- id — bigint — NOT NULL
- inserted_at — timestamp(0) — NOT NULL
- updated_at — timestamp(0) — NOT NULL
- unit_of_length — public.unit_of_length — NOT NULL
- unit_of_temperature — public.unit_of_temperature — NOT NULL
- preferred_range — public.range — NOT NULL
- base_url — character
- grafana_url — character
- language — text — NOT NULL
- unit_of_pressure — public.unit_of_pressure — NOT NULL
states
- id — integer — NOT NULL
- state — public.states_status — NOT NULL
- start_date — timestamp — NOT NULL
- end_date — timestamp
- car_id — smallint — NOT NULL
tokens
- id — integer — NOT NULL
- inserted_at — timestamp(0) — NOT NULL
- updated_at — timestamp(0) — NOT NULL
- refresh — bytea
- access — bytea
updates
- id — integer — NOT NULL
- start_date — timestamp — NOT NULL
- end_date — timestamp
- version — character
- car_id — smallint — NOT NULL