ERD for Recurly

23 tables

Loading diagram…

account

string

parent_account_id

string

dunning_campaign_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

has_past_due_invoice

boolean

code

string

username

string

preferred_locale

string

cc_emails

string

first_name

string

last_name

string

company

string

vat_number

string

tax_exempt

boolean

exemption_certificate

string

bill_to

string

address_phone

string

address_street1

string

address_street2

string

address_city

string

address_region

string

address_postal_code

string

address_country

string

created_at

date

updated_at

date

deleted_at

date

_weld_synced

date

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

address_postal_code

string

address_country

string

vat_number

string

valid

boolean

payment_method_object

string

payment_method_card_type

string

payment_method_first_six

string

payment_method_last_four

string

payment_method_last_two

string

payment_method_exp_month

int

payment_method_exp_year

int

payment_method_gateway_token

string

payment_method_cc_bin_country

string

payment_method_gateway_code

string

payment_method_billing_agreement_id

string

payment_method_name_on_account

string

payment_method_account_type

string

payment_method_routing_number

string

payment_method_routing_number_bank

string

payment_method_username

string

fraud_score

int

fraud_decision

string

fraud_risk_rules_triggered

string

primary_payment_method

boolean

backup_payment_method

boolean

created_at

date

updated_at

date

updated_by_ip

string

updated_by_country

string

_weld_synced

date

shipping_address

string

account_id

string

nickname

string

first_name

string

last_name

string

company

string

vat_number

string

phone

string

street1

string

street2

string

city

string

region

string

postal_code

string

country

string

created_at

date

updated_at

date

_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

revenue_schedule_type

string

avalara_transaction_type

int

avalara_service_type

int

tax_code

string

display_quantity

boolean

default_quantity

int

optional

boolean

tier_type

string

usage_timeframe

string

external_sku

string

created_at

date

updated_at

date

deleted_at

date

_weld_synced

date

add_on_pricing

add_on_id

string

currency

string

unit_amount

float

unit_amount_decimal

float

_weld_synced

date

invoice

string

account_id

string

billing_info_id

string

shipping_address_id

string

previous_invoice_id

string

dunning_campaign_id

string

uuid

string

type

string

origin

string

state

string

number

string

collection_method

string

po_number

string

net_terms

int

address_name_on_account

string

address_company

string

address_phone

string

address_street1

string

address_street2

string

address_city

string

address_region

string

address_postal_code

string

address_country

string

address_first_name

string

address_last_name

string

currency

string

discounted

float

subtotal

float

tax

float

total

float

refundable_amount

float

paid

float

balance

float

tax_info_type

string

tax_info_region

string

tax_info_rate

float

vat_number

string

vat_reverse_charge_notes

string

terms_and_conditions

string

customer_notes

string

created_at

date

updated_at

date

due_at

date

closed_at

date

_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

success

boolean

backup_payment_method_used

boolean

refunded

boolean

billing_address_first_name

string

billing_address_last_name

string

billing_address_phone

string

billing_address_street1

string

billing_address_street2

string

billing_address_city

string

billing_address_region

string

billing_address_postal_code

string

billing_address_country

string

collection_method

string

payment_method_object

string

payment_method_card_type

string

payment_method_first_six

string

payment_method_last_four

string

payment_method_last_two

string

payment_method_exp_month

int

payment_method_exp_year

int

payment_method_gateway_token

string

payment_method_cc_bin_country

string

payment_method_gateway_code

string

payment_method_billing_agreement_id

string

payment_method_name_on_account

string

payment_method_account_type

string

payment_method_routing_number

string

payment_method_routing_number_bank

string

payment_method_username

string

ip_address_v4

string

ip_address_country

string

status_code

string

status_message

string

customer_message

string

customer_message_locale

string

payment_gateway_id

string

payment_gateway_type

string

payment_gateway_name

string

gateway_message

string

gateway_reference

string

gateway_approval_code

string

gateway_response_code

string

gateway_response_time

float

gateway_response_values

string

cvv_check

string

avs_check

string

created_at

date

updated_at

