fixtures

Query actions Query actions
Test tables description

Custom SQL query returning 106 rows (hide)

This data as json, testall, testnone, testresponse, CSV

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