GigContact

A contact’s connection to a gig, with the role(s) they play on it (Bride, Planner, Photographer, …). Unique per (gig, contact); both FKs required — a link cannot exist without both ends. Replaces the QB relationship grab-bag (contact↔venue links deliberately not modeled).

  • References contacts.id.

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

  • References gigs.id.

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

  • Role(s) this contact plays on this gig. Vocabulary is brand-relabelable (t()); stored as text[].

    values
    • Bride
    • Groom
    • Planner
    • Assistant Planner
    • Functioning As Planner
    • Event Organizer
    • Client - Signatory
    • Primary Point of Contact