Schema: money

Financial — billings, payments, and transaction summaries.

Tables

19

Views

25

Functions

12

Triggers

43

Enum Types

0

This schema has 43 triggers. Many triggers modify data before write (BEFORE ROW triggers) or maintain denormalized summary tables (AFTER triggers). Review trigger bodies carefully before writing to these tables directly.

Tables

Table Triggers FKs Description

account_adjustment ⚡ 3

3

1

aged_billing

0

0

aged_payment

0

0

billable_xact

0

1

billing ⚡ 4

4

1

bnm_desk_payment ⚡ 3

3

1

bnm_payment ⚡ 3

3

0

cash_payment ⚡ 3

3

0

check_payment ⚡ 3

3

0

collections_tracker

0

3

credit_card_payment ⚡ 3

3

0

credit_payment ⚡ 3

3

0

debit_card_payment ⚡ 3

3

0

forgive_payment ⚡ 3

3

0

goods_payment ⚡ 3

3

0

grocery ⚡ 3

3

0

materialized_billable_xact_summary

0

0

payment ⚡ 3

3

0

work_payment ⚡ 3

3

0

Functions