
Figure 1
Entity-relationship diagram of the relational database schema.
Table 1
Performance.
| VARIABLE | TYPE | DESCRIPTION |
|---|---|---|
| performance_id | string | Unique identifier of the performance (primary key). |
| performance_date | date | Date of the performance in yyyy-mm-dd format. |
| performance_title | text | Title of the performance, as given in the official ticketing website. |
| venue_name | text | Name of the performance venue. |
| duration_minutes | int | Duration of the performance in minutes (integer values only). |
| performance_abstract | text | Description of the performance program. |
| start_time | time | Starting time of the performance in hh:mm format. |
| host_organization | text | Hosting organization. |
| sponsoring_organization | text | Sponsoring organizations; multiple values separated by commas. |
| mt20id | string | Standard performance identifier assigned by the KOPIS system. |
Table 2
Work.
| VARIABLE | TYPE | DESCRIPTION |
|---|---|---|
| work_id | string | Unique identifier of the work (primary key). |
| title_variant | text | Variant titles of the work, as collected from source materials; multiple values separated by commas. |
| mb_title | text | Official title of the work as registered in MusicBrainz. |
| mb_type | text | Genre or form of the work as defined by MusicBrainz. |
| mb_language | string | Lyric language in ISO 639-3 code as recorded in MusicBrainz. |
| mb_composer | text | Composer’s full name standardized in MusicBrainz. |
| mb_composer_birth_year | int | Composer’s birth year in yyyy format. |
| mb_composer_death_year | int | Composer’s death year in yyyy format. |
| mb_lyricist | text | Lyricist/poet as provided by MusicBrainz; multiple values allowed. |
| mb_arranger | text | Arranger of the work as recorded in MusicBrainz. |
| mbid | string | MusicBrainz work identifier in UUID format. |
| mb_parent_work_title | text | Title of the parent work if this is part of a larger composition. |
| mbid_parent_work | string | MusicBrainz parent work identifier in UUID format. |
Table 3
Person.
| VARIABLE | TYPE | DESCRIPTION |
|---|---|---|
| person_id | string | Unique identifier of the person (primary key). |
| person_name | text | Person’s name as recorded in source materials; original spelling preserved. |
| person_role | text | Role of the person within the performance; controlled vocabulary (e.g., main performer, accompanist, conductor, host). |
| person_medium | text | Voice type or instrument of the performer. |
| person_profile | text | Original biography or profile text from source materials. |
| person_isni | text | International Standard Name Identifier (ISNI) for the performer, when available, assigned via the National Library of Korea’s ISNI service. |
Table 4
Program.
| VARIABLE | TYPE | DESCRIPTION |
|---|---|---|
| program_item_id | string | Unique identifier of the program item (primary key). |
| performance_id | string | Identifier of the performance this item belongs to (foreign key). |
| work_id | string | Identifier of the work performed in this program item (foreign key). |
| program_order | int | Order of the item within the performance, starting from 1 and listed sequentially. |
| is_intermission | boolean | Indicates whether the item represents an intermission (TRUE/FALSE). |