date

voided_at

date

collected_at

date

_weld_synced

date

transaction_subscription

transaction_id

string

subscription_id

string

_weld_synced

date

invoice_subscription

invoice_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

amount

float

created_at

date

updated_at

date

voided_at

date

_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

state

string

legacy_category

string

plan_code

string

add_on_code

string

invoice_number

string

origin

string

accounting_code

string

product_code

string

credit_reason_code

string

currency

string

amount

float

description

string

quantity

int

unit_amount

float

unit_amount_decimal

float

tax_inclusive

boolean

subtotal

float

discount

float

tax

float

taxable

boolean

tax_exempt

boolean

avalara_transaction_type

int

avalara_service_type

int

tax_code

string

tax_info_type

string

tax_info_region

string

tax_info_rate

float

proration_rate

float

refund

boolean

refunded_quantity

int

credit_applied

float

start_date

date

end_date

date

created_at

date

updated_at

date

_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

avalara_service_type

int

tax_code

string

tax_exempt

boolean

created_at

date

updated_at

date

deleted_at

date

_weld_synced

date

item_pricing

item_id

string

currency

string

unit_amount

float

_weld_synced

date

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

trial_started_at

date

trial_ends_at

date

remaining_billing_cycles

int

total_billing_cycles

int

renewal_billing_cycles

int

auto_renew

boolean

paused_at

date

remaining_pause_cycles

int

currency

string

revenue_schedule_type

string

unit_amount

float

tax_inclusive

boolean

quantity

int

add_ons_total

float

subtotal

float

tax

float

tax_info_type

string

tax_info_region

string

tax_info_rate

float

total

float

collection_method

string

po_number

string

net_terms

int

terms_and_conditions

string

customer_notes

string

expiration_reason

string

bank_account_authorized_at

date

gateway_code

string

created_at

date

updated_at

date

activated_at

date

canceled_at

date

expires_at

date

_weld_synced

date

subscription_coupon_redemption

string

coupon_id

string

state

string

discounted

float

created_at

date

_weld_synced

date

account_acquisition

string

account_id

string

cost_currency

string

cost_amount

double

channel

string

subchannel

string

campaign

string

created_at

long

updated_at

long

_weld_synced

long

account_history

string

billing_info_id

string

parent_account_id

string

dunning_campaign_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

has_past_due_invoice

boolean

code

string

username

string

preferred_locale

string

cc_emails

string

first_name

string

last_name

string

company

string

vat_number

string

tax_exempt

boolean

exemption_certificate

string

bill_to

string

address_phone

string

address_street1

string

address_street2

string

address_city

string

address_region

string

address_postal_code

string

address_country

string

created_at

long

updated_at

long

deleted_at

long

billing_info_account_id

string

billing_info_first_name

string

billing_info_last_name

string

billing_info_company

string

billing_info_address_phone

string

billing_info_address_street1

string

billing_info_address_street2

string

billing_info_address_city

string

billing_info_address_region

string

billing_info_address_postal_code

string

billing_info_address_country

string

billing_info_vat_number

string

billing_info_valid

boolean

billing_info_payment_method_object

string

billing_info_payment_method_card_type

string

billing_info_payment_method_first_six

string

billing_info_payment_method_last_four

string

billing_info_payment_method_last_two

string

billing_info_payment_method_exp_month

int

billing_info_payment_method_exp_year

int

billing_info_payment_method_gateway_token

string

billing_info_payment_method_cc_bin_country

string

billing_info_payment_method_gateway_code

string

billing_info_payment_method_billing_agreement_id

string

billing_info_payment_method_name_on_account

string

billing_info_payment_method_account_type

string

billing_info_payment_method_routing_number

string

billing_info_payment_method_routing_number_bank

string

billing_info_payment_method_username

string

billing_info_fraud_score

int

billing_info_fraud_decision

string

billing_info_fraud_risk_rules_triggered

string

billing_info_primary_payment_method

boolean

billing_info_backup_payment_method

boolean

billing_info_created_at

long

billing_info_updated_at

long

billing_info_updated_by_ip

