TABLES
28
VIEWS
0
COLUMNS
300
Constraints
25
Anomalies
0
Routines
0
Database Properties
Database Type: PostgreSQL - 14.2
Tables
| Table / View | Children | Parents | Columns | Type | Comments |
|---|---|---|---|---|---|
| expense_class__t | 4 | 0 | 8 | Table | |
| groups | 0 | 0 | 9 | Table | |
| transaction | 0 | 0 | 14 | Table | |
| invoice_transaction_summaries__t | 3 | 0 | 8 | Table | |
| fund_type__t | 1 | 0 | 7 | Table | |
| budget_expense_class | 0 | 0 | 9 | Table | |
| temporary_order_transactions | 0 | 0 | 11 | Table | |
| group_fund_fiscal_year__t | 0 | 4 | 10 | Table | |
| invoice_transaction_summaries | 0 | 0 | 7 | Table | |
| groups__t | 1 | 0 | 10 | Table | |
| group_fund_fiscal_year | 0 | 0 | 11 | Table | |
| budget__t | 2 | 2 | 19 | Table | |
| fund__t | 7 | 2 | 13 | Table | |
| fund | 0 | 0 | 11 | Table | |
| budget | 0 | 0 | 11 | Table | |
| order_transaction_summaries__t | 0 | 0 | 7 | Table | |
| fiscal_year__t | 6 | 0 | 12 | Table | |
| temporary_invoice_transactions | 0 | 0 | 13 | Table | |
| expense_class | 0 | 0 | 7 | Table | |
| ledger__t | 1 | 1 | 13 | Table | |
| order_transaction_summaries | 0 | 0 | 7 | Table | |
| budget_expense_class__t | 0 | 2 | 9 | Table | |
| ledger | 0 | 0 | 10 | Table | |
| transaction__t | 1 | 5 | 18 | Table | |
| fund_type | 0 | 0 | 7 | Table | |
| temporary_invoice_transactions__t | 0 | 6 | 17 | Table | |
| fiscal_year | 0 | 0 | 9 | Table | |
| temporary_order_transactions__t | 0 | 3 | 13 | Table |