Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
budget_id | INT | 10 | √ | null |
|
|
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 |
|
|
budget warning at percentage |
|||||||||||||||
budget_expend | DECIMAL | 28,6 | √ | 0.000000 |
|
|
budget warning at amount |
|||||||||||||||
budget_notes | LONGTEXT | 2147483647 | √ | null |
|
|
notes related to this fund |
|||||||||||||||
timestamp | TIMESTAMP | 19 | CURRENT_TIMESTAMP |
|
|
date and time this fund was last touched (created or modified) |
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | budget_id |
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 |