User:CHGiffen/Data structures: Difference between revisions

From ChoralWiki
Jump to navigation Jump to search
(Edition data and Work data structures)
 
(2 intermediate revisions by the same user not shown)
Line 3: Line 3:
== Composer data ==
== Composer data ==
<pre>
<pre>
| ComposerName =          <!-- eg. Antonín Dvořák -->  
| Surame =          <!-- eg. Dvořák -->  
| ComposerLastFirst =    <!-- eg. Dvořák, Antonin -->
| Firstnames =    <!-- eg. Antonin -->
| ComposerSortKey =      <!-- diacritical free, eg. Dvorak, Antonin -->
| SortKey =      <!-- diacritical free, eg. Dvorak, Antonin -->
| ComposerAlias1 =
| Alias1 =
| ComposerAlias2 =
| Alias2 =
| ComposerAlias3 =
| Alias3 =
| ComposerBirthDate =
| BirthDate =
| ComposerBirthYear =
| BirthYear =
| ComposerDeathDate =
| DeathDate =
| ComposerDeathYear =
| DeathYear =
| ComposerNationality1 =
| Nationality1 =
| ComposerNationality2 =
| Nationality2 =
| ComposerEra1 =
| Era1 =
| ComposerEra2 =
| Era2 =
| ComposerInfo =
| Biography =
| WikipediaLink =
| ExternalLinks =
| TopMatter =
| BottomMatter =
</pre>
</pre>


Line 59: Line 63:
<pre>
<pre>
| Title = <!-- to coincide with Work page title part -->
| Title = <!-- to coincide with Work page title part -->
| Title.Cont = <!-- continuation of title, not normally emphasized -->
|   Title.Cont = <!-- continuation of title, not normally emphasized -->
| AltTitle =  
| AltTitle =  
| AltTitle.Cont <!-- continuation of alternate title, not normally emphasized -->
|   AltTitle.Cont <!-- continuation of alternate title, not normally emphasized -->
| ComposerCatalogNumber =
| ComposerCatalogNumber = <!-- eg. BWV pqr or Op. mn, No. k -->
| NumComposers = <!-- 1 is default -->
| NumComposers = <!-- 1 is default -->
| Composer.n.Lastname = <!-- n = 1...NumComposers -->
|   Composer.n.Lastname = <!-- n = 1...NumComposers -->
| Composer.n.Firstnames = <!-- n = 1...NumComposers -->
|   Composer.n.Firstnames = <!-- n = 1...NumComposers -->
| NumArrangers = <!-- 0 is default -->
|  Arranger.n.Lastname =
|  Arranger.n.Firstnames =
| NumLyricSources = <!-- 1 is default -->
| NumLyricSources = <!-- 1 is default -->
| Lyrics.n =  <!-- n = 1...NumLyricSources -->
|   Lyrics.n =  <!-- n = 1...NumLyricSources -->
| LyricSourceType.n = <!-- n = 1...NumLyricSources, eg. Lyricist, Source of text -->
|   LyricSourceType.n = <!-- n = 1...NumLyricSources, eg. Lyricist, Librettist, Bible, or other Source of text -->
| Voicing =
| Voicing = <!-- original voicing -->
| Instruments =
| NumGenres = <!-- 1 is default, although 2 or more would prevail -->
| Genre =
|   Genre.n =
| NumSections = <!-- 0 is default for works with now sections/movements -->
| NumLanguages = <!-- 1 is default, but could be 0 for instrumental works -->
| Section.n.Title = <!-- n = 1...NumSections -->
|  Language.n =
| Section.n.Voicing = <!-- n = 1...NumSections, use if variable voicing -->
| Instruments = <!-- original instrumentation -->
| Section.n.Instruments = <!-- n = 1...NumSections, use if this varies -->
| NumSections = <!-- 0 is default for works with no sections/movements -->
|   Section.n.Title = <!-- n = 1...NumSections -->
|   Section.n.Voicing = <!-- n = 1...NumSections, use if variable voicing -->
|   Section.n.Instruments = <!-- n = 1...NumSections, use if this varies -->
| Publication =
| Publication =
| Description =
| Description =
Line 89: Line 99:
| SerialID = <!-- currently this would be the CPDL # -->
| SerialID = <!-- currently this would be the CPDL # -->
| NumSubSerialItems = <!-- 0 is default (no subeditions) -->
| NumSubSerialItems = <!-- 0 is default (no subeditions) -->
| SubSerialID.n = <!-- n = 1...NumSubSerItems -->
|   SubSerialID.n = <!-- n = 1...NumSubSerItems -->
| SubEditionType.n = <!-- n = 1...NumSubSerItems, eg. "Oboe part" -->
|   SubEditionType.n = <!-- n = 1...NumSubSerItems, eg. "Oboe part" -->
| SupSerialID = <!-- if this is a subedition of another edition -->
| SupSerialID = <!-- if this is a subedition of another edition -->
| NumComposers = <!-- 1 is default -->
| NumComposers = <!-- 1 is default -->
<!-- the Composer and Arranger last and first names could be retrieved from appropriate Composer data records -->
<!-- Composer and Arranger last and first names could be retrieved from appropriate Composer data records -->
| Composer.n.Lastname = <!-- n = 1...NumComposers -->
|   Composer.n.Lastname = <!-- n = 1...NumComposers -->
| Composer.n.Firstnames = <!-- n = 1...NumComposers -->
|   Composer.n.Firstnames = <!-- n = 1...NumComposers -->
| NumArrangers = <!-- 1 is default -->  
| NumArrangers = <!-- 0 is default -->  
| Arranger.n.Lastname = <!-- n = 1...NumArrangers -->  
|   Arranger.n.Lastname = <!-- n = 1...NumArrangers -->  
| Arranger.n.Firstnames = <!-- n = 1...NumArrangers -->
|   Arranger.n.Firstnames = <!-- n = 1...NumArrangers -->
| MainTitle = <!-- main title of this work (parent work if a movement) -->
| MainTitle = <!-- main title of this work (parent work if a movement) -->
| MainTitle.SortKey = <!-- could be obtained from appropriate Work data record -->
| MainTitle.SortKey = <!-- could be obtained from appropriate Work data record -->

