home / cryptids

views_geometry_columns

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

View and edit SQL

Link view_name view_geometry view_rowid f_table_name f_geometry_column read_only
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)))
Powered by Datasette · Query took 33.835ms · Data license: CC Attribution 4.0 License · Data source: simonw/cryptozoology