dim_class_event_property


Description

The table contains simple properties of class events. This is a junk dimension that stores distinct combinations of event status, source, and booked_for_free flag.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
class_event_property_id varchar 256 null
fct_class_event.class_event_property_id fct_class_event_class_event_property_id_fkey R

The primary key of this table. System column calculated by DataOps.
status varchar 256 √ null

Status of the event, e.g., BOOKED, CANCELED, etc.
source varchar 256 √ null

The system from which the event was triggered, e.g., MYSPORTS, INTERNAL_API, etc.
booked_for_free bool 1 √ null

Is this booking event for free, that is, no contingent was used for booking a class
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