home

fixtures

Test tables description

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

Custom SQL query

123_starts_with_digits

content

0 rows

Table With Space In Name

pk, content

0 rows

complex_foreign_keys

pk, f1, f2, f3

1 row

compound_primary_key

pk1, pk2, content

1 row

compound_three_primary_keys

pk1, pk2, pk3, content

1,001 rows

custom_foreign_key_label

pk, foreign_key_with_custom_label

1 row

facet_cities

id, name

4 rows

facetable

pk, planet_int, on_earth, state, city_id, neighborhood

15 rows

foreign_key_references

pk, foreign_key_with_label, foreign_key_with_no_label

1 row

infinity

value

3 rows

no_primary_key

content, a, b, c

201 rows

primary_key_multiple_columns

id, content, content2

1 row

primary_key_multiple_columns_explicit_label

id, content, content2

1 row

searchable

pk, text1, text2, name with . and spaces

2 rows

searchable_tags

searchable_id, tag

2 rows

select

group, having, and, json

1 row

simple_primary_key

id, content

4 rows

sortable

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

201 rows

table/with/slashes.csv

pk, content

1 row

tags

tag

2 rows

units

pk, distance, frequency

3 rows

searchable_fts (hidden)

text1, text2, name with . and spaces, content

2 rows

searchable_fts_content (hidden)

docid, c0text1, c1text2, c2name with . and spaces, c3content

2 rows

searchable_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

searchable_fts_segments (hidden)

blockid, block

0 rows

Views

Queries

Download SQLite DB: fixtures.db

Powered by Datasette · Query took 0.086ms · Data license: Apache License 2.0 · Data source: tests/fixtures.py