ldp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
finance_fiscal_years
Description
https://dev.folio.org/reference/api/#mod-finance-storage
Columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
id
varchar
36
null
finance_budgets
.fiscal_year_id
finance_budgets_fiscal_year_id_fkey
R
finance_group_fund_fiscal_years
.fiscal_year_id
finance_group_fund_fiscal_years_fiscal_year_id_fkey
R
finance_ledgers
.fiscal_year_one_id
finance_ledgers_fiscal_year_one_id_fkey
R
finance_transactions
.fiscal_year_id
finance_transactions_fiscal_year_id_fkey
R
code
varchar
6
√
null
currency
varchar
3
√
null
name
varchar
4
√
null
period_end
timestamptz
35,6
√
null
period_start
timestamptz
35,6
√
null
series
varchar
2
√
null
data
json
2147483647
√
null
Showing 1 to 8 of 8 entries
Previous
1
Next
Indexes
Search:
Constraint Name
Type
Sort
Column(s)
finance_fiscal_years_pkey
Primary key
Asc
id
finance_fiscal_years_code_idx
Performance
Asc
code
finance_fiscal_years_currency_idx
Performance
Asc
currency
finance_fiscal_years_name_idx
Performance
Asc
name
finance_fiscal_years_period_end_idx
Performance
Asc
period_end
finance_fiscal_years_period_start_idx
Performance
Asc
period_start
finance_fiscal_years_series_idx
Performance
Asc
series
Showing 1 to 7 of 7 entries
Previous
1
Next
Relationships
Close relationships within degrees of separation
One
Two degrees
