tables

12 rows where database_id = 9

descending

id ▼	database_id	name	count	has_fts	is_hidden	label_column
100	sf-trees 9	PlantType	3	0	0	value
101	sf-trees 9	qCaretaker	21	0	0	value
102	sf-trees 9	qSiteInfo	31	0	0	value
103	sf-trees 9	qSpecies	562	0	0	value
104	sf-trees 9	qCareAssistant	15	0	0	value
105	sf-trees 9	qLegalStatus	9	0	0	value
106	sf-trees 9	Street_Tree_List	189144	1	0
107	sf-trees 9	Street_Tree_List_fts	189144	1	1
108	sf-trees 9	Street_Tree_List_fts_segments	1570	0	1
109	sf-trees 9	Street_Tree_List_fts_segdir	5	0	1
110	sf-trees 9	Street_Tree_List_fts_docsize	189144	0	1
111	sf-trees 9	Street_Tree_List_fts_stat	1	0	1	value

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