fiscal_year__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.fiscal_year_id budget__t_fiscal_year_id_fkeyR
group_fund_fiscal_year__t.fiscal_year_id group_fund_fiscal_year__t_fiscal_year_id_fkeyR
ledger__t.fiscal_year_one_id ledger__t_fiscal_year_one_id_fkeyR
temporary_invoice_transactions__t.fiscal_year_id temporary_invoice_transactions__t_fiscal_year_id_fkeyR
temporary_order_transactions__t.fiscal_year_id temporary_order_transactions__t_fiscal_year_id_fkeyR
transaction__t.fiscal_year_id transaction__t_fiscal_year_id_fkeyR
code varchar 6 √ null
name varchar 4 √ null
series varchar 2 √ null
currency varchar 3 √ null
period_end timestamptz 35,6 √ null
period_start timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
fiscal_year__t_pkey Primary key Asc id
fiscal_year__t___origin_idx Performance Asc __origin
fiscal_year__t___source_idx Performance Asc __source
fiscal_year__t___start_idx Performance Asc __start
fiscal_year__t_code_idx Performance Asc code
fiscal_year__t_currency_idx Performance Asc currency
fiscal_year__t_id_idx Performance Asc id
fiscal_year__t_name_idx Performance Asc name
fiscal_year__t_period_end_idx Performance Asc period_end
fiscal_year__t_period_start_idx Performance Asc period_start
fiscal_year__t_series_idx Performance Asc series

Relationships

Close relationships within degrees of separation