The basic data structure of a note is:

When the notation type is a list of articulations, technicals, or ornaments, the notation table notation_type values are articulations, technicals, and ornaments, respectively. These notation types are lists, with the individual articulations, technicals, and ornaments in the list stored as records in the joined articulation, technical, and ornament tables, respectively.

Notes may have a list of lyrics in the lyric table.

The information specific to the type of lyric is stored in the joined lyric_item record.

Table lyric_item is a single-inheritance table with discriminator column lyric_item_type whose values are extend, laughing, humming, and lyric text. A lyric text record may have its own extend value, which is a self-join on the lyric_item table whose record is an extend type.