FM ONE™/Data model
Part VI · §12–33 · 21 domains · 150+ tables

The canonical business graph for the entire funding lifecycle.

Person → Business → Application → Credit → Underwriting → Fundability → Lender Match → Submission → Offer → Contract → Funding → Invoice → Commission. Every entity a versioned, audited, tenant-scoped row.

§12 · Canonical business graph

The relationship spine.

Every FM record links back to a Business. Every deal is a Funding Opportunity on that business. Partners refer, Lenders receive, Credit/Financial profiles inform, AI recommends.

PERSON CONTACT + OWNER BUSINESS THE ANCHOR ◦ OWNERSHIP OPPORTUNITIES APPLICATIONS CREDIT PROFILES FINANCIAL PROFILES FUNDING PLANS SUBMISSIONS OFFERS + FUNDINGS COMMUNICATIONS APPOINTMENTS CONSENTS PARTNER REFERRAL LENDER · PRODUCT SUBMISSION
§13–33 · 21 domains

Every table. Every domain.

Hover any table name to see the accent color of its domain. Sensitive domains (credit, banking, consent, audit) have stricter access policies enforced at framework layer.

150+ TABLES
§13

Identity · Tenancy · Security

21 TABLES
platform_accounttenanttenant_brandtenant_location teamuseruser_identityuser_session user_rolerolepermissionrole_permission user_permission_overrideapi_clientapi_keyoauth_client oauth_grantservice_accountimpersonation_session login_eventsecurity_event
§14

CRM · Contacts · Businesses · Pipeline

29 TABLES
contactcontact_emailcontact_phonecontact_address contact_tagtagcontact_custom_field_valuecustom_field_definition custom_object_definitioncustom_object_recordcustom_object_fieldcustom_object_field_value businessbusiness_dbabusiness_addressbusiness_phone business_emailbusiness_domainbusiness_ownerbusiness_identifier business_relationshipleadlead_sourceopportunity opportunity_stagepipelinepipeline_stageopportunity_history opportunity_assignment
§15

Applications

14 TABLES
funding_applicationapplication_ownerapplication_business_snapshot application_financial_snapshotapplication_capital_requestapplication_question application_answerapplication_statusapplication_status_history application_completionapplication_sourceapplication_attribution application_reviewapplication_exception
§16

Credit · HIGHLY RESTRICTED

14 TABLES
credit_authorizationcredit_requestcredit_report credit_report_versioncredit_bureau_summarycredit_score credit_tradelinecredit_inquirycredit_derogatory credit_public_recordcredit_utilizationcredit_metric credit_analysiscredit_analysis_factor
§17

Banking & Financial · RESTRICTED

20 TABLES
financial_profilebank_account_profilebank_statement bank_statement_pagebank_statement_periodbank_transaction_summary bank_deposit_metricbank_balance_metricbank_nsf_metric bank_overdraft_metriccash_flow_metricrevenue_metric revenue_periodfinancial_statementprofit_loss_statement balance_sheetdebt_obligationfinancial_anomaly financial_analysisfinancial_analysis_factor
§18

Underwriting

16 TABLES
underwriting_caseunderwriting_rununderwriting_model underwriting_model_versionunderwriting_ruleunderwriting_rule_version underwriting_inputunderwriting_resultunderwriting_factor underwriting_reason_codeunderwriting_overrideunderwriting_override_reason manual_reviewmanual_review_decisiondecision_replay shadow_underwriting_run
§19

Fundability + Capital Signal

14 TABLES
fundability_profilefundability_scorefundability_score_component fundability_blockerfundability_strengthfundability_roadmap fundability_roadmap_actionfundability_milestonefundability_reassessment data_confidence_scorecapital_readiness_scorecapital_signal_score capital_signalcapital_signal_factor
§20

Lender Intelligence Graph™

20 TABLES
lenderlender_contactlender_status funding_productfunding_product_versionproduct_criterion criterion_sourceproduct_geographyproduct_industry_rule product_document_requirementproduct_credit_ruleproduct_revenue_rule product_business_age_ruleproduct_exposure_ruleproduct_inquiry_policy product_pricing_referencelender_observed_outcomelender_performance_metric lender_matchlender_match_reason
§21

Funding Plan Builder™

12 TABLES
funding_planfunding_plan_versionfunding_plan_strategy funding_plan_stepfunding_plan_productfunding_plan_dependency funding_plan_riskfunding_plan_assumptionfunding_plan_approval what_if_scenariowhat_if_inputwhat_if_result
§22

Submissions · Offers · Funding

