== Релации: == = Track = * __**track_id**__ (PK) * **name** * album_id* (FK → Album) * media_type_id* (FK → !MediaType) * genre_id* (FK → Genre) * composer * **milliseconds** * **bytes** = Album = * __**album_id**__ (PK) * **title** * artist_id* (FK → Artist) = Artist = * __**artist_id**__ (PK) * **name** = Genre = * __**genre_id**__ (PK) * **name** = !MediaType = * __**media_type_id**__ (PK) * **name** = Price = * __**price_id**__ (PK) * **value** * **date** * track_id* (FK → Track) = !InvoiceLine = * __**invoice_line_id**__ (PK) * invoice_id* (FK → Invoice) * track_id* (FK → Track) * **quantity** = Invoice = * __**invoice_id**__ (PK) * customer_id* (FK → Customer) * **invoice_date** * billing_address * billing_city * billing_state * billing_country * billing_postal_code * **total** = Customer = * __**customer_id**__ (PK) * **first_name** * **last_name** * company * support_rep_id* (FK → Employee) * personal_info_id* (FK → !AddressInfo) * contact_id* (FK → Contact) = Employee = * __**employee_id**__ (PK) * **first_name** * **last_name** * **title** * reports_to* (FK → Employee) * **birth_date** * **hire_date** * personal_info_id* (FK → !AddressInfo) * contact_id* (FK → Contact) = !AddressInfo = * __**address_info_id**__ (PK) * **address** * **city** * state * **country** * **postal_code** = Contact = * __**contact_id**__ (PK) * **phone** * fax * **email** = Playlist = * __**playlist_id**__ (PK) * **name** = !PlaylistTrack = * __**playlist_track_id**__ (PK) * playlist_id* (FK → Playlist) * track_id* (FK → Track)