virts_geometry_columns_statistics

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

This data as json, copyable

0 records

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);
CREATE INDEX [idx_virts_geometry_columns_statistics_virt_name]
    ON [virts_geometry_columns_statistics] ([virt_name]);
CREATE INDEX [idx_virts_geometry_columns_statistics_virt_geometry]
    ON [virts_geometry_columns_statistics] ([virt_geometry]);