[score image]
score
The score table is the parent table of the schema.
A score consists of a score header and a list of parts. Foreign key to score_header is score_header_id. The foreign key from part to score is score_id.
The score_name field value is assigned by the user or from the filename when a score is converted from a MusicXML file to a database record using the tasks interface. The field has a unique constraint, and is not part of the MusicXML definition.
The score_type field value indicates whether the original MusicXML source file is in partwise or timewise format. Valid values are PARTWISE or TIMEWISE.
The xml_comment table holds comment and processing instruction data found within a MusicXML file. Records are created when a MusicXML file is converted to a database record using the tasks interface. When converting from a database record to a MusicXML file in the tasks interface, the comments and processing instructions are re-inserted into the output file in their original locations.
The score_declaration tables holds the XML and DOCTYPE declarations data as found in the original MusicXML document when converted to a MusicXML database. When converting from the database to a MusicXML file, this information is included in the MusicXML output.
The xml_comment and score_declaration tables are not part of the MusicXML definition.