Chargebee Data Model
Authentication Authentication is done using an API key. An API key can be found and/or registered on https://SERVER/apikeys_and_webhooks/api. The API key is valid for a specific site. The Chargebee API key can be configured in settings.xml as the value of defaultPassword attribute of the database element. The site is derived from the connection string attribute 'server'. Beware that after deleting records, Chargebee can still return those records for some time (at least 5 seconds).
Richten Sie diese Plattform in der Invantive Cloud ein: https://cloud.invantive.com/chargebee
Bei Textvergleichen auf dieser Plattform wird zwischen Groß- und Kleinschreibung unterschieden.
Plattform
- Verwendung über: Invantive Cloud und die Invantive-Produkte auf Ihrem eigenen Computer oder Server.
- Art: Eine Anwendung, auf die über ihre API zugegriffen wird.
- Die Daten sind partitioniert, beispielsweise nach Unternehmen oder Verwaltungsbereich.
- Daten können sowohl geschrieben als auch gelesen werden.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Status of the platform: https://status.chargebee.com/.
Angaben
| Figure | Count |
|---|---|
| Tables | 114 |
| Columns | 1,534 |
Poster zum Daten Muster
In diesem Daten Muster sind noch keine Schlüssel definiert; die durch Punkte getrennten Relationen werden aus den Namen der Spalten abgeleitet.
Auf einer Tabelle des Posters: Zoom-Vergrößerung und Zoom-Verkleinung, mit den Pfeiltasten bewegen, 0 passt.
Das Poster als Text: Tabellen nach Themen und deren Zusammenhänge
Rechnung
Installments, InvoiceAdjustmentCreditNotes, InvoiceAppliedCredits, InvoiceCreditNotes, InvoiceDiscounts, InvoiceDunningAttempts, InvoiceLineItemDiscounts, InvoiceLineItemTaxes, InvoiceLineItemTiers, InvoiceLineItems, InvoiceLinkedOrders, InvoiceLinkedPayments, InvoiceNotes, InvoiceTaxes, Invoices
Abonnement
EntitlementOverrides, Entitlements, FeatureLevels, Features, SubscriptionEntitlements, SubscriptionAddons, SubscriptionChargedEventBasedAddons, SubscriptionChargedItems, SubscriptionCoupons, SubscriptionCustomFieldValues, SubscriptionDiscounts, SubscriptionEventBasedAddons, SubscriptionItemTiers, SubscriptionItems, Subscriptions
Kunde
CreditNotes, Cards, CustomerBalances, CustomerContacts, CustomerCustomFieldValues, CustomerReferralUrls, Customers, PromotionalCredits, UnbilledCharges, VirtualBankAccounts
Katastrophe
RampCouponsToAdd, RampCouponsToRemove, RampDiscountsToAdd, RampDiscountsToRemove, RampItemTiers, RampItemsToAdd, RampItemsToRemove, RampItemsToUpdate, Ramps
Coupon
CouponAddons, CouponCodes, CouponConstraints, CouponItemConstraintCriteria, CouponItemConstraints, CouponPlans, CouponSets, Coupons
Auftrag
GiftTimelines, Gifts, OrderLineItemDiscounts, OrderLineItemTaxes, OrderLineItems, OrderLinkedCreditNotes, OrderResentOrders, Orders
Quote
QuoteLineItemTiers, QuoteDiscounts, QuoteLineItemDiscounts, QuoteLineItemTaxes, QuoteLineItems, QuoteNotes, QuoteTaxes, Quotes
Plan
PlanApplicableAddons, PlanAttachedAddons, PlanCustomFieldValues, PlanEventBasedAddons, PlanTiers, Plans
Verhandlung
NATIVEPLATFORMSCALARREQUESTS, TransactionLinkedCreditNotes, TransactionLinkedInvoices, TransactionLinkedPayments, TransactionLinkedRefunds, Transactions
Anderes
EventWebhooks, Events, ItemPrices, Items
Addon
AddonCustomFieldValues, AddonTiers, Addons
Payment
PaymentReferenceNumbers, PaymentSourceMandates, PaymentSources
Kauf
PurchaseInvoiceIDs, PurchaseSubscriptionIDs, Purchases
Business (ohne Beziehungen)
BusinessEntities, BusinessEntityTransfers
Anmerkung (ohne Beziehungen)
Währung (ohne Beziehungen)
Benutzerdefiniert (ohne Beziehungen)
Gehostet (ohne Beziehungen)
HostedPageContents, HostedPages
Installment (ohne Beziehungen)
Element (ohne Beziehungen)
Quote (ohne Beziehungen)
Standort (ohne Beziehungen)
Unbilled (ohne Beziehungen)
Beziehungen
- AddonCustomFieldValues → Invoices (Kandidat): Derived from the column invoice_id.
- AddonTiers → Addons (Kandidat): Derived from the column addon_id.
- CouponAddons → Addons (Kandidat): Derived from the column addon_id.
- CouponAddons → Coupons (Kandidat): Derived from the column coupon_id.
- CouponCodes → Coupons (Kandidat): Derived from the column coupon_id.
- CouponConstraints → Coupons (Kandidat): Derived from the column coupon_id.
- CouponItemConstraintCriteria → Coupons (Kandidat): Derived from the column coupon_id.
- CouponItemConstraints → Coupons (Kandidat): Derived from the column coupon_id.
- CouponPlans → Coupons (Kandidat): Derived from the column coupon_id.
- CouponPlans → Plans (Kandidat): Derived from the column plan_id.
- CouponSets → Coupons (Kandidat): Derived from the column coupon_id.
- CreditNotes → Customers (Kandidat): Derived from the column customer_id.
- CreditNotes → Subscriptions (Kandidat): Derived from the column subscription_id.
- Cards → Customers (Kandidat): Derived from the column customer_id.
- CustomerBalances → Customers (Kandidat): Derived from the column customer_id.
- CustomerContacts → Customers (Kandidat): Derived from the column customer_id.
- CustomerCustomFieldValues → Customers (Kandidat): Derived from the column customer_id.
- CustomerReferralUrls → Customers (Kandidat): Derived from the column customer_id.
- EntitlementOverrides → Features (Kandidat): Derived from the column feature_id.
- Entitlements → Features (Kandidat): Derived from the column feature_id.
- FeatureLevels → Features (Kandidat): Derived from the column feature_id.
- SubscriptionEntitlements → Features (Kandidat): Derived from the column feature_id.
- SubscriptionEntitlements → Subscriptions (Kandidat): Derived from the column subscription_id.
- EventWebhooks → Events (Kandidat): Derived from the column event_id.
- GiftTimelines → Gifts (Kandidat): Derived from the column gift_id.
- Installments → Invoices (Kandidat): Derived from the column invoice_id.
- InvoiceAdjustmentCreditNotes → Invoices (Kandidat): Derived from the column invoice_id.
- InvoiceAppliedCredits → Invoices (Kandidat): Derived from the column invoice_id.
- InvoiceCreditNotes → Invoices (Kandidat): Derived from the column invoice_id.
- InvoiceDiscounts → Invoices (Kandidat): Derived from the column invoice_id.
- InvoiceDunningAttempts → Invoices (Kandidat): Derived from the column invoice_id.
- InvoiceDunningAttempts → Transactions (Kandidat): Derived from the column transaction_id.
- InvoiceLineItemDiscounts → Coupons (Kandidat): Derived from the column coupon_id.
- InvoiceLineItemDiscounts → Invoices (Kandidat): Derived from the column invoice_id.
- InvoiceLineItemTaxes → Invoices (Kandidat): Derived from the column invoice_id.
- InvoiceLineItemTiers → Invoices (Kandidat): Derived from the column invoice_id.
- InvoiceLineItems → Customers (Kandidat): Derived from the column customer_id.
- InvoiceLineItems → Invoices (Kandidat): Derived from the column invoice_id.
- InvoiceLineItems → Subscriptions (Kandidat): Derived from the column subscription_id.
- InvoiceLinkedOrders → Invoices (Kandidat): Derived from the column invoice_id.
- InvoiceLinkedPayments → Invoices (Kandidat): Derived from the column invoice_id.
- InvoiceNotes → Invoices (Kandidat): Derived from the column invoice_id.
- InvoiceTaxes → Invoices (Kandidat): Derived from the column invoice_id.
- Invoices → Customers (Kandidat): Derived from the column customer_id.
- Invoices → Subscriptions (Kandidat): Derived from the column subscription_id.
- PaymentReferenceNumbers → Invoices (Kandidat): Derived from the column invoice_id.
- QuoteLineItemTiers → Quotes (Kandidat): Derived from the column quote_id.
- ItemPrices → Items (Kandidat): Derived from the column item_id.
- NATIVEPLATFORMSCALARREQUESTS → Transactions (Kandidat): Derived from the column TRANSACTION_ID.
- OrderLineItemDiscounts → Coupons (Kandidat): Derived from the column coupon_id.
- OrderLineItemDiscounts → Orders (Kandidat): Derived from the column order_id.
- OrderLineItemTaxes → Orders (Kandidat): Derived from the column order_id.
- OrderLineItems → Invoices (Kandidat): Derived from the column invoice_id.
- OrderLineItems → Orders (Kandidat): Derived from the column order_id.
- OrderLinkedCreditNotes → Orders (Kandidat): Derived from the column order_id.
- OrderResentOrders → Orders (Kandidat): Derived from the column order_id.
- Orders → Customers (Kandidat): Derived from the column customer_id.
- Orders → Gifts (Kandidat): Derived from the column gift_id.
- Orders → Invoices (Kandidat): Derived from the column invoice_id.
- Orders → Subscriptions (Kandidat): Derived from the column subscription_id.
- PlanApplicableAddons → Plans (Kandidat): Derived from the column plan_id.
- PlanAttachedAddons → Plans (Kandidat): Derived from the column plan_id.
- PlanCustomFieldValues → Plans (Kandidat): Derived from the column plan_id.
- PlanEventBasedAddons → Plans (Kandidat): Derived from the column plan_id.
- PlanTiers → Plans (Kandidat): Derived from the column plan_id.
- PromotionalCredits → Customers (Kandidat): Derived from the column customer_id.
- QuoteDiscounts → Quotes (Kandidat): Derived from the column quote_id.
- QuoteLineItemDiscounts → Coupons (Kandidat): Derived from the column coupon_id.
- QuoteLineItemDiscounts → Quotes (Kandidat): Derived from the column quote_id.
- QuoteLineItemTaxes → Quotes (Kandidat): Derived from the column quote_id.
- QuoteLineItems → Customers (Kandidat): Derived from the column customer_id.
- QuoteLineItems → Quotes (Kandidat): Derived from the column quote_id.
- QuoteLineItems → Subscriptions (Kandidat): Derived from the column subscription_id.
- QuoteNotes → Quotes (Kandidat): Derived from the column quote_id.
- QuoteTaxes → Quotes (Kandidat): Derived from the column quote_id.
- Quotes → Customers (Kandidat): Derived from the column customer_id.
- Quotes → Invoices (Kandidat): Derived from the column invoice_id.
- Quotes → Subscriptions (Kandidat): Derived from the column subscription_id.
- PaymentSourceMandates → Invoices (Kandidat): Derived from the column invoice_id.
- PaymentSourceMandates → Subscriptions (Kandidat): Derived from the column subscription_id.
- PaymentSources → Customers (Kandidat): Derived from the column customer_id.
- PurchaseInvoiceIDs → Purchases (Kandidat): Derived from the column purchase_id.
- PurchaseSubscriptionIDs → Purchases (Kandidat): Derived from the column purchase_id.
- Purchases → Customers (Kandidat): Derived from the column customer_id.
- RampCouponsToAdd → Coupons (Kandidat): Derived from the column coupon_id.
- RampCouponsToAdd → Ramps (Kandidat): Derived from the column ramp_id.
- RampCouponsToRemove → Ramps (Kandidat): Derived from the column ramp_id.
- RampDiscountsToAdd → Ramps (Kandidat): Derived from the column ramp_id.
- RampDiscountsToRemove → Ramps (Kandidat): Derived from the column ramp_id.
- RampItemTiers → Ramps (Kandidat): Derived from the column ramp_id.
- RampItemsToAdd → Ramps (Kandidat): Derived from the column ramp_id.
- RampItemsToRemove → Ramps (Kandidat): Derived from the column ramp_id.
- RampItemsToUpdate → Ramps (Kandidat): Derived from the column ramp_id.
- Ramps → Subscriptions (Kandidat): Derived from the column subscription_id.
- SubscriptionAddons → Subscriptions (Kandidat): Derived from the column subscription_id.
- SubscriptionChargedEventBasedAddons → Subscriptions (Kandidat): Derived from the column subscription_id.
- SubscriptionChargedItems → Subscriptions (Kandidat): Derived from the column subscription_id.
- SubscriptionCoupons → Coupons (Kandidat): Derived from the column coupon_id.
- SubscriptionCoupons → Subscriptions (Kandidat): Derived from the column subscription_id.
- SubscriptionCustomFieldValues → Subscriptions (Kandidat): Derived from the column subscription_id.
- SubscriptionDiscounts → Coupons (Kandidat): Derived from the column coupon_id.
- SubscriptionDiscounts → Subscriptions (Kandidat): Derived from the column subscription_id.
- SubscriptionEventBasedAddons → Subscriptions (Kandidat): Derived from the column subscription_id.
- SubscriptionItemTiers → Subscriptions (Kandidat): Derived from the column subscription_id.
- SubscriptionItems → Subscriptions (Kandidat): Derived from the column subscription_id.
- Subscriptions → Customers (Kandidat): Derived from the column customer_id.
- Subscriptions → Gifts (Kandidat): Derived from the column gift_id.
- Subscriptions → Plans (Kandidat): Derived from the column plan_id.
- TransactionLinkedCreditNotes → Transactions (Kandidat): Derived from the column transaction_id.
- TransactionLinkedInvoices → Invoices (Kandidat): Derived from the column invoice_id.
- TransactionLinkedInvoices → Transactions (Kandidat): Derived from the column transaction_id.
- TransactionLinkedPayments → Transactions (Kandidat): Derived from the column transaction_id.
- TransactionLinkedRefunds → Transactions (Kandidat): Derived from the column transaction_id.
- Transactions → Customers (Kandidat): Derived from the column customer_id.
- Transactions → Subscriptions (Kandidat): Derived from the column subscription_id.
- UnbilledCharges → Customers (Kandidat): Derived from the column customer_id.
- UnbilledCharges → Subscriptions (Kandidat): Derived from the column subscription_id.
- VirtualBankAccounts → Customers (Kandidat): Derived from the column customer_id.
Tabellen
Chargebee.Addons
- AddonCustomFieldValues: Addon Custom Fields
- AddonTiers: Add-on Tiers
- Addons: Add-ons
Chargebee.Addresses
- Addresses: Addresses
Chargebee.BusinessEntities
- BusinessEntities: Business Entities
- BusinessEntityTransfers: Business Entity Transfers
Chargebee.Comments
- Comments: Comments
Chargebee.Coupons
- CouponAddons: Coupon Add-ons
- CouponCodes: Coupon Codes
- CouponConstraints: Coupon Constraints
- CouponItemConstraintCriteria: Coupon Item Constraint Criteria
- CouponItemConstraints: Coupon Item Constraints
- CouponPlans: Coupon Plans
- CouponSets: Coupon Sets
- Coupons: Coupons
Chargebee.CreditNotes
- CreditNotes: Credit Notes
Chargebee.Currencies
- Currencies: Currencies
Chargebee.CustomFields
- CustomFieldConfigurations: Custom Field Configs
Chargebee.Customers
- Cards: Cards
- CustomerBalances: Customer Balances
- CustomerContacts: Customer Contacts
- CustomerCustomFieldValues: Customer Custom Fields
- CustomerReferralUrls: Customer Referral URLs
- Customers: Customers
Chargebee.Entitlements
- EntitlementOverrides: Entitlement Overrides
- Entitlements: Entitlements
- FeatureLevels: Feature Levels
- Features: Features
- SubscriptionEntitlements: Subscription Entitlements
Chargebee.Events
- EventWebhooks: Event Webhooks
- Events: Events
Chargebee.Gifts
- GiftTimelines: Gift Timelines
- Gifts: Gifts
Chargebee.HostedPages
- HostedPageContents: Hosted Page Contents
- HostedPages: Hosted Pages
Chargebee.InAppPurchases
- InAppSubscriptionsById: In App Subscriptions
Chargebee.Invoices
- InstallmentConfigurations: Installment Configurations
- Installments: Installment Configurations
- InvoiceAdjustmentCreditNotes: Invoice Adjustment Credit Notes
- InvoiceAppliedCredits: Invoice Applied Credits
- InvoiceCreditNotes: Invoice Credit Notes
- InvoiceDiscounts: Invoice Discounts
- InvoiceDunningAttempts: Invoice Dunning Attempts
- InvoiceLineItemDiscounts: Invoice Line Item Discounts
- InvoiceLineItemTaxes: Invoice Line Item Taxes
- InvoiceLineItemTiers: Invoice Line Item Tiers
- InvoiceLineItems: Invoice Line Items
- InvoiceLinkedOrders: Invoice Linked Orders
- InvoiceLinkedPayments: Invoice Linked Payments
- InvoiceNotes: Invoice Notes
- InvoicePdfById: Invoice as PDF
- InvoiceTaxes: Invoice Taxes
- Invoices: Invoices
- PaymentReferenceNumbers: Payment Reference Numbers
- QuoteLineItemTiers: Quote Line Item Tiers
Chargebee.Items
- ItemFamilies: Item Families
- ItemPrices: Item Prices
- Items: Items
Chargebee.Native
- NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar Requests
Chargebee.Orders
- OrderLineItemDiscounts: Order Line Item Discounts
- OrderLineItemTaxes: Order Line Item Taxes
- OrderLineItems: Order Line Items
- OrderLinkedCreditNotes: Order Linked Credit Notes
- OrderResentOrders: Order Resent Orders
- Orders: Orders
Chargebee.Plans
- PlanApplicableAddons: Plan Applicable Add-ons
- PlanAttachedAddons: Plan Attached Add-ons
- PlanCustomFieldValues: Plan Custom Fields
- PlanEventBasedAddons: Plan Event-based Add-ons
- PlanTiers: Plan Tiers
- Plans: Plans
Chargebee.PromotionalCredits
- PromotionalCredits: Promotional Credits
Chargebee.Quotes
- QuoteDiscounts: Quote Discounts
- QuoteLineGroups: Quote Line Groups
- QuoteLineItemDiscounts: Quote Line Item Discounts
- QuoteLineItemTaxes: Quote Line Item Taxes
- QuoteLineItems: Quote Line Items
- QuoteNotes: Quote Notes
- QuoteTaxes: Quote Taxes
- Quotes: Quotes
Chargebee.SiteMigrationDetails
- SiteMigrationDetails: Site Migration Details
Chargebee.Subscriptions
- PaymentSourceMandates: Payment Source Mandates
- PaymentSources: Payment Sources
- PurchaseInvoiceIDs: Purchase Invoice IDs
- PurchaseSubscriptionIDs: Purchase Subscription IDs
- Purchases: Purchases
- RampCouponsToAdd: Ramp Coupons to Add
- RampCouponsToRemove: Ramp Coupons to Remove
- RampDiscountsToAdd: Ramp Discounts to Add
- RampDiscountsToRemove: Ramp Discounts to Remove
- RampItemTiers: Ramp Item Tiers
- RampItemsToAdd: Ramp Items to Add
- RampItemsToRemove: Ramp Items to Remove
- RampItemsToUpdate: Ramp Items to Update
- Ramps: Ramps
- SubscriptionAddons: Subscription Add-ons
- SubscriptionChargedEventBasedAddons: Subscription-charged Event-based Add-ons
- SubscriptionChargedItems: Subscription Items
- SubscriptionCoupons: Subscription Coupons
- SubscriptionCustomFieldValues: Subscription Custom Fields
- SubscriptionDiscounts: Subscription Items
- SubscriptionEventBasedAddons: Subscription Event-based Add-ons
- SubscriptionItemTiers: Subscription Items
- SubscriptionItems: Subscription Items
- Subscriptions: Subscriptions
- UsagesBySubscriptionID: Usages by Subscription ID
Chargebee.Transactions
- TransactionLinkedCreditNotes: Transaction Linked Credit Notes
- TransactionLinkedInvoices: Transaction Linked Invoices
- TransactionLinkedPayments: Transaction Linked Payments
- TransactionLinkedRefunds: Transaction Linked Refunds
- Transactions: Subscription Add-ons
Chargebee.UnbilledCharges
- UnbilledChargeTiers: Unbilled Charge Tiers
- UnbilledCharges: Unbilled Charges
Chargebee.VirtualBankAccounts
- VirtualBankAccounts: Virtual Bank Accounts
Attribute
The attributes of this platform are on the page Attributes.
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: