ChartMogul

Explore the interactive ERD

Table & Field Reference

data_source

Column	Type	Keys
`uuid`	String	PK
`created_at`	Unknown
`name`	String
`status`	String
`systems`	String

plan_group

Column	Type	Keys
`uuid`	String	PK
`name`	String
`plans_count`	Long

plan

Column	Type	Keys
`uuid`	String	PK
`data_source_uuid`	String	FK
`external_id`	String
`interval_count`	Long
`interval_unit`	String
`name`	String

mrr_churn_rate

Column	Type	Keys
`date`	Unknown	PK
`mrr_churn_rate`	Double
`percentage_change`	Double

account

Column	Type	Keys
`_fivetran_id`	String	PK
`currency`	String
`name`	String
`time_zone`	String
`week_start_on`	String

annualized_run_rate

Column	Type	Keys
`date`	Unknown	PK
`arr`	Long
`percentage_change`	Double

customer_data_source_uuids

Column	Type	Keys
`customer_uuid`	String	PKFK
`data_source_uuid`	String	PKFK

customer_attribute_tag

Column	Type	Keys
`tags`	String	PK
`customer_uuid`	String	PKFK

customer_external_ids

Column	Type	Keys
`external_id`	String	PK
`customer_uuid`	String	PKFK

customer

Column	Type	Keys
`uuid`	String	PK
`data_source_uuid`	String	FK
`address_address_zip`	String
`address_city`	String
`address_country`	String
`address_state`	String
`arr`	Long
`attributes_clearbit_company_category_industry`	String
`attributes_clearbit_company_category_industry_group`	String
`attributes_clearbit_company_category_sector`	String
`attributes_clearbit_company_category_sub_industry`	String
`attributes_clearbit_company_domain`	String
`attributes_clearbit_company_legal_name`	String
`attributes_clearbit_company_metrics_alexa_global_rank`	Long
`attributes_clearbit_company_metrics_employees`	Long
`attributes_clearbit_company_metrics_google_rank`	Long
`attributes_clearbit_company_metrics_market_cap`	Unknown
`attributes_clearbit_company_metrics_raised`	Long
`attributes_clearbit_company_name`	String
`attributes_clearbit_company_url`	String
`attributes_clearbit_person_employment_name`	String
`attributes_clearbit_person_name_full_name`	String
`attributes_stripe_coupon`	Boolean
`attributes_stripe_uid`	Long
`billing_system_type`	String
`billing_system_url`	String
`chartmogul_url`	String
`city`	String
`company`	String
`country`	String
`currency`	String
`currency_sign`	String
`customer_since`	Unknown
`email`	String
`external_id`	String
`free_trial_started_at`	Unknown
`id`	Long
`lead_created_at`	Unknown
`mrr`	Long
`name`	String
`state`	String
`status`	String
`zip`	String
`custom_`

customer_churn_rate

Column	Type	Keys
`date`	Unknown	PK
`customer_churn_rate`	Double
`percentage_change`	Double

plan_in_plan_group

Column	Type	Keys
`plan_group_uuid`	String	PKFK
`uuid`	String	PKFK
`data_source_uuid`	String	FK
`external_id`	String
`interval_count`	Long
`interval_unit`	String
`name`	String

customer_count

Column	Type	Keys
`date`	Unknown	PK
`customers`	Long
`percentage_change`	Double

customer_lifetime_value

Column	Type	Keys
`date`	Unknown	PK
`ltv`	Long
`percentage_change`	Double

cancellation_date

Column	Type	Keys
`cancellation_date`	Unknown	PK
`subscription_uuid`	String	PKFK

subscription

Column	Type	Keys
`uuid`	String	PK
`customer_uuid`	String	PKFK
`data_source_uuid`	String	FK
`plan_uuid`	String	FK
`external_id`	String
`subscription_set_external_id`	String

average_sale_price

Column	Type	Keys
`date`	Unknown	PK
`asp`	Long
`percentage_change`	Double

invoice_line_item

Column	Type	Keys
`uuid`	String	PK
`data_source_uuid`	Unknown	FK
`invoice_uuid`	String	FK
`plan_uuid`	String	FK
`subscription_uuid`	String	FK
`account_code`	Unknown
`amount_in_cents`	Long
`discount_amount_in_cents`	Long
`discount_code`	String
`discount_description`	String
`event_order`	Long
`external_id`	String
`prorated`	Boolean
`proration_type`	String
`quantity`	Long
`service_period_end`	Unknown
`service_period_start`	Unknown
`subscription_external_id`	String
`subscription_set_external_id`	String
`tax_amount_in_cents`	Long
`transaction_fees_currency`	String
`transaction_fees_in_cents`	Long
`type`	String

invoice_transaction

Column	Type	Keys
`uuid`	String	PK
`invoice_uuid`	String	FK
`amount_in_cent`	Long
`date`	Unknown
`external_id`	String
`result`	String
`transaction_fees_currency`	String
`transaction_fees_in_cent`	Long
`type`	String

invoice

Column	Type	Keys
`uuid`	String	PK
`customer_uuid`	String	FK
`currency`	String
`date`	Unknown
`due_date`	Unknown
`external_id`	String

average_revenue_per_account

Column	Type	Keys
`date`	Unknown	PK
`arpa`	Long
`percentage_change`	Double

metric_subscription

Column	Type	Keys
`id`	Long	PK
`customer_uuid`	String	FK
`arr`	Long
`billing_cycle`	String
`billing_cycle_count`	Long
`currency`	String
`currency_sign`	String
`end_date`	Unknown
`external_id`	String
`mrr`	Long
`plan`	String
`quantity`	Long
`start_date`	Unknown
`status`	String

monthly_recurring_revenue

Column	Type	Keys
`date`	Unknown	PK
`mrr`	Long
`mrr_churn`	Long
`mrr_contraction`	Long
`mrr_expansion`	Long
`mrr_new_business`	Long
`mrr_reactivation`	Long
`percentage_change`	Double

subscription_event

Column	Type	Keys
`id`	Long	PK
`data_source_uuid`	String	FK
`amount_in_cents`	Unknown
`created_at`	Unknown
`currency`	String
`data_source_customer_external_id`	String
`effective_date`	Unknown
`errors`	Json
`event_date`	Unknown
`event_type`	String
`external_id`	String
`plan_external_id`	String
`quantity`	Unknown
`retracted_event_id`	Unknown
`subscription_external_id`	String
`subscription_set_external_id`	String
`tax_amount_in_cents`	Long
`updated_at`	Unknown

activity

Column	Type	Keys
`uuid`	Unknown	PK
`customer_uuid`	Unknown	FK
`active_subscription_quantity`	Unknown
`activity_mrr`	Unknown
`activity_mrr_movement`	Unknown
`billing_connector_uuid`	Unknown
`currency`	Unknown
`customer_external_id`	Unknown
`customer_name`	Unknown
`date`	Unknown
`description`	Unknown
`plan_external_id`	Unknown
`subscription_external_id`	Unknown
`type`	Unknown