This data as json, CSV (advanced)
Suggested facets: count, has_fts, is_hidden
id ▼ | database_id | name | count | has_fts | is_hidden | label_column |
---|---|---|---|---|---|---|
1 | regmem 1 | people | 1421 | 0 | 0 | name |
2 | regmem 1 | members | 2677 | 0 | 0 | |
3 | regmem 1 | categories | 54 | 0 | 0 | |
4 | regmem 1 | items | 1384575 | 1 | 0 | |
5 | regmem 1 | items_fts_segments | 6223 | 0 | 1 | |
6 | regmem 1 | items_fts_segdir | 1 | 0 | 1 | |
7 | regmem 1 | items_fts_docsize | 1384575 | 0 | 1 | |
8 | regmem 1 | items_fts_stat | 1 | 0 | 1 | value |
9 | regmem 1 | items_fts | 0 | 1 | 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) );