temporary_invoice_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
amount numeric 131089 √ null
source varchar 7 √ null
currency varchar 3 √ null
expense_class_id uuid 2147483647 √ null
expense_class__t.id temporary_invoice_transactions__t_expense_class_id_fkeyR
source_invoice_id uuid 2147483647 √ null
invoice_transaction_summaries__t.id temporary_invoice_transactions__t_source_invoice_id_fkeyR
source_invoice_line_id uuid 2147483647 √ null
from_fund_id uuid 2147483647 √ null
fund__t.id temporary_invoice_transactions__t_from_fund_id_fkeyR
fiscal_year_id uuid 2147483647 √ null
fiscal_year__t.id temporary_invoice_transactions__t_fiscal_year_id_fkeyR
transaction_type varchar 15 √ null
payment_encumbrance_id uuid 2147483647 √ null
transaction__t.id temporary_invoice_transactions__t_payment_encumbrance_id_fkeyR
to_fund_id uuid 2147483647 √ null
fund__t.id temporary_invoice_transactions__t_to_fund_id_fkeyR

Indexes

Constraint Name Type Sort Column(s)
temporary_invoice_transactions__t_pkey Primary key Asc __id
temporary_invoice_transactions__t___origin_idx Performance Asc __origin
temporary_invoice_transactions__t___source_idx Performance Asc __source
temporary_invoice_transactions__t___start_idx Performance Asc __start
temporary_invoice_transactions__t_amount_idx Performance Asc amount
temporary_invoice_transactions__t_currency_idx Performance Asc currency
temporary_invoice_transactions__t_expense_class_id_idx Performance Asc expense_class_id
temporary_invoice_transactions__t_fiscal_year_id_idx Performance Asc fiscal_year_id
temporary_invoice_transactions__t_from_fund_id_idx Performance Asc from_fund_id
temporary_invoice_transactions__t_id_idx Performance Asc id
temporary_invoice_transactions__t_payment_encumbrance_id_idx Performance Asc payment_encumbrance_id
temporary_invoice_transactions__t_source_idx Performance Asc source
temporary_invoice_transactions__t_source_invoice_id_idx Performance Asc source_invoice_id
temporary_invoice_transactions__t_source_invoice_line_id_idx Performance Asc source_invoice_line_id
temporary_invoice_transactions__t_to_fund_id_idx Performance Asc to_fund_id
temporary_invoice_transactions__t_transaction_type_idx Performance Asc transaction_type

Relationships

Close relationships within degrees of separation