Chargebee schema and ERD

33 tables

Loading diagram…

subscription

string

customer_id

string

payment_source_id

string

currency_code

string

start_date

date

trial_end

date

remaining_billing_cycles

int

po_number

string

status

string

trial_start

date

trial_end_action

string

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

service_period_days

int

charge_on_event

string

charge_once

boolean

charge_on_option

string

subscription_item_tier

item_price_id

string

subscription_id

string

starting_unit

int

ending_unit

int

price

long

index

int

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

tax_juris_type

string

tax_juris_name

string

tax_amount_in_local_currency

long

local_currency_code

string

order_line_item_discount

index

int

line_item_id

string

discount_type

string

entity_id

string

discount_amount

long

resent_orders

order_id

string

index

int

reason

string

amount

long

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

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_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

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

invoice_discount

invoice_id

string

index

int

amount

long

description

string

line_item_id

string

entity_type

string

discount_type

string

entity_id

string

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

tax_juris_type

string

tax_juris_name

string

tax_amount_in_local_currency

long

local_currency_code

string

invoice_line_item_discount

index

int

line_item_id

string

discount_type

string

entity_id

string

discount_amount

float

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_invoice

transaction_id

string

invoice_id

string

applied_amount

long

applied_at

date

invoice_date

date

invoice_total

long

invoice_status

string

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

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

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

item_family

string

name

string

description

string

status

string

resource_version

long

updated_at

date

channel

string

_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

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

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

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

comment

string

entity_id

string

entity_type

string

notes

string

type

string

added_by

string

created_at

date

object

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

event

string

occurred_at

date

user

string

content

string

webhooks

string

webhook_status

string

source

enum

event_type

enum

_weld_synced

date