This data as json, CSV (advanced)
Suggested facets: count, is_hidden
id ▼ | database_id | name | count | has_fts | is_hidden | label_column |
---|---|---|---|---|---|---|
112 | timezones 10 | spatial_ref_sys | 4924 | 0 | 1 | |
113 | timezones 10 | spatialite_history | 14 | 0 | 1 | |
114 | timezones 10 | sqlite_sequence | 3 | 0 | 1 | |
115 | timezones 10 | geometry_columns | 1 | 0 | 1 | |
116 | timezones 10 | spatial_ref_sys_aux | 4873 | 0 | 1 | |
117 | timezones 10 | views_geometry_columns | 0 | 0 | 1 | |
118 | timezones 10 | virts_geometry_columns | 0 | 0 | 1 | |
119 | timezones 10 | geometry_columns_statistics | 1 | 0 | 1 | |
120 | timezones 10 | views_geometry_columns_statistics | 0 | 0 | 1 | |
121 | timezones 10 | virts_geometry_columns_statistics | 0 | 0 | 1 | |
122 | timezones 10 | geometry_columns_field_infos | 0 | 0 | 1 | |
123 | timezones 10 | views_geometry_columns_field_infos | 0 | 0 | 1 | |
124 | timezones 10 | virts_geometry_columns_field_infos | 0 | 0 | 1 | |
125 | timezones 10 | geometry_columns_time | 1 | 0 | 1 | |
126 | timezones 10 | geometry_columns_auth | 1 | 0 | 1 | |
127 | timezones 10 | views_geometry_columns_auth | 0 | 0 | 1 | |
128 | timezones 10 | virts_geometry_columns_auth | 0 | 0 | 1 | |
129 | timezones 10 | sql_statements_log | 1 | 0 | 1 | |
130 | timezones 10 | SpatialIndex | 0 | 0 | 1 | |
131 | timezones 10 | ElementaryGeometries | 0 | 0 | 1 | |
132 | timezones 10 | timezones | 439 | 0 | 0 | |
133 | timezones 10 | idx_timezones_Geometry | 439 | 0 | 1 | |
134 | timezones 10 | idx_timezones_Geometry_node | 13 | 0 | 1 | |
135 | timezones 10 | idx_timezones_Geometry_rowid | 439 | 0 | 1 | |
136 | timezones 10 | idx_timezones_Geometry_parent | 12 | 0 | 1 |
JSON shape: default, array, newline-delimited, object
CREATE TABLE tables ( id integer PRIMARY KEY, database_id integer, name text, count integer, has_fts integer, is_hidden integer, label_column text, FOREIGN KEY (database_id) REFERENCES databases(id) );