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 |