Tables


SchemaSpy Analysis of egdb3_14_1.money

Generated on Fri Dec 20 11:17 CST 2024

Evergreen 3.14.1 load-concerto-enhanced

XML Representation
Insertion Order Deletion Order
TABLES 19
VIEWS 25
COLUMNS 365
Constraints 7
Anomalies 0
Routines 12

Database Properties

Database Type: PostgreSQL - 15.10 (Ubuntu 15.10-1.pgdg24.04+1)

Tables

Table / View Children Parents Columns Rows Type Comments
credit_payment 0 0 8 -1 Table
payment 0 0 6 -1 Table
account_adjustment 0 1 9 -1 Table
collections_tracker 0 3 5 -1 Table
billing 1 1 13 90848 Table
work_payment 0 0 8 -1 Table
bnm_payment 0 0 8 -1 Table
bnm_desk_payment 0 1 9 -1 Table
grocery 0 0 7 58 Table
check_payment 0 0 10 -1 Table
cash_payment 0 0 9 27 Table
aged_billing 0 0 13 -1 Table
billable_xact 0 1 5 -1 Table
aged_payment 0 0 10 -1 Table
credit_card_payment 0 0 13 -1 Table
materialized_billable_xact_summary 0 0 14 559 Table
goods_payment 0 0 8 -1 Table
forgive_payment 0 0 8 -1 Table
debit_card_payment 0 0 9 -1 Table
billable_xact_summary_location_view 0 0 15 0 View
open_usr_summary 0 0 4 0 View
open_billable_xact_summary 0 0 15 0 View
open_transaction_billing_type_summary 0 0 5 0 View
billable_xact_summary 0 0 14 0 View
bnm_payment_view 0 0 9 0 View
cashdrawer_payment_view 0 0 7 0 View
open_usr_circulation_summary 0 0 4 0 View
non_drawer_payment_view 0 0 9 0 View
transaction_payment_with_void_summary 0 0 5 0 View
transaction_billing_type_summary 0 0 5 0 View
payment_view_for_aging 0 0 10 0 View
open_transaction_payment_summary 0 0 5 0 View
payment_view 0 0 7 0 View
open_with_balance_usr_summary 0 0 4 0 View
transaction_billing_summary 0 0 5 0 View
usr_circulation_summary 0 0 4 0 View
transaction_billing_with_void_summary 0 0 5 0 View
all_payments 0 0 10 0 View
desk_payment_view 0 0 10 0 View
open_transaction_billing_summary 0 0 5 0 View
usr_summary 0 0 4 0 View
billable_xact_with_void_summary 0 0 14 0 View
transaction_payment_summary 0 0 5 0 View
all_billings 0 0 13 0 View