tables

144 rows where database_id = 12

- 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
281	MetObjects 12	Department	20	1	0	value
282	MetObjects 12	Department_value_fts	20	1	1
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
287	MetObjects 12	Object Name	27381	1	0	value
288	MetObjects 12	Object Name_value_fts	27381	1	1
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
293	MetObjects 12	Culture	7132	1	0	value
294	MetObjects 12	Culture_value_fts	7132	1	1
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
299	MetObjects 12	Dynasty	348	1	0	value
300	MetObjects 12	Dynasty_value_fts	348	1	1
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
305	MetObjects 12	Reign	366	1	0	value
306	MetObjects 12	Reign_value_fts	366	1	1
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
311	MetObjects 12	Portfolio	3044	1	0	value
312	MetObjects 12	Portfolio_value_fts	3044	1	1
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
317	MetObjects 12	Artist Role	6090	1	0	value
318	MetObjects 12	Artist Role_value_fts	6090	1	1
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
323	MetObjects 12	Artist Alpha Sort	59247	1	0	value
324	MetObjects 12	Artist Alpha Sort_value_fts	59247	1	1
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
329	MetObjects 12	Artist Nationality	3806	1	0	value
330	MetObjects 12	Artist Nationality_value_fts	3806	1	1
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
335	MetObjects 12	Medium	63888	1	0	value
336	MetObjects 12	Medium_value_fts	63888	1	1
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
341	MetObjects 12	Geography Type	128	1	0	value
342	MetObjects 12	Geography Type_value_fts	128	1	1
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
347	MetObjects 12	City	2569	1	0	value
348	MetObjects 12	City_value_fts	2569	1	1
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
353	MetObjects 12	State	103	1	0	value
354	MetObjects 12	State_value_fts	103	1	1
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
359	MetObjects 12	County	1139	1	0	value
360	MetObjects 12	County_value_fts	1139	1	1
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
365	MetObjects 12	Country	1079	1	0	value
366	MetObjects 12	Country_value_fts	1079	1	1
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
371	MetObjects 12	Region	788	1	0	value
372	MetObjects 12	Region_value_fts	788	1	1
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
377	MetObjects 12	Subregion	370	1	0	value
378	MetObjects 12	Subregion_value_fts	370	1	1
379	MetObjects 12	Subregion_value_fts_segments	2	0	1
380	MetObjects 12	Subregion_value_fts_segdir	1	0	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)
        );