views_geometry_columns

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

This data as json, copyable

0 records

CREATE TABLE views_geometry_columns (
view_name TEXT NOT NULL,
view_geometry TEXT NOT NULL,
view_rowid TEXT NOT NULL,
f_table_name TEXT NOT NULL,
f_geometry_column TEXT NOT NULL,
read_only INTEGER NOT NULL,
CONSTRAINT pk_geom_cols_views PRIMARY KEY (view_name, view_geometry),
CONSTRAINT fk_views_geom_cols FOREIGN KEY (f_table_name, f_geometry_column) REFERENCES geometry_columns (f_table_name, f_geometry_column) ON DELETE CASCADE,
CONSTRAINT ck_vw_rdonly CHECK (read_only IN (0,1)));
CREATE INDEX idx_viewsjoin ON views_geometry_columns
(f_table_name, f_geometry_column);
CREATE INDEX [idx_views_geometry_columns_f_table_name]
    ON [views_geometry_columns] ([f_table_name]);
CREATE INDEX [idx_views_geometry_columns_f_geometry_column]
    ON [views_geometry_columns] ([f_geometry_column]);