home / cryptids

geometry_columns_field_infos

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

View and edit SQL

Link f_table_name f_geometry_column ordinal column_name null_values integer_values double_values text_values blob_values max_size integer_min integer_max double_min double_max
CREATE TABLE geometry_columns_field_infos (
f_table_name TEXT NOT NULL,
f_geometry_column 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_gcfld_infos PRIMARY KEY (f_table_name, f_geometry_column, ordinal, column_name),
CONSTRAINT fk_gcfld_infos FOREIGN KEY (f_table_name, f_geometry_column) REFERENCES geometry_columns (f_table_name, f_geometry_column) ON DELETE CASCADE)
Powered by Datasette · Query took 6.344ms · Data license: CC Attribution 4.0 License · Data source: simonw/cryptozoology