yongin_cleancar

Tables (6)

car

  • Key (car_num) — character varying(100) — Primary key — NOT NULL
  • Field (car_type) — character varying(100)

gps_temp

  • Field (car_num) — character varying(100)
  • Field (date) — date
  • Field (time) — time without time zone
  • Field (lon) — character varying(500)
  • Field (lat) — character varying(500)

noise_temp

  • Field (car_num) — character varying(100)
  • Field (date) — date
  • Field (time) — time without time zone
  • Field (noise) — numeric

points

  • Key (gid) — integer — Primary key — NOT NULL
  • lon — character varying(500)
  • Field2 (lat) — character varying(500)
  • Field3 (date) — character varying(100)
  • Field (time) — time without time zone
  • Field (geom) — geometry
  • Field (car_num) — character varying(100)
  • Field (noise) — integer
  • Field (rpm) — integer

rpm_temp

  • Field (car_num) — character varying(100)
  • Field (date) — date
  • Field (time) — time without time zone
  • Field (rpm) — numeric

temp

  • Field (latitude) — character varying(500)
  • Field (longitude) — character varying(500)
  • Field (date) — date
  • Field (time) — time without time zone