Data Relationship Truth Map

Shows whether the business chain is truly connected from demand to delivery.

Total

6

Mapped

6

Missing Link Column

0

Missing Table

0

Relationship	From	To	Expected Link	Counts	Truth
inquiry_to_proposal	Inquiry `public_inquiries`	Proposal `public_proposals`	`inquiry_id`	6 → 8	MAPPED
	Expected proposal should reference inquiry or source inquiry.
proposal_to_deal	Proposal `public_proposals`	Deal `public_deals`	`proposal_id`	8 → 7	MAPPED
	Expected deal should reference proposal.
deal_to_invoice	Deal `public_deals`	Invoice `revenue_invoices`	`deal_id`	7 → 1	MAPPED
	Expected invoice should reference deal.
invoice_to_payment	Invoice `revenue_invoices`	Payment `revenue_payments`	`invoice_id`	1 → 1	MAPPED
	Expected payment should reference invoice.
payment_to_project	Payment `revenue_payments`	Client Project `client_projects`	`payment_id`	1 → 2	MAPPED
	Expected paid payment should activate project.
project_to_account	Client Project `client_projects`	Client Account `client_accounts`	`project_id`	2 → 1	MAPPED
	Expected client account should reference project or client identity.