Attachment #132415 for bug #17656

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




  is_foreign_key: 1
  is_nullable: 0

foreign key for biblio.biblionumber that this subscription is attached to

=head2 subscriptionid

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

unique key for this subscription

=head2 librarian

  data_type: 'varchar'

  is_nullable: 1
  size: 100

the librarian's username from borrowers.userid

=head2 startdate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

start date for this subscription

=head2 aqbooksellerid

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

foreign key for aqbooksellers.id to link to the vendor

=head2 cost

  data_type: 'integer'

  default_value: 0
  is_nullable: 1

subscription length in weeks (will not be filled in if monthlength or numberlength is set)

=head2 monthlength

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

subscription length in weeks (will not be filled in if weeklength or numberlength is set)

=head2 numberlength

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

subscription length in weeks (will not be filled in if monthlength or weeklength is set)

=head2 periodicity

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

frequency type links to subscription_frequencies.id

=head2 countissuesperunit

  data_type: 'integer'

  data_type: 'longtext'
  is_nullable: 1

notes

=head2 status

  data_type: 'varchar'

  is_nullable: 0
  size: 100

status of this subscription

=head2 lastvalue1

  data_type: 'integer'

  datetime_undef_if_invalid: 1
  is_nullable: 1

first issue received date

=head2 manualhistory

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

yes or no to managing the history manually

=head2 irregularity

  data_type: 'mediumtext'
  is_nullable: 1

=head2 permanent_irregularity

  data_type: 'mediumtext'
  is_nullable: 1

=head2 skip_serialseq


  is_foreign_key: 1
  is_nullable: 1

the numbering pattern used links to subscription_numberpatterns.id

=head2 locale

  data_type: 'varchar'
  is_nullable: 1
  size: 80

for foreign language subscriptions to display months, seasons, etc correctly

=head2 distributedto

  data_type: 'mediumtext'

  data_type: 'mediumtext'
  is_nullable: 1

default call number

=head2 location

  data_type: 'varchar'

  is_nullable: 1
  size: 80

default shelving location (items.location)

=head2 branchcode

  data_type: 'varchar'

  is_nullable: 0
  size: 10

default branches (items.homebranch)

=head2 lastbranch

  data_type: 'varchar'

  default_value: 0
  is_nullable: 0

does receiving this serial create an item record

=head2 staffdisplaycount

  data_type: 'varchar'
  is_nullable: 1
  size: 10

how many issues to show to the staff

=head2 opacdisplaycount

  data_type: 'varchar'
  is_nullable: 1
  size: 10

how many issues to show to the public

=head2 graceperiod

  data_type: 'integer'
  default_value: 0
  is_nullable: 0

grace period in days

=head2 enddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

subscription end date

=head2 closed

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

yes / no if the subscription is closed

=head2 reneweddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date of last renewal for the subscription

=head2 itemtype

  data_type: 'varchar'

  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
  "irregularity",
  { data_type => "mediumtext", is_nullable => 1 },
  "permanent_irregularity",
  { data_type => "mediumtext", is_nullable => 1 },
  "skip_serialseq",
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
  "letter",

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-03-04 15:52:23
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0Pt/RPOtwhz5vHtPGljxfg

__PACKAGE__->has_many(
  "additional_field_values",
- 

Return to bug 17656

Lines 29-44 __PACKAGE__->table("subscription"); Link Here

(-)a/Koha/Schema/Result/Subscription.pm (-54 / +8 lines)
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	-