tables

9 rows where database_id = 1

descending

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

Advanced export

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)
        );