123

Tables (13)

Album

  • AlbumId — INTEGER — Primary key — NOT NULL
  • Title — NVARCHAR(160) — NOT NULL
  • ArtistId — INTEGER — Foreign key → Artist.ArtistId — NOT NULL
  • Column1 — BLOB

Artist

  • ArtistId — INTEGER — Primary key — NOT NULL
  • Name — NVARCHAR(120)

Customer

  • CustomerId — INTEGER — Primary key — NOT NULL
  • FirstName — NVARCHAR(40) — NOT NULL
  • LastName — NVARCHAR(20) — NOT NULL
  • Company — NVARCHAR(80)
  • Address — NVARCHAR(70)
  • City — NVARCHAR(40)
  • State — NVARCHAR(40)
  • Country — NVARCHAR(40)
  • PostalCode — NVARCHAR(10)
  • Phone — NVARCHAR(24)
  • Fax — NVARCHAR(24)
  • Email — NVARCHAR(60) — NOT NULL
  • SupportRepId — INTEGER — Foreign key → Employee.EmployeeId

Employee

  • EmployeeId — INTEGER — Primary key — NOT NULL
  • LastName — NVARCHAR(20) — NOT NULL
  • FirstName — NVARCHAR(20) — NOT NULL
  • Title — NVARCHAR(30)
  • ReportsTo — INTEGER — Foreign key → Employee.EmployeeId
  • BirthDate — DATETIME
  • HireDate — DATETIME
  • Address — NVARCHAR(70)
  • City — NVARCHAR(40)
  • State — NVARCHAR(40)
  • Country — NVARCHAR(40)
  • PostalCode — NVARCHAR(10)
  • Phone — NVARCHAR(24)
  • Fax — NVARCHAR(24)
  • Email — NVARCHAR(60)

Genre

  • GenreId — INTEGER — Primary key — NOT NULL
  • Name — NVARCHAR(120)

Invoice

  • InvoiceId — INTEGER — Primary key — NOT NULL
  • CustomerId — INTEGER — Foreign key → Customer.CustomerId — NOT NULL
  • InvoiceDate — DATETIME — NOT NULL
  • BillingAddress — NVARCHAR(70)
  • BillingCity — NVARCHAR(40)
  • BillingState — NVARCHAR(40)
  • BillingCountry — NVARCHAR(40)
  • BillingPostalCode — NVARCHAR(10)
  • Total — NUMERIC(10,2) — NOT NULL

InvoiceLine

  • InvoiceLineId — INTEGER — Primary key — NOT NULL
  • InvoiceId — INTEGER — Foreign key → Invoice.InvoiceId — NOT NULL
  • TrackId — INTEGER — Foreign key → Track.TrackId — NOT NULL
  • UnitPrice — NUMERIC(10,2) — NOT NULL
  • Quantity — INTEGER — NOT NULL

MediaType

  • MediaTypeId — INTEGER — Primary key — NOT NULL
  • Name — NVARCHAR(120)

Playlist

  • PlaylistId — INTEGER — Primary key — NOT NULL
  • Name — NVARCHAR(120)

PlaylistTrack

  • PlaylistId — INTEGER — Foreign key → Playlist.PlaylistId — NOT NULL
  • TrackId — INTEGER — Foreign key → Track.TrackId — NOT NULL

Track

  • TrackId — INTEGER — Primary key — NOT NULL
  • Name — NVARCHAR(200) — NOT NULL
  • AlbumId — INTEGER — Foreign key → Album.AlbumId
  • MediaTypeId — INTEGER — Foreign key → MediaType.MediaTypeId — NOT NULL
  • GenreId — INTEGER — Foreign key → Genre.GenreId
  • Composer — NVARCHAR(220)
  • Milliseconds — INTEGER — NOT NULL
  • Bytes — INTEGER
  • UnitPrice — NUMERIC(10,2) — NOT NULL

foo

  • bar — int
  • baz — varchar(20)

sqlite_schema

  • type — TEXT
  • name — TEXT
  • tbl_name — TEXT
  • rootpage — INT
  • sql — TEXT