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 |