Latest revision as of 14:09, 30 September 2010

Data structures

Composer data

| Surame =          <!-- eg. Dvořák --> 
| Firstnames =     <!-- eg. Antonin -->
| SortKey =       <!-- diacritical free, eg. Dvorak, Antonin -->
| Alias1 =
| Alias2 =
| Alias3 =
| BirthDate =
| BirthYear =
| DeathDate =
| DeathYear =
| Nationality1 =
| Nationality2 =
| Era1 =
| Era2 =
| Biography =
| WikipediaLink =
| ExternalLinks =
| TopMatter =
| BottomMatter =

Lyricist data

| LyricistName =
| LyricistLastFirst=
| LyricistSortKey =
| LyricistAlias1 =
| LyricistAlias2 =
| LyricistAlias3 =
| LyricistBirthDate =
| LyricistBirthYear =
| LyricistDeathDate =
| LyricistDeathYear =
| LyricistNationality1 =
| LyricistNationality2 =
| LyricistEra1 =
| LyricistEra2 =
| LyricistInfo =

Editor data

| EditorName =
| EditorUserID =
| EditorWebsite = 
| EditorContactInfo =

Contributor data

| ContributorName =
| ContributorUserID =
| ContributorWebsite =
| ContributorContactInfo =
| ContributorScoreCount =

Work data

| Title = <!-- to coincide with Work page title part -->
|   Title.Cont = <!-- continuation of title, not normally emphasized -->
| AltTitle = 
|   AltTitle.Cont <!-- continuation of alternate title, not normally emphasized -->
| ComposerCatalogNumber = <!-- eg. BWV pqr or Op. mn, No. k -->
| NumComposers = <!-- 1 is default -->
|   Composer.n.Lastname = <!-- n = 1...NumComposers -->
|   Composer.n.Firstnames = <!-- n = 1...NumComposers -->
| NumArrangers = <!-- 0 is default -->
|   Arranger.n.Lastname =
|   Arranger.n.Firstnames =
| NumLyricSources = <!-- 1 is default -->
|   Lyrics.n =  <!-- n = 1...NumLyricSources -->
|   LyricSourceType.n = <!-- n = 1...NumLyricSources, eg. Lyricist, Librettist, Bible, or other Source of text -->
| Voicing = <!-- original voicing -->
| NumGenres = <!-- 1 is default, although 2 or more would prevail -->
|   Genre.n =
| NumLanguages = <!-- 1 is default, but could be 0 for instrumental works -->
|   Language.n = 
| Instruments = <!-- original instrumentation -->
| NumSections = <!-- 0 is default for works with no sections/movements -->
|   Section.n.Title = <!-- n = 1...NumSections -->
|   Section.n.Voicing = <!-- n = 1...NumSections, use if variable voicing -->
|   Section.n.Instruments = <!-- n = 1...NumSections, use if this varies -->
| Publication =
| Description =
| Text-Translations =
| References =
| External websites = 

Lyric data

Edition data

| SerialID = <!-- currently this would be the CPDL # -->
| NumSubSerialItems = <!-- 0 is default (no subeditions) -->
|   SubSerialID.n = <!-- n = 1...NumSubSerItems -->
|   SubEditionType.n = <!-- n = 1...NumSubSerItems, eg. "Oboe part" -->
| SupSerialID = <!-- if this is a subedition of another edition -->
| NumComposers = <!-- 1 is default -->
<!-- Composer and Arranger last and first names could be retrieved from appropriate Composer data records -->
|   Composer.n.Lastname = <!-- n = 1...NumComposers -->
|   Composer.n.Firstnames = <!-- n = 1...NumComposers -->
| NumArrangers = <!-- 0 is default --> 
|   Arranger.n.Lastname = <!-- n = 1...NumArrangers --> 
|   Arranger.n.Firstnames = <!-- n = 1...NumArrangers -->
| MainTitle = <!-- main title of this work (parent work if a movement) -->
| MainTitle.SortKey = <!-- could be obtained from appropriate Work data record -->
<!-- Composer catalog number could be retrieved from appropriate Work data record -->
| ComposerCatalogNumber = <!-- eg. BWV 104 -->
| ThisTitle = <!-- if present, by virtue of being a movement/section -->
| NumContributors = <!-- 0 is default unless different from editor(s) -->
| Contributor.n = <!-- n = 1...NumContributors -->
| NumEditors = <!-- 1 is default -->
| Editor.n = <!-- n = 1...NumEditors -->
| Submitted yyyy =
| Submitted mm =
| Submitted dd =
| Copyright = 
| SheetFileType = <!-- pdf, ps, jpg, gif, ext, extpdf, extps, ... -->
| SheetFile = <!-- eg. [[Media:abcdefg.pdf]] -->
| PaperSize =
| NumPages =
| SheetFileSize = <!-- in kbytes -->
| SoundFileType = <!-- mid, mp3 -->
| SoundFile =
| SoundFileSize = <!-- in kbytes -->
| SourceFileType =
| SourceFile =
| SourceFileSize = <!-- in kbytes -->
| EditionVoicing =
| EditionInstruments =
| EditionLanguage = 
| EditionNotes =

Performer data

| PerformerType =           <!-- Soloist, Ensemble, Chorus, Society -->
| PerformerName =
| PerformerWebsite =
| PerformerContactInfo =
| PerformerInfo =