Track


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TrackId int 4 null
InvoiceLine.TrackId FK_InvoiceLineTrackId R
PlaylistTrack.TrackId FK_PlaylistTrackTrackId R
Name nvarchar 400 null
AlbumId int 4 √ null
Album.AlbumId FK_TrackAlbumId R
MediaTypeId int 4 null
MediaType.MediaTypeId FK_TrackMediaTypeId R
GenreId int 4 √ null
Genre.GenreId FK_TrackGenreId R
Composer nvarchar 440 √ null
Milliseconds int 4 null
Bytes int 4 √ null
UnitPrice numeric 12,2 null

Table contained 3503 rows

Indexes

Constraint Name Type Sort Column(s)
PK_Track Primary key Asc TrackId
IFK_TrackAlbumId Performance Asc AlbumId
IFK_TrackGenreId Performance Asc GenreId
IFK_TrackMediaTypeId Performance Asc MediaTypeId

Relationships

Close relationships within degrees of separation