kc657 / sql-starter

Data Structure

ALBUM
AlbumId INTEGER PRIMARY KEY
Title NVARCHAR(160)
ArtistId INTEGER FOREIGN KEY

ARTIST
ArtistId INTEGER PRIMARY KEY
Name NVARCHAR(120)

CUSTOMER
CustomerId INTEGER PRIMARY KEY
FirstName NVARCHAR(40)
LastName NVARCHAR(20)
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)

EMPLOYEE
EmployeeId INTEGER PRIMARY KEY
LastName NVARCHAR(20)
FirstName NVARCHAR(20)
Title NVARCHAR(30)
ReportsTo INTEGER FOREIGN KEY
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
Name NVARCHAR(120)

INVOICE
InvoiceId INTEGER PRIMARY KEY
CustomerId INTEGER FOREIGN KEY
InvoiceDate DATETIME
BillingAddress NVARCHAR(70)
BillingCity NVARCHAR(40)
BillingState NVARCHAR(40)
BillingCountry NVARCHAR(40)
BillingPostalCode NVARCHAR(10)
Total NUMERIC

INVOICELINE
InvoiceLineId INTEGER PRIMARY KEY
InvoiceId INTEGER FOREIGN KEY
TrackId INTEGER FOREIGN KEY
UnitPrice NUMERIC
Quantity INTEGER

MEDIATYPE
MediaTypeId INTEGER PRIMARY KEY
Name NVARCHAR(120)

PLAYLIST
PlaylistId INTEGER PRIMARY KEY
Name NVARCHAR(120)

PLAYLISTTRACK
PlaylistId INTEGER PRIMARY KEY
TrackId INTEGER FOREIGN KEY

TRACK
TrackId INTEGER PRIMARY KEY
Name NVARCHAR(200)
AlbumId INTEGER FOREIGN KEY
MediaTypeId INTEGER FOREIGN KEY
GenreId INTEGER FOREIGN KEY
Composer NVARCHAR(220)
Milliseconds INTEGER
Bytes INTEGER
UnitPrice NUMERIC