money.materialized_billable_xact_summary

id PK

bigint

No

usr

integer

Yes

xact_start

timestamp with time zone

Yes

xact_finish

timestamp with time zone

Yes

total_paid

numeric

Yes

last_payment_ts

timestamp with time zone

Yes

last_payment_note

text

Yes

last_payment_type

name

Yes

total_owed

numeric

Yes

last_billing_ts

timestamp with time zone

Yes

last_billing_note

text

Yes

last_billing_type

text

Yes

balance_owed

numeric

Yes

xact_type

name

Yes

materialized_billable_xact_summary_pkey PK

btree

CREATE UNIQUE INDEX materialized_billable_xact_summary_pkey ON money.materialized_billable_xact_summary USING btree (id)

money_mat_summary_usr_idx

btree

CREATE INDEX money_mat_summary_usr_idx ON money.materialized_billable_xact_summary USING btree (usr)

money_mat_summary_xact_start_idx

btree

CREATE INDEX money_mat_summary_xact_start_idx ON money.materialized_billable_xact_summary USING btree (xact_start)