GigSong

A song on one gig, inside one of the gig’s products, on a named list: the couple’s request, the set list, a favorite, the playlist, or do not play. A request holds what the couple wrote until the band leader connects it to a song in the library.

  • Who put it on the gig.

  • When a request was marked complete.

  • the date-time notation as defined by RFC 3339, section 5.6, for example, 2017-07-21T17:32:28Z

  • What the song is for, e.g. the first dance. References gig_moments.id.

  • The part of the gig this song belongs to. Removing the product from the gig removes its songs. References gig_products.id.

  • Never shown to the couple.

  • the date-time notation as defined by RFC 3339, section 5.6, for example, 2017-07-21T17:32:28Z

  • Shortened for the moment, or left at its original length.

  • The band leader’s answer to "do we already have it?".

    values
    in_libraryneeds_editsnewnull
  • The version meant, or a playlist.

  • Which list the song is on for this gig.

    values
    requestset_listfavoriteplaylistdo_not_playnull
  • Performed live by the band, or the recording played back.

  • The set it is played in, e.g. "Set 1".

  • When a request was set aside.

  • References staff_members.id.

  • The library song. Empty for a request nobody has decided on yet, and for one-offs. References songs.id.

  • As written by whoever added it. Kept after a library song is connected.

  • Where a request stands: needs_decision until a library song is connected, in_production while that song is being made, ready once it is active, then complete or set_aside. Null for songs that are not requests.

    values
    needs_decisionin_productionreadycompleteset_asidenull