Table testsql_comments.aqbudgetperiods
information related to Budgets

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
budget_period_id int 10  √ 
aqbudgets.budget_period_id Implied Constraint R
aqbudgets_planning.budget_period_id Implied Constraint R
primary key and unique number assigned by Koha
budget_period_startdate date 10 date when the budget starts
budget_period_enddate date 10 date when the budget ends
budget_period_active bit 0  √  0 whether this budget is active or not (1 for yes, 0 for no)
budget_period_description mediumtext 16777215  √  null description assigned to this budget
budget_period_total decimal 28,6  √  null total amount available in this budget
budget_period_locked bit 0  √  null whether this budget is locked or not (1 for yes, 0 for no)
sort1_authcat varchar 10  √  null statistical category for this budget
sort2_authcat varchar 10  √  null second statistical category for this budget

Table contained 0 rows at Mon Jul 16 09:22 NZST 2018

Indexes:
Column(s) Type Sort Constraint Name
budget_period_id Primary key Asc PRIMARY

Close relationships: