Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| event_occurrence_id | int8 |
|
|
The unique identifier for the specific occurrence of the event the attendee is registered for, E.g. 6789. |
| event_id | int8 |
|
|
The unique identifier for the event, E.g. 123. |
| company_id | int8 |
|
|
The unique identifier for the company associated with the event, E.g. 456. |
| created_at | timestamp |
|
|
The date and time when the event occurrence was created (in UTC), E.g. 2021-01-15 09:30:00. |
| beginning_at | timestamp |
|
|
The date and time when the event occurrence starts (in UTC), E.g. 2021-03-02 10:00:00. |
| ending_at | timestamp |
|
|
The date and time when the event occurrence ends (in UTC), E.g. 2021-03-02 12:00:00. |
| capacity | int4 |
|
|
The capacity of the event occurrence, i.e., the maximum number of attendees, E.g. 50. |
| invoices_generated_at | timestamp |
|
|
The date and time when invoices were generated for the event occurrence (in UTC), if applicable, E.g. 2021-03-15 12:30:00. |
| rsvp_date | date |
|
|
The date by which attendees need to RSVP for the event occurrence, E.g. 2021-02-28. |
| updated_at | timestamp |
|
|
The date and time when the event occurrence was last updated (in UTC), E.g. 2021-02-20 14:20:00. |
| archived_at | timestamp |
|
|
The date and time when the event occurrence was archived (in UTC), if applicable, E.g. 2021-05-01 00:00:00. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fct_event_occurrences_pkey | Primary key | Asc | event_occurrence_id |
| fct_event_occurrences_company_id_idx | Performance | Asc | company_id |
| fct_event_occurrences_event_id_idx | Performance | Asc | event_id |