Quote to Cash Entity Relationship Diagrams
Entity Relationship Diagrams for Quote to Cash Systems
Quote to Cash Entity Relationship Diagrams
Zuora Billing
erDiagram
Product ||..|{ ProductRatePlan : contains
ProductRatePlan ||..|{ ProductRatePlanCharge : contains
ProductRatePlanCharge ||..|{ ProductRatePlanChargeTier : contains
Account ||..o{ Subscription : has
Subscription ||..|{ RatePlan : has
RatePlan ||..|{ RatePlanCharge : has
RatePlanCharge ||..|{ RatePlanChargeTier : has
ProductRatePlan ||..|{ RatePlan : "catalog trace"
ProductRatePlanCharge ||..|{ RatePlanCharge : "catalog trace"
Subscription ||..o{ Amendment : has
Account ||..|{ Contact : has
Account ||..o{ PaymentMethod : has
Account ||..o{ PaymentMethodSnapshot : has
PaymentMethod ||..|| PaymentMethodSnapshot : has
Account ||..o{ Invoice : has
Account ||..o{ Payment : has
Invoice ||..|{ InvoiceItem : contains
InvoiceItem ||..|| RatePlanCharge : "subscription trace"
Invoice ||..o{ InvoicePayment : "payment trace"
InvoicePayment ||..|| Payment : "payment trace"
InvoiceItem ||..o{ TaxationItem : tax
Account ||..o{ Refund : has
Refund ||..|| PaymentMethodSnapshot : source
Refund ||..o{ RefundInvoicePayment : "refund trace"
RefundInvoicePayment ||..|| InvoicePayment : "refund trace"
InvoiceItem ||..o| Amendment : source
InvoiceItem ||..|| Subscription : "subscription trace"
Account {
varchar accountnumber
varchar additionalemailaddresses
boolean allowinvoiceedit
boolean autopay
decimal_22_9_ balance
varchar batch
varchar bcdsettingoption
bigint billcycleday
varchar-fk billtoid
varchar communicationprofileid
varchar-fk createdbyid
timestampwithtimezone createddate
decimal_22_9_ creditbalance
varchar creditmemotemplateid
varchar-fk crmid
varchar currency
varchar customerservicerepname
varchar-fk debitmemotemplateid
varchar-fk defaultpaymentmethodid
varchar-pk id
boolean invoicedeliveryprefsemail
boolean invoicedeliveryprefsprint
varchar invoicetemplateid
date lastinvoicedate
decimal_22_9_ mrr
varchar name
varchar notes
varchar parentid
varchar paymentgateway
varchar paymentterm
varchar purchaseordernumber
varchar salesrepname
varchar sequencesetid
varchar-fk soldtoid
varchar status
varchar taxcompanycode
varchar taxexemptcertificateid
varchar taxexemptcertificatetype
varchar taxexemptdescription
date taxexempteffectivedate
varchar taxexemptentityusecode
date taxexemptexpirationdate
varchar taxexemptissuingjurisdiction
varchar taxexemptstatus
decimal_22_9_ totaldebitmemobalance
decimal_22_9_ totalinvoicebalance
decimal_22_9_ unappliedbalance
decimal_22_9_ unappliedcreditmemoamount
varchar-fk updatedbyid
timestampwithtimezone updateddate
varchar vatid
varchar accountcode__c
varchar conversionrate__c
date credithold__c
varchar entity__c
varchar excludefromeoastarterbronzeoffer__c
varchar parent__c
varchar porequired__c
varchar portalnameurl__c
varchar portalrequired__c
varchar sfdc_sync__c
varchar sspchannel__c
varchar support_hold__c__c
}
Subscription {
varchar-fk accountid
boolean autorenew
varchar-fk billtocontactid
varchar-fk billtocontactsnapshotid
date cancelleddate
decimal_22_9_ cmrr
date contractacceptancedate
date contracteffectivedate
varchar createdbyid
timestampwithtimezone createddate
varchar-fk creatoraccountid
varchar creatorinvoiceownerid
bigint currentterm
varchar currenttermperiodtype
varchar-pk id
bigint initialterm
varchar initialtermperiodtype
varchar-fk invoiceownerid
boolean isinvoiceseparate
varchar name
varchar notes
timestampwithtimezone originalcreateddate
varchar-fk originalid
varchar paymentterm
varchar-fk previoussubscriptionid
varchar-fk rampid
varchar renewalsetting
bigint renewalterm
varchar renewaltermperiodtype
varchar revision
date serviceactivationdate
varchar status
date subscriptionenddate
date subscriptionstartdate
varchar-fk subscriptionversionamendmentid
date termenddate
date termstartdate
varchar termtype
varchar-fk updatedbyid
timestampwithtimezone updateddate
bigint version
varchar cpqbundlejsonid__qt
date opportunityclosedate__qt
varchar opportunityname__qt
varchar quotebusinesstype__qt
varchar quotenumber__qt
varchar quotetype__qt
varchar autorenew__c
varchar churn__c__c
varchar contractautorenew__c
varchar contractoperationalmetrics__c
varchar contractseatreconciliation__c
varchar endcustomerdetails__c
varchar eoastarterbronzeofferaccepted__c
varchar exclude_from_renewal_report__c__c
varchar excludefromanalysis__c
varchar gitlabnamespaceid__c
varchar gitlabnamespacename__c
varchar multiyeardealsubscriptionlinkage__c
varchar opportunityid__c
varchar purchase_order__c
varchar recurlyid__c
varchar renewal_subscription__c__c
varchar sfdcsync__c
varchar turnonautorenew__c
varchar turnoncloudlicensing__c
varchar turnonoperationalmetrics__c
varchar turnonseatreconciliation__c
}
Product{
boolean allowfeaturechanges
varchar category
varchar-fk createdbyid
timestampwithtimezone createddate
varchar description
date effectiveenddate
date effectivestartdate
varchar-pk id
varchar name
varchar sku
varchar-fk updatedbyid
timestampwithtimezone updateddate
}
ProductRatePlan{
varchar-fk createdbyid
timestampwithtimezone createddate
varchar description
date effectiveenddate
date effectivestartdate
varchar-pk id
varchar name
varchar-fk productid
varchar-fk updatedbyid
timestampwithtimezone updateddate
varchar guidedselling__c
varchar legacytieruidisplay__c
varchar prpcategory__c
}
ProductRatePlanCharge{
varchar accountingcode
varchar-fk accountreceivableaccountingcodeid
varchar-fk adjustmentliabilityaccountingcodeid
varchar-fk adjustmentrevenueaccountingcodeid
varchar applydiscountto
bigint billcycleday
varchar billcycletype
varchar billingperiod
varchar billingperiodalignment
varchar billingtiming
varchar chargemodel
varchar chargetype
varchar-fk contractassetaccountingcodeid
varchar-fk contractliabilityaccountingcodeid
varchar-fk contractrecognizedrevenueaccountingcodeid
varchar-fk createdbyid
timestampwithtimezone createddate
decimal_22_9_ defaultquantity
varchar deferredrevenueaccount
varchar-fk deferredrevenueaccountingcodeid
varchar description
varchar-fk discountclassid
varchar discountlevel
varchar enddatecondition
varchar-pk id
decimal_22_9_ includedunits
boolean legacyrevenuereporting
varchar listpricebase
decimal_22_9_ maxquantity
decimal_22_9_ minquantity
varchar name
bigint numberofperiod
varchar overagecalculationoption
varchar overageunusedunitscreditoption
varchar pricechangeoption
decimal_22_9_ priceincreasepercentage
varchar-fk productrateplanid
varchar ratinggroup
varchar recognizedrevenueaccount
varchar-fk recognizedrevenueaccountingcodeid
varchar revenuerecognitionrulename
varchar revreccode
varchar revrectriggercondition
varchar smoothingmodel
bigint specificbillingperiod
boolean taxable
varchar taxcode
varchar taxmode
varchar triggerevent
varchar-fk unbilledreceivablesaccountingcodeid
varchar uom
varchar-fk updatedbyid
timestampwithtimezone updateddate
bigint uptoperiods
varchar uptoperiodstype
varchar usagerecordratingoption
boolean usediscountspecificaccountingcode
boolean usetenantdefaultforpricechange
varchar weeklybillcycleday
varchar allocationeligibleflag__c
varchar bundleid__c
varchar pobstratefier__c
varchar sspeligibleflag__c
varchar trueuprevenuetermmonths__c
}
ProductRatePlanChargeTier{
boolean active
varchar-fk createdbyid
timestampwithtimezone createddate
varchar currency
decimal_22_9_ discountamount
decimal_22_9_ discountpercentage
decimal_22_9_ endingunit
varchar-pk id
decimal_22_9_ includedunits
decimal_22_9_ overageprice
decimal_22_9_ price
varchar priceformat
varchar-fk productrateplanchargeid
decimal_22_9_ startingunit
integer tier
varchar-fk updatedbyid
timestampwithtimezone updateddate
}
RatePlan {
varchar-fk amendmentid
varchar amendmenttype
varchar-fk createdbyid
timestampwithtimezone createddate
varchar-pk id
varchar name
varchar-fk productrateplanid
varchar-fk subscriptionid
varchar-fk updatedbyid
timestampwithtimezone updateddate
date synctriggerupdate__c
}
RatePlanCharge {
varchar accountingcode
varchar-fk accountreceivableaccountingcodeid
varchar applydiscountto
bigint billcycleday
varchar billcycletype
varchar billingperiod
varchar billingperiodalignment
varchar billingtiming
date chargedthroughdate
varchar chargemodel
varchar chargenumber
varchar chargetype
varchar-fk createdbyid
timestampwithtimezone createddate
varchar-fk deferredrevenueaccountingcodeid
varchar description
varchar discountlevel
decimal_22_9_ dmrc
decimal_22_9_ dtcv
date effectiveenddate
date effectivestartdate
varchar enddatecondition
varchar-pk id
boolean islastsegment
boolean isprocessed
varchar listpricebase
decimal_22_9_ mrr
varchar name
bigint numberofperiods
varchar-fk originalid
varchar overagecalculationoption
varchar overageunusedunitscreditoption
varchar pricechangeoption
decimal_22_9_ priceincreasepercentage
date processedthroughdate
varchar-fk productrateplanchargeid
decimal_22_9_ quantity
varchar-fk rateplanid
varchar ratinggroup
varchar-fk recognizedrevenueaccountingcodeid
varchar revenuerecognitionrulename
varchar revreccode
varchar revrectriggercondition
integer segment
bigint specificbillingperiod
date specificenddate
decimal_22_9_ tcv
date triggerdate
varchar triggerevent
varchar uom
varchar-fk updatedbyid
timestampwithtimezone updateddate
bigint uptoperiods
varchar uptoperiodstype
bigint version
varchar weeklybillcycleday
varchar psbundleid__c
varchar rampdealid__c
date synctriggerupdate__c
varchar unbilledarflag__c
}
RatePlanChargeTier {
varchar-fk createdbyid
timestampwithtimezone createddate
varchar currency
decimal_22_9_ discountamount
decimal_22_9_ discountpercentage
decimal_22_9_ endingunit
varchar-pk id
decimal_22_9_ includedunits
decimal_22_9_ overageprice
decimal_22_9_ price
varchar priceformat
varchar-fk rateplanchargeid
decimal_22_9_ startingunit
bigint tier
varchar-fk updatedbyid
timestampwithtimezone updateddate
}
Amendment {
boolean autorenew
varchar code
date contracteffectivedate
varchar-fk createdbyid
timestampwithtimezone createddate
bigint currentterm
varchar currenttermperiodtype
date customeracceptancedate
varchar description
date effectivedate
varchar-pk id
varchar name
varchar renewalsetting
bigint renewalterm
varchar renewaltermperiodtype
date resumedate
date serviceactivationdate
date specificupdatedate
varchar status
varchar-fk subscriptionid
date suspenddate
date termstartdate
varchar termtype
varchar type
varchar-fk updatedbyid
timestampwithtimezone updateddate
}
Contact {
varchar-fk accountid
varchar address1
varchar address2
varchar city
varchar country
varchar county
varchar-fk createdbyid
timestampwithtimezone createddate
varchar description
varchar fax
varchar firstname
varchar homephone
varchar-pk id
varchar lastname
varchar mobilephone
varchar nickname
varchar otherphone
varchar otherphonetype
varchar personalemail
varchar postalcode
varchar state
varchar taxregion
varchar-fk updatedbyid
timestampwithtimezone updateddate
varchar workemail
varchar workphone
varchar financeverifiedcontact__c
}
PaymentMethod {
varchar-fk accountid
varchar achabacode
varchar achaccountname
varchar achaccountnumbermask
varchar achaccounttype
varchar achaddress1
varchar achaddress2
varchar achbankname
varchar achcity
varchar achcountry
varchar achpostalcode
varchar achstate
boolean active
varchar bankbranchcode
varchar bankcheckdigit
varchar bankcity
varchar bankcode
varchar bankidentificationnumber
varchar bankname
varchar bankpostalcode
varchar bankstreetname
varchar bankstreetnumber
varchar banktransferaccountname
varchar banktransferaccountnumbermask
varchar banktransferaccounttype
varchar banktransfertype
varchar businessidentificationcode
varchar city
varchar companyname
varchar country
varchar-fk createdbyid
timestampwithtimezone createddate
varchar creditcardaddress1
varchar creditcardaddress2
varchar creditcardcity
varchar creditcardcountry
integer creditcardexpirationmonth
integer creditcardexpirationyear
varchar creditcardholdername
varchar creditcardmasknumber
varchar creditcardpostalcode
varchar creditcardstate
varchar creditcardtype
varchar devicesessionid
varchar email
varchar existingmandate
varchar firstname
varchar iban
varchar-pk id
varchar identitynumber
varchar ipaddress
boolean iscompany
boolean issystem
date lastfailedsaletransactiondate
varchar lastname
timestampwithtimezone lasttransactiondatetime
varchar lasttransactionstatus
date mandatecreationdate
varchar mandateid
varchar mandatereason
varchar mandatereceived
varchar mandatestatus
date mandateupdatedate
smallint maxconsecutivepaymentfailures
varchar name
integer numconsecutivefailures
varchar paymentmethodstatus
smallint paymentretrywindow
varchar paypalbaid
varchar paypalemail
varchar paypalpreapprovalkey
varchar paypaltype
varchar phone
varchar postalcode
varchar secondtokenid
varchar state
varchar streetname
varchar streetnumber
varchar tokenid
integer totalnumberoferrorpayments
integer totalnumberofprocessedpayments
varchar type
varchar-fk updatedbyid
timestampwithtimezone updateddate
boolean usedefaultretryrule
}
Invoice {
varchar-fk accountid
decimal_22_9_ adjustmentamount
decimal_22_9_ amount
decimal_22_9_ amountwithouttax
boolean autopay
decimal_22_9_ balance
varchar-fk billtocontactsnapshotid
varchar comments
varchar createdbyid
timestampwithtimezone createddate
decimal_22_9_ creditbalanceadjustmentamount
date duedate
varchar-pk id
boolean includesonetime
boolean includesrecurring
boolean includesusage
date invoicedate
varchar invoicenumber
timestampwithtimezone lastemailsentdate
decimal_22_9_ paymentamount
varchar postedby
timestampwithtimezone posteddate
decimal_22_9_ refundamount
boolean reversed
varchar soldtocontactsnapshotid
varchar source
varchar-fk sourceid
varchar status
date targetdate
decimal_22_9_ taxamount
decimal_22_9_ taxexemptamount
varchar taxmessage
varchar taxstatus
varchar transferredtoaccounting
varchar-fk updatedbyid
timestampwithtimezone updateddate
varchar vatlocalcurrencyamount__c
}
InvoiceItem {
varchar-fk accountid
varchar accountingcode
varchar-fk accountreceivableaccountingcodeid
varchar-fk adjustmentliabilityaccountingcodeid
varchar-fk adjustmentrevenueaccountingcodeid
varchar-fk amendmentid
varchar-fk appliedtoinvoiceitemid
decimal_22_9_ balance
varchar-fk billtocontactid
varchar-fk billtocontactsnapshotid
decimal_22_9_ chargeamount
timestampwithtimezone chargedate
varchar chargename
varchar-fk contractassetaccountingcodeid
varchar-fk contractliabilityaccountingcodeid
varchar-fk contractrecognizedrevenueaccountingcodeid
varchar-fk createdbyid
timestampwithtimezone createddate
varchar-fk defaultpaymentmethodid
varchar-fk deferredrevenueaccountingcodeid
varchar description
varchar-pk id
varchar-fk invoiceid
varchar-fk journalentryid
varchar-fk parentaccountid
varchar processingtype
varchar-fk productid
varchar-fk productrateplanchargeid
varchar-fk productrateplanid
decimal_22_9_ quantity
varchar-fk rateplanchargeid
varchar-fk rateplanid
varchar-fk recognizedrevenueaccountingcodeid
date revrecstartdate
date serviceenddate
date servicestartdate
varchar sku
varchar-fk soldtocontactid
varchar-fk soldtocontactsnapshotid
varchar-fk subscriptionid
decimal_22_9_ taxamount
varchar taxcode
decimal_22_9_ taxexemptamount
varchar taxmode
varchar-fk unbilledreceivablesaccountingcodeid
decimal_22_9_ unitprice
varchar uom
varchar-fk updatedbyid
timestampwithtimezone updateddate
}
TaxationItem{
varchar accountingcode
varchar-fk accountreceivableaccountingcodeid
decimal_22_9_ balance
varchar-fk createdbyid
timestampwithtimezone createddate
decimal_22_9_ creditamount
decimal_22_9_ exemptamount
varchar-pk id
varchar-fk invoiceitemid
varchar-fk journalentryid
varchar jurisdiction
varchar locationcode
varchar name
decimal_22_9_ paymentamount
varchar-fk salestaxpayableaccountingcodeid
varchar-fk taxableitemsnapshotid
decimal_22_9_ taxamount
varchar taxcode
varchar taxcodedescription
date taxdate
varchar taxmode
decimal_22_9_ taxrate
varchar taxratedescription
varchar taxratetype
varchar-fk updatedbyid
timestampwithtimezone updateddate
}
PaymentMethodSnapshot {
varchar-fk accountid
varchar achabacode
varchar achaccountname
varchar achaccountnumbermask
varchar achaccounttype
varchar achbankname
varchar bankbranchcode
varchar bankcheckdigit
varchar bankcity
varchar bankcode
varchar bankidentificationnumber
varchar bankname
varchar bankpostalcode
varchar bankstreetname
varchar bankstreetnumber
varchar banktransferaccountname
varchar banktransferaccountnumbermask
varchar banktransferaccounttype
varchar banktransfertype
varchar businessidentificationcode
varchar city
varchar companyname
varchar country
timestampwithtimezone createddate
varchar creditcardaddress1
varchar creditcardaddress2
varchar creditcardcity
varchar creditcardcountry
integer creditcardexpirationmonth
integer creditcardexpirationyear
varchar creditcardholdername
varchar creditcardmasknumber
varchar creditcardpostalcode
varchar creditcardstate
varchar creditcardtype
varchar devicesessionid
varchar email
varchar existingmandate
varchar firstname
varchar iban
varchar-pk id
varchar identitynumber
varchar ipaddress
boolean iscompany
date lastfailedsaletransactiondate
varchar lastname
timestampwithtimezone lasttransactiondatetime
varchar lasttransactionstatus
date mandatecreationdate
varchar mandateid
varchar mandatereason
varchar mandatereceived
varchar mandatestatus
date mandateupdatedate
smallint maxconsecutivepaymentfailures
varchar name
integer numconsecutivefailures
varchar paymentmethodid
varchar paymentmethodstatus
smallint paymentretrywindow
varchar paypalbaid
varchar paypalemail
varchar paypalpreapprovalkey
varchar paypaltype
varchar phone
varchar postalcode
varchar secondtokenid
varchar state
varchar streetname
varchar streetnumber
varchar tokenid
integer totalnumberoferrorpayments
integer totalnumberofprocessedpayments
varchar type
timestampwithtimezone updateddate
boolean usedefaultretryrule
}
InvoicePayment {
varchar-fk accountreceivableaccountingcodeid
decimal_22_9_ amount
varchar-fk cashaccountingcodeid
varchar-fk createdbyid
timestampwithtimezone createddate
varchar-pk id
varchar-fk invoiceid
varchar-fk journalentryid
varchar-fk paymentid
decimal_22_9_ refundamount
varchar-fk updatedbyid
timestampwithtimezone updateddate
}
Payment {
varchar-fk accountid
varchar accountingcode
decimal_22_9_ amount
decimal_22_9_ appliedamount
decimal_22_9_ appliedcreditbalanceamount
varchar authtransactionid
varchar bankidentificationnumber
timestampwithtimezone cancelledon
varchar comment
varchar-fk createdbyid
timestampwithtimezone createddate
varchar currency
date effectivedate
varchar gateway
varchar gatewayorderid
varchar gatewayreconciliationreason
varchar gatewayreconciliationstatus
varchar gatewayresponse
varchar gatewayresponsecode
varchar gatewaystate
varchar-pk id
boolean isstandalone
timestampwithtimezone markedforsubmissionon
varchar paymentmethodid
varchar-fk paymentmethodsnapshotid
varchar paymentnumber
varchar payoutid
varchar referencedpaymentid
varchar referenceid
decimal_22_9_ refundamount
varchar secondpaymentreferenceid
timestampwithtimezone settledon
varchar softdescriptor
varchar softdescriptorphone
varchar source
varchar sourcename
varchar status
timestampwithtimezone submittedon
varchar transactionsource
varchar transferredtoaccounting
varchar type
decimal_22_9_ unappliedamount
varchar updatedbyid
timestampwithtimezone updateddate
}
Refund {
varchar-fk accountid
varchar accountingcode
decimal_22_9_ amount
varchar associatedtransactionnumber
timestampwithtimezone cancelledon
varchar comment
varchar-fk createdbyid
timestampwithtimezone createddate
varchar gateway
varchar gatewayreconciliationreason
varchar gatewayreconciliationstatus
varchar gatewayresponse
varchar gatewayresponsecode
varchar gatewaystate
varchar-pk id
timestampwithtimezone markedforsubmissionon
varchar methodtype
varchar-fk paymentmethodid
varchar-fk paymentmethodsnapshotid
varchar payoutid
varchar reasoncode
varchar referenceid
date refunddate
varchar refundnumber
timestampwithtimezone refundtransactiontime
varchar secondrefundreferenceid
timestampwithtimezone settledon
varchar softdescriptor
varchar softdescriptorphone
varchar sourcetype
varchar status
timestampwithtimezone submittedon
varchar transferredtoaccounting
varchar type
varchar-fk updatedbyid
timestampwithtimezone updateddate
}
RefundInvoicePayment {
varchar-fk accountreceivableaccountingcodeid
varchar-fk cashaccountingcodeid
varchar-fk createdbyid
timestampwithtimezone createddate
varchar-pk id
varchar-fk invoicepaymentid
varchar-fk journalentryid
decimal_22_9_ refundamount
varchar-fk refundid
varchar-fk updatedbyid
timestampwithtimezone updateddate
}
CustomersDot (Customer Portal)
erDiagram
cloud_activations {
bigint id
timestampwithouttimezone created_at
timestampwithouttimezone updated_at
bigint customer_id
charactervarying activation_code
charactervarying subscription_name
boolean super_sonics_aware
}
coupons {
bigint id
charactervarying batch_id
charactervarying code
smallint status
}
customers {
integer id
charactervarying first_name
charactervarying last_name
timestampwithouttimezone created_at
timestampwithouttimezone updated_at
charactervarying email
charactervarying encrypted_password
charactervarying reset_password_token
timestampwithouttimezone reset_password_sent_at
timestampwithouttimezone remember_created_at
integer sign_in_count
timestampwithouttimezone current_sign_in_at
timestampwithouttimezone last_sign_in_at
inet current_sign_in_ip
inet last_sign_in_ip
charactervarying provider
charactervarying uid
charactervarying zuora_account_id
charactervarying country
charactervarying state
charactervarying city
charactervarying zip_code
charactervarying vat_code
charactervarying company
charactervarying salesforce_account_id
boolean billable
charactervarying access_token
charactervarying confirmation_token
timestampwithouttimezone confirmed_at
timestampwithouttimezone confirmation_sent_at
charactervarying unconfirmed_email
charactervarying address_1
charactervarying address_2
charactervarying company_size
charactervarying authentication_token
charactervarying phone_number
boolean login_activated
}
instance_review_settings {
integer id
integer users_count_threshold
timestampwithouttimezone created_at
timestampwithouttimezone updated_at
}
instance_reviews {
integer id
charactervarying email
charactervarying first_name
charactervarying last_name
charactervarying company
charactervarying address
charactervarying phone
charactervarying version
integer users_count
integer groups_count
integer projects_count
integer issues_count
integer merge_requests_count
integer internal_pipelines_count
integer external_pipelines_count
integer labels_count
integer milestones_count
integer notes_count
integer snippets_count
charactervarying country
charactervarying state
charactervarying employee_range
boolean communication_opted_in
}
admins {
integer id
charactervarying email
charactervarying encrypted_password
charactervarying reset_password_token
timestampwithouttimezone reset_password_sent_at
timestampwithouttimezone remember_created_at
integer sign_in_count
timestampwithouttimezone current_sign_in_at
timestampwithouttimezone last_sign_in_at
inet current_sign_in_ip
inet last_sign_in_ip
timestampwithouttimezone created_at
timestampwithouttimezone updated_at
charactervarying authentication_token
boolean manage_admin
charactervarying provider
charactervarying uid
smallint customer_access_level
smallint license_access_level
}
licenses {
bigint id
uuid license_file_md5
bigint customer_id
bigint creator_id
timestampwithtimezone created_at
timestampwithtimezone updated_at
timestampwithtimezone last_synced_at
timestampwithtimezone next_sync_at
integer users_count
integer previous_users_count
integer trueup_quantity
date expires_at
date starts_at
date trueup_from
date trueup_to
boolean trial
boolean cloud_licensing_enabled
charactervarying plan_code
charactervarying plan_name
charactervarying zuora_subscription_id
charactervarying email
charactervarying name
charactervarying company
charactervarying zuora_subscription_name
text notes
text license_file
timestampwithtimezone activated_at
boolean auto_renew_enabled
boolean seat_reconciliation_enabled
boolean operational_metrics_enabled
boolean reconciliation_completed
boolean offline_cloud_licensing_enabled
}
local_records {
bigint id
timestampwithouttimezone created_at
timestampwithouttimezone updated_at
charactervarying name
text csv
}
orders {
integer id
integer customer_id
charactervarying product_rate_plan_id
charactervarying subscription_id
charactervarying subscription_name
date start_date
date end_date
integer quantity
timestampwithouttimezone created_at
timestampwithouttimezone updated_at
charactervarying gl_namespace_id
charactervarying gl_namespace_name
charactervarying amendment_type
boolean trial
timestampwithouttimezone last_extra_ci_minutes_sync_at
charactervarying zuora_account_id
timestampwithouttimezone increased_billing_rate_notified_at
boolean reconciliation_accepted
timestampwithouttimezone billing_rate_adjusted_at
charactervarying billing_rate_last_action
smallint trial_extension_type
charactervarying source
}
trial_histories {
integer id
charactervarying gl_namespace_id
date start_date
date expired_on
timestampwithouttimezone created_at
timestampwithouttimezone updated_at
charactervarying glm_source
charactervarying glm_content
charactervarying trial_entity
}
zuora_user_with_hosts {
integer id
charactervarying zuora_user_id
charactervarying host
timestampwithouttimezone created_at
timestampwithouttimezone updated_at
}
self_managed_instance_activations {
bigint id
timestampwithouttimezone created_at
timestampwithouttimezone updated_at
timestampwithouttimezone activated_at
bigint self_managed_instance_id
bigint cloud_activation_id
}
self_managed_instances {
bigint id
timestampwithouttimezone created_at
timestampwithouttimezone updated_at
charactervarying instance_identifier
}
license_seat_links {
bigint id
timestampwithouttimezone created_at
timestampwithouttimezone updated_at
bigint order_id
integer active_user_count
integer max_historical_user_count
integer license_user_count
date license_starts_on
charactervarying zuora_subscription_name
charactervarying zuora_subscription_id
timestampwithtimezone report_timestamp
bigint license_id
bigint self_managed_instance_activation_id
charactervarying gitlab_version
charactervarying hostname
charactervarying instance_identifier
uuid license_md5
}
reconciliations {
bigint id
integer order_id
integer user_count
timestampwithouttimezone reconcile_done_at
timestampwithouttimezone created_at
timestampwithouttimezone updated_at
text error_message
date reconcile_on
smallint skip_reason
timestampwithtimezone upcoming_email_sent_at
timestampwithtimezone completed_email_sent_at
numeric quoted_invoice_amount
timestampwithtimezone quoted_invoice_at
}
leads {
bigint id
timestampwithtimezone created_at
timestampwithtimezone updated_at
date trial_start_date
bigint namespace_id
bigint user_id
boolean opt_in
boolean currently_in_trial
boolean is_for_business_use
charactervarying first_name
charactervarying last_name
charactervarying email
charactervarying phone
charactervarying company_name
charactervarying employees_bucket
charactervarying country
charactervarying state
charactervarying product_interaction
charactervarying provider
text comment_capture
charactervarying glm_content
charactervarying glm_source
timestampwithtimezone sent_at
}
cloud_activations }o--|| customers : ""
self_managed_instance_activations }o--|| cloud_activations : ""
licenses }o--|| customers : ""
orders }o--|| customers : ""
licenses }o--|| admins : ""
license_seat_links }o--|| licenses : ""
license_seat_links }o--|| orders : ""
reconciliations }o--|| orders : ""
license_seat_links }o--|| self_managed_instance_activations : ""
self_managed_instance_activations }o--|| self_managed_instances : ""
GitLab
erDiagram
ci_minutes_additional_packs {
bigint id
timestampwithtimezone created_at
timestampwithtimezone updated_at
bigint namespace_id
date expires_at
integer number_of_minutes
text purchase_xid
}
gitlab_subscriptions {
bigint id
timestampwithtimezone created_at
timestampwithtimezone updated_at
date start_date
date end_date
date trial_ends_on
integer namespace_id
integer hosted_plan_id
integer max_seats_used
integer seats
boolean trial
date trial_starts_on
boolean auto_renew
integer seats_in_use
integer seats_owed
smallint trial_extension_type
}
historical_data {
integer id
date date
integer active_user_count
timestampwithouttimezone created_at
timestampwithouttimezone updated_at
timestampwithtimezone recorded_at
}
licenses {
integer id
text data
timestampwithouttimezone created_at
timestampwithouttimezone updated_at
boolean cloud
timestampwithtimezone last_synced_at
}
members {
integer id
integer access_level
integer source_id
charactervarying source_type
integer user_id
integer notification_level
charactervarying type
timestampwithouttimezone created_at
timestampwithouttimezone updated_at
bigint member_namespace_id
}
namespace_limits {
bigint additional_purchased_storage_size
date additional_purchased_storage_ends_on
integer namespace_id
date temporary_storage_increase_ends_on
}
namespaces {
integer id
charactervarying name
charactervarying path
integer owner_id
timestampwithouttimezone created_at
timestampwithouttimezone updated_at
charactervarying type
charactervarying description
charactervarying avatar
integer parent_id
integer shared_runners_minutes_limit
bigint repository_size_limit
integer extra_shared_runners_minutes_limit
timestampwithtimezone last_ci_minutes_notification_at
integer last_ci_minutes_usage_notification_level
boolean shared_runners_enabled
}
personal_access_tokens {
integer id
integer user_id
charactervarying name
boolean revoked
date expires_at
timestampwithouttimezone created_at
timestampwithouttimezone updated_at
charactervarying scopes
boolean impersonation
charactervarying token_digest
boolean expire_notification_delivered
timestampwithtimezone last_used_at
boolean after_expiry_notification_delivered
}
plan_limits {
bigint id
bigint plan_id
integer storage_size_limit
}
plans {
integer id
timestampwithouttimezone created_at
timestampwithouttimezone updated_at
charactervarying name
charactervarying title
}
upcoming_reconciliations {
bigint id
bigint namespace_id
date next_reconciliation_date
date display_alert_from
timestampwithtimezone created_at
timestampwithtimezone updated_at
}
user_credit_card_validations {
bigint user_id
timestampwithtimezone credit_card_validated_at
date expiration_date
smallint last_digits
text holder_name
text network
}
users {
integer id
charactervarying email
charactervarying name
boolean admin
integer projects_limit
charactervarying username
charactervarying state
charactervarying first_name
charactervarying last_name
smallint user_type
}
gitlab_subscriptions |o--|| namespaces : ""
gitlab_subscriptions }o--|| plans : ""
members }o--|| namespaces : ""
members }o--|| users : ""
namespace_limits |o--|| namespaces : ""
namespaces }o--|| namespaces : ""
upcoming_reconciliations }o--|| namespaces : ""
users }o--|| namespaces : ""
personal_access_tokens }o--|| users : ""
plan_limits }o--|| plans : ""
user_credit_card_validations |o--|| users : ""
Last modified November 3, 2023: Update find and replace script (
9507e5be)
