virts_geometry_columns_field_infos

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_field_infos (
virt_name TEXT NOT NULL,
virt_geometry TEXT NOT NULL,
ordinal INTEGER NOT NULL,
column_name TEXT NOT NULL,
null_values INTEGER NOT NULL,
integer_values INTEGER NOT NULL,
double_values INTEGER NOT NULL,
text_values INTEGER NOT NULL,
blob_values INTEGER NOT NULL,
max_size INTEGER,
integer_min INTEGER,
integer_max INTEGER,
double_min DOUBLE,
double_max DOUBLE,
CONSTRAINT pk_vrtgcfld_infos PRIMARY KEY (virt_name, virt_geometry, ordinal, column_name),
CONSTRAINT fk_vrtgcfld_infos FOREIGN KEY (virt_name, virt_geometry) REFERENCES virts_geometry_columns (virt_name, virt_geometry) ON DELETE CASCADE);
CREATE INDEX [idx_virts_geometry_columns_field_infos_virt_name]
    ON [virts_geometry_columns_field_infos] ([virt_name]);
CREATE INDEX [idx_virts_geometry_columns_field_infos_virt_geometry]
    ON [virts_geometry_columns_field_infos] ([virt_geometry]);