tables

144 rows where database_id = 12 sorted by has_fts

View and edit SQL

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

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 17.892ms