Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| budget_period_id | INT | 10 | √ | null |
|
|
primary key and unique number assigned by Koha |
||||
| budget_period_startdate | DATE | 10 | null |
|
|
date when the budget starts |
|||||
| budget_period_enddate | DATE | 10 | null |
|
|
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 | LONGTEXT | 2147483647 | √ | 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 |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | budget_period_id |
Relationships
Close relationships within degrees of separation
