business
business → relationship
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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. |