| | 28 | |
| | 29 | = Track = |
| | 30 | * __**track_id**__ (PK) |
| | 31 | * **name** (NOT NULL) |
| | 32 | * album_id* (FK → Album) |
| | 33 | * media_type_id* (FK → MediaType) |
| | 34 | * genre_id* (FK → Genre) |
| | 35 | * composer |
| | 36 | * **milliseconds** (NOT NULL) |
| | 37 | * **bytes** (NOT NULL) |
| | 38 | |
| | 39 | = Album = |
| | 40 | * __**album_id**__ (PK) |
| | 41 | * **title** (NOT NULL) |
| | 42 | * artist_id* (FK → Artist) |
| | 43 | |
| | 44 | = Artist = |
| | 45 | * __**artist_id**__ (PK) |
| | 46 | * **name** (NOT NULL) |
| | 47 | |
| | 48 | = Genre = |
| | 49 | * __**genre_id**__ (PK) |
| | 50 | * **name** (NOT NULL) |
| | 51 | |
| | 52 | = MediaType = |
| | 53 | * __**media_type_id**__ (PK) |
| | 54 | * **name** (NOT NULL) |
| | 55 | |
| | 56 | = Price = |
| | 57 | * __**price_id**__ (PK) |
| | 58 | * **value** (NOT NULL) |
| | 59 | * **date** (NOT NULL) |
| | 60 | * track_id* (FK → Track) |
| | 61 | |
| | 62 | = InvoiceLine = |
| | 63 | * __**invoice_line_id**__ (PK) |
| | 64 | * invoice_id* (FK → Invoice) |
| | 65 | * track_id* (FK → Track) |
| | 66 | * **quantity** (NOT NULL) |
| | 67 | |
| | 68 | = Invoice = |
| | 69 | * __**invoice_id**__ (PK) |
| | 70 | * customer_id* (FK → Customer) |
| | 71 | * **invoice_date** (NOT NULL) |
| | 72 | * billing_address |
| | 73 | * billing_city |
| | 74 | * billing_state |
| | 75 | * billing_country |
| | 76 | * billing_postal_code |
| | 77 | * **total** (NOT NULL) |
| | 78 | |
| | 79 | = Customer = |
| | 80 | * __**customer_id**__ (PK) |
| | 81 | * **first_name** (NOT NULL) |
| | 82 | * **last_name** (NOT NULL) |
| | 83 | * company |
| | 84 | * support_rep_id* (FK → Employee) |
| | 85 | * personal_info_id* (FK → AddressInfo) |
| | 86 | * contact_id* (FK → Contact) |
| | 87 | |
| | 88 | = Employee = |
| | 89 | * __**employee_id**__ (PK) |
| | 90 | * **first_name** (NOT NULL) |
| | 91 | * **last_name** (NOT NULL) |
| | 92 | * **title** (NOT NULL) |
| | 93 | * reports_to* (FK → Employee) |
| | 94 | * **birth_date** (NOT NULL) |
| | 95 | * **hire_date** (NOT NULL) |
| | 96 | * personal_info_id* (FK → AddressInfo) |
| | 97 | * contact_id* (FK → Contact) |
| | 98 | |
| | 99 | = AddressInfo = |
| | 100 | * __**address_info_id**__ (PK) |
| | 101 | * **address** (NOT NULL) |
| | 102 | * **city** (NOT NULL) |
| | 103 | * state |
| | 104 | * **country** (NOT NULL) |
| | 105 | * **postal_code** (NOT NULL) |
| | 106 | |
| | 107 | = Contact = |
| | 108 | * __**contact_id**__ (PK) |
| | 109 | * **phone** (NOT NULL) |
| | 110 | * fax |
| | 111 | * **email** (NOT NULL) |
| | 112 | |
| | 113 | = Playlist = |
| | 114 | * __**playlist_id**__ (PK) |
| | 115 | * **name** (NOT NULL) |
| | 116 | |
| | 117 | = PlaylistTrack = |
| | 118 | * __**playlist_track_id**__ (PK) |
| | 119 | * playlist_id* (FK → Playlist) |
| | 120 | * track_id* (FK → Track) |
