tables

479 rows

descending

id ▼	database_id	name	count	has_fts	is_hidden	label_column
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
112	timezones 10	spatial_ref_sys	4924	0	1
113	timezones 10	spatialite_history	14	0	1
114	timezones 10	sqlite_sequence	3	0	1
115	timezones 10	geometry_columns	1	0	1
116	timezones 10	spatial_ref_sys_aux	4873	0	1
117	timezones 10	views_geometry_columns	0	0	1
118	timezones 10	virts_geometry_columns	0	0	1
119	timezones 10	geometry_columns_statistics	1	0	1
120	timezones 10	views_geometry_columns_statistics	0	0	1
121	timezones 10	virts_geometry_columns_statistics	0	0	1
122	timezones 10	geometry_columns_field_infos	0	0	1
123	timezones 10	views_geometry_columns_field_infos	0	0	1
124	timezones 10	virts_geometry_columns_field_infos	0	0	1
125	timezones 10	geometry_columns_time	1	0	1
126	timezones 10	geometry_columns_auth	1	0	1
127	timezones 10	views_geometry_columns_auth	0	0	1
128	timezones 10	virts_geometry_columns_auth	0	0	1
129	timezones 10	sql_statements_log	1	0	1
130	timezones 10	SpatialIndex	0	0	1
131	timezones 10	ElementaryGeometries	0	0	1
132	timezones 10	timezones	439	0	0
133	timezones 10	idx_timezones_Geometry	439	0	1
134	timezones 10	idx_timezones_Geometry_node	13	0	1
135	timezones 10	idx_timezones_Geometry_rowid	439	0	1
136	timezones 10	idx_timezones_Geometry_parent	12	0	1
137	MetObjects 11	Department	20	1	0	value
138	MetObjects 11	Department_value_fts	20	1	1
139	MetObjects 11	Department_value_fts_segments	0	0	1
140	MetObjects 11	Department_value_fts_segdir	1	0	1
141	MetObjects 11	Department_value_fts_docsize	20	0	1
142	MetObjects 11	Department_value_fts_stat	1	0	1	value
143	MetObjects 11	Object Name	27381	1	0	value
144	MetObjects 11	Object Name_value_fts	27381	1	1
145	MetObjects 11	Object Name_value_fts_segments	97	0	1
146	MetObjects 11	Object Name_value_fts_segdir	1	0	1
147	MetObjects 11	Object Name_value_fts_docsize	27381	0	1
148	MetObjects 11	Object Name_value_fts_stat	1	0	1	value
149	MetObjects 11	Culture	7132	1	0	value
150	MetObjects 11	Culture_value_fts	7132	1	1
151	MetObjects 11	Culture_value_fts_segments	27	0	1
152	MetObjects 11	Culture_value_fts_segdir	1	0	1
153	MetObjects 11	Culture_value_fts_docsize	7132	0	1
154	MetObjects 11	Culture_value_fts_stat	1	0	1	value
155	MetObjects 11	Dynasty	348	1	0	value
156	MetObjects 11	Dynasty_value_fts	348	1	1
157	MetObjects 11	Dynasty_value_fts_segments	2	0	1
158	MetObjects 11	Dynasty_value_fts_segdir	1	0	1
159	MetObjects 11	Dynasty_value_fts_docsize	348	0	1
160	MetObjects 11	Dynasty_value_fts_stat	1	0	1	value
161	MetObjects 11	Reign	366	1	0	value
162	MetObjects 11	Reign_value_fts	366	1	1
163	MetObjects 11	Reign_value_fts_segments	2	0	1
164	MetObjects 11	Reign_value_fts_segdir	1	0	1
165	MetObjects 11	Reign_value_fts_docsize	366	0	1
166	MetObjects 11	Reign_value_fts_stat	1	0	1	value
167	MetObjects 11	Portfolio	3044	1	0	value
168	MetObjects 11	Portfolio_value_fts	3044	1	1
169	MetObjects 11	Portfolio_value_fts_segments	27	0	1
170	MetObjects 11	Portfolio_value_fts_segdir	1	0	1
171	MetObjects 11	Portfolio_value_fts_docsize	3044	0	1
172	MetObjects 11	Portfolio_value_fts_stat	1	0	1	value
173	MetObjects 11	Artist Role	6090	1	0	value
174	MetObjects 11	Artist Role_value_fts	6090	1	1
175	MetObjects 11	Artist Role_value_fts_segments	17	0	1
176	MetObjects 11	Artist Role_value_fts_segdir	1	0	1
177	MetObjects 11	Artist Role_value_fts_docsize	6090	0	1
178	MetObjects 11	Artist Role_value_fts_stat	1	0	1	value
179	MetObjects 11	Artist Alpha Sort	59247	1	0	value
180	MetObjects 11	Artist Alpha Sort_value_fts	59247	1	1
181	MetObjects 11	Artist Alpha Sort_value_fts_segments	405	0	1
182	MetObjects 11	Artist Alpha Sort_value_fts_segdir	4	0	1
183	MetObjects 11	Artist Alpha Sort_value_fts_docsize	59247	0	1
184	MetObjects 11	Artist Alpha Sort_value_fts_stat	1	0	1	value
185	MetObjects 11	Artist Nationality	3806	1	0	value
186	MetObjects 11	Artist Nationality_value_fts	3806	1	1
187	MetObjects 11	Artist Nationality_value_fts_segments	14	0	1
188	MetObjects 11	Artist Nationality_value_fts_segdir	1	0	1
189	MetObjects 11	Artist Nationality_value_fts_docsize	3806	0	1
190	MetObjects 11	Artist Nationality_value_fts_stat	1	0	1	value
191	MetObjects 11	Medium	63888	1	0	value
192	MetObjects 11	Medium_value_fts	63888	1	1
193	MetObjects 11	Medium_value_fts_segments	341	0	1
194	MetObjects 11	Medium_value_fts_segdir	2	0	1
195	MetObjects 11	Medium_value_fts_docsize	63888	0	1
196	MetObjects 11	Medium_value_fts_stat	1	0	1	value
197	MetObjects 11	Geography Type	128	1	0	value
198	MetObjects 11	Geography Type_value_fts	128	1	1
199	MetObjects 11	Geography Type_value_fts_segments	0	0	1
200	MetObjects 11	Geography Type_value_fts_segdir	1	0	1

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