home / cryptids

geometry_columns_time

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

2 rows sorted by f_table_name

View and edit SQL

Link f_table_name ▼ f_geometry_column last_insert last_update last_delete
cryptids geom 2018-10-16T21:54:00.134Z 0000-01-01T00:00:00.000Z 0000-01-01T00:00:00.000Z
cryptids range 2018-10-16T21:54:00.134Z 0000-01-01T00:00:00.000Z 0000-01-01T00:00:00.000Z

Advanced export

JSON shape: default, array, object

CSV options:

CREATE TABLE geometry_columns_time (
f_table_name TEXT NOT NULL,
f_geometry_column TEXT NOT NULL,
last_insert TIMESTAMP NOT NULL DEFAULT '0000-01-01T00:00:00.000Z',
last_update TIMESTAMP NOT NULL DEFAULT '0000-01-01T00:00:00.000Z',
last_delete TIMESTAMP NOT NULL DEFAULT '0000-01-01T00:00:00.000Z',
CONSTRAINT pk_gc_time PRIMARY KEY (f_table_name, f_geometry_column),
CONSTRAINT fk_gc_time 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 3.177ms · Data license: CC Attribution 4.0 License · Data source: simonw/cryptozoology