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

(-)a/Koha/Schema/Result/Subscription.pm (-54 / +8 lines)
Lines 29-44 __PACKAGE__->table("subscription"); Link Here
29
  is_foreign_key: 1
29
  is_foreign_key: 1
30
  is_nullable: 0
30
  is_nullable: 0
31
31
32
foreign key for biblio.biblionumber that this subscription is attached to
33
34
=head2 subscriptionid
32
=head2 subscriptionid
35
33
36
  data_type: 'integer'
34
  data_type: 'integer'
37
  is_auto_increment: 1
35
  is_auto_increment: 1
38
  is_nullable: 0
36
  is_nullable: 0
39
37
40
unique key for this subscription
41
42
=head2 librarian
38
=head2 librarian
43
39
44
  data_type: 'varchar'
40
  data_type: 'varchar'
Lines 46-69 unique key for this subscription Link Here
46
  is_nullable: 1
42
  is_nullable: 1
47
  size: 100
43
  size: 100
48
44
49
the librarian's username from borrowers.userid
50
51
=head2 startdate
45
=head2 startdate
52
46
53
  data_type: 'date'
47
  data_type: 'date'
54
  datetime_undef_if_invalid: 1
48
  datetime_undef_if_invalid: 1
55
  is_nullable: 1
49
  is_nullable: 1
56
50
57
start date for this subscription
58
59
=head2 aqbooksellerid
51
=head2 aqbooksellerid
60
52
61
  data_type: 'integer'
53
  data_type: 'integer'
62
  default_value: 0
54
  default_value: 0
63
  is_nullable: 1
55
  is_nullable: 1
64
56
65
foreign key for aqbooksellers.id to link to the vendor
66
67
=head2 cost
57
=head2 cost
68
58
69
  data_type: 'integer'
59
  data_type: 'integer'
Lines 82-113 foreign key for aqbooksellers.id to link to the vendor Link Here
82
  default_value: 0
72
  default_value: 0
83
  is_nullable: 1
73
  is_nullable: 1
84
74
85
subscription length in weeks (will not be filled in if monthlength or numberlength is set)
86
87
=head2 monthlength
75
=head2 monthlength
88
76
89
  data_type: 'integer'
77
  data_type: 'integer'
90
  default_value: 0
78
  default_value: 0
91
  is_nullable: 1
79
  is_nullable: 1
92
80
93
subscription length in weeks (will not be filled in if weeklength or numberlength is set)
94
95
=head2 numberlength
81
=head2 numberlength
96
82
97
  data_type: 'integer'
83
  data_type: 'integer'
98
  default_value: 0
84
  default_value: 0
99
  is_nullable: 1
85
  is_nullable: 1
100
86
101
subscription length in weeks (will not be filled in if monthlength or weeklength is set)
102
103
=head2 periodicity
87
=head2 periodicity
104
88
105
  data_type: 'integer'
89
  data_type: 'integer'
106
  is_foreign_key: 1
90
  is_foreign_key: 1
107
  is_nullable: 1
91
  is_nullable: 1
108
92
109
frequency type links to subscription_frequencies.id
110
111
=head2 countissuesperunit
93
=head2 countissuesperunit
112
94
113
  data_type: 'integer'
95
  data_type: 'integer'
Lines 119-126 frequency type links to subscription_frequencies.id Link Here
119
  data_type: 'longtext'
101
  data_type: 'longtext'
120
  is_nullable: 1
102
  is_nullable: 1
121
103
122
notes
123
124
=head2 status
104
=head2 status
125
105
126
  data_type: 'varchar'
106
  data_type: 'varchar'
Lines 128-135 notes Link Here
128
  is_nullable: 0
108
  is_nullable: 0
129
  size: 100
109
  size: 100
130
110
131
status of this subscription
132
133
=head2 lastvalue1
111
=head2 lastvalue1
134
112
135
  data_type: 'integer'
113
  data_type: 'integer'
Lines 169-190 status of this subscription Link Here
169
  datetime_undef_if_invalid: 1
147
  datetime_undef_if_invalid: 1
170
  is_nullable: 1
148
  is_nullable: 1
171
149
172
first issue received date
173
174
=head2 manualhistory
150
=head2 manualhistory
175
151
176
  data_type: 'tinyint'
152
  data_type: 'tinyint'
177
  default_value: 0
153
  default_value: 0
178
  is_nullable: 0
154
  is_nullable: 0
179
155
180
yes or no to managing the history manually
181
182
=head2 irregularity
156
=head2 irregularity
183
157
184
  data_type: 'mediumtext'
158
  data_type: 'mediumtext'
185
  is_nullable: 1
159
  is_nullable: 1
186
160
187
any irregularities in the subscription
161
=head2 permanent_irregularity
162
163
  data_type: 'mediumtext'
164
  is_nullable: 1
188
165
189
=head2 skip_serialseq
166
=head2 skip_serialseq
190
167
Lines 204-219 any irregularities in the subscription Link Here
204
  is_foreign_key: 1
