home / cryptids

virts_geometry_columns_statistics

Data license: CC Attribution 4.0 License · Data source: simonw/cryptozoology

View and edit SQL

Link virt_name virt_geometry last_verified row_count extent_min_x extent_min_y extent_max_x extent_max_y
CREATE TABLE virts_geometry_columns_statistics (
virt_name TEXT NOT NULL,
virt_geometry TEXT NOT NULL,
last_verified TIMESTAMP,
row_count INTEGER,
extent_min_x DOUBLE,
extent_min_y DOUBLE,
extent_max_x DOUBLE,
extent_max_y DOUBLE,
CONSTRAINT pk_vrtgc_statistics PRIMARY KEY (virt_name, virt_geometry),
CONSTRAINT fk_vrtgc_statistics FOREIGN KEY (virt_name, virt_geometry) REFERENCES virts_geometry_columns (virt_name, virt_geometry) ON DELETE CASCADE)
Powered by Datasette · Query took 40.028ms · Data license: CC Attribution 4.0 License · Data source: simonw/cryptozoology