fixtures
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
This data as json, testall, testnone, testresponse, CSV
name | cid | name | type | notnull | dflt_value | pk | hidden |
---|---|---|---|---|---|---|---|
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_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 | ||
facetable | 10 | n | text | 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 | url | text | 0 | 0 | 0 | |
roadside_attractions | 4 | latitude | real | 0 | 0 | 0 | |
roadside_attractions | 5 | 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 |