ECOLM - An Electronic Corpus of Lute Music
The database
Pieces - Scoring
The table Piece_Scoring links piece with predefined instruments.
| PieceScoring ID | integer | Auto-increment-generated primary key |
| * Piece ID | integer | Join |
| * Instrumentation ID | integer | Join (see below) |
The look-up table for this, Instrumentation serves simply as a list of names
for instruments (e.g. ‘lute’), ensembles (‘Viols a5e’) and options
(‘Lute or Viol’).
| Instrumentation ID | integer | Auto-increment-generated primary key |
| Instrumentation Name | String | e.g. Violin |