fixtures2

Custom SQL query

Queries

Tables

123_starts_with_digits

content

0 rows

Table With Space In Name

pk, content

0 rows

attraction_characteristic

pk, name

2 rows

binary_data

data

3 rows

complex_foreign_keys

pk, f1, f2, f3

1 row

compound_primary_key

pk1, pk2, content

2 rows

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, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n

15 rows

foreign_key_references

pk, foreign_key_with_label, foreign_key_with_blank_label, foreign_key_with_no_label, foreign_key_compound_pk1, foreign_key_compound_pk2

2 rows

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

roadside_attraction_characteristics

attraction_id, characteristic_id

5 rows

roadside_attractions

pk, name, address, url, latitude, longitude

4 rows

searchable

pk, text1, text2, name with . and spaces

2 rows

searchable_fts

text1, text2, name with . and spaces, searchable_fts, docid, __langid

2 rows

searchable_tags

searchable_id, tag

2 rows

select

group, having, and, json

1 row

simple_primary_key

id, content

5 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

... and 4 hidden tables

Views

Download SQLite DB: fixtures2.db 252.0 KB