SQL Schema Explorer by Tim Abell

sqlite-chinook

InvoiceLine

Nearest Tables

Tap a table in the diagram to jump straight to it. Tap & drag in a gap to pan around. Tap & drag a table to re-arrange the diagram.

Tap the "enable zoom" button, then use the mouse wheel to zoom in to where the mouse pointer is.

Customised table layout is not remembered. Refresh the page to reset the diagram.

Columns

Name Type Nulls Outbound Foreign Key Inbound Foreign Keys Indexes
Primary Key InvoiceLineId INTEGER NOT NULL IPK_InvoiceLine
InvoiceId INTEGER NOT NULL Invoice(InvoiceId) IFK_InvoiceLineInvoiceId
TrackId INTEGER NOT NULL Track(TrackId) IFK_InvoiceLineTrackId
UnitPrice NUMERIC(10,2) NOT NULL
Quantity INTEGER NOT NULL

Foreign Keys

Outbound

From To
TrackId Track(TrackId)
InvoiceId Invoice(InvoiceId)

Indexes

Name Columns Unique
IFK_InvoiceLineTrackId TrackId
IFK_InvoiceLineInvoiceId InvoiceId
IPK_InvoiceLine InvoiceLineId Unique

Data

Skip to Data Controls Show just the data
InvoiceLineId 1
InvoiceId 1
TrackId 2Balls to the Wall
UnitPrice 0.99
Quantity 1
InvoiceLineId 2
InvoiceId 1
TrackId 4Restless and Wild
UnitPrice 0.99
Quantity 1
InvoiceLineId 3
InvoiceId 2
TrackId 6Put The Finger On You
UnitPrice 0.99
Quantity 1
InvoiceLineId 4
InvoiceId 2
TrackId 8Inject The Venom
UnitPrice 0.99
Quantity 1
InvoiceLineId 5
InvoiceId 2
TrackId 10Evil Walks
UnitPrice 0.99
Quantity 1
InvoiceLineId 6
InvoiceId 2
TrackId 12Breaking The Rules
UnitPrice 0.99
Quantity 1
InvoiceLineId 7
InvoiceId 3
TrackId 16Dog Eat Dog
UnitPrice 0.99
Quantity 1
InvoiceLineId 8
InvoiceId 3
TrackId 20Overdose
UnitPrice 0.99
Quantity 1
InvoiceLineId 9
InvoiceId 3
TrackId 24Love In An Elevator
UnitPrice 0.99
Quantity 1
InvoiceLineId 10
InvoiceId 3
TrackId 28Janie's Got A Gun
UnitPrice 0.99
Quantity 1
InvoiceLineId 11
InvoiceId 3
TrackId 32Deuces Are Wild
UnitPrice 0.99
Quantity 1
InvoiceLineId 12
InvoiceId 3
TrackId 36Angel
UnitPrice 0.99
Quantity 1
InvoiceLineId 13
InvoiceId 4
TrackId 42Right Through You
UnitPrice 0.99
Quantity 1
InvoiceLineId 14
InvoiceId 4
TrackId 48Not The Doctor
UnitPrice 0.99
Quantity 1
InvoiceLineId 15
InvoiceId 4
TrackId 54Bleed The Freak
UnitPrice 0.99
Quantity 1
InvoiceLineId 16
InvoiceId 4
TrackId 60Confusion
UnitPrice 0.99
Quantity 1
InvoiceLineId 17
InvoiceId 4
TrackId 66Por Causa De Você
UnitPrice 0.99
Quantity 1
InvoiceLineId 18
InvoiceId 4
TrackId 72Angela
UnitPrice 0.99
Quantity 1
InvoiceLineId 19
InvoiceId 4
TrackId 78Master Of Puppets
UnitPrice 0.99
Quantity 1
InvoiceLineId 20
InvoiceId 4
TrackId 84Welcome Home (Sanitarium)
UnitPrice 0.99
Quantity 1
InvoiceLineId 21
InvoiceId 4
TrackId 90Set It Off
UnitPrice 0.99
Quantity 1
InvoiceLineId 22
InvoiceId 5
TrackId 99Your Time Has Come
UnitPrice 0.99
Quantity 1
InvoiceLineId 23
InvoiceId 5
TrackId 108Dandelion
UnitPrice 0.99
Quantity 1
InvoiceLineId 24
InvoiceId 5
TrackId 117Rock 'N' Roll Music
UnitPrice 0.99
Quantity 1
InvoiceLineId 25
InvoiceId 5
TrackId 126Moon germs
UnitPrice 0.99
Quantity 1
InvoiceLineId 26
InvoiceId 5
TrackId 135Super Terrorizer
UnitPrice 0.99
Quantity 1
InvoiceLineId 27
InvoiceId 5
TrackId 144Heart Of Gold
UnitPrice 0.99
Quantity 1
InvoiceLineId 28
InvoiceId 5
TrackId 153Evil Woman
UnitPrice 0.99
Quantity 1
InvoiceLineId 29
InvoiceId 5
TrackId 162Cornucopia
UnitPrice 0.99
Quantity 1
InvoiceLineId 30
InvoiceId 5
TrackId 171Bowels Of The Devil
UnitPrice 0.99
Quantity 1
InvoiceLineId 31
InvoiceId 5
TrackId 180Body Count Anthem
UnitPrice 0.99
Quantity 1
InvoiceLineId 32
InvoiceId 5
TrackId 189Jerusalem
UnitPrice 0.99
Quantity 1
InvoiceLineId 33
InvoiceId 5
TrackId 198When My Left Eye Jumps
UnitPrice 0.99
Quantity 1
InvoiceLineId 34
InvoiceId 5
TrackId 207Meditação
UnitPrice 0.99
Quantity 1
InvoiceLineId 35
InvoiceId 5
TrackId 216Esse Cara
UnitPrice 0.99
Quantity 1
InvoiceLineId 36
InvoiceId 6
TrackId 230Bye, Bye Brasil
UnitPrice 0.99
Quantity 1
InvoiceLineId 37
InvoiceId 7
TrackId 231Atras Da Porta
UnitPrice 0.99
Quantity 1
InvoiceLineId 38
InvoiceId 7
TrackId 232Tatuagem
UnitPrice 0.99
Quantity 1
InvoiceLineId 39
InvoiceId 8
TrackId 234Morena De Angola
UnitPrice 0.99
Quantity 1
InvoiceLineId 40
InvoiceId 8
TrackId 236A Banda
UnitPrice 0.99
Quantity 1
InvoiceLineId 41
InvoiceId 9
TrackId 238Com Açúcar E Com Afeto
UnitPrice 0.99
Quantity 1
InvoiceLineId 42
InvoiceId 9
TrackId 240Meu Caro Amigo
UnitPrice 0.99
Quantity 1
InvoiceLineId 43
InvoiceId 9
TrackId 242Trocando Em Miúdos
UnitPrice 0.99
Quantity 1
InvoiceLineId 44
InvoiceId 9
TrackId 244Gota D'água
UnitPrice 0.99
Quantity 1
InvoiceLineId 45
InvoiceId 10
TrackId 248Etnia
UnitPrice 0.99
Quantity 1
InvoiceLineId 46
InvoiceId 10
TrackId 252Samba Do Lado
UnitPrice 0.99
Quantity 1
InvoiceLineId 47
InvoiceId 10
TrackId 256Sobremesa
UnitPrice 0.99
Quantity 1
InvoiceLineId 48
InvoiceId 10
TrackId 260Sangue De Bairro
UnitPrice 0.99
Quantity 1
InvoiceLineId 49
InvoiceId 10
TrackId 264Amor De Muito
UnitPrice 0.99
Quantity 1
InvoiceLineId 50
InvoiceId 10
TrackId 268Maracatu Atômico [Trip Hop]
UnitPrice 0.99
Quantity 1
InvoiceLineId 51
InvoiceId 11
TrackId 274Samba Makossa
UnitPrice 0.99
Quantity 1
InvoiceLineId 52
InvoiceId 11
TrackId 280Lixo Do Mangue
UnitPrice 0.99
Quantity 1
InvoiceLineId 53
InvoiceId 11
TrackId 286Firmamento
UnitPrice 0.99
Quantity 1
InvoiceLineId 54
InvoiceId 11
TrackId 292Já Foi
UnitPrice 0.99
Quantity 1
InvoiceLineId 55
InvoiceId 11
TrackId 298A Cor Do Sol
UnitPrice 0.99
Quantity 1
InvoiceLineId 56
InvoiceId 11
TrackId 304Firmamento
UnitPrice 0.99
Quantity 1
InvoiceLineId 57
InvoiceId 11
TrackId 310Sábado A Noite
UnitPrice 0.99
Quantity 1
InvoiceLineId 58
InvoiceId 11
TrackId 316Linha Do Equador
UnitPrice 0.99
Quantity 1
InvoiceLineId 59
InvoiceId 11
TrackId 322Livre Pra Viver
UnitPrice 0.99
Quantity 1
InvoiceLineId 60
InvoiceId 12
TrackId 331Lavadeira
UnitPrice 0.99
Quantity 1
InvoiceLineId 61
InvoiceId 12
TrackId 340Dazed and Confused
UnitPrice 0.99
Quantity 1
InvoiceLineId 62
InvoiceId 12
TrackId 349You Shook Me(2)
UnitPrice 0.99
Quantity 1
InvoiceLineId 63
InvoiceId 12
TrackId 358Man With The Woman Head
UnitPrice 0.99
Quantity 1
InvoiceLineId 64
InvoiceId 12
TrackId 367Leandro De Itaquera 2001
UnitPrice 0.99
Quantity 1
InvoiceLineId 65
InvoiceId 12
TrackId 376Vôo Sobre o Horizonte
UnitPrice 0.99
Quantity 1
InvoiceLineId 66
InvoiceId 12
TrackId 385All Star
UnitPrice 0.99
Quantity 1
InvoiceLineId 67
InvoiceId 12
TrackId 394Tanto Tempo
UnitPrice 0.99
Quantity 1
InvoiceLineId 68
InvoiceId 12
TrackId 403Bumbo Da Mangueira
UnitPrice 0.99
Quantity 1
InvoiceLineId 69
InvoiceId 12
TrackId 412Die Die My Darling
UnitPrice 0.99
Quantity 1
InvoiceLineId 70
InvoiceId 12
TrackId 421Radio GA GA
UnitPrice 0.99
Quantity 1
InvoiceLineId 71
InvoiceId 12
TrackId 430I'm Going Slightly Mad
UnitPrice 0.99
Quantity 1
InvoiceLineId 72
InvoiceId 12
TrackId 439Sure Know Something
UnitPrice 0.99
Quantity 1
InvoiceLineId 73
InvoiceId 12
TrackId 448God Of Thunder
UnitPrice 0.99
Quantity 1
InvoiceLineId 74
InvoiceId 13
TrackId 462Valentino's
UnitPrice 0.99
Quantity 1
InvoiceLineId 75
InvoiceId 14
TrackId 463Believe
UnitPrice 0.99
Quantity 1
InvoiceLineId 76
InvoiceId 14
TrackId 464As We Sleep
UnitPrice 0.99
Quantity 1
InvoiceLineId 77
InvoiceId 15
TrackId 466J Squared
UnitPrice 0.99
Quantity 1
InvoiceLineId 78
InvoiceId 15
TrackId 468Maria
UnitPrice 0.99
Quantity 1
InvoiceLineId 79
InvoiceId 16
TrackId 470Longview
UnitPrice 0.99
Quantity 1
InvoiceLineId 80
InvoiceId 16
TrackId 472Basket Case
UnitPrice 0.99
Quantity 1
InvoiceLineId 81
InvoiceId 16
TrackId 474She
UnitPrice 0.99
Quantity 1
InvoiceLineId 82
InvoiceId 16
TrackId 476Geek Stink Breath
UnitPrice 0.99
Quantity 1
InvoiceLineId 83
InvoiceId 17
TrackId 480Stuck With Me
UnitPrice 0.99
Quantity 1
InvoiceLineId 84
InvoiceId 17
TrackId 484Nice Guys Finish Last
UnitPrice 0.99
Quantity 1
InvoiceLineId 85
InvoiceId 17
TrackId 488Macy's Day Parade
UnitPrice 0.99
Quantity 1
InvoiceLineId 86
InvoiceId 17
TrackId 492Don't You Cry
UnitPrice 0.99
Quantity 1
InvoiceLineId 87
InvoiceId 17
TrackId 496Living On Love
UnitPrice 0.99
Quantity 1
InvoiceLineId 88
InvoiceId 17
TrackId 500Wherever You May Go
UnitPrice 0.99
Quantity 1
InvoiceLineId 89
InvoiceId 18
TrackId 506Diga Lá, Coração
UnitPrice 0.99
Quantity 1
InvoiceLineId 90
InvoiceId 18
TrackId 512Comportamento Geral
UnitPrice 0.99
Quantity 1
InvoiceLineId 91
InvoiceId 18
TrackId 518Podres Poderes
UnitPrice 0.99
Quantity 1
InvoiceLineId 92
InvoiceId 18
TrackId 524Queixa
UnitPrice 0.99
Quantity 1
InvoiceLineId 93
InvoiceId 18
TrackId 530Ando Meio Desligado
UnitPrice 0.99
Quantity 1
InvoiceLineId 94
InvoiceId 18
TrackId 536Vida De Cachorro
UnitPrice 0.99
Quantity 1
InvoiceLineId 95
InvoiceId 18
TrackId 542Meu Refrigerador Não Funciona
UnitPrice 0.99
Quantity 1
InvoiceLineId 96
InvoiceId 18
TrackId 548Smoke On The Water
UnitPrice 0.99
Quantity 1
InvoiceLineId 97
InvoiceId 18
TrackId 554Trampled Under Foot
UnitPrice 0.99
Quantity 1
InvoiceLineId 98
InvoiceId 19
TrackId 563União Da Ilha
UnitPrice 0.99
Quantity 1
InvoiceLineId 99
InvoiceId 19
TrackId 572Put Your Lights On
UnitPrice 0.99
Quantity 1
InvoiceLineId 100
InvoiceId 19
TrackId 581Primavera
UnitPrice 0.99
Quantity 1
Page
No earlier pages
Next Page >
2240 rows in table
100 rows shown
Showing rows 1 to 100

Display
Switch to table view
^ top