fixtures
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
This data as json, testall, testnone, testresponse, CSV
table | id | seq | table | from | to | on_update | on_delete | match |
---|---|---|---|---|---|---|---|---|
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 |