A record in the time table stores the data as defined in the time complexType in the MusicXML schema. A list of time records belongs to an attributes record in the music_data table, foreign key attributes_id.

The time table is single-inheritance, with discriminator column time_type. The discriminator value depends on the choice employed in the xs:choice section of the time complexType.

Discriminator values are:

• time signature
• senza misura

For either disriminator value:

• The number attribute is in field time_number
• The separator attribute is in field time_separator

A time signature consists of a list of beats/beat-type elements in sequence, followed by an optional interchangeable element.

Each beats/beat-type element sequence is a record in the time_signature_type table. The text of elements beats and beat-type is stored in fields beats and beat_type, respectively. Foreign key for the record is time_signature_id.

The foreign key for a time signature's interchangeable record is interchangeable_id in the time table.

Attribute separator value is in field time_separator.

An interchangeable has itself a list of time_signature_type records. The foreign key for this list in the time_signature_type table is interchangeable_id.

The senza-misura element text is in time table field value.