fct_event_attendees


Description

Attendees are members who have signed up for specific events at scheduled times. These events could be group activities, workshops, meetings, or any scheduled sessions offered by the company.

The fct_event_attendees model provides detailed information about members who have registered to attend events organised by the company. It combines data from attendee records, event schedules, and event details to offer a comprehensive view of event participation.

This model includes details such as the event ID, event title, member ID, attendance status, and timestamps related to their registration and cancellation.

Use this model to analyse event participation, track attendance trends, and understand member engagement.

Columns

Column Type Children Parents Comments
created_at timestamp

The date and time when the attendee record was created (in UTC), E.g. 2021-03-02 00:12:59.996101.
updated_at timestamp

The date and time when the attendee record was last updated (in UTC), E.g. 2021-03-17 22:59:01.116801.
attendee_id int8

The unique identifier for each attendee record, E.g. 12345.
event_occurrence_id int8
fct_event_occurrences.event_occurrence_id Implied Constraint R

The unique identifier for the specific time slot of the event the attendee is registered for, E.g. 6789.
event_id int8
fct_events.event_id Implied Constraint R

The unique identifier for the event, E.g. 789.
member_id int8

The unique identifier for the member attending the event, E.g. 5678.
canceled_at timestamp

The date and time when the attendee was cancelled from the event (in UTC), if applicable, E.g. 2021-04-01 15:00:00.
product_id int8
dim_products.product_id Implied Constraint R

The unique identifier for the product associated with the attendee, if applicable, E.g. 2345.
company_id int8
dim_companies.company_id Implied Constraint R

The company ID, E.g. 345.
event_title text

The title or name of the event, E.g. “Company Annual Meeting”.
status text

The attendance status of the attendee for the event. One of “absent”, “attended”, “paid”, “pending”.

Indexes

Constraint Name Type Sort Column(s)
fct_event_attendees_pkey Primary key Asc attendee_id
fct_event_attendees_company_id_idx Performance Asc company_id
fct_event_attendees_event_id_idx Performance Asc event_id
fct_event_attendees_event_occurrence_id_idx Performance Asc event_occurrence_id
fct_event_attendees_member_id_idx Performance Asc member_id
fct_event_attendees_product_id_idx Performance Asc product_id

Relationships

Close relationships within degrees of separation