fixtures

Test tables description

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

Custom SQL query returning 18 rows (hide)

tablecidnametypenotnulldflt_valuepkhidden
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
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
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