17 TABLES
lender_submissionsubmission_statussubmission_status_history submission_documentsubmission_conditionsubmission_condition_status submission_messagelender_responsefunding_offer offer_termoffer_feeoffer_condition offer_statusclient_offer_decisionfunding_contract funding_confirmationfunded_transaction
§23

Communications

22 TABLES
conversationconversation_participantconversation_channel messagemessage_deliverymessage_attachment email_messagesms_messagemms_message callcall_legcall_recording call_transcriptcall_summaryvoicemail phone_numberphone_routing_rulecall_queue call_dispositioncommunication_consent_snapshotsuppression_entry template
§24

Calendar

10 TABLES
calendarcalendar_useravailability_rule appointmentappointment_attendeeappointment_status appointment_reminderappointment_route_ruleround_robin_pool calendar_integration
§25

Documents · e-Sign

18 TABLES
documentdocument_versiondocument_type document_requirementdocument_requestdocument_request_item document_uploaddocument_extractiondocument_extracted_field document_validationdocument_anomalydocument_access_log document_signature_packetsignature_participantsignature_field signature_eventsigned_documentdocument_type
§26

Workflow Engine (FM Flow™)

16 TABLES
workflow_definitionworkflow_versionworkflow_trigger workflow_nodeworkflow_edgeworkflow_variable workflow_runworkflow_run_stepworkflow_wait workflow_errorworkflow_retryworkflow_approval workflow_goalworkflow_testworkflow_template workflow_metric
§27

Marketing · Campaigns · Pages

26 TABLES
campaigncampaign_channelcampaign_variant audienceaudience_ruleaudience_snapshot marketing_messagemarketing_sendmarketing_delivery marketing_openmarketing_clickmarketing_conversion landing_pagelanding_page_versionpage_component formform_versionform_field form_submissionsurveysurvey_question survey_responseab_testab_variant utm_touchattribution_touch
§28

Partners · Affiliates · Commissions · FM Partner OS™

25 TABLES
partnerpartner_typepartner_status partner_campaignpartner_enrollmentpartner_referral_link partner_referralpartner_referral_eventpartner_customer partner_hierarchypartner_trainingpartner_certification affiliate_campaigncommission_rulecommission_rule_version commissioncommission_adjustmentcommission_clawback payoutpayout_itempartner_report partner_mediapartner_couponpartner_magic_linkpartner_dashboard_snapshot
§29

Billing · Revenue

13 TABLES
invoiceinvoice_lineinvoice_status_history paymentpayment_method_referencepayment_attempt payment_allocationrefundwrite_off accounts_receivable_snapshotcollection_actionbilling_rule revenue_entry
§30

Compliance · Consent · Audit · IMMUTABLE

23 TABLES
consentconsent_typeconsent_version consent_eventprivacy_notice_versiondisclosure disclosure_versiondisclosure_acceptancemarketing_permission credit_permissiondata_share_permissionsuppression_rule claims_policyclaims_ruleclaims_violation compliance_reviewaudit_eventdata_access_event data_export_eventdata_deletion_requestretention_policy legal_holdprivacy_notice_version
§31

AI Agents · Sessions · Decisions

24 TABLES
ai_agentai_agent_versionai_tool ai_agent_tool_permissionai_policyai_session ai_turnai_messageai_tool_call ai_tool_resultai_decisionai_reason ai_confidenceai_human_reviewai_feedback ai_costai_latencyai_guardrail_event prompt_templateprompt_versionknowledge_document knowledge_chunkembedding_referenceai_agent_version
§32

Integration · Provider Adapters

12 TABLES
integrationintegration_accountintegration_credential_reference integration_webhookwebhook_deliverywebhook_retry integration_syncintegration_cursorintegration_error external_id_mappingprovider_requestprovider_response_metadata
§33

Migration · GHL/Zoho Cutover

11 TABLES
migration_jobmigration_sourcemigration_mapping migration_field_mappingmigration_recordmigration_exception migration_validationmigration_reconciliationmigration_cutover migration_rollbacklegacy_id_mapping
§74 · Sensitive Identifier Rule

Never expose raw SSN through ordinary CRM views.

Store an encrypted sensitive value + a masked display + a hash/token for controlled matching. Raw credit-report access uses separate, more restrictive authorization than summaries. Bank statement bytes live in R2; the database only stores metadata, integrity hashes, and access policy.

sensitive.example// stored (encrypted at rest) encrypted_value: "vault:..." // displayed (never raw) masked_display: "***-**-1234" // for controlled matching only match_hash: "sha256:..." // authorization required to decrypt access_policy: "credit.pii.read"