fixtures

Test tables description

Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette

Custom SQL query returning 101 rows (hide)

tablecidnametypenotnulldflt_valuepkhidden
simple_primary_key 0 id varchar(30) 0   1 0
simple_primary_key 1 content text 0   0 0
primary_key_multiple_columns 0 id varchar(30) 0   1 0
primary_key_multiple_columns 1 content text 0   0 0
primary_key_multiple_columns 2 content2 text 0   0 0
primary_key_multiple_columns_explicit_label 0 id varchar(30) 0   1 0
primary_key_multiple_columns_explicit_label 1 content text 0   0 0
primary_key_multiple_columns_explicit_label 2 content2 text 0   0 0
compound_primary_key 0 pk1 varchar(30) 0   1 0
compound_primary_key 1 pk2 varchar(30) 0   2 0
compound_primary_key 2 content text 0   0 0
compound_three_primary_keys 0 pk1 varchar(30) 0   1 0
compound_three_primary_keys 1 pk2 varchar(30) 0   2 0
compound_three_primary_keys 2 pk3 varchar(30) 0   3 0
compound_three_primary_keys 3 content text 0   0 0
foreign_key_references 0 pk varchar(30) 0   1 0
foreign_key_references 1 foreign_key_with_label varchar(30) 0   0 0
foreign_key_references 2 foreign_key_with_blank_label varchar(30) 0   0 0
foreign_key_references 3 foreign_key_with_no_label varchar(30) 0   0 0
foreign_key_references 4 foreign_key_compound_pk1 varchar(30) 0   0 0
foreign_key_references 5 foreign_key_compound_pk2 varchar(30) 0   0 0
sortable 0 pk1 varchar(30) 0   1 0
sortable 1 pk2 varchar(30) 0   2 0
sortable 2 content text 0   0 0
sortable 3 sortable integer 0   0 0
sortable 4 sortable_with_nulls real 0   0 0
sortable 5 sortable_with_nulls_2 real 0   0 0
sortable 6 text text 0   0 0
no_primary_key 0 content text 0   0 0
no_primary_key 1 a text 0   0 0
no_primary_key 2 b text 0   0 0
no_primary_key 3 c text 0   0 0
123_starts_with_digits 0 content text 0   0 0
Table With Space In Name 0 pk varchar(30) 0   1 0
Table With Space In Name 1 content text 0   0 0
table/with/slashes.csv 0 pk varchar(30) 0   1 0
table/with/slashes.csv 1 content text 0   0 0
complex_foreign_keys 0 pk varchar(30) 0   1 0
complex_foreign_keys 1 f1 text 0   0 0
complex_foreign_keys 2 f2 text 0   0 0
complex_foreign_keys 3 f3 text 0   0 0
custom_foreign_key_label 0 pk varchar(30) 0   1 0
custom_foreign_key_label 1 foreign_key_with_custom_label text 0   0 0
units 0 pk integer 0   1 0
units 1 distance int 0   0 0
units 2 frequency int 0   0 0
tags 0 tag TEXT 0   1 0
searchable 0 pk integer 0   1 0
searchable 1 text1 text 0   0 0
searchable 2 text2 text 0   0 0
searchable 3 name with . and spaces text 0   0 0
searchable_tags 0 searchable_id integer 0   1 0
searchable_tags 1 tag text 0   2 0
searchable_fts 0 text1   0   0 0
searchable_fts 1 text2   0   0 0
searchable_fts 2 name with . and spaces   0   0 0
searchable_fts 3 searchable_fts   0   0 1
searchable_fts 4 docid   0   0 1
searchable_fts 5 __langid   0   0 1
searchable_fts_segments 0 blockid INTEGER 0   1 0
searchable_fts_segments 1 block BLOB 0   0 0
searchable_fts_segdir 0 level INTEGER 0   1 0
searchable_fts_segdir 1 idx INTEGER 0   2 0
searchable_fts_segdir 2 start_block INTEGER 0   0 0
searchable_fts_segdir 3 leaves_end_block INTEGER 0   0 0
searchable_fts_segdir 4 end_block INTEGER 0   0 0
searchable_fts_segdir 5 root BLOB 0   0 0
searchable_fts_docsize 0 docid INTEGER 0   1 0
searchable_fts_docsize 1 size BLOB 0   0 0
searchable_fts_stat 0 id INTEGER 0   1 0
searchable_fts_stat 1 value BLOB 0   0 0
select 0 group text 0   0 0
select 1 having text 0   0 0
select 2 and text 0   0 0
select 3 json text 0   0 0
infinity 0 value REAL 0   0 0
facet_cities 0 id integer 0   1 0
facet_cities 1 name text 0   0 0
facetable 0 pk integer 0   1 0
facetable 1 created text 0   0 0
facetable 2 planet_int integer 0   0 0
facetable 3 on_earth integer 0   0 0
facetable 4 state text 0   0 0
facetable 5 city_id integer 0   0 0
facetable 6 neighborhood text 0   0 0
facetable 7 tags text 0   0 0
facetable 8 complex_array text 0   0 0
facetable 9 distinct_some_null   0   0 0
binary_data 0 data BLOB 0   0 0
roadside_attractions 0 pk integer 0   1 0
roadside_attractions 1 name text 0   0 0
roadside_attractions 2 address text 0   0 0
roadside_attractions 3 latitude real 0   0 0
roadside_attractions 4 longitude real 0   0 0
attraction_characteristic 0 pk integer 0   1 0
attraction_characteristic 1 name text 0   0 0
roadside_attraction_characteristics 0 attraction_id INTEGER 0   0 0
roadside_attraction_characteristics 1 characteristic_id INTEGER 0   0 0
generated_columns 0 body TEXT 0   0 0
generated_columns 1 id INT GENERATED ALWAYS 0   0 3
generated_columns 2 consideration INT GENERATED ALWAYS 0   0 3