ECOLM - An Electronic Corpus of Lute Music

The database

Bibliographic link tables

For books:

(Source | Piece | Person | Cluster)Book ID integer Auto-increment-generated primary key
* Source ID
* Piece ID
* Person ID
* Cluster ID
integer Joins with parent table
* Book ID integer Joins with cited book
(Source | Piece | Person | Cluster)Book Chapter string Chapter identifier
(Source | Piece | Person | Cluster)Book Pages string
(Source | Piece | Person | Cluster)Book Comments text Unstructured data.

For articles:

(Source | Piece | Person | Cluster)Article ID integer Auto-increment-generated primary key
* Source ID
* Piece ID
* Person ID
* Cluster ID
integer Joins with parent table
* Article ID integer Joins with cited book
(Source | Piece | Person | Cluster)Article Pages string
(Source | Piece | Person | Cluster)Article Comments text Unstructured data.

a href="?page=Database">Back to Database summary