Music Data
The
music_data table stores records that define a measure's contents.
Every measure (whose record is in the
measure table) contains a list of music data records.
Discriminator values
All music data records, of whatever type, are stored in the
music_data table, and the music data types are distinguished by the value in the discriminator column music_data_type.
The
music_data_type discriminator values are:
- note
- backup
- forward
- direction
- attributes
- harmony
- figured bass
- sound
- listening
- barline
- grouping
- link
- bookmark
A table with many fields
Since all music data type definitions are combined into a single table using Hibernate single-table inheritance annotations,
all of the
music_data fields are in a single table.
Thus, the music_data table itself has a long table description,
but each music data record individually only uses a subset of the music_data fields to store its data, depending on the music data type.
Individual music data types are shown in the subpages of this page.
The diagram below shows the
music_data table fields, with its foreign keys shown in the last column.