Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
Employee Table City nvarchar 80 null
Employee Table ReportsTo int 4 null
Track Table AlbumId int 4 null
Track Table Name nvarchar 400 null
Customer Table City nvarchar 80 null
AlbumsArtists View album nvarchar 320 null
Customer Table LastName nvarchar 40 null
InvoiceLine Table Quantity int 4 null
Invoice Table Total numeric 12 null
Album Table AlbumId int 4 null
Customer Table FirstName nvarchar 80 null
Employee Table Email nvarchar 120 null
InvoiceLine Table InvoiceId int 4 null
Invoice Table BillingAddress nvarchar 140 null
Employee Table Fax nvarchar 48 null
Playlist Table Name nvarchar 240 null
Invoice Table InvoiceDate datetime 16 null
InvoiceLine Table InvoiceLineId int 4 null
Customer Table CustomerId int 4 null
Invoice Table BillingPostalCode nvarchar 20 null
Customer Table State nvarchar 80 null
Employee Table PostalCode nvarchar 20 null
Invoice Table CustomerId int 4 null
Customer Table Fax nvarchar 48 null
Employee Table Country nvarchar 80 null
Artist Table Name nvarchar 240 null
Album Table Title nvarchar 320 null
Track Table TrackId int 4 null
Employee Table HireDate datetime 16 null
Track Table GenreId int 4 null
Customer Table SupportRepId int 4 null
Customer Table Company nvarchar 160 null
Customer Table Email nvarchar 120 null
Track Table Bytes int 4 null
AlbumsArtists View artist nvarchar 240 null
Invoice Table BillingCountry nvarchar 80 null
Employee Table FirstName nvarchar 40 null
Invoice Table BillingCity nvarchar 80 null
Genre Table Name nvarchar 240 null
Employee Table BirthDate datetime 16 null
MediaType Table Name nvarchar 240 null
Album Table ArtistId int 4 null
InvoiceLine Table UnitPrice numeric 12 null
Customer Table Country nvarchar 80 null
Playlist Table PlaylistId int 4 null
Customer Table Address nvarchar 140 null
Employee Table Address nvarchar 140 null
Employee Table Phone nvarchar 48 null
PlaylistTrack Table PlaylistId int 4 null
Artist Table ArtistId int 4 null
Invoice Table BillingState nvarchar 80 null
InvoiceLine Table TrackId int 4 null
Track Table Composer nvarchar 440 null
Employee Table LastName nvarchar 40 null
Employee Table EmployeeId int 4 null
Track Table Milliseconds int 4 null
Employee Table State nvarchar 80 null
MediaType Table MediaTypeId int 4 null
Track Table MediaTypeId int 4 null
Customer Table Phone nvarchar 48 null
Customer Table PostalCode nvarchar 20 null
Employee Table Title nvarchar 60 null
Invoice Table InvoiceId int 4 null
PlaylistTrack Table TrackId int 4 null
Track Table UnitPrice numeric 12 null
Genre Table GenreId int 4 null