Recurly schema and ERD

41 tables

Loading diagram…

account

subscription

invoice

invoice_line_item

transaction

plan

add_on

item

coupon

dunning_campaign

account_acquisition

string

account_id

string

cost_currency

string

cost_amount

double

channel

string

subchannel

string

campaign

string

created_at

date

updated_at

date

_weld_synced

date

account_note

string

account_id

string

message

string

created_at

date

_weld_synced

date

account

string

dunning_campaign_id

string

parent_account_id

string

state

string

hosted_login_token

string

has_live_subscription

boolean

has_active_subscription

boolean

has_future_subscription

boolean

has_canceled_subscription

boolean

has_paused_subscription

boolean

billing_info

string

account_id

string

first_name

string

last_name

string

company

string

address_phone

string

address_street1

string

address_street2

string

address_city

string

address_region

string

shipping_address

string

account_id

string

nickname

string

first_name

string

last_name

string

company

string

vat_number

string

phone

string

street1

string

subscription

string

account_id

string

plan_id

string

billing_info_id

string

shipping_address_id

string

shipping_method_id

string

active_invoice_id

string

state

string

uuid

string

shipping_amount

float

current_period_started_at

date

current_period_ends_at

date

current_term_started_at

date

current_term_ends_at

date

subscription_coupon_redemption

string

coupon_id

string

state

string

discounted

float

created_at

date

_weld_synced

date

subscription_ramp_interval

subscription_id

string

account_id

string

index

int

starting_billing_cycle

int

remaining_billing_cycles

int

unit_amount

float

_weld_synced

date

subscription_add_on

string

subscription_id

string

add_on_id

string

add_on_source

string

quantity

int

unit_amount

float

unit_amount_decimal

float

revenue_schedule_type

string

tier_type

string

usage_timeframe

string

usage_percentage

float

created_at

date

updated_at

date

expired_at

date

_weld_synced

date

subscription_add_on_tier

subscription_add_on_id

string

index

int

ending_quantity

int

unit_amount

float

unit_amount_decimal

float

_weld_synced

date

subscription_add_on_percentage_tier

subscription_add_on_id

string

index

int

ending_amount

float

usage_percentage

float

_weld_synced

date

invoice

string

account_id

string

billing_info_id

string

dunning_campaign_id

string

shipping_address_id

string

previous_invoice_id

string

uuid

string

type

string

origin

string

state

string

number

string

collection_method

string

po_number

string

invoice_subscription

invoice_id

string

subscription_id

string

_weld_synced

date

invoice_coupon_redemption

coupon_redemption_id

string

invoice_id

string

discounted

double

_weld_synced

date

invoice_line_item

string

item_id

string

account_id

string

subscription_id

string

plan_id

string

add_on_id

string

invoice_id

string

shipping_address_id

string

bill_for_account_id

string

previous_line_item_id

string

original_line_item_invoice_id

string

uuid

string

type

string

item_code

string

external_sku

string

revenue_schedule_type

string

invoice_line_item_discount

coupon_redemption_id

string

invoice_id

string

coupon_id

string

line_item_id

string

order_applied

int

discount_amount

double

currency

string

_weld_synced

date

transaction

string

account_id

string

invoice_id

string

original_transaction_id

string

voiced_by_invoice_id

string

uuid

string

type

string

origin

string

currency

string

amount

float

status

string

transaction_subscription

transaction_id

string

subscription_id

string

_weld_synced

date

credit_payment

string

account_id

string

parent_invoice_id

string

applied_to_invoice_id

string

original_invoice_id

string

original_credit_payment_id

string

refund_transaction_id

string

uuid

string

action

string

currency

string

plan

string

dunning_campaign_id

string

code

string

state

string

name

string

description

string

interval_unit

string

interval_length

int

trial_unit

string

trial_length

int

plan_pricing

plan_id

string

currency

string

setup_fee

float

unit_amount

float

_weld_synced

date

plan_ramp_interval

plan_id

string

index

int

starting_billing_cycle

int

currencies

string

_weld_synced

date

add_on

string

plan_id

string

item_id

string

measured_unit_id

string

code

string

state

string

name

string

add_on_type

string

usage_type

string

usage_percentage

float

accounting_code

string

add_on_pricing

add_on_id

string

currency

string

unit_amount

float

unit_amount_decimal

float

_weld_synced

date

add_on_percentage_tier

add_on_id

string

currency

string

ending_amount

float

usage_percentage

float

_weld_synced

date

add_on_tier

add_on_id

string

ending_quantity

int

currency

string

unit_amount

float

unit_amount_decimal

float

_weld_synced

date

item

string

code

string

state

string

name

string

description

string

external_sku

string

accounting_code

string

revenue_schedule_type

string

avalara_transaction_type

int

item_pricing

item_id

string

currency

string

unit_amount

float

_weld_synced

date

coupon

string

code

string

name

string

state

string

max_redemptions

int

max_redemptions_per_account

int

unique_coupon_codes_count

int

unique_code_template

string

unique_coupon_code_id

string

coupon_discount_pricing

coupon_id

string

currency

string

amount

float

_weld_synced

date

coupon_plan

coupon_id

string

plan_id

string

code

string

name

string

_weld_synced

date

coupon_item

coupon_id

string

item_id

string

code

string

state

string

name

string

description

string

_weld_synced

date

coupon_redemption

string

account_id

string

subscription_id

string

coupon_id

string

uuid

string

state

string

currency

string

discounted

double

remaining_duration_type

string

remaining_duration_expires_at

date

remaining_duration_redemptions_remaining

int

created_at

date

updated_at

date

removed_at

date

_weld_synced

date

dunning_campaign

string

code

string

name

string

description

string

default_campaign

string

created_at

date

updated_at

date

deleted_at

date

_weld_synced

date

dunning_cycle

dunning_campaign_id

string

index

int

type

string

applies_to_manual_trial

boolean

first_communication_interval

int

send_immediately_on_hard_decline

boolean

expire_subscription

boolean

fail_invoice

boolean

total_dunning_days

int

dunning_cycle_interval

dunning_campaign_id

string

index

int

days

int

email_template

string

_weld_synced

date

shipping_method

shipping_method_id

string

object

string

code

string

name

string

accounting_code

string

tax_code

string

created_at

string

updated_at

string

deleted_at

string

_weld_synced

date

account_history

string

dunning_campaign_id

string

billing_info_id

string

parent_account_id

string

state

string

hosted_login_token

string

has_live_subscription

boolean

has_active_subscription

boolean

has_future_subscription

boolean

has_canceled_subscription

boolean

has_paused_subscription

boolean

subscription_history

string

account_id

string

plan_id

string

billing_info_id

string

shipping_address_id

string

shipping_method_id

string

active_invoice_id

string

state

string

uuid

string

shipping_amount

float

current_period_started_at

date

current_period_ends_at

date

current_term_started_at

date

current_term_ends_at

date

invoice_history

string

account_id

string

billing_info_id

string

dunning_campaign_id

string

shipping_address_id

string

previous_invoice_id

string

uuid

string

type

string

origin

string

state

string

number

string

collection_method

string

po_number

string

plan_history

string

dunning_campaign_id

string

code

string

state

string

name

string

description

string

interval_unit

string

interval_length

int

trial_unit

string

trial_length

int