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).
- contactType: string | nullFormat: uuid
Id requiredReferences contacts.id.
- createdType: stringFormat: date-time
Time read-onlyrequiredthe date-time notation as defined by RFC 3339, section 5.6, for example, 2017-07-21T17:32:28Z
- gigType: string | nullFormat: uuid
Id requiredReferences gigs.id.
- idType: stringFormat: uuidread-onlyrequired
- labelType: string | nullrequired
- lastType: stringFormat: date-time
Edited Time read-onlyrequiredthe date-time notation as defined by RFC 3339, section 5.6, for example, 2017-07-21T17:32:28Z
- rolesType: array of string | nullenumrequired
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