string

billing_info_updated_by_country

string

shipping_addresses

string

_weld_synced

long

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

unique_coupon_code_code

string

unique_coupon_code_state

string

unique_coupon_code_bulk_coupon_id

string

unique_coupon_code_bulk_coupon_code

string

unique_coupon_code_created_at

date

unique_coupon_code_updated_at

date

unique_coupon_code_redeemed_at

date

unique_coupon_code_expired_at

date

duration

string

temporal_amount

int

temporal_unit

string

free_trial_unit

string

free_trial_amount

int

applies_to_all_plans

boolean

applies_to_all_items

boolean

applies_to_non_plan_charges

boolean

redemption_resource

string

discount_type

string

discount_percent

int

discount_trial_unit

string

discount_trial_length

int

coupon_type

string

hosted_page_description

string

invoice_description

string

redeem_by

date

created_at

date

updated_at

date

expired_at

date

_weld_synced

date

invoice_history

string

account_id

string

billing_info_id

string

shipping_address_id

string

previous_invoice_id

string

dunning_campaign_id

string

uuid

string

type

string

origin

string

state

string

number

string

collection_method

string

po_number

string

net_terms

int

address_name_on_account

string

address_company

string

address_phone

string

address_street1

string

address_street2

string

address_city

string

address_region

string

address_postal_code

string

address_country

string

address_first_name

string

address_last_name

string

currency

string

discounted

float

subtotal

float

tax

float

total

float

refundable_amount

float

paid

float

balance

float

tax_info_type

string

tax_info_region

string

tax_info_rate

float

vat_number

string

vat_reverse_charge_notes

string

terms_and_conditions

string

customer_notes

string

created_at

long

updated_at

long

due_at

long

closed_at

long

transactions

string

subscription_ids

string

credit_payments

string

line_items

string

_weld_synced

long

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

trial_requires_billing_info

boolean

total_billing_cycles

int

auto_renew

boolean

pricing_model

string

revenue_schedule_type

string

setup_fee_revenue_schedule_type

string

accounting_code

string

setup_fee_accounting_code

string

avalara_transaction_type

int

avalara_service_type

int

tax_code

string

tax_exempt

boolean

hosted_pages_success_url

string

hosted_pages_cancel_url

string

hosted_pages_bypass_confirmation

boolean

hosted_pages_display_quantity

boolean

allow_any_item_on_subscriptions

boolean

created_at

date

updated_at

date

deleted_at

date

_weld_synced

date

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

trial_requires_billing_info

boolean

total_billing_cycles

int

auto_renew

boolean

pricing_model

string

revenue_schedule_type

string

setup_fee_revenue_schedule_type

string

accounting_code

string

setup_fee_accounting_code

string

avalara_transaction_type

int

avalara_service_type

int

tax_code

string

tax_exempt

boolean

hosted_pages_success_url

string

hosted_pages_cancel_url

string

hosted_pages_bypass_confirmation

boolean

hosted_pages_display_quantity

boolean

allow_any_item_on_subscriptions

boolean

created_at

date

updated_at

date

deleted_at

date

currencies

string

ramp_intervals

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

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

long

current_period_ends_at

long

current_term_started_at

long

current_term_ends_at

long

trial_started_at

long

trial_ends_at

long

remaining_billing_cycles

int

total_billing_cycles

int

renewal_billing_cycles

int

auto_renew

boolean

paused_at

long

remaining_pause_cycles

int

currency

string

revenue_schedule_type

string

unit_amount

float

tax_inclusive

boolean

quantity

int

add_ons_total

float

subtotal

float

tax

float

tax_info_type

string

tax_info_region

string

tax_info_rate

float

total

float

collection_method

string

po_number

string

net_terms

int

terms_and_conditions

string

customer_notes

string

expiration_reason

string

bank_account_authorized_at

long

gateway_code

string

created_at

long

updated_at

long

activated_at

long

canceled_at

long

expires_at

long

coupon_redemptions

string

ramp_intervals

string

add_ons

string

_weld_synced

long

Table

Sub table