| Idx | Column Name | Data Type |
|---|---|---|
| * | ArtistId | INTEGER NOT NULL |
| Name | TEXT | |
| Referring Foreign Key | ||
| FK_Album Artist | ArtistId ↙ ❏ Album | |
| Idx | Column Name | Data Type |
|---|---|---|
| * | CustomerId | INTEGER NOT NULL |
| * | FirstName | TEXT NOT NULL |
| * | LastName | TEXT NOT NULL |
| Company | TEXT | |
| Address | TEXT | |
| City | TEXT | |
| State | TEXT | |
| Country | TEXT | |
| PostalCode | TEXT | |
| Phone | TEXT | |
| Fax | TEXT | |
| * | TEXT NOT NULL | |
| SupportRepId | INTEGER | |
| Foreign Key | ||
| FK_Customer Employee | SupportRepId ↗ ❏ Employee(EmployeeId) | |
| Referring Foreign Key | ||
| FK_Invoice Customer | CustomerId ↙ ❏ Invoice | |
| Idx | Column Name | Data Type |
|---|---|---|
| * | EmployeeId | INTEGER NOT NULL |
| * | LastName | TEXT NOT NULL |
| * | FirstName | TEXT NOT NULL |
| Title | TEXT | |
| ReportsTo | INTEGER | |
| BirthDate | DATETIME | |
| HireDate | DATETIME | |
| Address | TEXT | |
| City | TEXT | |
| State | TEXT | |
| Country | TEXT | |
| PostalCode | TEXT | |
| Phone | TEXT | |
| Fax | TEXT | |
| TEXT | ||
| Foreign Key | ||
| FK_Employee Employee | ReportsTo ↗ ❏ Employee(EmployeeId) | |
| Referring Foreign Key | ||
| FK_Customer Employee | EmployeeId ↙ ❏ Customer(SupportRepId) | |
| FK_Employee Employee | EmployeeId ↙ ❏ Employee(ReportsTo) | |
| Idx | Column Name | Data Type |
|---|---|---|
| * | GenreId | INTEGER NOT NULL |
| Name | TEXT | |
| Referring Foreign Key | ||
| FK_Track Genre | GenreId ↙ ❏ Track | |
| Idx | Column Name | Data Type |
|---|---|---|
| * | InvoiceId | INTEGER NOT NULL |
| * | CustomerId | INTEGER NOT NULL |
| * | InvoiceDate | DATETIME NOT NULL |
| BillingAddress | TEXT | |
| BillingCity | TEXT | |
| BillingState | TEXT | |
| BillingCountry | TEXT | |
| BillingPostalCode | TEXT | |
| * | Total | NUMERIC(10,2) NOT NULL |
| Foreign Key | ||
| FK_Invoice Customer | CustomerId ↗ ❏ Customer | |
| Referring Foreign Key | ||
| FK_InvoiceLine Invoice | InvoiceId ↙ ❏ InvoiceLine | |
| Idx | Column Name | Data Type |
|---|---|---|
| * | InvoiceLineId | INTEGER NOT NULL |
| * | InvoiceId | INTEGER NOT NULL |
| * | TrackId | INTEGER NOT NULL |
| * | UnitPrice | NUMERIC(10,2) NOT NULL |
| * | Quantity | INTEGER NOT NULL |
| Foreign Key | ||
| FK_InvoiceLine Invoice | InvoiceId ↗ ❏ Invoice | |
| FK_InvoiceLine Track | TrackId ↗ ❏ Track | |
| Idx | Column Name | Data Type |
|---|---|---|
| * | MediaTypeId | INTEGER NOT NULL |
| Name | TEXT | |
| Referring Foreign Key | ||
| FK_Track MediaType | MediaTypeId ↙ ❏ Track | |
| Idx | Column Name | Data Type |
|---|---|---|
| * | PlaylistId | INTEGER NOT NULL |
| Name | TEXT | |
| Referring Foreign Key | ||
| FK_PlaylistTrack Playlist | PlaylistId ↙ ❏ PlaylistTrack | |
| Idx | Column Name | Data Type |
|---|---|---|
| * | PlaylistId | INTEGER NOT NULL |
| * | TrackId | INTEGER NOT NULL |
| Foreign Key | ||
| FK_PlaylistTrack Playlist | PlaylistId ↗ ❏ Playlist | |
| FK_PlaylistTrack Track | TrackId ↗ ❏ Track | |
| Idx | Column Name | Data Type |
|---|---|---|
| * | TrackId | INTEGER NOT NULL |
| * | Name | TEXT NOT NULL |
| AlbumId | INTEGER | |
| * | MediaTypeId | INTEGER NOT NULL |
| GenreId | INTEGER | |
| Composer | TEXT | |
| * | Milliseconds | INTEGER NOT NULL |
| Bytes | INTEGER | |
| * | UnitPrice | NUMERIC(10,2) NOT NULL |
| Foreign Key | ||
| FK_Track Album | AlbumId ↗ ❏ Album | |
| FK_Track Genre | GenreId ↗ ❏ Genre | |
| FK_Track MediaType | MediaTypeId ↗ ❏ MediaType | |
| Referring Foreign Key | ||
| FK_InvoiceLine Track | TrackId ↙ ❏ InvoiceLine | |
| FK_PlaylistTrack Track | TrackId ↙ ❏ PlaylistTrack | |