create table track
(
    id                                    serial not null,
    vehicle_id                            integer not null,
    location_timestamp                    timestamp not null,
    odometer_meters                       double precision,
    latitude                              double precision,
    longitude                             double precision,
    created_at                            timestamp not null default now(),
    updated_at                            timestamp,
    constraint track_primary_key          primary key(id),
    constraint foreign_key_track_vehicle  foreign key (vehicle_id) 
                                              references vehicle(id)
);