author_id | name |
---|---|
1 | William Shakespeare |
2 | Jane Austen |
3 | Charles Dickens |
4 | Mark Twain |
5 | Leo Tolstoy |
genre_id | type |
---|---|
1 | Drama |
2 | Fantasy |
3 | Romance |
4 | Mystery |
5 | Horror |
comedy_id | title | genre_id | author_id |
---|---|---|---|
(→ genres.genre_id) | (→ authors.author_id) | ||
1 | A Midsummer Night's Dream | 1 | 1 |
2 | The Importance of Being Earnest | 2 | 2 |
3 | Pride and Prejudice | 3 | 3 |
4 | The Adventures of Tom Sawyer | 4 | 4 |
5 | War and Peace | 5 | 5 |
tragedy_id | title | genre_id | author_id |
---|---|---|---|
(→ genres.genre_id) | (→ authors.author_id) | ||
1 | Romeo and Juliet | 6 | 1 |
2 | Macbeth | 7 | 1 |
3 | Persuasion | 8 | 3 |
4 | Great Expectations | 9 | 4 |
5 | Anna Karenina | 10 | 5 |
book_id | title | comedy_id | tragedy_id | author_id | genre_id |
---|---|---|---|---|---|
(→ comedies.comedy_id) | (→ tragedies.tragedy_id) | (→ authors.author_id) | (→ genres.genre_id) | ||
1 | Casino Royale | None | None | 6 | 11 |
2 | Harry Potter and the Philosopher's Stone | 12 | 13 | 7 | 14 |
3 | To Kill a Mockingbird | 15 | 16 | 8 | 17 |
4 | Crime and Punishment | 18 | 19 | 9 | 20 |
5 | Moby Dick | 21 | 22 | 10 | 23 |