dim_purchased_contingent


Description

A contingent defining how often a service can be used, that is paid for (not included in a customer’s contract).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
purchased_contingent_id varchar 256 null
fct_class_event.purchased_contingent_id fct_class_event_purchased_contingent_id_fkey R
fct_customer_appointment.purchased_contingent_id fct_customer_appointment_purchased_contingent_id_fkey R
fct_service_usage.purchased_contingent_id fct_service_usage_purchased_contingent_id_fkey R

Primary key for purchased contingent
name varchar 256 √ null

Name of the contingent
variant_name varchar 256 √ null

Variant name of the contingent
item_number varchar 256 √ null

Item number of the contingent
num_of_usage int4 10 √ null

How many times this contingent could be used initially.
price numeric 19,2 √ null

How much a customer paid for this contingent
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