Churnkey

Explore the interactive ERD

Table & Field Reference

session_presented_offer

Column	Type	Keys
`guid`	Unknown	PK
`session_id`	Unknown	PKFK
`accepted`	Unknown
`accepted_at`	Unknown
`declined_at`	Unknown
`discount_config_coupon_id`	Unknown
`discount_config_custom_duration`	Unknown
`offer_type`	Unknown
`pause_config_interval`	Unknown
`pause_config_max_pause_length`	Unknown
`presented_at`	Unknown
`survey_offer`	Unknown

session_accepted_offer

Column	Type	Keys
`guid`	Unknown	PK
`session_id`	Unknown	PKFK
`coupon_amount`	Unknown
`coupon_duration`	Unknown
`coupon_id`	Unknown
`coupon_type`	Unknown
`new_plan_id`	Unknown
`new_plan_price`	Unknown
`offer_type`	Unknown
`pause_duration`	Unknown
`pause_interval`	Unknown

session_steps_viewed

Column	Type	Keys
`guid`	Unknown	PK
`start_at`	Unknown	PK
`session_id`	Unknown	PKFK
`duration`	Unknown
`end_at`	Unknown
`num_choices`	Unknown
`step_type`	Unknown

customer_attribute

Column	Type	Keys
`name`	Unknown	PK
`customer_id`	Unknown	PKFK
`customer_session_id`	Unknown	PKFK
`value`	Unknown

customer

Column	Type	Keys
`id`	Unknown	PK
`session_id`	Unknown	PKFK
`billing_interval`	Unknown
`billing_interval_count`	Unknown
`created`	Unknown
`currency`	Unknown
`email`	Unknown
`item_quantity`	Unknown
`latest_discount_expiration`	Unknown
`pause_end`	Unknown
`paused`	Unknown
`plan_id`	Unknown
`plan_price`	Unknown
`subscription_discount_coupon_amount`	Unknown
`subscription_discount_coupon_duration`	Unknown
`subscription_discount_coupon_id`	Unknown
`subscription_discount_coupon_type`	Unknown
`subscription_discount_end`	Unknown
`subscription_discount_id`	Unknown
`subscription_discount_start`	Unknown
`subscription_id`	Unknown
`subscription_period_end`	Unknown
`subscription_period_start`	Unknown
`subscription_start`	Unknown

session

Column	Type	Keys
`id`	Unknown	PK
`aborted`	Unknown
`abtest`	Unknown
`blueprint_id`	Unknown
`canceled`	Unknown
`created_at`	Unknown
`custom_action_handler`	Unknown
`discount_cooldown`	Unknown
`discount_cooldown_applied`	Unknown
`feedback`	Unknown
`followup_question`	Unknown
`followup_response`	Unknown
`managed_flow`	Unknown
`mode`	Unknown
`organization`	Unknown
`provider`	Unknown
`recording`	Unknown
`recording_end_time`	Unknown
`recording_start_time`	Unknown
`save_type`	Unknown
`segment_id`	Unknown
`sentiment_scores_emotion_a_angry`	Unknown
`sentiment_scores_emotion_a_confused`	Unknown
`sentiment_scores_emotion_a_grateful`	Unknown
`sentiment_scores_emotion_a_practical`	Unknown
`sentiment_scores_emotion_b_angry`	Unknown
`sentiment_scores_emotion_b_confused`	Unknown
`sentiment_scores_emotion_b_grateful`	Unknown
`sentiment_scores_emotion_b_practical`	Unknown
`sentiment_scores_product_a_negative`	Unknown
`sentiment_scores_product_a_positive`	Unknown
`sentiment_scores_product_b_negative`	Unknown
`sentiment_scores_product_b_recommend`	Unknown
`sentiment_scores_product_c_great`	Unknown
`sentiment_scores_product_c_poor`	Unknown
`sentiment_scores_product_d_dislike`	Unknown
`sentiment_scores_product_d_hate`	Unknown
`sentiment_scores_product_d_likes`	Unknown
`sentiment_scores_product_d_love`	Unknown
`sentiment_scores_reactivate_a_negative`	Unknown
`sentiment_scores_reactivate_a_reactivate`	Unknown
`sentiment_scores_reactivate_b_negative`	Unknown
`sentiment_scores_reactivate_b_reactivate`	Unknown
`sentiment_scores_reason_a_budget`	Unknown
`sentiment_scores_reason_a_ease`	Unknown
`sentiment_scores_reason_a_feature`	Unknown
`sentiment_scores_reason_a_need`	Unknown
`sentiment_scores_reason_a_refund`	Unknown
`sentiment_scores_reason_a_technical`	Unknown
`sentiment_scores_reason_b_budget`	Unknown
`sentiment_scores_reason_b_ease`	Unknown
`sentiment_scores_reason_b_feature`	Unknown
`sentiment_scores_reason_b_need`	Unknown
`sentiment_scores_reason_b_refund`	Unknown
`sentiment_scores_reason_b_technical`	Unknown
`sentiment_scores_subjective_a_emotional`	Unknown
`sentiment_scores_subjective_a_reasonable`	Unknown
`survey_choice_id`	Unknown
`survey_choice_value`	Unknown
`survey_id`	Unknown
`updated_at`	Instant