| id | name | |
|---|---|---|
| 1 | John Doe | john@example.com |
| 2 | Jane Smith | jane@example.com |
| 3 | Michael Johnson | michael@example.com |
| id | method | description |
|---|---|---|
| 1 | Film Negatives | Storing physical copies of films on celluloid. |
| 2 | Digital Files | Storing digital copies of films on hard drives or cloud storage. |
| 3 | Blu-ray Discs | Storing high definition video on Blu-ray discs. |
| 4 | DVDs | Storing standard definition video on DVDs. |
| id | title | year |
|---|---|---|
| 1 | The Shawshank Redemption | 1994.0 |
| 2 | The Godfather | 1972.0 |
| 3 | Pulp Fiction | 1994.0 |
| 4 | Schindler's List | 1993.0 |
| 5 | Forrest Gump | 1994.0 |
| film_id | archiver_id | preservation_method_id |
|---|---|---|
| (→ Films.id) | (→ Film_Archivists.id) | (→ Preservation_Methods.id) |
| None | 1 | 1 |
| None | 2 | 1 |
| None | 3 | 1 |
| None | 3 | 1 |
| director_id | firstname | lastname |
|---|---|---|
| 1 | Frank | Darabont |
| 2 | Mario | Puzo |
| 3 | Quentin | Tarantino |
| 4 | Steven | Spielberg |
| 5 | Robert | Zemeckis |
| producer_id | firstname | lastname |
|---|---|---|
| 1 | Albert | Ruddy |
| 2 | Gordon | Carroll |
| 3 | Barry | Winkler |
| 4 | Joel | Silver |
| 5 | Mark | Harrison |
| actor_id | firstname | lastname |
|---|---|---|
| 1 | Tim | Robin |
| 2 | Marlon | Brando |
| 3 | Brad | Pitt |
| 4 | Tom | Hanks |
| 5 | Jack | Nicholson |
| role_id | film_id | director_id | producer_id | actor_id |
|---|---|---|---|---|
| (→ Films.id) | (→ Director.director_id) | (→ Producer.producer_id) | (→ Actor.actor_id) | |
| 1 | 1 | 2 | 3 | 4 |
| 2 | 2 | 1 | 4 | 5 |
| 3 | 3 | 6 | 5 | 7 |
| 4 | 4 | 8 | 7 | 8 |
| 5 | 5 | 9 | 8 | 9 |