fct_class_event

-1 rows


Description

Stores all customers 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 id of a studio where appointment take place
appointment_id int8 19 null
dim_appointment.appointment_id fct_class_event_appointment_id_fkey R

The id of 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 appointment was created
event_date_time timestamptz 35 null

The timestamp of the appointment creation date
class_id int8 19 null
dim_class.class_id fct_class_event_class_id_fkey R

The id of a related class of 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 inclusive contingent which was used for bookingIf 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 purchased contingent which was used for booking. If NULL purchased contingent was not used to book a class
class_event_property_id int8 19 null
dim_class_event_property.class_event_property_id fct_class_event_class_event_property_id_fkey R

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

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

Relationships

Close relationships within degrees of separation