preview__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

The studio where the appointment event took place
appointment_id int8 19 √ null

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

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

End date of appointment
event_date_id int4 10 √ null
dim_date.date_id Implied Constraint 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

The ID of the related class for the appointment
customer_id int8 19 √ null

The ID of the customer
inclusive_contingent_id int8 19 √ null

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

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

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).
data_landing_time timestamptz 35 getdate()

System column. UTC timestamp assigned when a table batch is applied on Redshift. It represents warehouse landing order at table-batch granularity, not source event order. Usable to filter for incremental extractions.

Relationships

Close relationships within degrees of separation