fct_class_event


Description

Stores all customer events for class appointments such as booking or cancellations

Columns

Column Type Size Nulls Auto Default Children Parents Comments
class_event_id int8 19 null

The primary key of this table. System column calculated by the source System.
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id fct_class_event_organization_unit_id_fkey R

The studio where the appointment event took place
appointment_id int8 19 √ null
dim_appointment.appointment_id fct_class_event_appointment_id_fkey R

The ID of the appointment where a customer wants to participate
start_date_id int4 10 √ null
dim_date.date_id fct_class_event_start_date_id_fkey R

Start date of appointment
end_date_id int4 10 √ null
dim_date.date_id fct_class_event_end_date_id_fkey R

End date of appointment
event_date_id int4 10 √ null
dim_date.date_id fct_class_event_event_date_id_fkey R

The date when the appointment event was created
event_date_time timestamptz 35 √ null

The timestamp when the appointment event was created
class_id int8 19 √ null
dim_class.class_id fct_class_event_class_id_fkey R

The ID of the related class for the appointment
customer_id int8 19 √ null
dim_customer.customer_id fct_class_event_customer_id_fkey R

The ID of the customer
inclusive_contingent_id int8 19 √ null
dim_inclusive_contingent.inclusive_contingent_id fct_class_event_inclusive_contingent_id_fkey R

The ID of the inclusive contingent which was used for booking. If NULL, inclusive contingent was not used to book a class
purchased_contingent_id int8 19 √ null
dim_purchased_contingent.purchased_contingent_id fct_class_event_purchased_contingent_id_fkey R

The ID of the purchased contingent which was used for booking. If NULL, purchased contingent was not used to book a class
class_event_property_id varchar 256 √ null
dim_class_event_property.class_event_property_id fct_class_event_class_event_property_id_fkey R

Appointment event properties, e.g., status of the event (BOOKED, CANCELED), source - from which system the event was triggered, whether it was booked for free or not
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).

Relationships

Close relationships within degrees of separation