tables

144 rows where database_id = 12

View and edit SQL

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

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
        );
Powered by Datasette · Query took 14.657ms