fct_class_event


Columns

Column Type Size Nulls Auto Default Children Parents Comments
class_event_id int8 19 null
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id Implied Constraint R
appointment_id int8 19 √ null
dim_appointment.appointment_id Implied Constraint R
start_date_id int4 10 √ null
dim_date.date_id Implied Constraint R
end_date_id int4 10 √ null
dim_date.date_id Implied Constraint R
event_date_id int4 10 √ null
dim_date.date_id Implied Constraint R
event_date_time timestamptz 35 √ null
class_id int8 19 √ null
dim_class.class_id Implied Constraint R
customer_id int8 19 √ null
dim_customer.customer_id Implied Constraint R
inclusive_contingent_id int8 19 √ null
dim_inclusive_contingent.inclusive_contingent_id Implied Constraint R
purchased_contingent_id int8 19 √ null
class_event_property_id varchar 256 √ null
dim_class_event_property.class_event_property_id Implied Constraint R
last_updated timestamptz 35 √ null

Relationships

Close relationships within degrees of separation