Koha::Schema::Result::Subscription
subscription
data_type: 'integer' is_foreign_key: 1 is_nullable: 0
foreign key for biblio.biblionumber that this subscription is attached to
data_type: 'integer' is_auto_increment: 1 is_nullable: 0
unique key for this subscription
data_type: 'varchar' default_value: (empty string) is_nullable: 1 size: 100
the librarian's username from borrowers.userid
data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1
start date for this subscription
data_type: 'integer' is_foreign_key: 1 is_nullable: 1
foreign key for aqbooksellers.id to link to the vendor
data_type: 'integer' default_value: 0 is_nullable: 1
data_type: 'integer' default_value: 0 is_nullable: 1
data_type: 'integer' default_value: 0 is_nullable: 1
subscription length in weeks (will not be filled in if monthlength or numberlength is set)
data_type: 'integer' default_value: 0 is_nullable: 1
subscription length in weeks (will not be filled in if weeklength or numberlength is set)
data_type: 'integer' default_value: 0 is_nullable: 1
subscription length in weeks (will not be filled in if monthlength or weeklength is set)
data_type: 'integer' is_foreign_key: 1 is_nullable: 1
frequency type links to subscription_frequencies.id
data_type: 'integer' default_value: 1 is_nullable: 0
data_type: 'longtext' is_nullable: 1
notes
data_type: 'varchar' default_value: (empty string) is_nullable: 0 size: 100
status of this subscription
data_type: 'integer' is_nullable: 1
data_type: 'integer' default_value: 0 is_nullable: 1
data_type: 'integer' is_nullable: 1
data_type: 'integer' default_value: 0 is_nullable: 1
data_type: 'integer' is_nullable: 1
data_type: 'integer' default_value: 0 is_nullable: 1
data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1
first issue received date
data_type: 'tinyint' default_value: 0 is_nullable: 0
yes or no to managing the history manually
data_type: 'mediumtext' is_nullable: 1
any irregularities in the subscription
data_type: 'tinyint' default_value: 0 is_nullable: 0
data_type: 'varchar' is_nullable: 1 size: 20
data_type: 'integer' is_foreign_key: 1 is_nullable: 1
the numbering pattern used links to subscription_numberpatterns.id
data_type: 'varchar' is_nullable: 1 size: 80
for foreign language subscriptions to display months, seasons, etc correctly
data_type: 'mediumtext' is_nullable: 1
data_type: 'longtext' is_nullable: 1
data_type: 'mediumtext' is_nullable: 1
default call number
data_type: 'varchar' default_value: (empty string) is_nullable: 1 size: 80
default shelving location (items.location)
data_type: 'varchar' default_value: (empty string) is_nullable: 0 size: 10
default branches (items.homebranch)
data_type: 'varchar' is_nullable: 1 size: 10
data_type: 'tinyint' default_value: 0 is_nullable: 0
does receiving this serial create an item record
data_type: 'integer' is_nullable: 1
how many issues to show to the staff
data_type: 'integer' is_nullable: 1
how many issues to show to the public
data_type: 'integer' default_value: 0 is_nullable: 0
grace period in days
data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1
subscription end date
data_type: 'tinyint' default_value: 0 is_nullable: 0
yes / no if the subscription is closed
data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1
date of last renewal for the subscription
data_type: 'varchar' is_nullable: 1 size: 10
data_type: 'varchar' is_nullable: 1 size: 10
data_type: 'integer' is_nullable: 1
data_type: 'varchar' is_nullable: 1 size: 80
collection code to assign to serial items
data_type: 'text' is_nullable: 1
Template Toolkit syntax to generate the default "Published on (text)" field when receiving an issue this serial
Type: belongs_to
Related object: Koha::Schema::Result::Aqbookseller
Type: has_many
Related object: Koha::Schema::Result::Aqorder
Type: belongs_to
Related object: Koha::Schema::Result::Biblio
Type: belongs_to
Related object: Koha::Schema::Result::SubscriptionNumberpattern
Type: belongs_to
Related object: Koha::Schema::Result::SubscriptionFrequency
Type: has_many
Related object: Koha::Schema::Result::Serial
Type: might_have
Related object: Koha::Schema::Result::Subscriptionhistory
Type: has_many
Related object: Koha::Schema::Result::Subscriptionroutinglist