User:CHGiffen/Data structures: Difference between revisions

From ChoralWiki
Jump to navigation Jump to search
(Edition data and Work data structures)
(→‎Composer data: refine data structure)
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>



Revision as of 12:20, 10 June 2009

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 =
| NumComposers = <!-- 1 is default -->
| Composer.n.Lastname = <!-- n = 1...NumComposers -->
| Composer.n.Firstnames = <!-- n = 1...NumComposers -->
| NumLyricSources = <!-- 1 is default -->
| Lyrics.n =  <!-- n = 1...NumLyricSources -->
| LyricSourceType.n = <!-- n = 1...NumLyricSources, eg. Lyricist, Source of text -->
| Voicing =
| Instruments =
| Genre =
| NumSections = <!-- 0 is default for works with now 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 -->
<!-- the 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 = <!-- 1 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 =