| 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 |