Any object type that includes attributeGroup text-formatting, or whose definition includes any attributes defined in the attributeGroup text-formatting in the MusicXML schema stores its text data in the text_format table.

Element text is stored in field value.

All attributes in the text-formatting attributeGroup in the MusicXML schema are stored in the text_format table, except for attributeGroup print-style-align which are display table fields.

Exceptions:

Some database record types have a single scalar value found in attributeGroup text-formatting, and these single values are stored with the main record:

• justify: metronome, lyric, part-name-text, and group-name-text
• xml:lang: directive and lyric language
• enclosure: percussion

Direction types dynamics, rehearsal, symbol, and words in the direction_type table have a text_format record, foreign key text_format_id.

Data types footnote, text_display, lyric_text_data, and credit_display are all of formatted display type which uses the text_format and display tables to store their data. See the Formatted Display page, and these tables in the table reference for more information.