tables

20 rows where database_id = 14

View and edit SQL

Suggested facets: count, has_fts, is_hidden, label_column

id ▼ database_id name count has_fts is_hidden label_column
460 merlin 14 description 7012 1 0 name
461 merlin 14 unit 5970 1 0 name
462 merlin 14 contract 6793 0 0 name
463 merlin 14 vehicle 230849 1 0  
464 merlin 14 vehicle_history 1004918 0 0  
465 merlin 14 description_fts 7012 1 1  
466 merlin 14 description_fts_segments 80 0 1  
467 merlin 14 description_fts_segdir 1 0 1  
468 merlin 14 description_fts_docsize 7012 0 1  
469 merlin 14 description_fts_stat 1 0 1 value
470 merlin 14 unit_fts 5970 1 1  
471 merlin 14 unit_fts_segments 28 0 1  
472 merlin 14 unit_fts_segdir 1 0 1  
473 merlin 14 unit_fts_docsize 5970 0 1  
474 merlin 14 unit_fts_stat 1 0 1 value
475 merlin 14 vehicle_fts 230849 1 1  
476 merlin 14 vehicle_fts_segments 2045 0 1  
477 merlin 14 vehicle_fts_segdir 14 0 1  
478 merlin 14 vehicle_fts_docsize 230346 0 1  
479 merlin 14 vehicle_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 24.584ms