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