tables

144 rows where database_id = 12

View and edit SQL

id ▼ database_id name count has_fts is_hidden label_column
381 MetObjects 12 Subregion_value_fts_docsize 370 0 1  
382 MetObjects 12 Subregion_value_fts_stat 1 0 1 value
383 MetObjects 12 Locale 831 1 0 value
384 MetObjects 12 Locale_value_fts 831 1 1  
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
389 MetObjects 12 Locus 1322 1 0 value
390 MetObjects 12 Locus_value_fts 1322 1 1  
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
395 MetObjects 12 Excavation 339 1 0 value
396 MetObjects 12 Excavation_value_fts 339 1 1  
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
401 MetObjects 12 River 229 1 0 value
402 MetObjects 12 River_value_fts 229 1 1  
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
407 MetObjects 12 Classification 1201 1 0 value
408 MetObjects 12 Classification_value_fts 1201 1 1  
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
413 MetObjects 12 Repository 1 1 0 value
414 MetObjects 12 Repository_value_fts 1 1 1  
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
419 MetObjects 12 MetObjects 464360 1 0  
420 MetObjects 12 MetObjects_fts 464360 1 1  
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

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