fct_checkin

-1 rows


Description

The event of a customer visiting a gym (organization_unit) owned by you.

Columns

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

The primary key of this table. System column calculated by the source System.
checkin_time timestamp 29,6 null

The local timestamp at which the checkin happened.
checkout_time timestamp 29,6 √ null

The local timestamp at which the customer left the gym again (if he left).
checkin_date_id int4 10 null
dim_date.date_id fct_checkin_checkin_date_id_fkey R

The date at which the checkin happened
checkout_date_id int4 10 √ null
dim_date.date_id fct_checkin_checkout_date_id_fkey R

The date at which the checkout happened (if it happened).
organization_unit_id int8 19 null
dim_organization_unit.organization_unit_id fct_checkin_organization_unit_id_fkey R

The gym (organization_unit) which the customer visited.
customer_organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id fct_checkin_customer_organization_unit_id_fkey R

The gym (organization_unit) the customer originally signed up to. Is set to null after privacy settings come into effect.
customer_id int8 19 √ null
dim_customer.customer_id fct_checkin_customer_id_fkey R

The person who visited. Is set to null when privacy settings come into effect.
device_id int8 19 √ null
dim_device.device_id fct_checkin_device_id_fkey R

The machine registering the checkin. Null if person was directly checked-in through Website (without a device).
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