[direction_type image]
direction_type
Direction type records correspond to subelements of element direction-type.
A direction-type element may have more than one subelement, so each direction_type record belongs to a direction_type_list record using foreign key direction_type_list_id.
direction_type_type is the discriminator column that distinguishes the direction type. Values are:
  • rehearsal
  • segno
  • coda
  • words
  • symbol
  • wedge
  • dynamics
  • dashes
  • bracket
  • pedal
  • beat metronome
  • note metronome
  • octave shift
  • harp pedals
  • damp
  • damp all
  • eyeglasses
  • string mute
  • scordatura
  • image
  • principal voice
  • accordion registration
  • staff divide
  • other direction
Additionally, all percussion element subelements are direction types. Their discriminator values are:
  • glass
  • metal
  • wood
  • pitched
  • membrane
  • effect
  • timpani
  • beater
  • stick
  • stick location
  • other percussion
As with any other table that uses single inheritance and a discriminator value, any particular type of direction type will only use some of the fields in the table.
All direction types join to display, foreign key display_id. Direction types with text values join to text_format, foreign key text_format_id.
The number attribute value is stored in field direction_type_number.
Dynamics markings for dynamics are in table dynamics_marking, one-to-many foreign key join on dynamics_id.
Dynamics that are a subelement of the notations element are stored as a notation record whose dynamics_id field joins to the direction_type table, where the dynamics values are stored in the same way as dynamics that subelements of direction-type.
A beat metronome has two foreign keys to metronome_mark: metronome_mark_1_id and metronome_mark_2_id.
A note metronome has two lists of metronome_note records. The foreign keys in metronome_note to distinguish these two lists are note_metronome_1_id and note_metronome_2_id.
Pedal tunings for harp pedals are in pedal_tuning, foreign key harp_pedals_id.
Accords for scordatura are in table accord, foreign key scordatura_id.