invoice_transaction_summaries__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
temporary_invoice_transactions__t.source_invoice_id temporary_invoice_transactions__t_source_invoice_id_fkeyR
transaction__t.source_invoice_id transaction__t_source_invoice_id_fkeyR
vouchers__t.invoice_id vouchers__t_invoice_id_fkeyR
num_payments_credits numeric 131089 √ null
num_pending_payments numeric 131089 √ null

Indexes

Constraint Name Type Sort Column(s)
invoice_transaction_summaries__t_pkey Primary key Asc id
invoice_transaction_summaries__t___origin_idx Performance Asc __origin
invoice_transaction_summaries__t___source_idx Performance Asc __source
invoice_transaction_summaries__t___start_idx Performance Asc __start
invoice_transaction_summaries__t_id_idx Performance Asc id
invoice_transaction_summaries__t_num_payments_credits_idx Performance Asc num_payments_credits
invoice_transaction_summaries__t_num_pending_payments_idx Performance Asc num_pending_payments

Relationships

Close relationships within degrees of separation