SalesFlow ERD

57 tables · 93 option sets · 251 relationships·Updated 49d ago

profile_owner_useraccount_custom_businesstype_option_appointment_typestype_option_appointment_typesapplication_option_applicationsaccount_custom_businessinvoices_list_custom_invoicestatus_option_api_log_statusappt_user_userevent_custom_eventappt_status_user_userappt_outcome_user_userappt_user_end_date_dateappt_user_start_date_dateappt_account_custom_businessappt_invitee_custom_customerappt_outcome_request_user_userappt_application_option_applicationsappt_status_option_appointment_statusesappt_event_type_option_appointment_typesappt_event_type_option_appointment_typesappt_outcome_option_appointment_outcomesappt_outcome_request_option_appointment_outcomesappt_outcome_filtering_option_appointment_outcomesadyenlentity_account_custom_businesscontac_custom_customerinvoice_custom_invoiceaccount_custom_businessstatus_option_adyen_settlement_statusbusiness_custom_businesscustomer_custom_customercreated_by_option_card_creatorpay_method_fee_custom_tax_ratepay_method_type_option_payment_method0pay_method_type_option_payment_method0account_custom_businesscontact_custom_customercampaign_custom_campaignutm_event_type_option_utm_event_typeutm_event_type_option_utm_event_typeacct_cancel_user_usercurrency_custom_currencyacct_users__list__list_useracct_adyen_industry_custom_industryacct_backup_payment_method_custom_cardacct_backup_payment_method_custom_cardacct_cancel_reason_option_cancel_reasonacct_primary_payment_method_custom_cardacct_primary_payment_method_custom_cardacct_legal_entity_type_option_legal_entity_typeactive_subscription_plan_custom_stripe_price_idacct_adyen_legal_entity_custom_adyen_legal_entityacct_cancel_positives_list_option_cancel_positivesacct_pending_subscription_downgrade_custom_stripe_price_idacct_store_payment_method_list_custom_store_payment_methodacct_store_payment_method_list_custom_store_payment_methodacct_subscription_status_option_stripe_subscription_statusaccount_custom_businessutm_partner_custom_businesssalesperson_userbusiness_custom_businessbusiness_custom_businesspaid_by_userbusiness_custom_businesssub_plan_custom_stripe_price_idstatus_option_stripe_subscription_statuscur_merchant_option_merchantscard_list_custom_cardbusiness_custom_businessdefault_card_custom_cardcont_type_option_contact_statuscont_source_option_customer_sourceaccount_custom_businessvisibility_list_option_roleapp_plan_custom_stripe_price_idapp_plan_custom_stripe_price_idapp_components_option_app_componentsapp_components_option_app_components_variants_list_custom_email_template_variantcommunity_post_custom_postbusiness_custom_businessinv_invoice_custom_invoiceinv_txn_customer_custom_customerinv_txn_card_international_booleaninv_txn_card_creator_option_card_creatorinv_txn_card_creator_option_card_creatorinv_disp_def_invoice_custom_invoiceinv_disp_def_account_custom_businessdef_rsn_level_option_dispute_defense_levelinv_disp_def_doc_level1_option_dispute_defense_levelinv_disp_def_doc_level3_option_dispute_defense_levelfeat_user_userfeat_type_option_featuresfeat_account_custom_businessfeat_action_option_feature_actionsheader_menu_custom_header_menubutton_style_option_button_stylefeather_icon_option_feather_iconinternal_bubble_page_option_pageinternal_page_custom_static_pageinternal_page_custom_static_pageaction_type_option_header_action_typeelement_type_option_header_element_typewidget_type_option____navigation_widget_actionshow_user_text_booleanheader_items_list_custom_header_item_template_custom_email_templatesalesperson_userbusiness_custom_businesscustomer_custom_customerinv_paylink_custom_pay_linkinv_transfer_custom_transferproducts_list_custom_productinv_dispute_defense_user_userinstallment_custom_installment1payment_type2_option_payment_typepurchase_order_custom_purchase_orderinv_refund_status_option_refund_statusinv_transfer_list_list_custom_transferinv_collect_method_option_payment_methodinv_dispute_status2_option_dispute_statuspayment_status_option_invoice_payment_statustransactions_list_custom_customer_transactiontransactions_list_custom_customer_transactioninvoice_payment_refund_list_custom_invoice_payment_refundinv_dispute_recovery_status_option_dispute_recovery_statussalesperson_userpaylink_tax_custom_tax_ratepaylink_account_custom_businesspaylink_type_option_paylink_typepaylink_products_list_custom_productpaylink_status_option_paylink_statuspaylink_payment_type_option_payment_typepaylink_interval_option_subscription_frequencypaylink_ord_details_list_custom_pay_link_order_detailinvoice_custom_invoicebusiness_custom_businesspurchase_order_custom_purchase_orderstatus_option_invoice_payment_statusstatus_option_invoice_payment_statusinv_history_field_custom_app_dataappdatahistory_account_custom_businessinvoice_custom_invoiceproduct_custom_productbusiness_custom_businessinv_prod_status_option_invoice_payment_statusinv_prod_status_option_invoice_payment_statuspl_ord_det_product_custom_productpl_ord_det_account_custom_businesspl_ord_det_paylink_custom_pay_linkinvoice_custom_invoiceaccount_custom_businessstatus_option_refund_statuslikes_list_usersaves_list_usermodified_by_usertype_option_post_typesaccount_custom_businesssection_option_sectionsstatus_option_post_statusbusiness_custom_businessprod_payment_method_fee_list_custom_tax_rateprod_payment_method_fee_list_custom_tax_rateprod_payment_method_list_option_payment_method0prod_payment_method_list_option_payment_method0business_custom_businesscustomer_custom_customertax_rate_custom_tax_rateinvoices1_list_custom_invoicepayment_type_2_option_payment_typeord_processing_rate_custom_tax_rateinstallment_list_custom_installment1product_order_line_list_custom_product_order_lineproduct_order_line_list_custom_product_order_linesubscription_frequency_option_subscription_frequencyproduct_custom_productbusiness_custom_businesspurchase_order_custom_purchase_orderproduct_custom_productbusiness_custom_businessaccount_custom_businessimages_list_imageapp_price_name2_option_app_planapp_price_account_custom_businessapp_plan_component_custom_componentapp_plan_component_custom_componentapp_plan_components_list_custom_componentapp_plan_components_list_custom_componentapp_plan_components_list_custom_componentspm_account_custom_businessspm_adyen_card_brand_option_adyen_payment_methodspm_adyen_card_brand_option_adyen_payment_methodspm_adyen_card_brand_option_adyen_payment_methodsalesperson_userproduct_custom_productbusiness_custom_businessrole_option_rolebusiness_custom_businesslanguage_option_languageuser_account_creator_booleanuser_permission_option_permissionsuser_account_setup_popup_on_booleanchart_interval_option_chart_intervaldate_range_preset_option_date_range_presetuser_accessible_accounts_list_custom_businessuser_appointment_sort_option_appointment_sortuser_appointment_sort_option_appointment_sortuser_onboarding_stage_option_onboarding_stageuser_adyen_legal_entity_custom_adyen_legal_entityuser_account_setup_steps_list_option_account_setup_stepsuser_account_setup_steps_list_option_account_setup_stepsaccount_custom_businessuser_account_custom_businessuser_account_custom_businessuser_account_custom_businessapplication_option_applicationswhook_event_option_webhook_event_typewhook_event_option_webhook_event_typewhook_event_list_option_webhook_event_typewhook_event_list_option_webhook_event_typelanguage__on_booleanno_usersnap__booleanlanguage__default_option_languageemail_template_groupings_list_textlanguage__options_list_option_languagecompleted_admin_options_list_option_admin_menucanvas_page_builder___app_wide_images_list_imagecanvas_page_builder___app_wide_images_list_imagedefault_password_strength_option_____password_strengthbusiness_custom_businessfee_type_option_fee_typesfee_name_payment_method_option_payment_method0fee_name_payment_method_option_payment_method0transfer_invoice_custom_invoicetransfer_account_custom_businesstransfer_type_option_transfer_typetransfer_status_option_transfer_statusxfer_category_option_transfer_categoryxfer_priority_option_adyen_transfer_prioritiesbusiness_custom_businesscomm_pay_users_list_userinvoices_list_custom_invoiceuser_userrole_option_roleaccount_custom_businessdefault_custom_businessstatus_option_user_statusstatus_option_user_statusonboarding_stage_option_onboarding_stagesetup_steps_list_option_account_setup_stepsbusiness_custom_business
Event
Id: text
Name: text
Duration: number
Description: text
Profile Owner: user
Account: custom.business
Default Type: option.appointment_types
Application: option.applications
API Log
Action: text
Key1: text
Key2: text
Key3: text
Value1: text
Value2: text
Value3: text
API Root: text
Error: boolean
Error Body: text
App CRM
Client ID: text
Current Expires In: date
Client Secret: text
Authorization Token: text
Current Access Token: text
Current Refresh Token: text
App Data
App Data Field: text
App Data Table: text
App Data ID: text
Appointment
APPT ID: text
APPT User: user
APPT Date End: date
APPT Event ID: text
APPT Event: custom.event
APPT User Name: text
APPT Date Start: date
APPT Event Name: text
APPT User Email (No User): text
APPT Status Date: date
App Variable
APP VAR Dummy option: number
Adyen Legal Entity
AdyenLEntity Name: text
AdyenLEntity Legal Entity ID: text
AdyenLEntity Type: text
AdyenLEntity Country: text
AdyenLEntity BusinessLine ID: text
AdyenLEntity AccountHolder ID: text
AdyenLEntity MainBalanceAccount ID: text
AdyenLEntity Account: custom.business
AdyenLEntity AccountHolder Status: text
AdyenLEntity MainBalanceAccount status: text
Adyen Settlement Details
ARN: text
Type: text
Store: text
Lookup: text
Acquirer: text
Metadata: text
TimeZone: text
Reserved1: text
Reserved2: text
Reserved3: text
Pay Method
PAY METHOD ID: text
PAY METHOD Details: text
PAY METHOD Last 4: text
PAY METHOD Account: custom.business
PAY METHOD Customer: custom.customer
PAY METHOD Country Issuer: text
PAY METHOD Country Billing: text
PAY METHOD Creator: option.card_creator
PAY METHOD FEE: custom.tax_rate
PAY METHOD Type: option.payment_method0
UTM Event
UTM URL: text
UTM Event Fingerprint: text
UTM Event Account: custom.business
UTM Event Contact: custom.customer
UTM Event Campaign: custom.campaign
UTM Event Type: option.utm_event_type
Account
ACCT Company City: text
ACCT Company Name: text
ACCT Company Logo: image
ACCT Company State: text
ACCT Company Country: text
ACCT Company Website: text
ACCT Data LTV: number
ACCT Data MRR: number
ACCT Company Postal Code: text
[dep] ACCT Stripe Active: boolean
UTM
UTM URL: text
UTM Term: text
UTM Medium: text
UTM Source: text
UTM Content: text
UTM Campaign: text
UTM Account: custom.business
UTM Partner: custom.business
Goal User
GOAL USER Year: number
GOAL USER User: user
GOAL USER Account: custom.business
GOAL USER Monthly Revenue: number
GOAL USER Monthly Commission: number
GOAL USER Conversation Rate: number
GOAL USER Offer Conversion Rate: number
GOAL USER Appointment Conversion Rate: number
GOAL USER Conversation Conversion Rate: number
Notification
NOTIF Name: text
NOTIF ID: text
NOTIF Body: text
NOTIF Description: text
NOTIF Active: boolean
NOTIF Subject: text
NOTIF Signature: text
NOTIF Account: custom.business
NOTIF Fields: list.text
Subscription
SUB Paid User [dep]: user
SUB ID: text
SUB Plan [dep]: text
SUB Date: date
SUB Payment Status: text
SUB Amount: number
SUB Account: custom.business
SUB Date Next: date
SUB Quantity [dep]: number
SUB Plan: custom.stripe_price_id
⚙️ Dummy
Last: text
Email: text
First: text
Title: text
Address: text
Order: number
Price: number
Attachment: file
Cover photo: image
Phone number: number
App Country
Country Name: text
Region: text
Country Number: text
Country Code2: text
Country Code3: text
Supported: boolean
App Currency
CUR Name: text
CUR Symbol: text
CUR Code: text
CUR Comma: number
CUR Payout Fixed Charges: number
CUR Merchant: option.merchants
CUR Cross-border Transfer Fee: number
CUR Payout Percentage Charges: number
Contact
CONT Name Last: text
CONT Email: text
CONT Name First: text
CONT Phone: text
CONT Company: text
CONT Name Full: text
CONT Search: text
CONT Pay Method: list.custom.card
CONT Account: custom.business
CONT Default Pay Method: custom.card
App Permissions
Tab Name: text
Locked: boolean
Subtab Name: text
Account: custom.business
Roles: list.option.role
App Plan: custom.stripe_price_id
Component: option.app_components
⚙️ Email template
Name: text
Id name: text
Include button?: boolean
Description: text
Enabled?: boolean
Template folder: text
Canvas default?: boolean
Disable admin access?: boolean
List of mail merge terms: list.text
Email variants: list.custom.email_template_variant
Post Comment
Show: boolean
Comment: text
Post: custom.post
Invoice Transaction
INV TXN ID: text
[dep] INV TNX PAYMT FEE: number
INV TXN Card ID: text
INV TNX COMM AMOUNT: number
INV TNX SALES AMOUNT: number
INV TXN Payment Method Type: text
INV TXN Account: custom.business
INV TXN Cancelled: boolean
INV TNX Invoice: custom.invoice
INV TXN Successful?: boolean
Invoice Dispute Defense
INV DISP DEF Reason Code: text
INV DISP DEF Reason Name: text
INV DISP DEF Doc Type Code1: text
INV DISP DEF Doc Type Name1: text
INV DISP DEF Doc Type Code2: text
INV DISP DEF Doc Type Code3: text
INV DISP DEF Doc Type Name2: text
INV DISP DEF Doc Type Name3: text
INV DISP DEF Invoice: custom.invoice
INV DISP DEF Account: custom.business
Feature Log
FEAT Date: date
FEAT User: user
FEAT Type: option.features
FEAT Account: custom.business
FEAT Action: option.feature_actions
Industry
IND Code: text
IND Description: text
IND Needs Approval?: boolean
⚙️ Navigation item
Url: text
Order: number
HTML Hook: text
Link name: text
Url parameter: text
Icon name: text
Javascript trigger: text
Open link in new tab?: boolean
Header: custom.header_menu
Button style: option.button_style
⚙️ Header
Id: text
Name: text
Logo link: text
Logged-in?: boolean
Show user text?: boolean
Navigation items: list.custom.header_item
⚙️ Email template variant
Text body: text
Text button: text
Text subject: text
Is active?: boolean
Language code: text
Language name: text
Text signature: text
Email template: custom.email_template
⚙️ Verify
Type: text
Date used: date
Date expired: date
Sent to: text
Code: text
Invoice
INV Status User: text
INV Date Due: date
INV Notes - deleted: text
INV Notes: text
INV TXN ID: text
INV ID: text
INV Date Issue: date
[dep] INV Description: text
INV User: user
INV Search: text
Mytable
email: text
PayLink
PAYLINK Salesperson: user
PAYLINK Name: text
PAYLINK Amount: number
PAYLINK Redirect URL: text
PAYLINK Tax Amount: number
PAYLINK Comm Amount: number
PAYLINK Tax Rate: custom.tax_rate
PAYLINK Interval Custom: number
PAYLINK Account: custom.business
PAYLINK Installments: number
Order Installment
ORD INST Amount: number
ORD INST Date: date
[dep] ORD INST Description: text
ORD INST Invoice: custom.invoice
ORD INST Account: custom.business
ORD INST Order: custom.purchase_order
ORD INST Status: option.invoice_payment_status
⚙️ Palette color
Type: text
Color: text
App Data History
AppDataHistory NewValue: text
AppDataHistory OldValue: text
AppDataHistory TableName: text
AppDataHistory RecordID: text
AppDataHistory FieldName: text
AppDataHistory FieldID: custom.app_data
AppDataHistory Account: custom.business
Invoice Product
INV PROD Date: date
INV PROD Amount: number
INV PROD Year: number
INV PROD Count: number
INV PROD Invoice: custom.invoice
INV PROD Product: custom.product
INV PROD Account: custom.business
INV PROD Status: option.invoice_payment_status
PayLink Order Detail
PL ORD DET Amount: number
PL ORD DET Quantity: number
PL ORD DET Comm Amount: number
PL ORD DET Product Amount: number
PL ORD DET Product: custom.product
PL ORD DET Account: custom.business
PL ORD DET Paylink: custom.pay_link
Invoice Refund
Reason: text
Outcome: text
Amount: number
PSP ID: text
Invoice: custom.invoice
Account: custom.business
Status: option.refund_status
Post
Title: text
Image: image
Description: text
Score: number
Show: boolean
Likes: list.user
Saves: list.user
Modified By: user
Publish Date: date
Click Count: number
Product
PROD Name: text
PROD Description: text
PROD Price Min: number
PROD Active: boolean
PROD Unpaid: boolean
PROD Price Max: number
PROD Price: number
PROD Price Fixed: boolean
PROD Account: custom.business
PROD Commission: number
Order
ORD ID: text
ORD Date Payment First: date
ORD Tax Amount: number
ORD Year: number
ORD Amount: number
ORD Account: custom.business
ORD Customer: custom.customer
ORD Tax Rate: custom.tax_rate
ORD Processing Amount: number
ORD Product Amount: number
Order Detail
ORD DET Quantity: number
ORD DET Product Amount: number
ORD DET Amount: number
ORD DET Product: custom.product
ORD DET Account: custom.business
ORD DET Comm Amount: number
ORD DET Order: custom.purchase_order
Goal Product
GOAL PROD Year: number
GOAL PROD Product: custom.product
GOAL PROD Account: custom.business
GOAL PROD Monthly Cash: number
GOAL PROD Monthly Sales: number
Sweep
SWP ID: text
SWP Status: text
SWP Currency: text
SWP Account: custom.business
SWP Topup Amount: number
SWP Trigger Amount: number
⚙️ Marketing page
SEO / social name: text
Body html: text
Index?: boolean
Files: list.file
Header html: text
Images: list.image
Page maker instance id: text
Last published: date
SEO / social description: text
Slug changed?: boolean
App Plan
APP PLAN ID: text
APP PLAN Unlimited: boolean
APP PLAN Amount: number
APP PLAN Description: text
APP PLAN Fee Txn Fixed: number
APP PLAN Max User Count: number
APP PLAN Fee Txn ACH Pct: number
APP PLAN Name: option.app_plan
APP PLAN Fee Txn Pct: number
APP PLAN Account: custom.business
Store Payment Method
SPM ID: text
SPM allowed: boolean
SPM Account: custom.business
SPM Adyen Card Brand: option.adyen_payment_method
User Commission
USER COMM User: user
USER COMM Amount: number
USER COMM Product: custom.product
USER COMM Account: custom.business
User
USER Address City: text
USER Name Last: text
USER Name First: text
USER Region: text
USER Address Country: text
USER Photo Profile: image
USER Name Full: text
USER Active Last: date
USER ID Oncehub: text
USER ID Calendly: text
Webhook
ID: text
Name: text
Secret (Encrypted): text
WHook JSON: text
WHook URL: text
WHook Name: text
WHook Description: text
WHook Enabled?: boolean
Account: custom.business
WHook Initialized?: boolean
⚙️ App settings
Name: text
Email: text
Logo dark: image
Private token: text
Bubble app id: text
Icon dark: image
Airdev project id: text
Logo light: image
Email logo: image
Dedicated id: text
Fee
FEE Name Full: text
FEE Rate: number
FEE Name User Input: text
FEE Enabled: boolean
FEE Account: custom.business
Fee Type: option.fee_types
FEE Name Payment Method: option.payment_method0
Transfer
XFER ID: text
XFER To: text
XFER From: text
XFER Reference Note: text
XFER Attempts: number
XFER Reason: text
XFER Currency: text
XFER Amount: number
XFER Reference ID: text
XFER Description: text
Commission Payout
COMM PAY Date: date
COMM PAY ID: text
COMM PAY Revenue: number
COMM PAY Commission: number
COMM PAY Account: custom.business
COMM PAY Users: list.user
COMM ADYEN Transfer ID: text
COMM PAY Invoices: list.custom.invoice
User Account
User: user
Active Last: date
Role: option.role
Onboarding Step [dep]: number
Account Creator: boolean
Account: custom.business
Default - deleted: custom.business
Onboarding Complete: date
Setup Popup Show: boolean
Status: option.user_status
Goal Company
GOAL COMP Year: number
GOAL COMP Appointment Conversion Rate: number
GOAL COMP Conversation Conversion Rate: number
GOAL COMP Account: custom.business
GOAL COMP Refund Rate: number
GOAL COMP Dispute Rate: number
GOAL COMP Collect Rate: number
GOAL COMP Show Up Rate: number
GOAL COMP Sales Call Conv Rate: number
GOAL COMP Offer Conversion Rate: number
⚙️ Navigation feather icon
284 options
Bubble pages
16 options
User Role
4 options
⚙️ Admin option categories
3 options
Images
34 options
App Fee
6 options
App Plan Names
5 options
App Features
13 options
⚙️ Language
47 options
Post Section
9 options
app_plans
0 options
Fee Types
3 options
Merchants
5 options
Sort Post
3 options
⚙️ Admin options
31 options
Component
0 options
General Tabs
6 options
Post Score
4 options
Post Type
3 options
User Permission
4 options
Post Status
4 options
User Status
2 options
App Integration
3 options
⚙️ Navigation button style
2 options
Calendly API
2 options
Card Creator
2 options
Pay Link Type
3 options
Payment Type
3 options
Product Tabs
3 options
Sort Invoice
16 options
HighLevel API
2 options
Cancel Reason
8 options
Partner Tiers
3 options
Refund Reason
4 options
Refund Status
4 options
Transfer Type
8 options
⚙️ Verify type
2 options
API Log Status
3 options
App Components
27 options
Chart Interval
2 options
Contact Type
3 options
Dispute Reason
3 options
Dispute Status
8 options
Pay Link Status
2 options
Collect Method
3 options
UTM Event Type
5 options
API environment
2 options
Adyen Checkout envURL
2 options
Customer Source
5 options
Feature Actions
4 options
Global Variable
6 options
Payment Method
4 options
Transfer Status
5 options
Appointment Sort
10 options
Cancel Positives
6 options
onboarding stage
10 options
Payout Frequency
3 options
Appointment Type
2 options
Chart Date Preset
10 options
Legal Entity Type
3 options
Transfer Category
6 options
⚙️ Navigation action type
5 options
Sort Commission Unpaid
12 options
Webhook Events
12 options
Account Setup Steps
15 options
⚙️ Navigation element type
8 options
Sort Invoice Overdue
10 options
⚙️ Reusable element
2 options
Adyen Card Brand
4 options
Appointment Outcome
7 options
Appointment Status
3 options
Punctuation Setting
2 options
⚙️ Password strength
5 options
Dispute Defense Level
3 options
Transfer Payment Type
3 options
Invoice Payment Status
8 options
Payment Frequency
4 options
Adyen Settlement Status
5 options
Dispute Recovery Status
6 options
Adyen Authorisation Type
2 options
CanvasTag Keyword Search
0 options
Dispute Issuer Comments
0 options
Sort Leaderboard (w/Appts)
7 options
Transfer Priority
6 options
Product Pricing
2 options
General Payment Status
3 options
Subscription Payment Type
4 options
⚙️ Yesno (inclusive "yes/no")
3 options
Invoice Fee Payment Status
3 options
Sort Leaderboard (w/out Appts)
5 options
Subscription Status
7 options
⚙️ Navigation widget type
4 options
Daily Collection Fee Start Date
1 options
React Flow