The part_list_item table stores the data from the part-list complexType in the MusicXML schema, XML choose elements part-group and score-part. The list as a whole belongs to a score_header record, foreign key score_header_id.

The part_list_item table stores more than one data type, so the table is single-inheritance, discriminator column part_list_item_type.

Discriminator values are:

• part group
• score part

part_list_item records are stored in the order they are encountered within the part-list element, using the ordering field.

Both types of part list item have two joins to records in the name_display table, one for the name display, and one for the abbreviation display. Foreign keys to table name_display are:

• name_display_id
• abbreviation_display_id

For a score-part element, these represent the elements part-name-display and part-abbreviation-display. For a part-group element, these represent the elements group-name-display and group-abbreviation-display

There are two records in the group_name table, one for the group-name element, one for the group-abbreviation element. Foreign keys to table group_name are:

• group_name_id
• group_abbreviation_id

group-symbol, group-barline, and editorial data are stored in associated tables group_symbol, group_barline, and editorial.

The value for attribute number is stored in field part_group_number.

Foreign keys to table part_name are:

• part_name_id
• part_abbreviation_id

Each group subelement text value is stored in a joined score_part_group table record.

Each subelement score-instrument is a record in table score_instrument.

Each subelement player is a record in table player.

Each midi-device/midi-instrument element sequence is a record in table midi.

The id attribute value is stored in field element_id.