temporary_order_transactions__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
from_fund_id uuid 2147483647 √ null
fund__t.id temporary_order_transactions__t_from_fund_id_fkeyR
fiscal_year_id uuid 2147483647 √ null
fiscal_year__t.id temporary_order_transactions__t_fiscal_year_id_fkeyR
expense_class_id uuid 2147483647 √ null
expense_class__t.id temporary_order_transactions__t_expense_class_id_fkeyR
amount numeric 131089 √ null
transaction_type varchar 11 √ null
source varchar 6 √ null
currency varchar 3 √ null

Indexes

Constraint Name Type Sort Column(s)
temporary_order_transactions__t_pkey Primary key Asc __id
temporary_order_transactions__t___origin_idx Performance Asc __origin
temporary_order_transactions__t___source_idx Performance Asc __source
temporary_order_transactions__t___start_idx Performance Asc __start
temporary_order_transactions__t_amount_idx Performance Asc amount
temporary_order_transactions__t_currency_idx Performance Asc currency
temporary_order_transactions__t_expense_class_id_idx Performance Asc expense_class_id
temporary_order_transactions__t_fiscal_year_id_idx Performance Asc fiscal_year_id
temporary_order_transactions__t_from_fund_id_idx Performance Asc from_fund_id
temporary_order_transactions__t_id_idx Performance Asc id
temporary_order_transactions__t_source_idx Performance Asc source
temporary_order_transactions__t_transaction_type_idx Performance Asc transaction_type

Relationships

Close relationships within degrees of separation