tables

10 rows where database_id = 6

descending

id ▼	database_id	name	count	has_fts	is_hidden	label_column
61	food-trucks 6	Applicant	131	0	0	value
62	food-trucks 6	FacilityType	2	0	0	value
63	food-trucks 6	block	414	0	0	value
64	food-trucks 6	Status	6	0	0	value
65	food-trucks 6	Mobile_Food_Facility_Permit	673	1	0
66	food-trucks 6	Mobile_Food_Facility_Permit_fts	673	1	1
67	food-trucks 6	Mobile_Food_Facility_Permit_fts_segments	28	0	1
68	food-trucks 6	Mobile_Food_Facility_Permit_fts_segdir	1	0	1
69	food-trucks 6	Mobile_Food_Facility_Permit_fts_docsize	673	0	1
70	food-trucks 6	Mobile_Food_Facility_Permit_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)
        );