geometry_columns_time
Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api
2 rows sorted by last_insert
This data as json, CSV (advanced)
Suggested facets: last_update (date)
Link | f_table_name | f_geometry_column | last_insert ▼ | last_update | last_delete |
---|---|---|---|---|---|
timezones,geometry | timezones | geometry | 2023-01-08T20:29:50.875Z | 0000-01-01T00:00:00.000Z | 0000-01-01T00:00:00.000Z |
countries,geometry | countries | geometry | 2023-01-08T20:29:58.458Z | 0000-01-01T00:00:00.000Z | 0000-01-01T00:00:00.000Z |
Advanced export
JSON shape: default, array, newline-delimited, object
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);