Relationships

How resources connect, including cardinality and integrity rules.

business

business → relationship

Property	Definition
Parent / from	business
Child / to	relationship
Cardinality	1:N
Join / link	relationship.to_entity_id
Meaning	Business ownership/officer links
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

person

person → relationship

Property	Definition
Parent / from	person
Child / to	relationship
Cardinality	1:N
Join / link	relationship.from_entity_id
Meaning	Owner, director or guarantor roles
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

business/person

business/person → connection

Property	Definition
Parent / from	business/person
Child / to	connection
Cardinality	1:N
Join / link	common.subject_id
Meaning	Permissioned data connections
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

consent

consent → connection

Property	Definition
Parent / from	consent
Child / to	connection
Cardinality	1:N
Join / link	connection.consent_id
Meaning	Authorization can govern multiple source connections
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

connection

connection → bank_account

Property	Definition
Parent / from	connection
Child / to	bank_account
Cardinality	1:N
Join / link	bank_account.connection_id
Meaning	Provider account scope
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

bank_account

bank_account → account_balance

Property	Definition
Parent / from	bank_account
Child / to	account_balance
Cardinality	1:N
Join / link	account_balance.account_id
Meaning	Timestamped balance history
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

bank_account → bank_transaction

Property	Definition
Parent / from	bank_account
Child / to	bank_transaction
Cardinality	1:N
Join / link	bank_transaction.account_id
Meaning	One movement on one account
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

verification

verification → verification_check

Property	Definition
Parent / from	verification
Child / to	verification_check
Cardinality	1:N
Join / link	verification_check.verification_id
Meaning	Per-feature evidence
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

verification → screening_match

Property	Definition
Parent / from	verification
Child / to	screening_match
Cardinality	1:N
Join / link	screening_match.verification_id
Meaning	Screening candidates
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

merchant_account

merchant_account → payment

Property	Definition
Parent / from	merchant_account
Child / to	payment
Cardinality	1:N
Join / link	payment.merchant_account_id
Meaning	Processing relationship
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

merchant_account → payout

Property	Definition
Parent / from	merchant_account
Child / to	payout
Cardinality	1:N
Join / link	payout.merchant_account_id
Meaning	Settlement events
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

payment

payment → refund

Property	Definition
Parent / from	payment
Child / to	refund
Cardinality	1:N
Join / link	refund.payment_id
Meaning	Partial or full refunds
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

payment → dispute

Property	Definition
Parent / from	payment
Child / to	dispute
Cardinality	1:N
Join / link	dispute.payment_id
Meaning	Payment disputes
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

payout

payout → bank_transaction

Property	Definition
Parent / from	payout
Child / to	bank_transaction
Cardinality	N:M
Join / link	Reconciliation links / provenance
Meaning	Partial/aggregated deposits require allocations; scalar link only for a verified one-to-one match
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

order

order → order_line

Property	Definition
Parent / from	order
Child / to	order_line
Cardinality	1:N
Join / link	order_line.order_id
Meaning	Item-level commercial detail
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

order → payment

Property	Definition
Parent / from	order
Child / to	payment
Cardinality	1:N
Join / link	payment.order_id
Meaning	Split tenders and installments
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

counterparty

counterparty → invoice

Property	Definition
Parent / from	counterparty
Child / to	invoice
Cardinality	1:N
Join / link	invoice.counterparty_id
Meaning	Customer receivables
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

counterparty → bill

Property	Definition
Parent / from	counterparty
Child / to	bill
Cardinality	1:N
Join / link	bill.counterparty_id
Meaning	Supplier payables
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

accounting_payment

accounting_payment → invoice/bill

Property	Definition
Parent / from	accounting_payment
Child / to	invoice/bill
Cardinality	N:M
Join / link	accounting_payment.allocations[]
Meaning	Partial and multi-document allocations
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

journal

journal → journal_line

Property	Definition
Parent / from	journal
Child / to	journal_line
Cardinality	1:N
Join / link	journal_line.journal_id
Meaning	Double-entry postings
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

ledger_account

ledger_account → journal_line

Property	Definition
Parent / from	ledger_account
Child / to	journal_line
Cardinality	1:N
Join / link	journal_line.ledger_account_id
Meaning	Account activity
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

financial_statement

financial_statement → statement_line

Property	Definition
Parent / from	financial_statement
Child / to	statement_line
Cardinality	1:N
Join / link	statement_line.statement_id
Meaning	Classified report lines
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

product

product → inventory_balance

Property	Definition
Parent / from	product
Child / to	inventory_balance
Cardinality	1:N
Join / link	inventory_balance.product_id
Meaning	Split by location, owner and lot
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

location

location → inventory_balance

Property	Definition
Parent / from	location
Child / to	inventory_balance
Cardinality	1:N
Join / link	inventory_balance.location_id
Meaning	Stock custody location
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

application

application → decision

Property	Definition
Parent / from	application
Child / to	decision
Cardinality	1:N
Join / link	decision.application_id
Meaning	Versioned assessments and reassessments
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

application → loan

Property	Definition
Parent / from	application
Child / to	loan
Cardinality	1:N
Join / link	loan.application_id
Meaning	Approved facilities can produce multiple loans
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

credit_facility

credit_facility → loan

Property	Definition
Parent / from	credit_facility
Child / to	loan
Cardinality	1:N
Join / link	loan.facility_id
Meaning	Draws within a facility
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

loan

loan → installment

Property	Definition
Parent / from	loan
Child / to	installment
Cardinality	1:N
Join / link	installment.loan_id
Meaning	Contractual schedule
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

loan → repayment

Property	Definition
Parent / from	loan
Child / to	repayment
Cardinality	1:N
Join / link	repayment.loan_id
Meaning	Payment events
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

loan/facility

loan/facility → collateral

Property	Definition
Parent / from	loan/facility
Child / to	collateral
Cardinality	1:N
Join / link	collateral.loan_id / facility_id
Meaning	A pledge record must declare the actual obligation; reuse asset identity carefully
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

lien_search

lien_search → lien

Property	Definition
Parent / from	lien_search
Child / to	lien
Cardinality	N:M
Join / link	Search evidence contexts
Meaning	A filing can recur in many searches; keep registry+filing identity stable
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

lien

lien → filing_event

Property	Definition
Parent / from	lien
Child / to	filing_event
Cardinality	1:N
Join / link	filing_event.lien_id
Meaning	Chronological registration chain
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

monitor

monitor → alert

Property	Definition
Parent / from	monitor
Child / to	alert
Cardinality	1:N
Join / link	alert.monitor_id
Meaning	Signal review queue
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

risk_snapshot

risk_snapshot → attribute

Property	Definition
Parent / from	risk_snapshot
Child / to	attribute
Cardinality	N:M
Join / link	risk_snapshot.attribute_ids[]
Meaning	Snapshot references immutable value versions
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.

common

common → document

Property	Definition
Parent / from	common
Child / to	document
Cardinality	N:M
Join / link	Evidence document IDs in source/provenance
Meaning	Documents can support multiple fields without duplicate storage
Integrity rule	All references must resolve within the authenticated tenant; unresolved source IDs stay in provenance.