![[direction_type image]](images/table_reference/direction_type.png)
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.