Venue
id | name | address | venue_capacity |
1 | Arena | 123 Street | 500 |
2 | Theatre | 456 Avenue | 800 |
3 | Cinema Hall | 789 Boulevard | 400 |
4 | Performing Arts Center | 000 Lane | 600 |
5 | Music Auditorium | 999 Road | 700 |
Concert
id | title | date | artist_name | venue_id |
| | | | (→ Venue.id) |
1 | Rock Show | 2022-10-10 19:00:00 | Band A | 1 |
2 | Pop Concert | 2022-11-10 20:00:00 | Artist B | 2 |
3 | Jazz Night | 2022-12-10 21:00:00 | Musician C | 3 |
4 | Classical Symphony | 2022-11-20 18:00:00 | Composer D | 4 |
5 | Metal Festival | 2022-12-20 22:00:00 | Group E | 5 |
Theater_Play
id | title | start_date | end_date | theater_company | venue_id |
| | | | | (→ Venue.id) |
1 | Shakespeare Play | 2022-10-10 19:00:00 | 2022-10-20 22:00:00 | Company F | 1 |
2 | Modern Drama | 2022-11-10 20:00:00 | 2022-11-20 22:00:00 | Company G | 2 |
3 | Children's Musical | 2022-12-10 18:00:00 | 2022-12-20 22:00:00 | Company H | 3 |
4 | Historical Tragedy | 2022-11-20 19:00:00 | 2022-12-20 22:00:00 | Company I | 4 |
5 | Romantic Comedy | 2022-12-10 20:00:00 | 2022-12-20 22:00:00 | Company J | 5 |
Movie
id | title | release_date | director | genre | duration |
1 | Action Film | 2022-09-01 00:00:00 | Director A | Action | 120 |
2 | Animation | 2022-10-01 00:00:00 | Director B | Animation | 90 |
3 | Horror | 2022-11-01 00:00:00 | Director C | Horror | 105 |
4 | Documentary | 2022-12-01 00:00:00 | Director D | Documentary | 85 |
5 | Drama | 2022-12-15 00:00:00 | Director E | Drama | 130 |
Review
id | rating | reviewer_name | comment | movie_id |
| | | | (→ Movie.id) |
1 | 8/10 | User X | Great action sequences! | 1 |
2 | 7/10 | User Y | Interesting storyline. | 2 |
3 | 6/10 | User Z | Could have been better. | 3 |
4 | 9/10 | User W | An emotional journey! | 4 |
5 | 5/10 | User V | Not my cup of tea. | 5 |