home / fixtures

compound_three_primary_keys

52 rows where pk2 = "i"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pk1, pk3

Link pk1 pk2 pk3 content
a,i,a a i a a-i-a
a,i,b a i b a-i-b
a,i,c a i c a-i-c
a,i,d a i d a-i-d
a,i,e a i e a-i-e
a,i,f a i f a-i-f
a,i,g a i g a-i-g
a,i,h a i h a-i-h
a,i,i a i i a-i-i
a,i,j a i j a-i-j
a,i,k a i k a-i-k
a,i,l a i l a-i-l
a,i,m a i m a-i-m
a,i,n a i n a-i-n
a,i,o a i o a-i-o
a,i,p a i p a-i-p
a,i,q a i q a-i-q
a,i,r a i r a-i-r
a,i,s a i s a-i-s
a,i,t a i t a-i-t
a,i,u a i u a-i-u
a,i,v a i v a-i-v
a,i,w a i w a-i-w
a,i,x a i x a-i-x
a,i,y a i y a-i-y
a,i,z a i z a-i-z
b,i,a b i a b-i-a
b,i,b b i b b-i-b
b,i,c b i c b-i-c
b,i,d b i d b-i-d
b,i,e b i e b-i-e
b,i,f b i f b-i-f
b,i,g b i g b-i-g
b,i,h b i h b-i-h
b,i,i b i i b-i-i
b,i,j b i j b-i-j
b,i,k b i k b-i-k
b,i,l b i l b-i-l
b,i,m b i m b-i-m
b,i,n b i n b-i-n
b,i,o b i o b-i-o
b,i,p b i p b-i-p
b,i,q b i q b-i-q
b,i,r b i r b-i-r
b,i,s b i s b-i-s
b,i,t b i t b-i-t
b,i,u b i u b-i-u
b,i,v b i v b-i-v
b,i,w b i w b-i-w
b,i,x b i x b-i-x
b,i,y b i y b-i-y
b,i,z b i z b-i-z

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE compound_three_primary_keys (
  pk1 varchar(30),
  pk2 varchar(30),
  pk3 varchar(30),
  content text,
  PRIMARY KEY (pk1, pk2, pk3)
);
CREATE INDEX idx_compound_three_primary_keys_content ON compound_three_primary_keys(content);
Powered by Datasette · Queries took 4.934ms