home / cryptids

views_geometry_columns_auth

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

View and edit SQL

Link view_name view_geometry hidden
CREATE TABLE views_geometry_columns_auth (
view_name TEXT NOT NULL,
view_geometry TEXT NOT NULL,
hidden INTEGER NOT NULL,
CONSTRAINT pk_vwgc_auth PRIMARY KEY (view_name, view_geometry),
CONSTRAINT fk_vwgc_auth FOREIGN KEY (view_name, view_geometry) REFERENCES views_geometry_columns (view_name, view_geometry) ON DELETE CASCADE,
CONSTRAINT ck_vwgc_hidden CHECK (hidden IN (0,1)))
Powered by Datasette · Query took 2.525ms · Data license: CC Attribution 4.0 License · Data source: simonw/cryptozoology