acq.fund_debit_total (view)

↑ acq schema

This is a database view, not a base table. It has no triggers, indexes, or FK constraints of its own. Querying this view may be more efficient than joining the underlying tables directly.

Columns

Column Type Nullable Notes

Column	Type	Nullable	Notes
fund	`integer`	Yes
amount	`numeric`	Yes

fund

integer

Yes

amount

numeric

Yes

View Definition

 SELECT fund.id AS fund,
    sum(COALESCE(fund_debit.amount, 0::numeric)) AS amount
   FROM acq.fund fund
     LEFT JOIN acq.fund_debit fund_debit ON fund.id = fund_debit.fund
  GROUP BY fund.id;