Aug. 23rd, 2017

artsyhonker: a girl with glasses and purple shoulder-length hair (Default)
Things I want to track about music:

Title/First line of text
Composer: Last name, first name, initials, birth year, death year, nationality, website, e-mail, role, link to contact composer, link to composer's website, notes
Arranger: all the info from Composer.
Language
Lyricist
Translator
Date of composition/publication
Publisher (if applicable)
Voicing
Instrumentation
Genre (e.g. hymn, chant, anthem, canticle, responses, voluntary...)
Metre (for hymns)
Tune name (for hymns)
Duration (in time)
Duration (in verses, for hymns)
Difficulty
Hymnals the work is published in
Anthologies the work is published in
Url to order a deadtree copy
url to buy a download
url to a free download, if any legal
url to contact composer
Liturgical context: seasons, saints, services, themes, where in the service it might fit,
Scriptural references (this is fairly complicated because a piece might be relevant to one verse or to a range of them and it might skip some within that range, but at least someone has numbered the chapters and verses already, thank you Dominicans; I almost want to do this with a link to bible.oremus.org because that is a sensible site)
Lectionary Date (there are three years worth of these)
Related works (e.g. a Magnificat may be linked to a Nunc Dimittis)

Some of these are one-to-one relationships, some of them are one-to-many. I don't really get how to do the one-to-many thing, yet.

I think I need the following tables:
Works
People
Hymnals
Urls
Liturgical context
Scriptural context
Lectionary Date
Relationships between works

But, I am not quite sure what I am doing...

Profile

artsyhonker: a girl with glasses and purple shoulder-length hair (Default)
artsyhonker

September 2017

S M T W T F S
      12
3456789
10111213141516
17181920212223
24252627282930

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Sep. 23rd, 2017 08:03 pm
Powered by Dreamwidth Studios