Attributes
An Attributes music data type record is stored in the
music_data table with a discriminator value of attributes.
The one-to-one part symbol association is stored in the
part_symbol with the foreign key
part_symbol_id in the music_data table.
One-to-many associations store lists of attributes subelements of the same type, each in their own table having the foreign key
attributes_id that joins to the primary key column music_data.id.
The one-to-many tables are:
- key_signature
- time
- clef
- staff_details
- measure_style
- directive
- transpose
Time
The time table has a discriminator value of
time signature or senza misura.
The
time signature record joins to a list of time_signature_type records and an interchangeable record. The
interchangeable record has its own list of time_signature_type records.