User:CHGiffen/Data structures: Difference between revisions

From ChoralWiki
Jump to navigation Jump to search
(→‎Composer data: refine data structure)
Line 93: Line 93:
| 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 -->

Revision as of 13:44, 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 =
| 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 -->
<!-- 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 =