| id | name | birth_date | death_date |
|---|---|---|---|
| 1 | Composer A | 1900-01-01 | 1980-12-31 |
| 2 | Composer B | 1920-01-01 | 2000-12-31 |
| id | name | birth_date | death_date |
|---|---|---|---|
| 1 | Conductor C | 1930-01-01 | 2000-12-31 |
| 2 | Conductor D | 1940-01-01 | 2020-12-31 |
| id | name |
|---|---|
| 1 | London Symphony Orchestra |
| 2 | New York Philharmonic |
| id | title | composer_id | conductor_id |
|---|---|---|---|
| (→ Composer.id) | (→ Conductor.id) | ||
| 1 | Opéra A | 1 | 1 |
| 2 | Opéra B | 2 | 2 |
| id | title | composer_id |
|---|---|---|
| (→ Composer.id) | ||
| 1 | Symphony A | 1 |
| 2 | Symphony B | 2 |
| id | date | symphony_id | orchestra_id | conductor_id |
|---|---|---|---|---|
| (→ Symphony.id) | (→ Orchestra.id) | (→ Conductor.id) | ||
| 1 | 2022-06-01 | 1 | 1 | 1 |
| 2 | 2022-07-01 | 2 | 2 | 2 |