Chargebee schema and ERD

49 tables

Loading diagram…

subscription

customer

payment_source

price_variant

credit_note

unbilled_charge

invoice

order

transaction

subscription

string

customer_id

string

payment_source_id

string

plan_id

string

currency_code

string

start_date

date

trial_end

date

remaining_billing_cycles

int

po_number

string

status

string

trial_start

date

usage

string

subscription_id

string

item_price_id

string

invoice_id

string

usage_date

date

line_item_id

string

quantity

string

source

string

note

string

resource_version

long

updated_at

date

created_at

date

_weld_synced

date

subscription_item

subscription_id

string

item_price_id

string

index

int

item_type

string

quantity

int

unit_price

long

amount

long

free_quantity

int

trial_end

date

billing_cycles

int

subscription_contract_term

string

subscription_id

string

status

string

contract_start

date

contract_end

date

billing_cycle

int

action_at_term_end

string

total_contract_value

long

cancellation_cutoff_period

int

created_at

date

remaining_billing_cycles

int

_weld_synced

date

subscription_item_tier

item_price_id

string

subscription_id

string

starting_unit

int

ending_unit

int

price

long

index

int

_weld_synced

date

subscription_coupon

subscription_id

string

coupon_id

string

apply_till

date

applied_count

int

coupon_code

string

_weld_synced

date

customer

string

first_name

string

last_name

string

phone

string

company

string

vat_number

string

auto_collection

string

offline_payment_method

string

customer_contact

string

customer_id

string

first_name

string

last_name

string

enabled

boolean

_weld_synced

date

customer_referral_url

customer_id

string

index

int

external_customer_id

string

referral_sharing_url

string

created_at

date

updated_at

date

referral_campaign_id

string

referral_account_id

string

referral_external_campaign_id

string

referral_system

string

_weld_synced

date

coupon

string

name

string

invoice_name

string

discount_type

enum

discount_percentage

double

discount_amount

double

currency_code

string

duration_type

enum

valid_till

date

event

string

occurred_at

date

user

string

content

string

webhooks

string

webhook_status

string

source

enum

event_type

enum

_weld_synced

date

payment_source

string

customer_id

string

resource_version

date

updated_at

date

created_at

date

type

string

reference_id

string

status

string

gateway

string

gateway_account_id

string

payment_source_mandate

string

subscription_id

string

payment_source_id

string

created_at

date

_weld_synced

date

price_variant

string

name

string

type

string

external_name

string

resource_version

date

status

string

object

string

created_at

date

updated_at

date

_weld_synced

date

price_variant_attribute

price_variant_id

string

name

string

value

string

_weld_synced

date

promotional_credit

string

customer_id

string

type

string

amount

long

currency_code

string

description

string

credit_type

string

reference

string

closing_balance

long

done_by

string

created_at

date

_weld_synced

date

credit_note

string

customer_id

string

subscription_id

string

invoice_id

string

type

string

reason_code

string

status

string

vat_number

string

date

price_type

string

currency_code

string

total_contract_value

long

credit_note_tax

credit_note_id

string

index

int

name

string

amount

long

description

string

_weld_synced

date

credit_note_discount

credit_note_id

string

index

int

amount

long

description

string

line_item_id

string

entity_type

string

discount_type

string

entity_id

string

_weld_synced

date

credit_note_line_item

string

credit_note_id

string

subscription_id

string

customer_id

string

date_from

date

date_to

date

unit_amount

long

quantity

int

amount

long

pricing_model

string

is_taxed

boolean

tax_amount

long

credit_note_line_item_tier

line_item_id

string

index

int

starting_unit

int

ending_unit

int

quantity_used

int

unit_amount

long

_weld_synced

date

credit_note_line_item_discount

index

int

line_item_id

string

discount_type

string

entity_id

string

amount

long

_weld_synced

date

credit_note_line_item_tax

line_item_id

string

index

int

tax_name

string

tax_rate

double

is_partial_tax_applied

boolean

is_non_compliance_tax

boolean

taxable_amount

long

tax_amount

long

credit_note_refund

transaction_id

string

credit_note_id

