View | Details | Raw Unified | Return to bug 32132
Collapse All | Expand All

(-)a/Koha/Schema/Result/Aqbudget.pm (-41 / +5 lines)
Lines 29-67 __PACKAGE__->table("aqbudgets"); Link Here
29
  is_auto_increment: 1
29
  is_auto_increment: 1
30
  is_nullable: 0
30
  is_nullable: 0
31
31
32
primary key and unique number assigned to each fund by Koha
33
34
=head2 budget_parent_id
32
=head2 budget_parent_id
35
33
36
  data_type: 'integer'
34
  data_type: 'integer'
37
  is_nullable: 1
35
  is_nullable: 1
38
36
39
if this fund is a child of another this will include the parent id (aqbudgets.budget_id)
40
41
=head2 budget_code
37
=head2 budget_code
42
38
43
  data_type: 'varchar'
39
  data_type: 'varchar'
44
  is_nullable: 1
40
  is_nullable: 1
45
  size: 30
41
  size: 30
46
42
47
code assigned to the fund by the user
48
49
=head2 budget_name
43
=head2 budget_name
50
44
51
  data_type: 'varchar'
45
  data_type: 'varchar'
52
  is_nullable: 1
46
  is_nullable: 1
53
  size: 80
47
  size: 80
54
48
55
name assigned to the fund by the user
56
57
=head2 budget_branchcode
49
=head2 budget_branchcode
58
50
59
  data_type: 'varchar'
51
  data_type: 'varchar'
60
  is_nullable: 1
52
  is_nullable: 1
61
  size: 10
53
  size: 10
62
54
63
branch that this fund belongs to (branches.branchcode)
64
65
=head2 budget_amount
55
=head2 budget_amount
66
56
67
  data_type: 'decimal'
57
  data_type: 'decimal'
Lines 69-76 branch that this fund belongs to (branches.branchcode) Link Here
69
  is_nullable: 1
59
  is_nullable: 1
70
  size: [28,6]
60
  size: [28,6]
71
61
72
total amount for this fund
73
74
=head2 budget_encumb
62
=head2 budget_encumb
75
63
76
  data_type: 'decimal'
64
  data_type: 'decimal'
Lines 78-85 total amount for this fund Link Here
78
  is_nullable: 1
66
  is_nullable: 1
79
  size: [28,6]
67
  size: [28,6]
80
68
81
budget warning at percentage
82
83
=head2 budget_expend
69
=head2 budget_expend
84
70
85
  data_type: 'decimal'
71
  data_type: 'decimal'
Lines 87-101 budget warning at percentage Link Here
87
  is_nullable: 1
73
  is_nullable: 1
88
  size: [28,6]
74
  size: [28,6]
89
75
90
budget warning at amount
91
92
=head2 budget_notes
76
=head2 budget_notes
93
77
94
  data_type: 'longtext'
78
  data_type: 'longtext'
95
  is_nullable: 1
79
  is_nullable: 1
96
80
97
notes related to this fund
98
99
=head2 timestamp
81
=head2 timestamp
100
82
101
  data_type: 'timestamp'
83
  data_type: 'timestamp'
Lines 103-117 notes related to this fund Link Here
103
  default_value: current_timestamp
85
  default_value: current_timestamp
104
  is_nullable: 0
86
  is_nullable: 0
105
87
106
date and time this fund was last touched (created or modified)
107
108
=head2 budget_period_id
88
=head2 budget_period_id
109
89
110
  data_type: 'integer'
90
  data_type: 'integer'
111
  is_foreign_key: 1
91
  is_foreign_key: 1
112
  is_nullable: 1
92
  is_nullable: 0
113
114
id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id)
115
93
116
=head2 sort1_authcat
94
=head2 sort1_authcat
117
95
Lines 119-149 id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id) Link Here
119
  is_nullable: 1
97
  is_nullable: 1
120
  size: 80
98
  size: 80
121
99
122
statistical category for this fund
123
124
=head2 sort2_authcat
100
=head2 sort2_authcat
125
101
126
  data_type: 'varchar'
102
  data_type: 'varchar'
127
  is_nullable: 1
103
  is_nullable: 1
128
  size: 80
104
  size: 80
129
105
130
second statistical category for this fund
131
132
=head2 budget_owner_id
106
=head2 budget_owner_id
133
107
134
  data_type: 'integer'
108
  data_type: 'integer'
135
  is_nullable: 1
109
  is_nullable: 1
136
110
137
borrowernumber of the person who owns this fund (borrowers.borrowernumber)
138
139
=head2 budget_permission
111
=head2 budget_permission
140
112
141
  data_type: 'integer'
113
  data_type: 'integer'
142
  default_value: 0
114
  default_value: 0
143
  is_nullable: 1
115
  is_nullable: 1
144
116
145
level of permission for this fund (used only by the owner, only by the library, or anyone)
146
147
=cut
117
=cut
148
118
149
__PACKAGE__->add_columns(
119
__PACKAGE__->add_columns(
Lines 188-194 __PACKAGE__->add_columns( Link Here
188
    is_nullable => 0,
158
    is_nullable => 0,
189
  },
159
  },
190
  "budget_period_id",
160
  "budget_period_id",
191
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
161
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
192
  "sort1_authcat",
162
  "sort1_authcat",
193
  { data_type => "varchar", is_nullable => 1, size => 80 },
163
  { data_type => "varchar", is_nullable => 1, size => 80 },
194
  "sort2_authcat",
164
  "sort2_authcat",
Lines 300-311 __PACKAGE__->belongs_to( Link Here
300
  "budget_period",
270
  "budget_period",
301
  "Koha::Schema::Result::Aqbudgetperiod",
271
  "Koha::Schema::Result::Aqbudgetperiod",
302
  { budget_period_id => "budget_period_id" },
272
  { budget_period_id => "budget_period_id" },
303
  {
273
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
304
    is_deferrable => 1,
305
    join_type     => "LEFT",
306
    on_delete     => "CASCADE",
307
    on_update     => "CASCADE",
308
  },
309
);
274
);
310
275
311
=head2 suggestions
276
=head2 suggestions
Lines 349-356 Composing rels: L</aqbudgetborrowers> -> borrowernumber Link Here
349
__PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber");
314
__PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber");
350
315
351
316
352
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
317
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-02-16 08:09:10
353
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sl+TGQXY85UWwS+Ld/vvyQ
318
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4dPgExt3A7IMjKRyB8u1zA
354
319
355
__PACKAGE__->belongs_to(
320
__PACKAGE__->belongs_to(
356
  "budget",
321
  "budget",
357
- 

Return to bug 32132