A lyric_syllable record consists of a lyric element's subelement combination of syllabic/elision/text.

The record's encompassing structure is a lyric text record in table lyric_item, lyric_item_type value lyric text. Foreign key to the lyric_item table is lyric_text_id. A lyric may have multiple syllabic/elision/text combinations, so the relation to the lyric_item table is many-to-one. See lyric_item for more information on a lyric text record.

elision and text element data are in separate elision and lyric_text_data tables because the two types have separate display values. Foreign keys to these two tables are elision_id and lyric_text_data_id.