aqbudgetperiods

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
budget_period_id INT 10 null
aqbudgets.budget_period_id aqbudgetperiods_ibfk_1 C

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