This data as json, CSV (advanced)
Suggested facets: count, has_fts, is_hidden, label_column
id ▼ | database_id | name | count | has_fts | is_hidden | label_column |
---|---|---|---|---|---|---|
425 | wtr 13 | spatial_ref_sys | 4924 | 0 | 1 | |
426 | wtr 13 | spatialite_history | 13 | 0 | 1 | |
427 | wtr 13 | sqlite_sequence | 1 | 0 | 1 | |
428 | wtr 13 | geometry_columns | 1 | 0 | 1 | |
429 | wtr 13 | spatial_ref_sys_aux | 4873 | 0 | 1 | |
430 | wtr 13 | views_geometry_columns | 0 | 0 | 1 | |
431 | wtr 13 | virts_geometry_columns | 0 | 0 | 1 | |
432 | wtr 13 | geometry_columns_statistics | 1 | 0 | 1 | |
433 | wtr 13 | views_geometry_columns_statistics | 0 | 0 | 1 | |
434 | wtr 13 | virts_geometry_columns_statistics | 0 | 0 | 1 | |
435 | wtr 13 | geometry_columns_field_infos | 0 | 0 | 1 | |
436 | wtr 13 | views_geometry_columns_field_infos | 0 | 0 | 1 | |
437 | wtr 13 | virts_geometry_columns_field_infos | 0 | 0 | 1 | |
438 | wtr 13 | geometry_columns_time | 1 | 0 | 1 | |
439 | wtr 13 | geometry_columns_auth | 1 | 0 | 1 | |
440 | wtr 13 | views_geometry_columns_auth | 0 | 0 | 1 | |
441 | wtr 13 | virts_geometry_columns_auth | 0 | 0 | 1 | |
442 | wtr 13 | sql_statements_log | 0 | 0 | 1 | |
443 | wtr 13 | SpatialIndex | 0 | 0 | 1 | |
444 | wtr 13 | ElementaryGeometries | 0 | 0 | 1 | |
445 | wtr 13 | KNN | 0 | 0 | 0 | |
446 | wtr 13 | licensee | 28936 | 1 | 0 | name |
447 | wtr 13 | product | 63 | 0 | 0 | name |
448 | wtr 13 | license | 79116 | 0 | 0 | |
449 | wtr 13 | license_frequency | 371188 | 1 | 0 | |
450 | wtr 13 | licensee_fts | 28936 | 1 | 1 | |
451 | wtr 13 | licensee_fts_segments | 122 | 0 | 1 | |
452 | wtr 13 | licensee_fts_segdir | 2 | 0 | 1 | |
453 | wtr 13 | licensee_fts_docsize | 28936 | 0 | 1 | |
454 | wtr 13 | licensee_fts_stat | 1 | 0 | 1 | value |
455 | wtr 13 | license_frequency_fts | 371188 | 1 | 1 | |
456 | wtr 13 | license_frequency_fts_segments | 1110 | 0 | 1 | |
457 | wtr 13 | license_frequency_fts_segdir | 10 | 0 | 1 | |
458 | wtr 13 | license_frequency_fts_docsize | 371188 | 0 | 1 | |
459 | wtr 13 | license_frequency_fts_stat | 1 | 0 | 1 | value |
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) );