Calendar Event Responses
The calendar_event_responses table contains data about which entity has which response to which event (calendar event), such as whether they RSVPed, confirmed, or attended.
This table can be used to determine which entities have which response to which event, as well as metadata about the response such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| calendar_event_id | The numerical identifier of the event that this response is attached to. Relates to the id column in the calendar_events table. |
INT8 | No |
| entity_id | The numerical identifier of the entity that is connected to this event response. Relates to the id column in the entities table. |
INT8 | No |
| campaign_id | The numerical identifier of the campaign this event response happened in. Relates to the id column in the campaigns table. |
INT8 | No |
| status | The response. One of rsvp, attended, tentative, declined, no_show, confirmed or double_confirmed. |
VARCHAR | No |
| created_by_id | The numerical identifier of the user that created this response. Relates to the id column in the users table. |
INT4 | No |
| updated_by_id | The numerical identifier of the user that last updated this response. Relates to the id column in the users table. |
INT4 | No |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was updated. | TIMESTAMP | No |
| responded_at | The UTC timestamp when this response was last updated. | TIMESTAMP | No |