fixtures

Test tables description

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

Custom SQL query returning 14 rows (hide)

tableidseqtablefromtoon_updateon_deletematch
foreign_key_references 0 0 compound_primary_key foreign_key_compound_pk1 pk1 NO ACTION NO ACTION NONE
foreign_key_references 0 1 compound_primary_key foreign_key_compound_pk2 pk2 NO ACTION NO ACTION NONE
foreign_key_references 1 0 primary_key_multiple_columns foreign_key_with_no_label id NO ACTION NO ACTION NONE
foreign_key_references 2 0 simple_primary_key foreign_key_with_blank_label id NO ACTION NO ACTION NONE
foreign_key_references 3 0 simple_primary_key foreign_key_with_label id NO ACTION NO ACTION NONE
complex_foreign_keys 0 0 simple_primary_key f3 id NO ACTION NO ACTION NONE
complex_foreign_keys 1 0 simple_primary_key f2 id NO ACTION NO ACTION NONE
complex_foreign_keys 2 0 simple_primary_key f1 id NO ACTION NO ACTION NONE
custom_foreign_key_label 0 0 primary_key_multiple_columns_explicit_label foreign_key_with_custom_label id NO ACTION NO ACTION NONE
searchable_tags 0 0 tags tag tag NO ACTION NO ACTION NONE
searchable_tags 1 0 searchable searchable_id pk NO ACTION NO ACTION NONE
facetable 0 0 facet_cities city_id id NO ACTION NO ACTION NONE
roadside_attraction_characteristics 0 0 attraction_characteristic characteristic_id pk NO ACTION NO ACTION NONE
roadside_attraction_characteristics 1 0 roadside_attractions attraction_id pk NO ACTION NO ACTION NONE