The technical table stores data for all subelements of the technical element.

A technical list is a type of notation, so each record in technical joins to the notation table where the technicals list record is stored, foreign key technicals_id, notation_type technicals.

The technical table is single-inheritance with discriminator column technical_type.

Discriminator values are:

• up bow
• down bow
• harmonic
• open string
• thumb position
• fingering
• pluck
• double tongue
• triple tongue
• stopped
• snap pizzicato
• fret
• string number
• hammer on
• pull off
• bend
• tap
• heel
• toe
• fingernails
• hole
• arrow
• handbell
• brass bend
• flip
• smear
• open
• half muted
• harmon mute
• golpe
• other technical

The string number discriminator value is used by the string element.

technical table fields:

• type: harmonic subelement name natural or artificial; hammer-on and pull-off type attribute; hole-type element text
• harmonic_pitch: stores the subelement name base-pitch, touching-pitch, or sounding-pitch
• string_number: string element text
• value: fingering, pluck, fret, hammer-on, pull-off, tap, handbell, other-technical element text; harmon-mute element's harmon-closed subelement text
• notation_number: hammer-on, pull-off number attribute
• tap_hand: hand attribute value for a tap
• hole_closed: a hole's hole-closed subelement text
• location: hole-closed element's location attribute; harmon-closed element's location attribute

techcnical table joins:

• bend_with_bar: with-bar subelement data for a bend
• bend_sound: bend-sound attributeGroup data for a bend
• bend_type: represents the pre-bend and release subelement choice. Table is a single-inheritance table with discriminator column bend_type_type, discriminator values pre bend and release.

Additionally, a frame note has three types of technical as data members: string number, fret, and fingering. These data members join to the technical table with foreign keys string_id, fret_id, and fingering_id.