fund__t


Columns

Column Type Size Nulls Auto Default Children Parents Comments
__id int8 19 √ null
__cf bool 1 true
__start timestamptz 35,6 null
__source varchar 63 null
__origin varchar 63 ''::character varying
id uuid 2147483647 null
budget__t.fund_id budget__t_fund_id_fkeyR
group_fund_fiscal_year__t.fund_id group_fund_fiscal_year__t_fund_id_fkeyR
temporary_invoice_transactions__t.from_fund_id temporary_invoice_transactions__t_from_fund_id_fkeyR
temporary_invoice_transactions__t.to_fund_id temporary_invoice_transactions__t_to_fund_id_fkeyR
temporary_order_transactions__t.from_fund_id temporary_order_transactions__t_from_fund_id_fkeyR
transaction__t.from_fund_id transaction__t_from_fund_id_fkeyR
transaction__t.to_fund_id transaction__t_to_fund_id_fkeyR
fund_status varchar 8 √ null
name varchar 39 √ null
fund_type_id uuid 2147483647 √ null
fund_type__t.id fund__t_fund_type_id_fkeyR
external_account_no varchar 10 √ null
code varchar 5 √ null
ledger_id uuid 2147483647 √ null
ledger__t.id fund__t_ledger_id_fkeyR
description varchar 23 √ null

Indexes

Constraint Name Type Sort Column(s)
fund__t_pkey Primary key Asc id
fund__t___origin_idx Performance Asc __origin
fund__t___source_idx Performance Asc __source
fund__t___start_idx Performance Asc __start
fund__t_code_idx Performance Asc code
fund__t_description_idx Performance Asc description
fund__t_external_account_no_idx Performance Asc external_account_no
fund__t_fund_status_idx Performance Asc fund_status
fund__t_fund_type_id_idx Performance Asc fund_type_id
fund__t_id_idx Performance Asc id
fund__t_ledger_id_idx Performance Asc ledger_id
fund__t_name_idx Performance Asc name

Relationships

Close relationships within degrees of separation