tables

144 rows where database_id = 12 sorted by has_fts

- remove filter - id database_id name count has_fts is_hidden label_column

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - id database_id name count has_fts is_hidden label_column

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by id Sort by database_id Sort by name Sort by count Sort by has_fts Sort by is_hidden Sort by label_column

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: has_fts, is_hidden

id	database_id	name	count	has_fts ▼	is_hidden	label_column
283	MetObjects 12	Department_value_fts_segments	0	0	1
284	MetObjects 12	Department_value_fts_segdir	1	0	1
285	MetObjects 12	Department_value_fts_docsize	20	0	1
286	MetObjects 12	Department_value_fts_stat	1	0	1	value
289	MetObjects 12	Object Name_value_fts_segments	97	0	1
290	MetObjects 12	Object Name_value_fts_segdir	1	0	1
291	MetObjects 12	Object Name_value_fts_docsize	27381	0	1
292	MetObjects 12	Object Name_value_fts_stat	1	0	1	value
295	MetObjects 12	Culture_value_fts_segments	27	0	1
296	MetObjects 12	Culture_value_fts_segdir	1	0	1
297	MetObjects 12	Culture_value_fts_docsize	7132	0	1
298	MetObjects 12	Culture_value_fts_stat	1	0	1	value
301	MetObjects 12	Dynasty_value_fts_segments	2	0	1
302	MetObjects 12	Dynasty_value_fts_segdir	1	0	1
303	MetObjects 12	Dynasty_value_fts_docsize	348	0	1
304	MetObjects 12	Dynasty_value_fts_stat	1	0	1	value
307	MetObjects 12	Reign_value_fts_segments	2	0	1
308	MetObjects 12	Reign_value_fts_segdir	1	0	1
309	MetObjects 12	Reign_value_fts_docsize	366	0	1
310	MetObjects 12	Reign_value_fts_stat	1	0	1	value
313	MetObjects 12	Portfolio_value_fts_segments	27	0	1
314	MetObjects 12	Portfolio_value_fts_segdir	1	0	1
315	MetObjects 12	Portfolio_value_fts_docsize	3044	0	1
316	MetObjects 12	Portfolio_value_fts_stat	1	0	1	value
319	MetObjects 12	Artist Role_value_fts_segments	17	0	1
320	MetObjects 12	Artist Role_value_fts_segdir	1	0	1
321	MetObjects 12	Artist Role_value_fts_docsize	6090	0	1
322	MetObjects 12	Artist Role_value_fts_stat	1	0	1	value
325	MetObjects 12	Artist Alpha Sort_value_fts_segments	405	0	1
326	MetObjects 12	Artist Alpha Sort_value_fts_segdir	4	0	1
327	MetObjects 12	Artist Alpha Sort_value_fts_docsize	59247	0	1
328	MetObjects 12	Artist Alpha Sort_value_fts_stat	1	0	1	value
331	MetObjects 12	Artist Nationality_value_fts_segments	14	0	1
332	MetObjects 12	Artist Nationality_value_fts_segdir	1	0	1
333	MetObjects 12	Artist Nationality_value_fts_docsize	3806	0	1
334	MetObjects 12	Artist Nationality_value_fts_stat	1	0	1	value
337	MetObjects 12	Medium_value_fts_segments	341	0	1
338	MetObjects 12	Medium_value_fts_segdir	2	0	1
339	MetObjects 12	Medium_value_fts_docsize	63888	0	1
340	MetObjects 12	Medium_value_fts_stat	1	0	1	value
343	MetObjects 12	Geography Type_value_fts_segments	0	0	1
344	MetObjects 12	Geography Type_value_fts_segdir	1	0	1
345	MetObjects 12	Geography Type_value_fts_docsize	128	0	1
346	MetObjects 12	Geography Type_value_fts_stat	1	0	1	value
349	MetObjects 12	City_value_fts_segments	8	0	1
350	MetObjects 12	City_value_fts_segdir	1	0	1
351	MetObjects 12	City_value_fts_docsize	2569	0	1
352	MetObjects 12	City_value_fts_stat	1	0	1	value
355	MetObjects 12	State_value_fts_segments	0	0	1
356	MetObjects 12	State_value_fts_segdir	1	0	1
357	MetObjects 12	State_value_fts_docsize	103	0	1
358	MetObjects 12	State_value_fts_stat	1	0	1	value
361	MetObjects 12	County_value_fts_segments	4	0	1
362	MetObjects 12	County_value_fts_segdir	1	0	1
363	MetObjects 12	County_value_fts_docsize	1139	0	1
364	MetObjects 12	County_value_fts_stat	1	0	1	value
367	MetObjects 12	Country_value_fts_segments	4	0	1
368	MetObjects 12	Country_value_fts_segdir	1	0	1
369	MetObjects 12	Country_value_fts_docsize	1079	0	1
370	MetObjects 12	Country_value_fts_stat	1	0	1	value
373	MetObjects 12	Region_value_fts_segments	3	0	1
374	MetObjects 12	Region_value_fts_segdir	1	0	1
375	MetObjects 12	Region_value_fts_docsize	788	0	1
376	MetObjects 12	Region_value_fts_stat	1	0	1	value
379	MetObjects 12	Subregion_value_fts_segments	2	0	1
380	MetObjects 12	Subregion_value_fts_segdir	1	0	1
381	MetObjects 12	Subregion_value_fts_docsize	370	0	1
382	MetObjects 12	Subregion_value_fts_stat	1	0	1	value
385	MetObjects 12	Locale_value_fts_segments	5	0	1
386	MetObjects 12	Locale_value_fts_segdir	1	0	1
387	MetObjects 12	Locale_value_fts_docsize	831	0	1
388	MetObjects 12	Locale_value_fts_stat	1	0	1	value
391	MetObjects 12	Locus_value_fts_segments	6	0	1
392	MetObjects 12	Locus_value_fts_segdir	1	0	1
393	MetObjects 12	Locus_value_fts_docsize	1322	0	1
394	MetObjects 12	Locus_value_fts_stat	1	0	1	value
397	MetObjects 12	Excavation_value_fts_segments	2	0	1
398	MetObjects 12	Excavation_value_fts_segdir	1	0	1
399	MetObjects 12	Excavation_value_fts_docsize	339	0	1
400	MetObjects 12	Excavation_value_fts_stat	1	0	1	value
403	MetObjects 12	River_value_fts_segments	0	0	1
404	MetObjects 12	River_value_fts_segdir	1	0	1
405	MetObjects 12	River_value_fts_docsize	229	0	1
406	MetObjects 12	River_value_fts_stat	1	0	1	value
409	MetObjects 12	Classification_value_fts_segments	4	0	1
410	MetObjects 12	Classification_value_fts_segdir	1	0	1
411	MetObjects 12	Classification_value_fts_docsize	1201	0	1
412	MetObjects 12	Classification_value_fts_stat	1	0	1	value
415	MetObjects 12	Repository_value_fts_segments	0	0	1
416	MetObjects 12	Repository_value_fts_segdir	1	0	1
417	MetObjects 12	Repository_value_fts_docsize	1	0	1
418	MetObjects 12	Repository_value_fts_stat	1	0	1	value
421	MetObjects 12	MetObjects_fts_segments	6536	0	1
422	MetObjects 12	MetObjects_fts_segdir	15	0	1
423	MetObjects 12	MetObjects_fts_docsize	464360	0	1
424	MetObjects 12	MetObjects_fts_stat	1	0	1	value
281	MetObjects 12	Department	20	1	0	value
282	MetObjects 12	Department_value_fts	20	1	1
287	MetObjects 12	Object Name	27381	1	0	value
288	MetObjects 12	Object Name_value_fts	27381	1	1

Next page

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