virts_geometry_columns_auth

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_auth (
virt_name TEXT NOT NULL,
virt_geometry TEXT NOT NULL,
hidden INTEGER NOT NULL,
CONSTRAINT pk_vrtgc_auth PRIMARY KEY (virt_name, virt_geometry),
CONSTRAINT fk_vrtgc_auth FOREIGN KEY (virt_name, virt_geometry) REFERENCES virts_geometry_columns (virt_name, virt_geometry) ON DELETE CASCADE,
CONSTRAINT ck_vrtgc_hidden CHECK (hidden IN (0,1)));
CREATE INDEX [idx_virts_geometry_columns_auth_virt_name]
    ON [virts_geometry_columns_auth] ([virt_name]);
CREATE INDEX [idx_virts_geometry_columns_auth_virt_geometry]
    ON [virts_geometry_columns_auth] ([virt_geometry]);