tables

12 rows where database_id = 5

descending

id ▼	database_id	name	count	has_fts	is_hidden	label_column
49	sf-trees 5	PlantType	3	0	0	value
50	sf-trees 5	qCaretaker	21	0	0	value
51	sf-trees 5	qSiteInfo	31	0	0	value
52	sf-trees 5	qSpecies	562	0	0	value
53	sf-trees 5	qCareAssistant	15	0	0	value
54	sf-trees 5	qLegalStatus	9	0	0	value
55	sf-trees 5	Street_Tree_List	189144	1	0
56	sf-trees 5	Street_Tree_List_fts	189144	1	1
57	sf-trees 5	Street_Tree_List_fts_segments	1570	0	1
58	sf-trees 5	Street_Tree_List_fts_segdir	5	0	1
59	sf-trees 5	Street_Tree_List_fts_docsize	189144	0	1
60	sf-trees 5	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)
        );