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