181
  is_foreign_key: 1
205
  is_nullable: 1
182
  is_nullable: 1
206
183
207
the numbering pattern used links to subscription_numberpatterns.id
208
209
=head2 locale
184
=head2 locale
210
185
211
  data_type: 'varchar'
186
  data_type: 'varchar'
212
  is_nullable: 1
187
  is_nullable: 1
213
  size: 80
188
  size: 80
214
189
215
for foreign language subscriptions to display months, seasons, etc correctly
216
217
=head2 distributedto
190
=head2 distributedto
218
191
219
  data_type: 'mediumtext'
192
  data_type: 'mediumtext'
Lines 229-236 for foreign language subscriptions to display months, seasons, etc correctly Link Here
229
  data_type: 'mediumtext'
202
  data_type: 'mediumtext'
230
  is_nullable: 1
203
  is_nullable: 1
231
204
232
default call number
233
234
=head2 location
205
=head2 location
235
206
236
  data_type: 'varchar'
207
  data_type: 'varchar'
Lines 238-245 default call number Link Here
238
  is_nullable: 1
209
  is_nullable: 1
239
  size: 80
210
  size: 80
240
211
241
default shelving location (items.location)
242
243
=head2 branchcode
212
=head2 branchcode
244
213
245
  data_type: 'varchar'
214
  data_type: 'varchar'
Lines 247-254 default shelving location (items.location) Link Here
247
  is_nullable: 0
216
  is_nullable: 0
248
  size: 10
217
  size: 10
249
218
250
default branches (items.homebranch)
251
252
=head2 lastbranch
219
=head2 lastbranch
253
220
254
  data_type: 'varchar'
221
  data_type: 'varchar'
Lines 261-316 default branches (items.homebranch) Link Here
261
  default_value: 0
228
  default_value: 0
262
  is_nullable: 0
229
  is_nullable: 0
263
230
264
does receiving this serial create an item record
265
266
=head2 staffdisplaycount
231
=head2 staffdisplaycount
267
232
268
  data_type: 'varchar'
233
  data_type: 'varchar'
269
  is_nullable: 1
234
  is_nullable: 1
270
  size: 10
235
  size: 10
271
236
272
how many issues to show to the staff
273
274
=head2 opacdisplaycount
237
=head2 opacdisplaycount
275
238
276
  data_type: 'varchar'
239
  data_type: 'varchar'
277
  is_nullable: 1
240
  is_nullable: 1
278
  size: 10
241
  size: 10
279
242
280
how many issues to show to the public
281
282
=head2 graceperiod
243
=head2 graceperiod
283
244
284
  data_type: 'integer'
245
  data_type: 'integer'
285
  default_value: 0
246
  default_value: 0
286
  is_nullable: 0
247
  is_nullable: 0
287
248
288
grace period in days
289
290
=head2 enddate
249
=head2 enddate
291
250
292
  data_type: 'date'
251
  data_type: 'date'
293
  datetime_undef_if_invalid: 1
252
  datetime_undef_if_invalid: 1
294
  is_nullable: 1
253
  is_nullable: 1
295
254
296
subscription end date
297
298
=head2 closed
255
=head2 closed
299
256
300
  data_type: 'tinyint'
257
  data_type: 'tinyint'
301
  default_value: 0
258
  default_value: 0
302
  is_nullable: 0
259
  is_nullable: 0
303
260
304
yes / no if the subscription is closed
305
306
=head2 reneweddate
261
=head2 reneweddate
307
262
308
  data_type: 'date'
263
  data_type: 'date'
309
  datetime_undef_if_invalid: 1
264
  datetime_undef_if_invalid: 1
310
  is_nullable: 1
265
  is_nullable: 1
311
266
312
date of last renewal for the subscription
313
314
=head2 itemtype
267
=head2 itemtype
315
268
316
  data_type: 'varchar'
269
  data_type: 'varchar'
Lines 377-382 __PACKAGE__->add_columns( Link Here
377
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
330
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
378
  "irregularity",
331
  "irregularity",
379
  { data_type => "mediumtext", is_nullable => 1 },
332
  { data_type => "mediumtext", is_nullable => 1 },
333
  "permanent_irregularity",
334
  { data_type => "mediumtext", is_nullable => 1 },
380
  "skip_serialseq",
335
  "skip_serialseq",
381
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
336
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
382
  "letter",
337
  "letter",
Lines 549-556 __PACKAGE__->has_many( Link Here
549
);
504
);
550
505
551
506
552
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
507
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-03-04 15:52:23
553
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RA/Z4pcP53tB0kXgo0W6fQ
508
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0Pt/RPOtwhz5vHtPGljxfg
554
509
555
__PACKAGE__->has_many(
510
__PACKAGE__->has_many(
556
  "additional_field_values",
511
  "additional_field_values",
557
- 

Return to bug 17656