string

applied_amount

long

applied_at

date

_weld_synced

date

credit_note_allocation

credit_note_id

string

invoice_id

string

index

int

allocated_amount

long

allocated_at

date

_weld_synced

date

allocated_invoice

credit_note_id

string

invoice_id

string

index

int

allocated_amount

long

allocated_at

date

invoice_date

date

invoice_status

string

_weld_synced

date

unbilled_charge

string

customer_id

string

subscription_id

string

date_from

long

date_to

long

unit_amount

long

pricing_model

string

quantity

long

amount

long

currency_code

string

discount_amount

long

unbilled_charge_tier

unbilled_charge_id

string

index

int

starting_unit

int

ending_unit

int

quantity_used

int

unit_amount

long

_weld_synced

date

invoice

string

customer_id

string

subscription_id

string

po_number

string

recurring

boolean

status

string

vat_number

string

price_type

string

date

due_date

date

net_term_days

int

invoice_tax

invoice_id

string

index

int

name

string

amount

long

description

string

_weld_synced

date

invoice_discount

invoice_id

string

index

int

amount

long

description

string

line_item_id

string

entity_type

string

discount_type

string

entity_id

string

_weld_synced

date

invoice_line_item

string

invoice_id

string

customer_id

string

date_from

date

date_to

date

unit_amount

long

quantity

int

amount

long

pricing_model

string

is_taxed

boolean

tax_amount

long

invoice_line_item_tax

index

int

line_item_id

string

tax_name

string

tax_rate

double

is_partial_tax_applied

boolean

is_non_compliance_tax

boolean

taxable_amount

long

tax_amount

long

invoice_line_item_discount

index

int

line_item_id

string

discount_type

string

entity_id

string

discount_amount

float

_weld_synced

date

invoice_line_item_tier

index

int

line_item_id

string

starting_unit

int

ending_unit

int

quantity_used

int

unit_amount

float

_weld_synced

date

order

string

invoice_id

string

subscription_id

string

customer_id

string

document_number

string

status

string

cancellation_reason

string

payment_status

string

order_type

string

price_type

string

reference_id

string

fulfillment_status

string

order_line_item

string

order_id

string

invoice_id

string

unit_price

long

description

string

amount

long

fulfillment_quantity

int

fulfillment_amount

long

tax_amount

long

amount_paid

long

amount_adjusted

long

order_line_item_tax

line_item_id

string

index

int

tax_name

string

tax_rate

double

is_partial_tax_applied

boolean

is_non_compliance_tax

boolean

taxable_amount

long

tax_amount

long

order_line_item_discount

index

int

line_item_id

string

discount_type

string

entity_id

string

discount_amount

long

_weld_synced

date

resent_orders

order_id

string

index

int

reason

string

amount

long

_weld_synced

date

transaction

string

customer_id

string

subscription_id

string

payment_source_id

string

gateway_account_id

string

payment_method

string

reference_number

string

gateway

string

type

string

date

settled_at

date

exchange_rate

float

transaction_credit_note

transaction_id

string

creditnote_id

string

_weld_synced

date

transaction_invoice

transaction_id

string

invoice_id

string

applied_amount

long

applied_at

date

invoice_date

date

invoice_total

long

invoice_status

string

_weld_synced

date

transaction_refund

transaction_id

string

index

int

transaction_status

string

transaction_date

date

transaction_amount

long

_weld_synced

date

virtual_bank_account

string

customer_id

string

scheme

string

bank_name

string

account_number

string

routing_number

string

swift_code

string

gateway

string

gateway_account_id

string

item_price

string

item_family_id

string

item_id

string

name

string

description

string

status

string

external_name

string

pricing_model

string

price

long

period

int

currency_code

string

item

string

item_family_id

string

name

string

external_name

string

description

string

status

string

resource_version

long

updated_at

date

type

string

is_shippable

boolean

item_family

string

name

string

description

string

status

string

resource_version

long

updated_at

date

channel

string

_weld_synced

date

comment

string

entity_id

string

entity_type

string

notes

string

type

string

added_by

string

created_at

date

object

string

_weld_synced

date