Many MusicXML elements have sets of attributes or element values referring to display and/or text formatting.

Any element that has any of the following defined has its database record joined to a display table record using foreign key display_id. The display record is created if any of these values are present.

If any font attributes are present, a font table record is created, and joined from foreign key font_id in the display table.

Many elements are defined as having a text value and associated formatting information (for example, dynamics, rehearsal, words). In these cases, the text value is stored in the text_format table's value field, joined by the foreign key text_format_id. The other fields in the formatting record are shown in the diagram below.

The text_format record is created if a text value or any other formatting value is present.

Some elements have both display and text formatting. These elements are implemented as a FormattedDisplay class in the Java code. FormattedDisplay classes are also implemented as an ordered item, so any mapped database table for a FormattedDisplay class will have an ordering column, whether or not it is used.

The FormattedDisplay tables are: