home / fixtures

Menu

fixtures

Test tables description

23 tables5 views4 queries249.9 kB

Custom SQL query

Queries

4 queries →
  • magic_parameters select :_header_user_agent as user_agent, :_now_datetime_utc as datetime
  • pragma_cache_size PRAGMA cache_size;
  • Search neighborhoods
  • 𝐜𝐢𝐭𝐢𝐞𝐬 select id, name from facet_cities order by id limit 1;

Tables and views

Schema →
  • 123_starts_with_digits 0 rows

    content

  • Table With Space In Name 0 rows

    pk, content

  • attraction_characteristic 2 rows

    pk, name

    links to roadside_attraction_characteristics

  • binary_data 3 rows

    data

  • complex_foreign_keys 1 row

    pk, f1, f2, f3

    links to simple_primary_key

  • compound_primary_key 3 rows

    pk1, pk2, content

  • compound_three_primary_keys 1,001 rows

    pk1, pk2, pk3, content

  • custom_foreign_key_label 1 row

    pk, foreign_key_with_custom_label

    links to primary_key_multiple_columns_explicit_label

  • facet_cities 4 rows

    id, name

    links to facetable

  • facetable 15 rows

    pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n

    links to facet_cities

  • foreign_key_references 2 rows

    pk, foreign_key_with_label, foreign_key_with_blank_label, foreign_key_with_no_label, foreign_key_compound_pk1, foreign_key_compound_pk2

    links to primary_key_multiple_columns, simple_primary_key

  • infinity 3 rows

    value

  • primary_key_multiple_columns 1 row

    id, content, content2

    links to foreign_key_references

  • primary_key_multiple_columns_explicit_label 1 row

    id, content, content2

    links to custom_foreign_key_label

  • roadside_attraction_characteristics 5 rows

    attraction_id, characteristic_id

    links to attraction_characteristic, roadside_attractions

  • roadside_attractions 4 rows

    pk, name, address, url, latitude, longitude

    links to roadside_attraction_characteristics

  • searchable 2 rows

    pk, text1, text2, name with . and spaces

    full-text searchlinks to searchable_tags

  • searchable_tags 2 rows

    searchable_id, tag

    links to searchable, tags

  • select 1 row

    group, having, and, json

  • simple_primary_key 5 rows

    id, content

    links to complex_foreign_keys, foreign_key_references

  • sortable 201 rows

    pk1, pk2, content, sortable, sortable_with_nulls, sortable_with_nulls_2, text

  • table/with/slashes.csv 1 row

    pk, content

  • tags 2 rows

    tag

    links to searchable_tags

  • binary_data_view view
  • paginated_view view
  • searchable_view view
  • searchable_view_configured_by_metadata view
  • simple_view view

… and 2 hidden tables

Download SQLite database 249.9 kB

Powered by Datasette