transpose has a many-to-one relationship with an attributes record in the music_data table, foreign key attributes_id.

Attribute number value is in field staff_number.

The transpose group deinition in the MusicXML schema is separated out to the transpose_info table. The boolean column doubled is set to the presence or absence of the double element. The boolean column doubled_above is set to the double element's above attribute value.