tables

13 rows where database_id = 4

descending

id ▼	database_id	name	count	has_fts	is_hidden	label_column
36	sf-film-locations 4	Title	307	0	0	value
37	sf-film-locations 4	Director	249	0	0	value
38	sf-film-locations 4	Writer	266	0	0	value
39	sf-film-locations 4	Release Year	75	0	0	value
40	sf-film-locations 4	Actors	551	0	0	value
41	sf-film-locations 4	Production Company	179	0	0	value
42	sf-film-locations 4	Distributor	119	0	0	value
43	sf-film-locations 4	Film_Locations_in_San_Francisco	1622	1	0
44	sf-film-locations 4	Film_Locations_in_San_Francisco_fts	1622	1	1
45	sf-film-locations 4	Film_Locations_in_San_Francisco_fts_segments	61	0	1
46	sf-film-locations 4	Film_Locations_in_San_Francisco_fts_segdir	1	0	1
47	sf-film-locations 4	Film_Locations_in_San_Francisco_fts_docsize	1622	0	1
48	sf-film-locations 4	Film_Locations_in_San_Francisco_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)
        );