id | name | address |
---|---|---|
1 | The Royal Theatre | 123 Main St |
2 | Drama House | 456 Broadway |
id | name | |
---|---|---|
1 | John Doe | johndoe@gmail.com |
2 | Jane Smith | janesmith@yahoo.com |
id | title | description | theater_company_id | producer_id |
---|---|---|---|---|
(→ Theater_Company.id) | (→ Producer.id) | |||
1 | Hamlet | A classic tragedy by William Shakespeare. | 1 | 1 |
2 | Othello | Another great work from Shakespeare. | 1 | 1 |
id | first_name | last_name |
---|---|---|
1 | Tom | Cruise |
2 | Matthew | McConaughey |
play_id | actor_id | character_played |
---|---|---|
(→ Stage_Play.id) | (→ Actor.id) | |
1 | 1 | Hamlet |
2 | 1 | Othello |
1 | 2 | Laertes |
2 | 2 | Iago |
id | rating | reviewer_email | stage_play_id |
---|---|---|---|
(→ Stage_Play.id) | |||
1 | 8 | reviews@hotmail.com | 1 |
2 | 9 | reviews@outlook.com | 2 |