google_place_visits

0 rows where place_visit_id = 1

✎ View and edit SQL

This data as json

0 records

CREATE TABLE `google_place_visits` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`center_lat_e7` integer,`center_lng_e7` integer,`duration_end_timestamp_ms` datetime,`duration_start_timestamp_ms` datetime,`edit_confirmation_status` text,`location_address` text,`location_latitude_e7` integer,`location_location_confidence` real,`location_longitude_e7` integer,`location_name` text,`location_place_id` text,`location_source_info_device_tag` integer,`place_confidence` text,`visit_confidence` integer,`place_visit_id` integer,PRIMARY KEY (`id`),CONSTRAINT `fk_google_place_visits_place_visit` FOREIGN KEY (`place_visit_id`) REFERENCES `google_place_visits`(`id`),CONSTRAINT `fk_google_place_visits_child_visits` FOREIGN KEY (`place_visit_id`) REFERENCES `google_place_visits`(`id`));
CREATE INDEX `idx_google_place_visits_deleted_at` ON `google_place_visits`(`deleted_at`);
CREATE UNIQUE INDEX `google_place_visits_key` ON `google_place_visits`(`center_lat_e7`,`center_lng_e7`,`duration_end_timestamp_ms`,`duration_start_timestamp_ms`,`location_place_id`);