tables

144 rows where database_id = 11

- 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
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
201	MetObjects 11	Geography Type_value_fts_docsize	128	0	1
202	MetObjects 11	Geography Type_value_fts_stat	1	0	1	value
203	MetObjects 11	City	2569	1	0	value
204	MetObjects 11	City_value_fts	2569	1	1
205	MetObjects 11	City_value_fts_segments	8	0	1
206	MetObjects 11	City_value_fts_segdir	1	0	1
207	MetObjects 11	City_value_fts_docsize	2569	0	1
208	MetObjects 11	City_value_fts_stat	1	0	1	value
209	MetObjects 11	State	103	1	0	value
210	MetObjects 11	State_value_fts	103	1	1
211	MetObjects 11	State_value_fts_segments	0	0	1
212	MetObjects 11	State_value_fts_segdir	1	0	1
213	MetObjects 11	State_value_fts_docsize	103	0	1
214	MetObjects 11	State_value_fts_stat	1	0	1	value
215	MetObjects 11	County	1139	1	0	value
216	MetObjects 11	County_value_fts	1139	1	1
217	MetObjects 11	County_value_fts_segments	4	0	1
218	MetObjects 11	County_value_fts_segdir	1	0	1
219	MetObjects 11	County_value_fts_docsize	1139	0	1
220	MetObjects 11	County_value_fts_stat	1	0	1	value
221	MetObjects 11	Country	1079	1	0	value
222	MetObjects 11	Country_value_fts	1079	1	1
223	MetObjects 11	Country_value_fts_segments	4	0	1
224	MetObjects 11	Country_value_fts_segdir	1	0	1
225	MetObjects 11	Country_value_fts_docsize	1079	0	1
226	MetObjects 11	Country_value_fts_stat	1	0	1	value
227	MetObjects 11	Region	788	1	0	value
228	MetObjects 11	Region_value_fts	788	1	1
229	MetObjects 11	Region_value_fts_segments	3	0	1
230	MetObjects 11	Region_value_fts_segdir	1	0	1
231	MetObjects 11	Region_value_fts_docsize	788	0	1
232	MetObjects 11	Region_value_fts_stat	1	0	1	value
233	MetObjects 11	Subregion	370	1	0	value
234	MetObjects 11	Subregion_value_fts	370	1	1
235	MetObjects 11	Subregion_value_fts_segments	2	0	1
236	MetObjects 11	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)
        );