invitation Table (492)

Invitations to events

Fields

NameDescriptionTypeNull
invitation_idPrimary keyPK
event_uidThe UID associated with this event, all integrators should refer to this UID when referring to the eventString(255)
event_sequenceThe current sequence number of the event info, so we know if we got a new or old event updateInt
event_dtstampDTSTAMP so we know if we got a new or old event update when sequence is the sameDateTime
appointment_idThe id of the mother appointment recordFK appointment
registeredRegistered whenUtcDateTime
registered_associate_idRegistered by whomFK associate
updatedLast updated whenUtcDateTime
updated_associate_idLast updated by whomFK associate
updatedCountNumber of updates made to this recordUShort
organizer_emailThe email address of the organizer of the event.String(255)
organizer_fullnameThe organizer’s full nameString(255)
recurring_end_dateThe end date for a recurring eventDateTime
recurring_start_dateThe start date for a recurring eventDateTime
template_languageThe SO-language used for email invitations (see PhysicalDocument.GetTemplateLanguages(), CultureDataFormatter.MapCultureToSuperOfficeLanguage()String(16)

invitation table relationship diagram

Indexes

FieldsTypesDescription
invitation_idPKClustered, Unique
event_uidString(255)Index
appointment_idFKIndex

Relationships

TableDescription
appointmentTasks, appointments, followups, phone calls; and documents (document_id != 0). An appointment always has a corresponding record in VisibleFor specifying who may see this.
associateEmployees, resources and other users - except for External persons

Replication Flags

  • None

Security Flags

  • No access control via user’s Role.