Table testsql_comments.aqbudgets
information related to Funds

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_id int 10  √ 
aqbudgetborrowers.budget_id aqbudgetborrowers_ibfk_1 C
aqbudgets_planning.budget_id aqbudgets_planning_ifbk_1 C
aqinvoices.shipmentcost_budgetid aqinvoices_fk_shipmentcost_budgetid N
aqorders.budget_id aqorders_budget_id_fk C
suggestions.budgetid suggestions_budget_id_fk N
vendor_edi_accounts.shipment_budget vfk_shipment_budget R
primary key and unique number assigned to each fund by Koha
budget_parent_id int 10  √  null if this fund is a child of another this will include the parent id (aqbudgets.budget_id)
budget_code varchar 30  √  null code assigned to the fund by the user
budget_name varchar 80  √  null name assigned to the fund by the user
budget_branchcode varchar 10  √  null branch that this fund belongs to (branches.branchcode)
budget_amount decimal 28,6  √  0.000000 total amount for this fund
budget_encumb decimal 28,6  √  0.000000 not used in the code
budget_expend decimal 28,6  √  0.000000 not used in the code
budget_notes mediumtext 16777215  √  null notes related to this fund
timestamp timestamp 19 CURRENT_TIMESTAMP date and time this fund was last touched (created or modified)
budget_period_id int 10  √  null
aqbudgetperiods.budget_period_id Implied Constraint R
id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id)
sort1_authcat varchar 80  √  null statistical category for this fund
sort2_authcat varchar 80  √  null second statistical category for this fund
budget_owner_id int 10  √  null borrowernumber of the person who owns this fund (borrowers.borrowernumber)
budget_permission int 10  √  0 level of permission for this fund (used only by the owner, only by the library, or anyone)

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

Indexes:
Column(s) Type Sort Constraint Name
budget_id Primary key Asc PRIMARY
budget_branchcode Performance Asc budget_branchcode
budget_code Performance Asc budget_code
budget_owner_id Performance Asc budget_owner_id
budget_parent_id Performance Asc budget_parent_id
budget_period_id Performance Asc budget_period_id

Close relationships  within of separation: