ECOLM - An Electronic Corpus of Lute Music

The database

Pieces - Page references

The table Piece_Pageref is the one table still containing obsolence for backward compatibility with some of the earlier web application functions. These fields will be removed in the near future. The remaining fields represent a link between the page reference and individual pieces. Links can be labelled as starting, continuing or ending a piece. Currently, it is impossible to indicate the order in which continuation pages should be read (they could be out of order, especially if the source has been rebound), but a fix for this is (probably by giving the PiecePageref ID of the next page

PiecePageref ID integer Auto-increment-generated primary key
* Piece ID integer Join
PiecePageref Ref enum ‘Start’, ‘Continuation’ or ‘Finish’
* Page ID integer Join
PiecePageref Type enum Same as in Pagination. Now obsolete.
PiecePageref Number string Obsolete
PiecePageref System string Numbers for main systems, T, B, L, R (with numbers if necessary) for marginalia.
PiecePageref Item string a is the first item, and so forth down the alphabet (for historical reasons; may change)

Note that the system information marks the first appearance of the piece on a page, so for continuation pages it is usually system 1, item a. Endings are, as yet, unspecified. Given full TabCode, they may be deduced.

Back to Database summary