tables

20 rows where database_id = 14

descending

id ▼	database_id	name	count	has_fts	is_hidden	label_column
460	merlin 14	description	7012	1	0	name
461	merlin 14	unit	5970	1	0	name
462	merlin 14	contract	6793	0	0	name
463	merlin 14	vehicle	230849	1	0
464	merlin 14	vehicle_history	1004918	0	0
465	merlin 14	description_fts	7012	1	1
466	merlin 14	description_fts_segments	80	0	1
467	merlin 14	description_fts_segdir	1	0	1
468	merlin 14	description_fts_docsize	7012	0	1
469	merlin 14	description_fts_stat	1	0	1	value
470	merlin 14	unit_fts	5970	1	1
471	merlin 14	unit_fts_segments	28	0	1
472	merlin 14	unit_fts_segdir	1	0	1
473	merlin 14	unit_fts_docsize	5970	0	1
474	merlin 14	unit_fts_stat	1	0	1	value
475	merlin 14	vehicle_fts	230849	1	1
476	merlin 14	vehicle_fts_segments	2045	0	1
477	merlin 14	vehicle_fts_segdir	14	0	1
478	merlin 14	vehicle_fts_docsize	230346	0	1
479	merlin 14	vehicle_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)
        );