create table track
(
    id                            serial           not null,
    person_id                     integer          not null,
    location_timestamp            timestamp        not null,
    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_person   
        foreign key (person_id) references person(id)
);