id | name |
---|---|
1 | Paperback |
2 | Hardcover |
3 | Ebook |
4 | Audiobook |
5 | Digital |
id | title | author |
---|---|---|
1 | Pride and Prejudice | Jane Austen |
2 | Great Expectations | Charles Dickens |
3 | War and Peace | Leo Tolstoy |
4 | The Adventures of Huckleberry Finn | Mark Twain |
5 | 1984 | George Orwell |
id | firstname | lastname |
---|---|---|
1 | Jane | Austen |
2 | Charles | Dickens |
3 | Leo | Tolstoy |
4 | Mark | Twain |
5 | George | Orwell |
book_id | author_id |
---|---|
(→ Books.id) | (→ Authors.id) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |
book_id | format_id |
---|---|
(→ Books.id) | (→ Formats.id) |
1 | 1 |
1 | 2 |
2 | 1 |
2 | 3 |
3 | 1 |
3 | 4 |
4 | 1 |
4 | 5 |
5 | 2 |
5 | 1 |