Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TrackId | INTEGER | 2000000000 | null |
|
|
|||||||||
| Name | NVARCHAR | 200 | null |
|
|
|||||||||
| AlbumId | INTEGER | 2000000000 | √ | null |
|
|
||||||||
| MediaTypeId | INTEGER | 2000000000 | null |
|
|
|||||||||
| GenreId | INTEGER | 2000000000 | √ | null |
|
|
||||||||
| Composer | NVARCHAR | 220 | √ | null |
|
|
||||||||
| Milliseconds | INTEGER | 2000000000 | null |
|
|
|||||||||
| Bytes | INTEGER | 2000000000 | √ | null |
|
|
||||||||
| UnitPrice | NUMERIC | 12,2 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| IFK_TrackAlbumId | Performance | Asc | AlbumId |
| IFK_TrackGenreId | Performance | Asc | GenreId |
| IFK_TrackMediaTypeId | Performance | Asc | MediaTypeId |