Angelina Jordan Wiki:Databases

This wiki uses the Cargo extension^↗ to create and maintain databases for certain types of information.

Existing databases

Performances database

The performance database gathers information about all known performances of songs (or wordless compositions) by Angelina. It is structured into this set of tables:

• Performances – an entry describes the performing of a song, which also includes rehearsals and fragments
  • is linked via the "songs" field with the "Songs" table (join on: Performance.song = song.page)
  • {{Performance}} - Cargo template declaring the table, and also used for creating entries to that table
  • {{cPerf}} - additional template for creating entries
  • link to more relevant things…
• Videos – videos or video parts of those performances
  • is linked via the "pid" (Performance ID) field to the "Performances" table (join on: Videos.pid = Performances.id)
  • {{Video}} - Cargo template declaring the table, and also used for creating entries to that table
  • {{cxvl}}, {{cytv}} - additional templates for creating entries
  • link to more relevant things…
• Song - basic information about the songs themselves
  • {{Song}} - Cargo template declaring the table, and can also be used for creating entries to that
  • {{Infobox song}} - the usual template to create an entry, used on the song's article page
  • link to more relevant things…
• Literals - a technical mapping of values to literals to aid the construction of a rating for videos based on performance type, and video duration and quality
  • {{cLiteral}} - Cargo template declaring the table, and also used for creating entries to that
  • link to more relevant things…

Databases/tables being considered

There are many other things that could be "turned into" databases or addtional tables:

• YouTube channels
• Other social media pages
• Other websites
• References (i.e., published articles, etc.)
• Timeline events (this is starting to be implemented)
• Locations/venues
• Companies/organizations
• People (musicians, etc.)
• Recordings (i.e., things that are "released" and possibly can be purchased)
• Video meta data (this is currently available as JSON data)

See also User:Dcljr/Ideas and User:Most2dot0/Ideas for more thoughts along these lines.