money.payment_view (view)

↑ money 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
id	`bigint`	Yes
xact	`bigint`	Yes
payment_ts	`timestamp with time zone`	Yes
voided	`boolean`	Yes
amount	`numeric(6,2)`	Yes
note	`text`	Yes
payment_type	`name`	Yes

bigint

Yes

xact

bigint

Yes

payment_ts

timestamp with time zone

Yes

voided

boolean

Yes

amount

numeric(6,2)

Yes

note

text

Yes

payment_type

name

Yes

View Definition

 SELECT p.id,
    p.xact,
    p.payment_ts,
    p.voided,
    p.amount,
    p.note,
    c.relname AS payment_type
   FROM money.payment p
     JOIN pg_class c ON p.tableoid = c.oid;