From a2f438b881db89ee83e8aef9121b47f65ef9c433 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 21 Jan 2021 14:39:51 +0100 Subject: [PATCH] Bug 26947: DBIC schema changes Signed-off-by: Jonathan Druart --- Koha/Schema/Result/AccountCreditType.pm | 6 +- Koha/Schema/Result/AccountDebitType.pm | 10 +- Koha/Schema/Result/AccountOffset.pm | 14 +- Koha/Schema/Result/AccountOffsetType.pm | 6 +- Koha/Schema/Result/Accountline.pm | 8 +- Koha/Schema/Result/ActionLog.pm | 20 ++- Koha/Schema/Result/AdditionalField.pm | 16 +- Koha/Schema/Result/AdditionalFieldValue.pm | 12 +- Koha/Schema/Result/AdvancedEditorMacro.pm | 14 +- Koha/Schema/Result/ApiKey.pm | 14 +- Koha/Schema/Result/Aqbasket.pm | 36 +++- Koha/Schema/Result/Aqbookseller.pm | 46 +++++- Koha/Schema/Result/Aqbudget.pm | 34 +++- Koha/Schema/Result/Aqbudgetperiod.pm | 22 ++- Koha/Schema/Result/Aqcontact.pm | 30 +++- Koha/Schema/Result/Aqinvoice.pm | 22 ++- Koha/Schema/Result/AqinvoiceAdjustment.pm | 20 ++- Koha/Schema/Result/Aqorder.pm | 98 ++++++++++- Koha/Schema/Result/AqorderUser.pm | 8 +- Koha/Schema/Result/AqordersClaim.pm | 10 +- Koha/Schema/Result/AqordersItem.pm | 10 +- Koha/Schema/Result/ArticleRequest.pm | 6 +- Koha/Schema/Result/AuthorisedValue.pm | 16 +- Koha/Schema/Result/Biblio.pm | 34 +++- Koha/Schema/Result/BiblioFramework.pm | 8 +- Koha/Schema/Result/Biblioitem.pm | 36 +++- Koha/Schema/Result/Borrower.pm | 156 +++++++++++++++++- Koha/Schema/Result/BorrowerAttribute.pm | 12 +- Koha/Schema/Result/BorrowerAttributeType.pm | 30 +++- Koha/Schema/Result/BorrowerDebarment.pm | 20 ++- Koha/Schema/Result/BorrowerFile.pm | 18 +- Koha/Schema/Result/BorrowerModification.pm | 6 +- .../Schema/Result/BorrowerPasswordRecovery.pm | 10 +- Koha/Schema/Result/Branch.pm | 50 +++++- Koha/Schema/Result/Branchtransfer.pm | 22 ++- Koha/Schema/Result/CashRegister.pm | 18 +- Koha/Schema/Result/CashRegisterAction.pm | 14 +- Koha/Schema/Result/Category.pm | 46 +++++- Koha/Schema/Result/City.pm | 14 +- Koha/Schema/Result/ClubHold.pm | 12 +- Koha/Schema/Result/Collection.pm | 6 +- Koha/Schema/Result/Course.pm | 24 ++- Koha/Schema/Result/CourseInstructor.pm | 8 +- Koha/Schema/Result/CourseItem.pm | 40 ++++- Koha/Schema/Result/CourseReserve.pm | 12 +- Koha/Schema/Result/CoverImage.pm | 18 +- Koha/Schema/Result/Deletedbiblio.pm | 34 +++- Koha/Schema/Result/Deletedbiblioitem.pm | 36 +++- Koha/Schema/Result/Deletedborrower.pm | 156 +++++++++++++++++- Koha/Schema/Result/Deleteditem.pm | 92 ++++++++++- Koha/Schema/Result/Desk.pm | 10 +- Koha/Schema/Result/HouseboundProfile.pm | 20 ++- Koha/Schema/Result/HouseboundRole.pm | 10 +- Koha/Schema/Result/HouseboundVisit.pm | 16 +- Koha/Schema/Result/Illcomment.pm | 14 +- Koha/Schema/Result/Illrequest.pm | 38 ++++- Koha/Schema/Result/Illrequestattribute.pm | 12 +- Koha/Schema/Result/ImportBatch.pm | 30 +++- Koha/Schema/Result/ImportBatchProfile.pm | 28 +++- Koha/Schema/Result/ImportRecordMatch.pm | 10 +- Koha/Schema/Result/Issue.pm | 40 ++++- Koha/Schema/Result/Item.pm | 92 ++++++++++- Koha/Schema/Result/Itemtype.pm | 40 ++++- Koha/Schema/Result/LanguageScriptBidi.pm | 8 +- Koha/Schema/Result/LanguageSubtagRegistry.pm | 8 +- Koha/Schema/Result/Letter.pm | 24 ++- Koha/Schema/Result/LibraryGroup.pm | 26 ++- Koha/Schema/Result/Linktracker.pm | 16 +- Koha/Schema/Result/Localization.pm | 6 +- Koha/Schema/Result/Message.pm | 18 +- Koha/Schema/Result/MiscFile.pm | 20 ++- Koha/Schema/Result/NeedMergeAuthority.pm | 14 +- Koha/Schema/Result/OauthAccessToken.pm | 10 +- Koha/Schema/Result/OldIssue.pm | 40 ++++- Koha/Schema/Result/OldReserve.pm | 50 +++++- Koha/Schema/Result/OpacNews.pm | 24 ++- Koha/Schema/Result/Overduerule.pm | 28 +++- Koha/Schema/Result/PatronConsent.pm | 6 +- Koha/Schema/Result/PatronList.pm | 10 +- Koha/Schema/Result/PatronListPatron.pm | 10 +- Koha/Schema/Result/Patronimage.pm | 10 +- Koha/Schema/Result/ProblemReport.pm | 24 ++- .../Result/PseudonymizedBorrowerAttribute.pm | 10 +- Koha/Schema/Result/Quote.pm | 12 +- Koha/Schema/Result/Rating.pm | 10 +- Koha/Schema/Result/RepeatableHoliday.pm | 18 +- Koha/Schema/Result/ReportsDictionary.pm | 18 +- Koha/Schema/Result/Reserve.pm | 44 ++++- Koha/Schema/Result/ReturnClaim.pm | 28 +++- Koha/Schema/Result/Review.pm | 16 +- Koha/Schema/Result/SavedSql.pm | 20 ++- Koha/Schema/Result/SearchHistory.pm | 20 ++- Koha/Schema/Result/Serial.pm | 34 +++- Koha/Schema/Result/SpecialHoliday.pm | 20 ++- Koha/Schema/Result/Statistic.pm | 24 ++- Koha/Schema/Result/Stockrotationitem.pm | 12 +- Koha/Schema/Result/Stockrotationrota.pm | 14 +- Koha/Schema/Result/Stockrotationstage.pm | 14 +- Koha/Schema/Result/Subscription.pm | 56 ++++++- Koha/Schema/Result/Subscriptionroutinglist.pm | 12 +- Koha/Schema/Result/Suggestion.pm | 68 +++++++- Koha/Schema/Result/Systempreference.pm | 14 +- Koha/Schema/Result/TagAll.pm | 16 +- Koha/Schema/Result/TagsApproval.pm | 14 +- Koha/Schema/Result/TagsIndex.pm | 10 +- Koha/Schema/Result/Virtualshelfcontent.pm | 12 +- Koha/Schema/Result/Virtualshelfshare.pm | 14 +- Koha/Schema/Result/Virtualshelve.pm | 22 ++- Koha/Schema/Result/Z3950server.pm | 40 ++++- 109 files changed, 2496 insertions(+), 218 deletions(-) diff --git a/Koha/Schema/Result/AccountCreditType.pm b/Koha/Schema/Result/AccountCreditType.pm index 602b1fd7e9..d246ebad99 100644 --- a/Koha/Schema/Result/AccountCreditType.pm +++ b/Koha/Schema/Result/AccountCreditType.pm @@ -61,6 +61,8 @@ Is autogeneration of credit number enabled for this credit type default_value: 0 is_nullable: 0 +boolean flag to denote if this till is archived or not + =cut __PACKAGE__->add_columns( @@ -123,8 +125,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-06-25 09:19:20 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GESL9hjEPlrQBiuHO4haAw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pqgg1XzDq/zm/epjihLT8Q __PACKAGE__->add_columns( '+is_system' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/AccountDebitType.pm b/Koha/Schema/Result/AccountDebitType.pm index 8772813c2e..74c6da8a80 100644 --- a/Koha/Schema/Result/AccountDebitType.pm +++ b/Koha/Schema/Result/AccountDebitType.pm @@ -41,12 +41,16 @@ __PACKAGE__->table("account_debit_types"); default_value: 1 is_nullable: 0 +boolean flag to denote if this debit type is available for manual invoicing + =head2 can_be_sold data_type: 'tinyint' default_value: 0 is_nullable: 0 +boolean flag to denote if this debit type is available at point of sale + =head2 default_amount data_type: 'decimal' @@ -65,6 +69,8 @@ __PACKAGE__->table("account_debit_types"); default_value: 0 is_nullable: 0 +boolean flag to denote if this till is archived or not + =cut __PACKAGE__->add_columns( @@ -129,8 +135,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-17 12:22:04 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8FIMJZ+JAmqa+Dx7oymBjw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ulpJRbi7H40EXr1QG+URKg __PACKAGE__->add_columns( '+is_system' => { is_boolean => 1 } diff --git a/Koha/Schema/Result/AccountOffset.pm b/Koha/Schema/Result/AccountOffset.pm index 02751ae83a..0bde09394c 100644 --- a/Koha/Schema/Result/AccountOffset.pm +++ b/Koha/Schema/Result/AccountOffset.pm @@ -29,18 +29,24 @@ __PACKAGE__->table("account_offsets"); is_auto_increment: 1 is_nullable: 0 +unique identifier for each offset + =head2 credit_id data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +The id of the accountline the increased the patron's balance + =head2 debit_id data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +The id of the accountline that decreased the patron's balance + =head2 type data_type: 'varchar' @@ -48,12 +54,16 @@ __PACKAGE__->table("account_offsets"); is_nullable: 0 size: 16 +The type of offset this is + =head2 amount data_type: 'decimal' is_nullable: 0 size: [26,6] +The amount of the change + =head2 created_on data_type: 'timestamp' @@ -153,8 +163,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-20 16:27:04 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:tPPrIug2c7PbDO7LCxCJAA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:d6cqxL2VddjOmUqe3nLptw sub koha_object_class { 'Koha::Account::Offset'; diff --git a/Koha/Schema/Result/AccountOffsetType.pm b/Koha/Schema/Result/AccountOffsetType.pm index fd62a02969..f046b81197 100644 --- a/Koha/Schema/Result/AccountOffsetType.pm +++ b/Koha/Schema/Result/AccountOffsetType.pm @@ -29,6 +29,8 @@ __PACKAGE__->table("account_offset_types"); is_nullable: 0 size: 16 +The type of offset this is + =cut __PACKAGE__->add_columns( @@ -66,8 +68,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-20 16:27:04 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rPRWMfAfRke3jGG3iISi2A +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HGUopAaOUF8FcmqQjIrRiw # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Accountline.pm b/Koha/Schema/Result/Accountline.pm index 3a5a48cb99..47edfcf4e4 100644 --- a/Koha/Schema/Result/Accountline.pm +++ b/Koha/Schema/Result/Accountline.pm @@ -97,6 +97,8 @@ autogenerated number for credits is_nullable: 1 size: 80 +optional authorised value PAYMENT_TYPE + =head2 amountoutstanding data_type: 'decimal' @@ -140,6 +142,8 @@ autogenerated number for credits is_nullable: 1 size: 10 +the branchcode of the library where a payment was made, a manual invoice created, etc. + =cut __PACKAGE__->add_columns( @@ -377,8 +381,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-06-25 09:19:20 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:I/S3NLbod+8BgBMcwYz+cA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MBdnk+5gD5TMX/ZOqEf3kA =head2 library diff --git a/Koha/Schema/Result/ActionLog.pm b/Koha/Schema/Result/ActionLog.pm index 78236ea9eb..27949e0989 100644 --- a/Koha/Schema/Result/ActionLog.pm +++ b/Koha/Schema/Result/ActionLog.pm @@ -29,6 +29,8 @@ __PACKAGE__->table("action_logs"); is_auto_increment: 1 is_nullable: 0 +unique identifier for each action + =head2 timestamp data_type: 'timestamp' @@ -36,38 +38,52 @@ __PACKAGE__->table("action_logs"); default_value: current_timestamp is_nullable: 0 +the date and time the action took place + =head2 user data_type: 'integer' default_value: 0 is_nullable: 0 +the staff member who performed the action (borrowers.borrowernumber) + =head2 module data_type: 'mediumtext' is_nullable: 1 +the module this action was taken against + =head2 action data_type: 'mediumtext' is_nullable: 1 +the action (includes things like DELETED, ADDED, MODIFY, etc) + =head2 object data_type: 'integer' is_nullable: 1 +the object that the action was taken against (could be a borrowernumber, itemnumber, etc) + =head2 info data_type: 'mediumtext' is_nullable: 1 +information about the action (usually includes SQL statement) + =head2 interface data_type: 'varchar' is_nullable: 1 size: 30 +the context this action was taken in + =cut __PACKAGE__->add_columns( @@ -107,8 +123,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("action_id"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VVXBchLYkj+S+lLhl7bKgw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uwUz/TduCEGKtT1UR2x84A # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/AdditionalField.pm b/Koha/Schema/Result/AdditionalField.pm index 6a9b1e54b2..8bfdfb0f54 100644 --- a/Koha/Schema/Result/AdditionalField.pm +++ b/Koha/Schema/Result/AdditionalField.pm @@ -29,6 +29,8 @@ __PACKAGE__->table("additional_fields"); is_auto_increment: 1 is_nullable: 0 +primary key identifier + =head2 tablename data_type: 'varchar' @@ -36,6 +38,8 @@ __PACKAGE__->table("additional_fields"); is_nullable: 0 size: 255 +tablename of the new field + =head2 name data_type: 'varchar' @@ -43,6 +47,8 @@ __PACKAGE__->table("additional_fields"); is_nullable: 0 size: 255 +name of the field + =head2 authorised_value_category data_type: 'varchar' @@ -50,6 +56,8 @@ __PACKAGE__->table("additional_fields"); is_nullable: 0 size: 16 +is an authorised value category + =head2 marcfield data_type: 'varchar' @@ -57,12 +65,16 @@ __PACKAGE__->table("additional_fields"); is_nullable: 0 size: 16 +contains the marc field to copied into the record + =head2 searchable data_type: 'tinyint' default_value: 0 is_nullable: 0 +is the field searchable? + =cut __PACKAGE__->add_columns( @@ -126,8 +138,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-10-02 15:12:02 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vvz9GJNkU4K7bftDNuRHVA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KwAIcvo1IWRRRb/Mb9LyRA # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/AdditionalFieldValue.pm b/Koha/Schema/Result/AdditionalFieldValue.pm index 9dd368d783..b3f1b7c41e 100644 --- a/Koha/Schema/Result/AdditionalFieldValue.pm +++ b/Koha/Schema/Result/AdditionalFieldValue.pm @@ -29,17 +29,23 @@ __PACKAGE__->table("additional_field_values"); is_auto_increment: 1 is_nullable: 0 +primary key identifier + =head2 field_id data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +foreign key references additional_fields(id) + =head2 record_id data_type: 'integer' is_nullable: 0 +record_id + =head2 value data_type: 'varchar' @@ -47,6 +53,8 @@ __PACKAGE__->table("additional_field_values"); is_nullable: 0 size: 255 +value for this field + =cut __PACKAGE__->add_columns( @@ -106,8 +114,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-10-02 15:12:02 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:a9G6nhDU9dBDcRRN0vzkLA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6Y4sBMbKYSbGN7fAy7OhEQ # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/AdvancedEditorMacro.pm b/Koha/Schema/Result/AdvancedEditorMacro.pm index 7c5448bd94..5cd53cee35 100644 --- a/Koha/Schema/Result/AdvancedEditorMacro.pm +++ b/Koha/Schema/Result/AdvancedEditorMacro.pm @@ -29,29 +29,39 @@ __PACKAGE__->table("advanced_editor_macros"); is_auto_increment: 1 is_nullable: 0 +Unique ID of the macro + =head2 name data_type: 'varchar' is_nullable: 0 size: 80 +Name of the macro + =head2 macro data_type: 'longtext' is_nullable: 1 +The macro code itself + =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +ID of the borrower who created this macro + =head2 shared data_type: 'tinyint' default_value: 0 is_nullable: 1 +Bit to define if shared or private macro + =cut __PACKAGE__->add_columns( @@ -102,8 +112,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-02 15:01:04 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Wx556VlgXYqdP2XyQ87Jzg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:abYuKrQLDx8KB3ZdEGBlqA __PACKAGE__->add_columns( '+shared' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/ApiKey.pm b/Koha/Schema/Result/ApiKey.pm index f8e091fbb7..55946b34b9 100644 --- a/Koha/Schema/Result/ApiKey.pm +++ b/Koha/Schema/Result/ApiKey.pm @@ -29,30 +29,40 @@ __PACKAGE__->table("api_keys"); is_nullable: 0 size: 191 +API client ID + =head2 secret data_type: 'varchar' is_nullable: 0 size: 191 +API client secret used for API authentication + =head2 description data_type: 'varchar' is_nullable: 0 size: 255 +API client description + =head2 patron_id data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +Foreign key to the borrowers table + =head2 active data_type: 'tinyint' default_value: 1 is_nullable: 0 +0 means this API key is revoked + =cut __PACKAGE__->add_columns( @@ -112,8 +122,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-04-14 14:48:10 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qnu4QSACpOSQaZgd52ozmw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2yvvoid4Taq7cjXFDuMoAA __PACKAGE__->add_columns( '+active' => { is_boolean => 1 } diff --git a/Koha/Schema/Result/Aqbasket.pm b/Koha/Schema/Result/Aqbasket.pm index 60d5633a58..eb2ce481b7 100644 --- a/Koha/Schema/Result/Aqbasket.pm +++ b/Koha/Schema/Result/Aqbasket.pm @@ -29,40 +29,54 @@ __PACKAGE__->table("aqbasket"); is_auto_increment: 1 is_nullable: 0 +primary key, Koha defined number + =head2 basketname data_type: 'varchar' is_nullable: 1 size: 50 +name given to the basket at creation + =head2 note data_type: 'longtext' is_nullable: 1 +the internal note added at basket creation + =head2 booksellernote data_type: 'longtext' is_nullable: 1 +the vendor note added at basket creation + =head2 contractnumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +links this basket to the aqcontract table (aqcontract.contractnumber) + =head2 creationdate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +the date the basket was created + =head2 closedate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +the date the basket was closed + =head2 booksellerid data_type: 'integer' @@ -70,35 +84,47 @@ __PACKAGE__->table("aqbasket"); is_foreign_key: 1 is_nullable: 0 +the Koha assigned ID for the vendor (aqbooksellers.id) + =head2 authorisedby data_type: 'varchar' is_nullable: 1 size: 10 +the borrowernumber of the person who created the basket + =head2 booksellerinvoicenumber data_type: 'longtext' is_nullable: 1 +appears to always be NULL + =head2 basketgroupid data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +links this basket to its group (aqbasketgroups.id) + =head2 deliveryplace data_type: 'varchar' is_nullable: 1 size: 10 +basket delivery place + =head2 billingplace data_type: 'varchar' is_nullable: 1 size: 10 +basket billing place + =head2 branch data_type: 'varchar' @@ -106,18 +132,24 @@ __PACKAGE__->table("aqbasket"); is_nullable: 1 size: 10 +basket branch + =head2 is_standing data_type: 'tinyint' default_value: 0 is_nullable: 0 +orders in this basket are standing + =head2 create_items data_type: 'enum' extra: {list => ["ordering","receiving","cataloguing"]} is_nullable: 1 +when items should be created for orders in this basket + =cut __PACKAGE__->add_columns( @@ -309,8 +341,8 @@ Composing rels: L -> borrowernumber __PACKAGE__->many_to_many("borrowernumbers", "aqbasketusers", "borrowernumber"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gSw/f4JmMBzEssEFRg2fAQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6NoSiMu1GqEqT7F5wAVeig __PACKAGE__->has_many( "additional_field_values", diff --git a/Koha/Schema/Result/Aqbookseller.pm b/Koha/Schema/Result/Aqbookseller.pm index a9bf2e51bd..4c5d19a0e2 100644 --- a/Koha/Schema/Result/Aqbookseller.pm +++ b/Koha/Schema/Result/Aqbookseller.pm @@ -29,63 +29,87 @@ __PACKAGE__->table("aqbooksellers"); is_auto_increment: 1 is_nullable: 0 +primary key and unique identifier assigned by Koha + =head2 name data_type: 'longtext' is_nullable: 0 +vendor name + =head2 address1 data_type: 'longtext' is_nullable: 1 +first line of vendor physical address + =head2 address2 data_type: 'longtext' is_nullable: 1 +second line of vendor physical address + =head2 address3 data_type: 'longtext' is_nullable: 1 +third line of vendor physical address + =head2 address4 data_type: 'longtext' is_nullable: 1 +fourth line of vendor physical address + =head2 phone data_type: 'varchar' is_nullable: 1 size: 30 +vendor phone number + =head2 accountnumber data_type: 'longtext' is_nullable: 1 +vendor account number + =head2 notes data_type: 'longtext' is_nullable: 1 +order notes + =head2 postal data_type: 'longtext' is_nullable: 1 +vendor postal address (all lines) + =head2 url data_type: 'varchar' is_nullable: 1 size: 255 +vendor web address + =head2 active data_type: 'tinyint' is_nullable: 1 +is this vendor active (1 for yes, 0 for no) + =head2 listprice data_type: 'varchar' @@ -93,6 +117,8 @@ __PACKAGE__->table("aqbooksellers"); is_nullable: 1 size: 10 +currency code for list prices + =head2 invoiceprice data_type: 'varchar' @@ -100,44 +126,60 @@ __PACKAGE__->table("aqbooksellers"); is_nullable: 1 size: 10 +currency code for invoice prices + =head2 gstreg data_type: 'tinyint' is_nullable: 1 +is your library charged tax (1 for yes, 0 for no) + =head2 listincgst data_type: 'tinyint' is_nullable: 1 +is tax included in list prices (1 for yes, 0 for no) + =head2 invoiceincgst data_type: 'tinyint' is_nullable: 1 +is tax included in invoice prices (1 for yes, 0 for no) + =head2 tax_rate data_type: 'decimal' is_nullable: 1 size: [6,4] +the tax rate the library is charged + =head2 discount data_type: 'float' is_nullable: 1 size: [6,4] +discount offered on all items ordered from this vendor + =head2 fax data_type: 'varchar' is_nullable: 1 size: 50 +vendor fax number + =head2 deliverytime data_type: 'integer' is_nullable: 1 +vendor delivery time + =cut __PACKAGE__->add_columns( @@ -345,8 +387,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-17 08:54:13 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1lSFcy25po9EBzkNkjL5UA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qu4OqSCsEKEeJD9VtOEd4g __PACKAGE__->add_columns( '+active' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Aqbudget.pm b/Koha/Schema/Result/Aqbudget.pm index e645e55432..182a7e39c5 100644 --- a/Koha/Schema/Result/Aqbudget.pm +++ b/Koha/Schema/Result/Aqbudget.pm @@ -29,29 +29,39 @@ __PACKAGE__->table("aqbudgets"); is_auto_increment: 1 is_nullable: 0 +primary key and unique number assigned to each fund by Koha + =head2 budget_parent_id data_type: 'integer' is_nullable: 1 +if this fund is a child of another this will include the parent id (aqbudgets.budget_id) + =head2 budget_code data_type: 'varchar' is_nullable: 1 size: 30 +code assigned to the fund by the user + =head2 budget_name data_type: 'varchar' is_nullable: 1 size: 80 +name assigned to the fund by the user + =head2 budget_branchcode data_type: 'varchar' is_nullable: 1 size: 10 +branch that this fund belongs to (branches.branchcode) + =head2 budget_amount data_type: 'decimal' @@ -59,6 +69,8 @@ __PACKAGE__->table("aqbudgets"); is_nullable: 1 size: [28,6] +total amount for this fund + =head2 budget_encumb data_type: 'decimal' @@ -66,6 +78,8 @@ __PACKAGE__->table("aqbudgets"); is_nullable: 1 size: [28,6] +budget warning at percentage + =head2 budget_expend data_type: 'decimal' @@ -73,11 +87,15 @@ __PACKAGE__->table("aqbudgets"); is_nullable: 1 size: [28,6] +budget warning at amount + =head2 budget_notes data_type: 'longtext' is_nullable: 1 +notes related to this fund + =head2 timestamp data_type: 'timestamp' @@ -85,35 +103,47 @@ __PACKAGE__->table("aqbudgets"); default_value: current_timestamp is_nullable: 0 +date and time this fund was last touched (created or modified) + =head2 budget_period_id data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id) + =head2 sort1_authcat data_type: 'varchar' is_nullable: 1 size: 80 +statistical category for this fund + =head2 sort2_authcat data_type: 'varchar' is_nullable: 1 size: 80 +second statistical category for this fund + =head2 budget_owner_id data_type: 'integer' is_nullable: 1 +borrowernumber of the person who owns this fund (borrowers.borrowernumber) + =head2 budget_permission data_type: 'integer' default_value: 0 is_nullable: 1 +level of permission for this fund (used only by the owner, only by the library, or anyone) + =cut __PACKAGE__->add_columns( @@ -319,8 +349,8 @@ Composing rels: L -> borrowernumber __PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber"); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-13 23:03:50 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kmzXRyD6aNqPr5C6u9GBHA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sl+TGQXY85UWwS+Ld/vvyQ __PACKAGE__->belongs_to( "budget", diff --git a/Koha/Schema/Result/Aqbudgetperiod.pm b/Koha/Schema/Result/Aqbudgetperiod.pm index 5ae2c98e81..211cb9504f 100644 --- a/Koha/Schema/Result/Aqbudgetperiod.pm +++ b/Koha/Schema/Result/Aqbudgetperiod.pm @@ -29,52 +29,70 @@ __PACKAGE__->table("aqbudgetperiods"); is_auto_increment: 1 is_nullable: 0 +primary key and unique number assigned by Koha + =head2 budget_period_startdate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 0 +date when the budget starts + =head2 budget_period_enddate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 0 +date when the budget ends + =head2 budget_period_active data_type: 'tinyint' default_value: 0 is_nullable: 1 +whether this budget is active or not (1 for yes, 0 for no) + =head2 budget_period_description data_type: 'longtext' is_nullable: 1 +description assigned to this budget + =head2 budget_period_total data_type: 'decimal' is_nullable: 1 size: [28,6] +total amount available in this budget + =head2 budget_period_locked data_type: 'tinyint' is_nullable: 1 +whether this budget is locked or not (1 for yes, 0 for no) + =head2 sort1_authcat data_type: 'varchar' is_nullable: 1 size: 10 +statistical category for this budget + =head2 sort2_authcat data_type: 'varchar' is_nullable: 1 size: 10 +second statistical category for this budget + =cut __PACKAGE__->add_columns( @@ -128,8 +146,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-13 23:03:50 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0xS/Pc8hoKlNKfW9zDd4Gg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:F/ipbU/Wrqy3pDInlmLOTw sub koha_object_class { 'Koha::Acquisition::Budget'; diff --git a/Koha/Schema/Result/Aqcontact.pm b/Koha/Schema/Result/Aqcontact.pm index 0de8efc761..295ee9187e 100644 --- a/Koha/Schema/Result/Aqcontact.pm +++ b/Koha/Schema/Result/Aqcontact.pm @@ -29,77 +29,103 @@ __PACKAGE__->table("aqcontacts"); is_auto_increment: 1 is_nullable: 0 +primary key and unique number assigned by Koha + =head2 name data_type: 'varchar' is_nullable: 1 size: 100 +name of contact at vendor + =head2 position data_type: 'varchar' is_nullable: 1 size: 100 +contact person's position + =head2 phone data_type: 'varchar' is_nullable: 1 size: 100 +contact's phone number + =head2 altphone data_type: 'varchar' is_nullable: 1 size: 100 +contact's alternate phone number + =head2 fax data_type: 'varchar' is_nullable: 1 size: 100 +contact's fax number + =head2 email data_type: 'varchar' is_nullable: 1 size: 100 +contact's email address + =head2 notes data_type: 'longtext' is_nullable: 1 +notes related to the contact + =head2 orderacquisition data_type: 'tinyint' default_value: 0 is_nullable: 0 +should this contact receive acquisition orders + =head2 claimacquisition data_type: 'tinyint' default_value: 0 is_nullable: 0 +should this contact receive acquisitions claims + =head2 claimissues data_type: 'tinyint' default_value: 0 is_nullable: 0 +should this contact receive serial claims + =head2 acqprimary data_type: 'tinyint' default_value: 0 is_nullable: 0 +is this the primary contact for acquisitions messages + =head2 serialsprimary data_type: 'tinyint' default_value: 0 is_nullable: 0 +is this the primary contact for serials messages + =head2 booksellerid data_type: 'integer' @@ -169,8 +195,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:R2x8Z9Db2oDULEODgLuw8Q +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IefjqDsoXPLWKSfhYGne1A __PACKAGE__->add_columns( '+orderacquisition' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Aqinvoice.pm b/Koha/Schema/Result/Aqinvoice.pm index fe1f8f265e..e27cbfa20a 100644 --- a/Koha/Schema/Result/Aqinvoice.pm +++ b/Koha/Schema/Result/Aqinvoice.pm @@ -29,53 +29,71 @@ __PACKAGE__->table("aqinvoices"); is_auto_increment: 1 is_nullable: 0 +ID of the invoice, primary key + =head2 invoicenumber data_type: 'longtext' is_nullable: 0 +Name of invoice + =head2 booksellerid data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +foreign key to aqbooksellers + =head2 shipmentdate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +date of shipment + =head2 billingdate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +date of billing + =head2 closedate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +invoice close date, NULL means the invoice is open + =head2 shipmentcost data_type: 'decimal' is_nullable: 1 size: [28,6] +shipment cost + =head2 shipmentcost_budgetid data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +foreign key to aqbudgets, link the shipment cost to a budget + =head2 message_id data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +foreign key to edifact invoice message + =cut __PACKAGE__->add_columns( @@ -199,8 +217,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-16 13:50:45 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mpdxTbkz/8WInG5Wp4q7Ug +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LkekSbup37Z2WVnU/c9K+g sub koha_object_class { 'Koha::Acquisition::Invoice'; diff --git a/Koha/Schema/Result/AqinvoiceAdjustment.pm b/Koha/Schema/Result/AqinvoiceAdjustment.pm index 16bc45acb2..2977f2a4ce 100644 --- a/Koha/Schema/Result/AqinvoiceAdjustment.pm +++ b/Koha/Schema/Result/AqinvoiceAdjustment.pm @@ -29,41 +29,55 @@ __PACKAGE__->table("aqinvoice_adjustments"); is_auto_increment: 1 is_nullable: 0 +primary key for adjustments + =head2 invoiceid data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +foreign key to link an adjustment to an invoice + =head2 adjustment data_type: 'decimal' is_nullable: 1 size: [28,6] +amount of adjustment + =head2 reason data_type: 'varchar' is_nullable: 1 size: 80 +reason for adjustment defined by authorised values in ADJ_REASON category + =head2 note data_type: 'mediumtext' is_nullable: 1 +text to explain adjustment + =head2 budget_id data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +optional link to budget to apply adjustment to + =head2 encumber_open data_type: 'smallint' default_value: 1 is_nullable: 0 +whether or not to encumber the funds when invoice is still open, 1 = yes, 0 = no + =head2 timestamp data_type: 'timestamp' @@ -71,6 +85,8 @@ __PACKAGE__->table("aqinvoice_adjustments"); default_value: current_timestamp is_nullable: 0 +timestamp of last adjustment to adjustment + =cut __PACKAGE__->add_columns( @@ -147,8 +163,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-19 17:32:57 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jl0qxkZWVs2D1pi3kaRjpg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gy1vtvgPtZgUtWhwPWqlWA sub koha_object_class { 'Koha::Acquisition::Invoice::Adjustment'; diff --git a/Koha/Schema/Result/Aqorder.pm b/Koha/Schema/Result/Aqorder.pm index f873aa6da3..58cbdd1897 100644 --- a/Koha/Schema/Result/Aqorder.pm +++ b/Koha/Schema/Result/Aqorder.pm @@ -29,23 +29,31 @@ __PACKAGE__->table("aqorders"); is_auto_increment: 1 is_nullable: 0 +primary key and unique identifier assigned by Koha to each line + =head2 biblionumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +links the order to the biblio being ordered (biblio.biblionumber) + =head2 entrydate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +the date the bib was added to the basket + =head2 quantity data_type: 'smallint' is_nullable: 1 +the quantity ordered + =head2 currency data_type: 'varchar' @@ -53,92 +61,124 @@ __PACKAGE__->table("aqorders"); is_nullable: 1 size: 10 +the currency used for the purchase + =head2 listprice data_type: 'decimal' is_nullable: 1 size: [28,6] +the vendor price for this line item + =head2 datereceived data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +the date this order was received + =head2 invoiceid data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +id of invoice + =head2 freight data_type: 'decimal' is_nullable: 1 size: [28,6] +shipping costs (not used) + =head2 unitprice data_type: 'decimal' is_nullable: 1 size: [28,6] +the actual cost entered when receiving this line item + =head2 unitprice_tax_excluded data_type: 'decimal' is_nullable: 1 size: [28,6] +the unit price excluding tax (on receiving) + =head2 unitprice_tax_included data_type: 'decimal' is_nullable: 1 size: [28,6] +the unit price including tax (on receiving) + =head2 quantityreceived data_type: 'smallint' default_value: 0 is_nullable: 0 +the quantity that have been received so far + =head2 created_by data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +the borrowernumber of order line's creator + =head2 datecancellationprinted data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +the date the line item was deleted + =head2 cancellationreason data_type: 'mediumtext' is_nullable: 1 +reason of cancellation + =head2 order_internalnote data_type: 'longtext' is_nullable: 1 +notes related to this order line, made for staff + =head2 order_vendornote data_type: 'longtext' is_nullable: 1 +notes related to this order line, made for vendor + =head2 purchaseordernumber data_type: 'longtext' is_nullable: 1 +not used? always NULL + =head2 basketno data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +links this order line to a specific basket (aqbasket.basketno) + =head2 timestamp data_type: 'timestamp' @@ -146,114 +186,152 @@ __PACKAGE__->table("aqorders"); default_value: current_timestamp is_nullable: 0 +the date and time this order line was last modified + =head2 rrp data_type: 'decimal' is_nullable: 1 size: [13,2] +the retail cost for this line item + =head2 replacementprice data_type: 'decimal' is_nullable: 1 size: [28,6] +the replacement cost for this line item + =head2 rrp_tax_excluded data_type: 'decimal' is_nullable: 1 size: [28,6] +the replacement cost excluding tax + =head2 rrp_tax_included data_type: 'decimal' is_nullable: 1 size: [28,6] +the replacement cost including tax + =head2 ecost data_type: 'decimal' is_nullable: 1 size: [13,2] +the replacement cost for this line item + =head2 ecost_tax_excluded data_type: 'decimal' is_nullable: 1 size: [28,6] +the estimated cost excluding tax + =head2 ecost_tax_included data_type: 'decimal' is_nullable: 1 size: [28,6] +the estimated cost including tax + =head2 tax_rate_bak data_type: 'decimal' is_nullable: 1 size: [6,4] +the tax rate for this line item (%) + =head2 tax_rate_on_ordering data_type: 'decimal' is_nullable: 1 size: [6,4] +the tax rate on ordering for this line item (%) + =head2 tax_rate_on_receiving data_type: 'decimal' is_nullable: 1 size: [6,4] +the tax rate on receiving for this line item (%) + =head2 tax_value_bak data_type: 'decimal' is_nullable: 1 size: [28,6] +the tax value for this line item + =head2 tax_value_on_ordering data_type: 'decimal' is_nullable: 1 size: [28,6] +the tax value on ordering for this line item + =head2 tax_value_on_receiving data_type: 'decimal' is_nullable: 1 size: [28,6] +the tax value on receiving for this line item + =head2 discount data_type: 'float' is_nullable: 1 size: [6,4] +the discount for this line item (%) + =head2 budget_id data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +the fund this order goes against (aqbudgets.budget_id) + =head2 budgetdate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +not used? always NULL + =head2 sort1 data_type: 'varchar' is_nullable: 1 size: 80 +statistical field + =head2 sort2 data_type: 'varchar' is_nullable: 1 size: 80 +second statistical field + =head2 sort1_authcat data_type: 'varchar' @@ -271,17 +349,23 @@ __PACKAGE__->table("aqorders"); data_type: 'tinyint' is_nullable: 1 +was this price uncertain (1 for yes, 0 for no) + =head2 subscriptionid data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +links this order line to a subscription (subscription.subscriptionid) + =head2 parent_ordernumber data_type: 'integer' is_nullable: 1 +ordernumber of parent order line, or same as ordernumber if no parent + =head2 orderstatus data_type: 'varchar' @@ -289,29 +373,39 @@ __PACKAGE__->table("aqorders"); is_nullable: 1 size: 16 +the current status for this line item. Can be 'new', 'ordered', 'partial', 'complete' or 'cancelled' + =head2 line_item_id data_type: 'varchar' is_nullable: 1 size: 35 +Supplier's article id for Edifact orderline + =head2 suppliers_reference_number data_type: 'varchar' is_nullable: 1 size: 35 +Suppliers unique edifact quote ref + =head2 suppliers_reference_qualifier data_type: 'varchar' is_nullable: 1 size: 3 +Type of number above usually 'QLI' + =head2 suppliers_report data_type: 'mediumtext' is_nullable: 1 +reports received from suppliers + =cut __PACKAGE__->add_columns( @@ -660,8 +754,8 @@ Composing rels: L -> borrowernumber __PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber"); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-05-04 08:25:41 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Pf6reFaSldsjIA6XThbDFA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:c1YBLkG64bdFakf4/cGjXA __PACKAGE__->belongs_to( "basket", diff --git a/Koha/Schema/Result/AqorderUser.pm b/Koha/Schema/Result/AqorderUser.pm index 54750d4ce5..4f6df2f0cd 100644 --- a/Koha/Schema/Result/AqorderUser.pm +++ b/Koha/Schema/Result/AqorderUser.pm @@ -29,12 +29,16 @@ __PACKAGE__->table("aqorder_users"); is_foreign_key: 1 is_nullable: 0 +the order this patrons receive notifications from (aqorders.ordernumber) + =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +the borrowernumber for the patron receiving notifications for this order (borrowers.borrowernumber) + =cut __PACKAGE__->add_columns( @@ -91,8 +95,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-03-11 11:50:38 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6mhRlYUeJnpQIJ2P9WTbHQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:G5LCF3HRXk7YKl8/t7HIyg # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/AqordersClaim.pm b/Koha/Schema/Result/AqordersClaim.pm index 3b86f6747c..10ca443eab 100644 --- a/Koha/Schema/Result/AqordersClaim.pm +++ b/Koha/Schema/Result/AqordersClaim.pm @@ -29,12 +29,16 @@ __PACKAGE__->table("aqorders_claims"); is_auto_increment: 1 is_nullable: 0 +ID of the claims + =head2 ordernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +order linked to this claim + =head2 claimed_on data_type: 'timestamp' @@ -42,6 +46,8 @@ __PACKAGE__->table("aqorders_claims"); default_value: current_timestamp is_nullable: 0 +Date of the claims + =cut __PACKAGE__->add_columns( @@ -88,8 +94,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-05-04 08:25:41 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YHD9b6rUAPUM5HzFg4k9Wg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4/GYhhysSbrh67vIq67xZw sub koha_object_class { 'Koha::Acquisition::Order::Claim'; diff --git a/Koha/Schema/Result/AqordersItem.pm b/Koha/Schema/Result/AqordersItem.pm index ac99f2e10c..147d8e8f33 100644 --- a/Koha/Schema/Result/AqordersItem.pm +++ b/Koha/Schema/Result/AqordersItem.pm @@ -29,11 +29,15 @@ __PACKAGE__->table("aqorders_items"); is_foreign_key: 1 is_nullable: 0 +the order this item is attached to (aqorders.ordernumber) + =head2 itemnumber data_type: 'integer' is_nullable: 0 +the item number for this item (items.itemnumber) + =head2 timestamp data_type: 'timestamp' @@ -41,6 +45,8 @@ __PACKAGE__->table("aqorders_items"); default_value: current_timestamp is_nullable: 0 +the date and time this order item was last touched + =cut __PACKAGE__->add_columns( @@ -87,8 +93,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hvDuLTY3idYc1ujykNDrPQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0qoEUMlkDZDBMxvaNwYtrA # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/ArticleRequest.pm b/Koha/Schema/Result/ArticleRequest.pm index b787c91eca..b1bf431329 100644 --- a/Koha/Schema/Result/ArticleRequest.pm +++ b/Koha/Schema/Result/ArticleRequest.pm @@ -112,6 +112,8 @@ __PACKAGE__->table("article_requests"); datetime_undef_if_invalid: 1 is_nullable: 1 +Be careful with two timestamps in one table not allowing NULL + =head2 updated_on data_type: 'timestamp' @@ -257,8 +259,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-02 09:44:27 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Dhz1mVI7Z/6ibqaBZkPvUA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5V0gW/nMkgDImbKMlIa2BA # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/AuthorisedValue.pm b/Koha/Schema/Result/AuthorisedValue.pm index 90d754e595..874c166b02 100644 --- a/Koha/Schema/Result/AuthorisedValue.pm +++ b/Koha/Schema/Result/AuthorisedValue.pm @@ -29,6 +29,8 @@ __PACKAGE__->table("authorised_values"); is_auto_increment: 1 is_nullable: 0 +unique key, used to identify the authorized value + =head2 category data_type: 'varchar' @@ -37,6 +39,8 @@ __PACKAGE__->table("authorised_values"); is_nullable: 0 size: 32 +key used to identify the authorized value category + =head2 authorised_value data_type: 'varchar' @@ -44,24 +48,32 @@ __PACKAGE__->table("authorised_values"); is_nullable: 0 size: 80 +code use to identify the authorized value + =head2 lib data_type: 'varchar' is_nullable: 1 size: 200 +authorized value description as printed in the staff interface + =head2 lib_opac data_type: 'varchar' is_nullable: 1 size: 200 +authorized value description as printed in the OPAC + =head2 imageurl data_type: 'varchar' is_nullable: 1 size: 200 +authorized value URL + =cut __PACKAGE__->add_columns( @@ -161,8 +173,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07048 @ 2020-04-07 11:23:19 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6MjWlDqdpIOwsJlyjQawAg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LH9dpEEzlVVsjNVv/jnONg # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Biblio.pm b/Koha/Schema/Result/Biblio.pm index fa3979886f..32ddcf2c15 100644 --- a/Koha/Schema/Result/Biblio.pm +++ b/Koha/Schema/Result/Biblio.pm @@ -29,6 +29,8 @@ __PACKAGE__->table("biblio"); is_auto_increment: 1 is_nullable: 0 +unique identifier assigned to each bibliographic record + =head2 frameworkcode data_type: 'varchar' @@ -36,51 +38,71 @@ __PACKAGE__->table("biblio"); is_nullable: 0 size: 4 +foreign key from the biblio_framework table to identify which framework was used in cataloging this record + =head2 author data_type: 'longtext' is_nullable: 1 +statement of responsibility from MARC record (100$a in MARC21) + =head2 title data_type: 'longtext' is_nullable: 1 +title (without the subtitle) from the MARC record (245$a in MARC21) + =head2 medium data_type: 'longtext' is_nullable: 1 +medium from the MARC record (245$h in MARC21) + =head2 subtitle data_type: 'longtext' is_nullable: 1 +remainder of the title from the MARC record (245$b in MARC21) + =head2 part_number data_type: 'longtext' is_nullable: 1 +part number from the MARC record (245$n in MARC21) + =head2 part_name data_type: 'longtext' is_nullable: 1 +part name from the MARC record (245$p in MARC21) + =head2 unititle data_type: 'longtext' is_nullable: 1 +uniform title (without the subtitle) from the MARC record (240$a in MARC21) + =head2 notes data_type: 'longtext' is_nullable: 1 +values from the general notes field in the MARC record (500$a in MARC21) split by bar (|) + =head2 serial data_type: 'tinyint' is_nullable: 1 +Boolean indicating whether biblio is for a serial + =head2 seriestitle data_type: 'longtext' @@ -91,6 +113,8 @@ __PACKAGE__->table("biblio"); data_type: 'smallint' is_nullable: 1 +publication or copyright date from the MARC record + =head2 timestamp data_type: 'timestamp' @@ -98,17 +122,23 @@ __PACKAGE__->table("biblio"); default_value: current_timestamp is_nullable: 0 +date and time this record was last touched + =head2 datecreated data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 0 +the date this record was added to Koha + =head2 abstract data_type: 'longtext' is_nullable: 1 +summary from the MARC record (520$a in MARC21) + =cut __PACKAGE__->add_columns( @@ -451,8 +481,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-10-12 09:13:32 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:R4PNOXHa9cRIx/up7HWz4Q +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nmmsZusHYNAMimE9sImSNg __PACKAGE__->has_one( diff --git a/Koha/Schema/Result/BiblioFramework.pm b/Koha/Schema/Result/BiblioFramework.pm index 93ed47386b..15755315d2 100644 --- a/Koha/Schema/Result/BiblioFramework.pm +++ b/Koha/Schema/Result/BiblioFramework.pm @@ -30,6 +30,8 @@ __PACKAGE__->table("biblio_framework"); is_nullable: 0 size: 4 +the unique code assigned to the framework + =head2 frameworktext data_type: 'varchar' @@ -37,6 +39,8 @@ __PACKAGE__->table("biblio_framework"); is_nullable: 0 size: 255 +the description/name given to the framework + =cut __PACKAGE__->add_columns( @@ -59,8 +63,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("frameworkcode"); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KY1w7J/5cBsz9VV7QEBKPw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YdCNaeY5v1WcfcDuA6xE0w # FIXME This should not be needed, we need to add the FK at DB level # It cannot be done now because the default framework (frameworkcode=='') diff --git a/Koha/Schema/Result/Biblioitem.pm b/Koha/Schema/Result/Biblioitem.pm index 49e52e7678..94d62f451a 100644 --- a/Koha/Schema/Result/Biblioitem.pm +++ b/Koha/Schema/Result/Biblioitem.pm @@ -29,6 +29,8 @@ __PACKAGE__->table("biblioitems"); is_auto_increment: 1 is_nullable: 0 +primary key, unique identifier assigned by Koha + =head2 biblionumber data_type: 'integer' @@ -36,6 +38,8 @@ __PACKAGE__->table("biblioitems"); is_foreign_key: 1 is_nullable: 0 +foreign key linking this table to the biblio table + =head2 volume data_type: 'longtext' @@ -52,16 +56,22 @@ __PACKAGE__->table("biblioitems"); is_nullable: 1 size: 10 +biblio level item type (MARC21 942$c) + =head2 isbn data_type: 'longtext' is_nullable: 1 +ISBN (MARC21 020$a) + =head2 issn data_type: 'longtext' is_nullable: 1 +ISSN (MARC21 022$a) + =head2 ean data_type: 'longtext' @@ -78,6 +88,8 @@ __PACKAGE__->table("biblioitems"); is_nullable: 1 size: 255 +publisher (MARC21 260$b) + =head2 volumedate data_type: 'date' @@ -89,6 +101,8 @@ __PACKAGE__->table("biblioitems"); data_type: 'mediumtext' is_nullable: 1 +volume information (MARC21 362$a) + =head2 collectiontitle data_type: 'longtext' @@ -127,12 +141,16 @@ __PACKAGE__->table("biblioitems"); is_nullable: 1 size: 255 +illustrations (MARC21 300$b) + =head2 pages data_type: 'varchar' is_nullable: 1 size: 255 +number of pages (MARC21 300$c) + =head2 notes data_type: 'longtext' @@ -144,29 +162,39 @@ __PACKAGE__->table("biblioitems"); is_nullable: 1 size: 255 +material size (MARC21 300$c) + =head2 place data_type: 'varchar' is_nullable: 1 size: 255 +publication place (MARC21 260$a) + =head2 lccn data_type: 'varchar' is_nullable: 1 size: 25 +library of congress control number (MARC21 010$a) + =head2 url data_type: 'mediumtext' is_nullable: 1 +url (MARC21 856$u) + =head2 cn_source data_type: 'varchar' is_nullable: 1 size: 10 +classification source (MARC21 942$2) + =head2 cn_class data_type: 'varchar' @@ -191,12 +219,16 @@ __PACKAGE__->table("biblioitems"); is_nullable: 1 size: 255 +normalized version of the call number used for sorting + =head2 agerestriction data_type: 'varchar' is_nullable: 1 size: 255 +target audience/age restriction from the bib record (MARC21 521$a) + =head2 totalissues data_type: 'integer' @@ -326,8 +358,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ogVRTKNaUQSI3BE2xC2lww +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Q5VdRYkLa95Kc96wiwLh/g __PACKAGE__->belongs_to( biblio => "Koha::Schema::Result::Biblio", "biblionumber" ); diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm index 08f974d0ff..a9ff404569 100644 --- a/Koha/Schema/Result/Borrower.pm +++ b/Koha/Schema/Result/Borrower.pm @@ -29,173 +29,237 @@ __PACKAGE__->table("borrowers"); is_auto_increment: 1 is_nullable: 0 +primary key, Koha assigned ID number for patrons/borrowers + =head2 cardnumber data_type: 'varchar' is_nullable: 1 size: 32 +unique key, library assigned ID number for patrons/borrowers + =head2 surname data_type: 'longtext' is_nullable: 1 +patron/borrower's last name (surname) + =head2 firstname data_type: 'mediumtext' is_nullable: 1 +patron/borrower's first name + =head2 title data_type: 'longtext' is_nullable: 1 +patron/borrower's title, for example: Mr. or Mrs. + =head2 othernames data_type: 'longtext' is_nullable: 1 +any other names associated with the patron/borrower + =head2 initials data_type: 'mediumtext' is_nullable: 1 +initials for your patron/borrower + =head2 streetnumber data_type: 'tinytext' is_nullable: 1 +the house number for your patron/borrower's primary address + =head2 streettype data_type: 'tinytext' is_nullable: 1 +the street type (Rd., Blvd, etc) for your patron/borrower's primary address + =head2 address data_type: 'longtext' is_nullable: 1 +the first address line for your patron/borrower's primary address + =head2 address2 data_type: 'mediumtext' is_nullable: 1 +the second address line for your patron/borrower's primary address + =head2 city data_type: 'longtext' is_nullable: 1 +the city or town for your patron/borrower's primary address + =head2 state data_type: 'mediumtext' is_nullable: 1 +the state or province for your patron/borrower's primary address + =head2 zipcode data_type: 'tinytext' is_nullable: 1 +the zip or postal code for your patron/borrower's primary address + =head2 country data_type: 'mediumtext' is_nullable: 1 +the country for your patron/borrower's primary address + =head2 email data_type: 'longtext' is_nullable: 1 +the primary email address for your patron/borrower's primary address + =head2 phone data_type: 'mediumtext' is_nullable: 1 +the primary phone number for your patron/borrower's primary address + =head2 mobile data_type: 'tinytext' is_nullable: 1 +the other phone number for your patron/borrower's primary address + =head2 fax data_type: 'longtext' is_nullable: 1 +the fax number for your patron/borrower's primary address + =head2 emailpro data_type: 'mediumtext' is_nullable: 1 +the secondary email addres for your patron/borrower's primary address + =head2 phonepro data_type: 'mediumtext' is_nullable: 1 +the secondary phone number for your patron/borrower's primary address + =head2 B_streetnumber accessor: 'b_streetnumber' data_type: 'tinytext' is_nullable: 1 +the house number for your patron/borrower's alternate address + =head2 B_streettype accessor: 'b_streettype' data_type: 'tinytext' is_nullable: 1 +the street type (Rd., Blvd, etc) for your patron/borrower's alternate address + =head2 B_address accessor: 'b_address' data_type: 'mediumtext' is_nullable: 1 +the first address line for your patron/borrower's alternate address + =head2 B_address2 accessor: 'b_address2' data_type: 'mediumtext' is_nullable: 1 +the second address line for your patron/borrower's alternate address + =head2 B_city accessor: 'b_city' data_type: 'longtext' is_nullable: 1 +the city or town for your patron/borrower's alternate address + =head2 B_state accessor: 'b_state' data_type: 'mediumtext' is_nullable: 1 +the state for your patron/borrower's alternate address + =head2 B_zipcode accessor: 'b_zipcode' data_type: 'tinytext' is_nullable: 1 +the zip or postal code for your patron/borrower's alternate address + =head2 B_country accessor: 'b_country' data_type: 'mediumtext' is_nullable: 1 +the country for your patron/borrower's alternate address + =head2 B_email accessor: 'b_email' data_type: 'mediumtext' is_nullable: 1 +the patron/borrower's alternate email address + =head2 B_phone accessor: 'b_phone' data_type: 'longtext' is_nullable: 1 +the patron/borrower's alternate phone number + =head2 dateofbirth data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +the patron/borrower's date of birth (YYYY-MM-DD) + =head2 branchcode data_type: 'varchar' @@ -204,6 +268,8 @@ __PACKAGE__->table("borrowers"); is_nullable: 0 size: 10 +foreign key from the branches table, includes the code of the patron/borrower's home branch + =head2 categorycode data_type: 'varchar' @@ -212,193 +278,263 @@ __PACKAGE__->table("borrowers"); is_nullable: 0 size: 10 +foreign key from the categories table, includes the code of the patron category + =head2 dateenrolled data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +date the patron was added to Koha (YYYY-MM-DD) + =head2 dateexpiry data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +date the patron/borrower's card is set to expire (YYYY-MM-DD) + =head2 date_renewed data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +date the patron/borrower's card was last renewed + =head2 gonenoaddress data_type: 'tinyint' is_nullable: 1 +set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address + =head2 lost data_type: 'tinyint' is_nullable: 1 +set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card + =head2 debarred data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +until this date the patron can only check-in (no loans, no holds, etc.), is a fine based on days instead of money (YYYY-MM-DD) + =head2 debarredcomment data_type: 'varchar' is_nullable: 1 size: 255 +comment on the stop of the patron + =head2 contactname data_type: 'longtext' is_nullable: 1 +used for children and profesionals to include surname or last name of guarantor or organization name + =head2 contactfirstname data_type: 'mediumtext' is_nullable: 1 +used for children to include first name of guarantor + =head2 contacttitle data_type: 'mediumtext' is_nullable: 1 +used for children to include title (Mr., Mrs., etc) of guarantor + =head2 borrowernotes data_type: 'longtext' is_nullable: 1 +a note on the patron/borrower's account that is only visible in the staff interface + =head2 relationship data_type: 'varchar' is_nullable: 1 size: 100 +used for children to include the relationship to their guarantor + =head2 sex data_type: 'varchar' is_nullable: 1 size: 1 +patron/borrower's gender + =head2 password data_type: 'varchar' is_nullable: 1 size: 60 +patron/borrower's Bcrypt encrypted password + =head2 flags data_type: 'integer' is_nullable: 1 +will include a number associated with the staff member's permissions + =head2 userid data_type: 'varchar' is_nullable: 1 size: 75 +patron/borrower's opac and/or staff interface log in + =head2 opacnote data_type: 'longtext' is_nullable: 1 +a note on the patron/borrower's account that is visible in the OPAC and staff interface + =head2 contactnote data_type: 'varchar' is_nullable: 1 size: 255 +a note related to the patron/borrower's alternate address + =head2 sort1 data_type: 'varchar' is_nullable: 1 size: 80 +a field that can be used for any information unique to the library + =head2 sort2 data_type: 'varchar' is_nullable: 1 size: 80 +a field that can be used for any information unique to the library + =head2 altcontactfirstname data_type: 'mediumtext' is_nullable: 1 +first name of alternate contact for the patron/borrower + =head2 altcontactsurname data_type: 'mediumtext' is_nullable: 1 +surname or last name of the alternate contact for the patron/borrower + =head2 altcontactaddress1 data_type: 'mediumtext' is_nullable: 1 +the first address line for the alternate contact for the patron/borrower + =head2 altcontactaddress2 data_type: 'mediumtext' is_nullable: 1 +the second address line for the alternate contact for the patron/borrower + =head2 altcontactaddress3 data_type: 'mediumtext' is_nullable: 1 +the city for the alternate contact for the patron/borrower + =head2 altcontactstate data_type: 'mediumtext' is_nullable: 1 +the state for the alternate contact for the patron/borrower + =head2 altcontactzipcode data_type: 'mediumtext' is_nullable: 1 +the zipcode for the alternate contact for the patron/borrower + =head2 altcontactcountry data_type: 'mediumtext' is_nullable: 1 +the country for the alternate contact for the patron/borrower + =head2 altcontactphone data_type: 'mediumtext' is_nullable: 1 +the phone number for the alternate contact for the patron/borrower + =head2 smsalertnumber data_type: 'varchar' is_nullable: 1 size: 50 +the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on) + =head2 sms_provider_id data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +the provider of the mobile phone number defined in smsalertnumber + =head2 privacy data_type: 'integer' default_value: 1 is_nullable: 0 +patron/borrower's privacy settings related to their checkout history + =head2 privacy_guarantor_fines data_type: 'tinyint' default_value: 0 is_nullable: 0 +controls if relatives can see this patron's fines + =head2 privacy_guarantor_checkouts data_type: 'tinyint' default_value: 0 is_nullable: 0 +controls if relatives can see this patron's checkouts + =head2 checkprevcheckout data_type: 'varchar' @@ -406,6 +542,8 @@ __PACKAGE__->table("borrowers"); is_nullable: 0 size: 7 +produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'. + =head2 updated_on data_type: 'timestamp' @@ -413,12 +551,16 @@ __PACKAGE__->table("borrowers"); default_value: current_timestamp is_nullable: 0 +time of last change could be useful for synchronization with external systems (among others) + =head2 lastseen data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +last time a patron has been seen (connected at the OPAC or staff interface) + =head2 lang data_type: 'varchar' @@ -426,29 +568,39 @@ __PACKAGE__->table("borrowers"); is_nullable: 0 size: 25 +lang to use to send notices to this patron + =head2 login_attempts data_type: 'integer' default_value: 0 is_nullable: 0 +number of failed login attemps + =head2 overdrive_auth_token data_type: 'mediumtext' is_nullable: 1 +persist OverDrive auth token + =head2 anonymized data_type: 'tinyint' default_value: 0 is_nullable: 0 +flag for data anonymization + =head2 autorenew_checkouts data_type: 'tinyint' default_value: 1 is_nullable: 0 +flag for allowing auto-renewal + =cut __PACKAGE__->add_columns( @@ -1713,8 +1865,8 @@ Composing rels: L -> ordernumber __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber"); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-11-09 19:12:25 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Kp53XFs7tFIpzNSqm/WY8w +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Q9AXeEJckLl7CX6E40DUBw __PACKAGE__->add_columns( '+anonymized' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/BorrowerAttribute.pm b/Koha/Schema/Result/BorrowerAttribute.pm index 2a8398ad68..2dfa6907e8 100644 --- a/Koha/Schema/Result/BorrowerAttribute.pm +++ b/Koha/Schema/Result/BorrowerAttribute.pm @@ -29,12 +29,16 @@ __PACKAGE__->table("borrower_attributes"); is_auto_increment: 1 is_nullable: 0 +Row id field + =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +foreign key from the borrowers table, defines which patron/borrower has this attribute + =head2 code data_type: 'varchar' @@ -42,12 +46,16 @@ __PACKAGE__->table("borrower_attributes"); is_nullable: 0 size: 10 +foreign key from the borrower_attribute_types table, defines which custom field this value was entered for + =head2 attribute data_type: 'varchar' is_nullable: 1 size: 255 +custom patron field value + =cut __PACKAGE__->add_columns( @@ -106,8 +114,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-12-08 04:41:27 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:EarETnedFsmRmAAJAUrKGg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:P6K6sqVzIiwOgAAkAjQyiA =head2 borrower_attribute_types diff --git a/Koha/Schema/Result/BorrowerAttributeType.pm b/Koha/Schema/Result/BorrowerAttributeType.pm index 1d807f5081..ce969376ba 100644 --- a/Koha/Schema/Result/BorrowerAttributeType.pm +++ b/Koha/Schema/Result/BorrowerAttributeType.pm @@ -29,60 +29,80 @@ __PACKAGE__->table("borrower_attribute_types"); is_nullable: 0 size: 10 +unique key used to identify each custom field + =head2 description data_type: 'varchar' is_nullable: 0 size: 255 +description for each custom field + =head2 repeatable data_type: 'tinyint' default_value: 0 is_nullable: 0 +defines whether one patron/borrower can have multiple values for this custom field (1 for yes, 0 for no) + =head2 unique_id data_type: 'tinyint' default_value: 0 is_nullable: 0 +defines if this value needs to be unique (1 for yes, 0 for no) + =head2 opac_display data_type: 'tinyint' default_value: 0 is_nullable: 0 +defines if this field is visible to patrons on their account in the OPAC (1 for yes, 0 for no) + =head2 opac_editable data_type: 'tinyint' default_value: 0 is_nullable: 0 +defines if this field is editable by patrons on their account in the OPAC (1 for yes, 0 for no) + =head2 staff_searchable data_type: 'tinyint' default_value: 0 is_nullable: 0 +defines if this field is searchable via the patron search in the staff interface (1 for yes, 0 for no) + =head2 authorised_value_category data_type: 'varchar' is_nullable: 1 size: 32 +foreign key from authorised_values that links this custom field to an authorized value category + =head2 display_checkout data_type: 'tinyint' default_value: 0 is_nullable: 0 +defines if this field displays in checkout screens + =head2 category_code data_type: 'varchar' is_nullable: 1 size: 10 +defines a category for an attribute_type + =head2 class data_type: 'varchar' @@ -90,18 +110,24 @@ __PACKAGE__->table("borrower_attribute_types"); is_nullable: 0 size: 255 +defines a class for an attribute_type + =head2 keep_for_pseudonymization data_type: 'tinyint' default_value: 0 is_nullable: 0 +defines if this field is copied to anonymized_borrower_attributes (1 for yes, 0 for no) + =head2 mandatory data_type: 'tinyint' default_value: 0 is_nullable: 0 +defines if the attribute is mandatory or not + =cut __PACKAGE__->add_columns( @@ -193,8 +219,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-07-20 12:40:43 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+5TTNyiyjJkADhbkSLvGLw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:a/IA2iqSJqg3oOS+o1nXFg __PACKAGE__->add_columns( '+keep_for_pseudonymization' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/BorrowerDebarment.pm b/Koha/Schema/Result/BorrowerDebarment.pm index 0a603de58a..4f1921b5dd 100644 --- a/Koha/Schema/Result/BorrowerDebarment.pm +++ b/Koha/Schema/Result/BorrowerDebarment.pm @@ -29,18 +29,24 @@ __PACKAGE__->table("borrower_debarments"); is_auto_increment: 1 is_nullable: 0 +unique key for the restriction + =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +foreign key for borrowers.borrowernumber for patron who is restricted + =head2 expiration data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +expiration date of the restriction + =head2 type data_type: 'enum' @@ -48,16 +54,22 @@ __PACKAGE__->table("borrower_debarments"); extra: {list => ["SUSPENSION","OVERDUES","MANUAL","DISCHARGE"]} is_nullable: 0 +type of restriction + =head2 comment data_type: 'mediumtext' is_nullable: 1 +comments about the restriction + =head2 manager_id data_type: 'integer' is_nullable: 1 +foreign key for borrowers.borrowernumber for the librarian managing the restriction + =head2 created data_type: 'timestamp' @@ -65,12 +77,16 @@ __PACKAGE__->table("borrower_debarments"); default_value: current_timestamp is_nullable: 0 +date the restriction was added + =head2 updated data_type: 'timestamp' datetime_undef_if_invalid: 1 is_nullable: 1 +date the restriction was updated + =cut __PACKAGE__->add_columns( @@ -136,8 +152,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:J9J1ReRLqhVasOQXvde2Uw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vQL2xYGB5GI//2l4FdIR9w # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/BorrowerFile.pm b/Koha/Schema/Result/BorrowerFile.pm index 6f0982d519..bcbed92a95 100644 --- a/Koha/Schema/Result/BorrowerFile.pm +++ b/Koha/Schema/Result/BorrowerFile.pm @@ -29,35 +29,47 @@ __PACKAGE__->table("borrower_files"); is_auto_increment: 1 is_nullable: 0 +unique key + =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +foreign key linking to the patron via the borrowernumber + =head2 file_name data_type: 'varchar' is_nullable: 0 size: 255 +file name + =head2 file_type data_type: 'varchar' is_nullable: 0 size: 255 +type of file + =head2 file_description data_type: 'varchar' is_nullable: 1 size: 255 +description given to the file + =head2 file_content data_type: 'longblob' is_nullable: 0 +the file + =head2 date_uploaded data_type: 'timestamp' @@ -65,6 +77,8 @@ __PACKAGE__->table("borrower_files"); default_value: current_timestamp is_nullable: 0 +date and time the file was added + =cut __PACKAGE__->add_columns( @@ -119,8 +133,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sbkf7bvdO4CgmiBLgIwYQg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fWpDdEeF4RHkIiD71sGvsQ # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/BorrowerModification.pm b/Koha/Schema/Result/BorrowerModification.pm index f11d0880b7..21046fbf79 100644 --- a/Koha/Schema/Result/BorrowerModification.pm +++ b/Koha/Schema/Result/BorrowerModification.pm @@ -421,6 +421,8 @@ __PACKAGE__->table("borrower_modifications"); datetime_undef_if_invalid: 1 is_nullable: 1 +data processing consent + =cut __PACKAGE__->add_columns( @@ -610,8 +612,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("verification_token", "borrowernumber"); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-17 08:12:55 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eK1U1HkJyF1dL9WpcrkxdA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:be+U0NZYRzthZMeOPcg0jA sub koha_object_class { 'Koha::Patron::Modification'; diff --git a/Koha/Schema/Result/BorrowerPasswordRecovery.pm b/Koha/Schema/Result/BorrowerPasswordRecovery.pm index c7f567d102..3c3dab0e4c 100644 --- a/Koha/Schema/Result/BorrowerPasswordRecovery.pm +++ b/Koha/Schema/Result/BorrowerPasswordRecovery.pm @@ -28,12 +28,16 @@ __PACKAGE__->table("borrower_password_recovery"); data_type: 'integer' is_nullable: 0 +the user asking a password recovery + =head2 uuid data_type: 'varchar' is_nullable: 0 size: 128 +a unique string to identify a password recovery attempt + =head2 valid_until data_type: 'timestamp' @@ -41,6 +45,8 @@ __PACKAGE__->table("borrower_password_recovery"); default_value: current_timestamp is_nullable: 0 +a time limit on the password recovery attempt + =cut __PACKAGE__->add_columns( @@ -70,8 +76,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("borrowernumber"); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2016-01-22 10:16:52 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:c4ehAGqOD6YHpGg85BX8YQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hEkX4lXahD+yz2VEb+JP1A # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Branch.pm b/Koha/Schema/Result/Branch.pm index 04a4a11eb6..87f4ec190f 100644 --- a/Koha/Schema/Result/Branch.pm +++ b/Koha/Schema/Result/Branch.pm @@ -30,121 +30,167 @@ __PACKAGE__->table("branches"); is_nullable: 0 size: 10 +a unique key assigned to each branch + =head2 branchname data_type: 'longtext' is_nullable: 0 +the name of your library or branch + =head2 branchaddress1 data_type: 'longtext' is_nullable: 1 +the first address line of for your library or branch + =head2 branchaddress2 data_type: 'longtext' is_nullable: 1 +the second address line of for your library or branch + =head2 branchaddress3 data_type: 'longtext' is_nullable: 1 +the third address line of for your library or branch + =head2 branchzip data_type: 'varchar' is_nullable: 1 size: 25 +the zip or postal code for your library or branch + =head2 branchcity data_type: 'longtext' is_nullable: 1 +the city or province for your library or branch + =head2 branchstate data_type: 'longtext' is_nullable: 1 +the state for your library or branch + =head2 branchcountry data_type: 'mediumtext' is_nullable: 1 +the county for your library or branch + =head2 branchphone data_type: 'longtext' is_nullable: 1 +the primary phone for your library or branch + =head2 branchfax data_type: 'longtext' is_nullable: 1 +the fax number for your library or branch + =head2 branchemail data_type: 'longtext' is_nullable: 1 +the primary email address for your library or branch + =head2 branchillemail data_type: 'longtext' is_nullable: 1 +the ILL staff email address for your library or branch + =head2 branchreplyto data_type: 'longtext' is_nullable: 1 +the email to be used as a Reply-To + =head2 branchreturnpath data_type: 'longtext' is_nullable: 1 +the email to be used as Return-Path + =head2 branchurl data_type: 'longtext' is_nullable: 1 +the URL for your library or branch's website + =head2 issuing data_type: 'tinyint' is_nullable: 1 +unused in Koha + =head2 branchip data_type: 'varchar' is_nullable: 1 size: 15 +the IP address for your library or branch + =head2 branchnotes data_type: 'longtext' is_nullable: 1 +notes related to your library or branch + =head2 opac_info data_type: 'mediumtext' is_nullable: 1 +HTML that displays in OPAC + =head2 geolocation data_type: 'varchar' is_nullable: 1 size: 255 +geolocation of your library + =head2 marcorgcode data_type: 'varchar' is_nullable: 1 size: 16 +MARC Organization Code, see http://www.loc.gov/marc/organizations/orgshome.html, when empty defaults to syspref MARCOrgCode + =head2 pickup_location data_type: 'tinyint' default_value: 1 is_nullable: 0 +the ability to act as a pickup location + =cut __PACKAGE__->add_columns( @@ -841,8 +887,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-11-11 14:23:25 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pOqM3Rfe/H4J+m1XxVfaUQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Uu8m3hyDhM50oTSeNTJbdg __PACKAGE__->add_columns( '+pickup_location' => { is_boolean => 1 } diff --git a/Koha/Schema/Result/Branchtransfer.pm b/Koha/Schema/Result/Branchtransfer.pm index 7fc813e507..4df4ab1d66 100644 --- a/Koha/Schema/Result/Branchtransfer.pm +++ b/Koha/Schema/Result/Branchtransfer.pm @@ -29,6 +29,8 @@ __PACKAGE__->table("branchtransfers"); is_auto_increment: 1 is_nullable: 0 +primary key + =head2 itemnumber data_type: 'integer' @@ -36,6 +38,8 @@ __PACKAGE__->table("branchtransfers"); is_foreign_key: 1 is_nullable: 0 +the itemnumber that it is in transit (items.itemnumber) + =head2 daterequested data_type: 'timestamp' @@ -43,12 +47,16 @@ __PACKAGE__->table("branchtransfers"); default_value: current_timestamp is_nullable: 0 +the date the transfer was requested + =head2 datesent data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +the date the transfer was initialized + =head2 frombranch data_type: 'varchar' @@ -57,12 +65,16 @@ __PACKAGE__->table("branchtransfers"); is_nullable: 0 size: 10 +the branch the transfer is coming from + =head2 datearrived data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +the date the transfer arrived at its destination + =head2 tobranch data_type: 'varchar' @@ -71,17 +83,23 @@ __PACKAGE__->table("branchtransfers"); is_nullable: 0 size: 10 +the branch the transfer was going to + =head2 comments data_type: 'longtext' is_nullable: 1 +any comments related to the transfer + =head2 reason data_type: 'enum' extra: {list => ["Manual","StockrotationAdvance","StockrotationRepatriation","ReturnToHome","ReturnToHolding","RotatingCollection","Reserve","LostReserve","CancelReserve"]} is_nullable: 1 +what triggered the transfer + =cut __PACKAGE__->add_columns( @@ -211,8 +229,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-20 12:30:59 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:G5GZTxF8X/mcIKXmuGVWIQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rseS0EldT7FjkmfRkgasBg sub koha_object_class { 'Koha::Item::Transfer'; diff --git a/Koha/Schema/Result/CashRegister.pm b/Koha/Schema/Result/CashRegister.pm index 6cb01e7848..339142a51c 100644 --- a/Koha/Schema/Result/CashRegister.pm +++ b/Koha/Schema/Result/CashRegister.pm @@ -29,17 +29,23 @@ __PACKAGE__->table("cash_registers"); is_auto_increment: 1 is_nullable: 0 +unique identifier for each account register + =head2 name data_type: 'varchar' is_nullable: 0 size: 24 +the user friendly identifier for each account register + =head2 description data_type: 'longtext' is_nullable: 0 +the user friendly description for each account register + =head2 branch data_type: 'varchar' @@ -47,24 +53,32 @@ __PACKAGE__->table("cash_registers"); is_nullable: 0 size: 10 +the foreign key the library this account register belongs + =head2 branch_default data_type: 'tinyint' default_value: 0 is_nullable: 0 +boolean flag to denote that this till is the branch default + =head2 starting_float data_type: 'decimal' is_nullable: 1 size: [28,6] +the starting float this account register should be assigned + =head2 archived data_type: 'tinyint' default_value: 0 is_nullable: 0 +boolean flag to denote if this till is archived or not + =cut __PACKAGE__->add_columns( @@ -160,8 +174,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-07-23 13:21:03 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zP8my0Zp5bSARTBfws4n1A +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:NNSzc20vEH34dmEsTb5K0Q __PACKAGE__->add_columns( '+archived' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/CashRegisterAction.pm b/Koha/Schema/Result/CashRegisterAction.pm index 6643a73a85..41c63d7e3c 100644 --- a/Koha/Schema/Result/CashRegisterAction.pm +++ b/Koha/Schema/Result/CashRegisterAction.pm @@ -29,30 +29,40 @@ __PACKAGE__->table("cash_register_actions"); is_auto_increment: 1 is_nullable: 0 +unique identifier for each account register action + =head2 code data_type: 'varchar' is_nullable: 0 size: 24 +action code denoting the type of action recorded (enum), + =head2 register_id data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +id of cash_register this action belongs to, + =head2 manager_id data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +staff member performing the action + =head2 amount data_type: 'decimal' is_nullable: 1 size: [28,6] +amount recorded in action (signed) + =head2 timestamp data_type: 'timestamp' @@ -127,8 +137,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-07-23 13:21:03 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Oaee+hS82IEJHHBGuOXDtw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Fo6979mQEueJrDQw38Bh0w sub koha_objects_class { 'Koha::Cash::Register::Actions'; diff --git a/Koha/Schema/Result/Category.pm b/Koha/Schema/Result/Category.pm index 0fdac2cc7c..9cd2dc71ae 100644 --- a/Koha/Schema/Result/Category.pm +++ b/Koha/Schema/Result/Category.pm @@ -30,38 +30,52 @@ __PACKAGE__->table("categories"); is_nullable: 0 size: 10 +unique primary key used to idenfity the patron category + =head2 description data_type: 'longtext' is_nullable: 1 +description of the patron category + =head2 enrolmentperiod data_type: 'smallint' is_nullable: 1 +number of months the patron is enrolled for (will be NULL if enrolmentperioddate is set) + =head2 enrolmentperioddate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +date the patron is enrolled until (will be NULL if enrolmentperiod is set) + =head2 upperagelimit data_type: 'smallint' is_nullable: 1 +age limit for the patron + =head2 dateofbirthrequired data_type: 'tinyint' is_nullable: 1 +the minimum age required for the patron category + =head2 finetype data_type: 'varchar' is_nullable: 1 size: 30 +unused in Koha + =head2 bulk data_type: 'tinyint' @@ -73,28 +87,38 @@ __PACKAGE__->table("categories"); is_nullable: 1 size: [28,6] +enrollment fee for the patron + =head2 overduenoticerequired data_type: 'tinyint' is_nullable: 1 +are overdue notices sent to this patron category (1 for yes, 0 for no) + =head2 issuelimit data_type: 'smallint' is_nullable: 1 +unused in Koha + =head2 reservefee data_type: 'decimal' is_nullable: 1 size: [28,6] +cost to place holds + =head2 hidelostitems data_type: 'tinyint' default_value: 0 is_nullable: 0 +are lost items shown to this category (1 for yes, 0 for no) + =head2 category_type data_type: 'varchar' @@ -102,6 +126,8 @@ __PACKAGE__->table("categories"); is_nullable: 0 size: 1 +type of Koha patron (Adult, Child, Professional, Organizational, Statistical, Staff) + =head2 BlockExpiredPatronOpacActions accessor: 'block_expired_patron_opac_actions' @@ -109,6 +135,8 @@ __PACKAGE__->table("categories"); default_value: -1 is_nullable: 0 +wheither or not a patron of this category can renew books or place holds once their card has expired. 0 means they can, 1 means they cannot, -1 means use syspref BlockExpiredPatronOpacActions + =head2 default_privacy data_type: 'enum' @@ -116,6 +144,8 @@ __PACKAGE__->table("categories"); extra: {list => ["default","never","forever"]} is_nullable: 0 +Default privacy setting for this patron category + =head2 checkprevcheckout data_type: 'varchar' @@ -123,31 +153,43 @@ __PACKAGE__->table("categories"); is_nullable: 0 size: 7 +produce a warning for this patron category if this item has previously been checked out to this patron if 'yes', not if 'no', defer to syspref setting if 'inherit'. + =head2 reset_password data_type: 'tinyint' is_nullable: 1 +if patrons of this category can do the password reset flow, + =head2 change_password data_type: 'tinyint' is_nullable: 1 +if patrons of this category can change their passwords in the OAPC + =head2 min_password_length data_type: 'smallint' is_nullable: 1 +set minimum password length for patrons in this category + =head2 require_strong_password data_type: 'tinyint' is_nullable: 1 +set required password strength for patrons in this category + =head2 exclude_from_local_holds_priority data_type: 'tinyint' is_nullable: 1 +Exclude patrons of this category from local holds priority + =cut __PACKAGE__->add_columns( @@ -302,8 +344,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-18 09:33:32 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ab4IZUfNu63C/SWLPXlMNg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:O4duiIu9dHKr31ToxFGubA __PACKAGE__->add_columns( '+exclude_from_local_holds_priority' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/City.pm b/Koha/Schema/Result/City.pm index f95b63076d..5855dd21ec 100644 --- a/Koha/Schema/Result/City.pm +++ b/Koha/Schema/Result/City.pm @@ -29,6 +29,8 @@ __PACKAGE__->table("cities"); is_auto_increment: 1 is_nullable: 0 +unique identifier added by Koha + =head2 city_name data_type: 'varchar' @@ -36,24 +38,32 @@ __PACKAGE__->table("cities"); is_nullable: 0 size: 100 +name of the city + =head2 city_state data_type: 'varchar' is_nullable: 1 size: 100 +name of the state/province + =head2 city_country data_type: 'varchar' is_nullable: 1 size: 100 +name of the country + =head2 city_zipcode data_type: 'varchar' is_nullable: 1 size: 20 +zip or postal code + =cut __PACKAGE__->add_columns( @@ -82,8 +92,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("cityid"); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zEjfS65sp13yF7dH8/ojZQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PF0pi+dNbKvxVDSpvHgB1Q sub koha_objects_class { 'Koha::Cities'; diff --git a/Koha/Schema/Result/ClubHold.pm b/Koha/Schema/Result/ClubHold.pm index fca4b51046..04759bf412 100644 --- a/Koha/Schema/Result/ClubHold.pm +++ b/Koha/Schema/Result/ClubHold.pm @@ -35,18 +35,24 @@ __PACKAGE__->table("club_holds"); is_foreign_key: 1 is_nullable: 0 +id for the club the hold was generated for + =head2 biblio_id data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +id for the bibliographic record the hold has been placed against + =head2 item_id data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +If item-level, the id for the item the hold has been placed agains + =head2 date_created data_type: 'timestamp' @@ -54,6 +60,8 @@ __PACKAGE__->table("club_holds"); default_value: current_timestamp is_nullable: 0 +Timestamp for the placed hold + =cut __PACKAGE__->add_columns( @@ -154,8 +162,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-01 07:08:47 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FYGXVx1P2R+dGbeP1xshPA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dGkIYbw9CX0LqiH8XmuGAQ sub koha_objects_class { 'Koha::Club::Holds'; diff --git a/Koha/Schema/Result/Collection.pm b/Koha/Schema/Result/Collection.pm index f8c3d8e46b..90d5809a3e 100644 --- a/Koha/Schema/Result/Collection.pm +++ b/Koha/Schema/Result/Collection.pm @@ -52,6 +52,8 @@ __PACKAGE__->table("collections"); is_nullable: 1 size: 10 +'branchcode for branch where item should be held.' + =cut __PACKAGE__->add_columns( @@ -117,8 +119,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Nx6GPmSO3ckjDmF7dz0DKA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bNonPwexORvzFUQlDKobEQ # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Course.pm b/Koha/Schema/Result/Course.pm index cd1ede28e3..29823d75df 100644 --- a/Koha/Schema/Result/Course.pm +++ b/Koha/Schema/Result/Course.pm @@ -29,52 +29,70 @@ __PACKAGE__->table("courses"); is_auto_increment: 1 is_nullable: 0 +unique id for the course + =head2 department data_type: 'varchar' is_nullable: 1 size: 80 +the authorised value for the DEPARTMENT + =head2 course_number data_type: 'varchar' is_nullable: 1 size: 255 +the 'course number' assigned to a course + =head2 section data_type: 'varchar' is_nullable: 1 size: 255 +the 'section' of a course + =head2 course_name data_type: 'varchar' is_nullable: 1 size: 255 +the name of the course + =head2 term data_type: 'varchar' is_nullable: 1 size: 80 +the authorised value for the TERM + =head2 staff_note data_type: 'longtext' is_nullable: 1 +the text of the staff only note + =head2 public_note data_type: 'longtext' is_nullable: 1 +the text of the public / opac note + =head2 students_count data_type: 'varchar' is_nullable: 1 size: 20 +how many students will be taking this course/section + =head2 enabled data_type: 'enum' @@ -82,6 +100,8 @@ __PACKAGE__->table("courses"); extra: {list => ["yes","no"]} is_nullable: 0 +determines whether the course is active + =head2 timestamp data_type: 'timestamp' @@ -181,8 +201,8 @@ Composing rels: L -> borrowernumber __PACKAGE__->many_to_many("borrowernumbers", "course_instructors", "borrowernumber"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:o0EBOuJCHxH5IG/PgsJfxg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Yoy4Un1rFmPk2EJW7Rf5/g # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/CourseInstructor.pm b/Koha/Schema/Result/CourseInstructor.pm index 15ec47ee52..961d07c710 100644 --- a/Koha/Schema/Result/CourseInstructor.pm +++ b/Koha/Schema/Result/CourseInstructor.pm @@ -29,12 +29,16 @@ __PACKAGE__->table("course_instructors"); is_foreign_key: 1 is_nullable: 0 +foreign key to link to courses.course_id + =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +foreign key to link to borrowers.borrowernumber for instructor information + =cut __PACKAGE__->add_columns( @@ -91,8 +95,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7vP3bJ0YA6LEepYOaNg++A +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8JrMgWOtc6LGT7EjOzyjrQ sub koha_objects_class { 'Koha::Course::Instructors'; diff --git a/Koha/Schema/Result/CourseItem.pm b/Koha/Schema/Result/CourseItem.pm index 495cf77964..de50b7987e 100644 --- a/Koha/Schema/Result/CourseItem.pm +++ b/Koha/Schema/Result/CourseItem.pm @@ -29,48 +29,64 @@ __PACKAGE__->table("course_items"); is_auto_increment: 1 is_nullable: 0 +course item id + =head2 itemnumber data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +items.itemnumber for the item on reserve + =head2 itype data_type: 'varchar' is_nullable: 1 size: 10 +new itemtype for the item to have while on reserve (optional) + =head2 itype_enabled data_type: 'tinyint' default_value: 0 is_nullable: 0 +indicates if itype should be changed while on course reserve + =head2 itype_storage data_type: 'varchar' is_nullable: 1 size: 10 +a place to store the itype when item is on course reserve + =head2 ccode data_type: 'varchar' is_nullable: 1 size: 80 +new category code for the item to have while on reserve (optional) + =head2 ccode_enabled data_type: 'tinyint' default_value: 0 is_nullable: 0 +indicates if ccode should be changed while on course reserve + =head2 ccode_storage data_type: 'varchar' is_nullable: 1 size: 80 +a place to store the ccode when item is on course reserve + =head2 homebranch data_type: 'varchar' @@ -78,12 +94,16 @@ __PACKAGE__->table("course_items"); is_nullable: 1 size: 10 +new home branch for the item to have while on reserve (optional) + =head2 homebranch_enabled data_type: 'tinyint' default_value: 0 is_nullable: 0 +indicates if homebranch should be changed while on course reserve + =head2 homebranch_storage data_type: 'varchar' @@ -91,6 +111,8 @@ __PACKAGE__->table("course_items"); is_nullable: 1 size: 10 +a place to store the homebranch when item is on course reserve + =head2 holdingbranch data_type: 'varchar' @@ -98,36 +120,48 @@ __PACKAGE__->table("course_items"); is_nullable: 1 size: 10 +new holding branch for the item to have while on reserve (optional) + =head2 holdingbranch_enabled data_type: 'tinyint' default_value: 0 is_nullable: 0 +indicates if itype should be changed while on course reserve + =head2 holdingbranch_storage data_type: 'varchar' is_nullable: 1 size: 10 +a place to store the holdingbranch when item is on course reserve + =head2 location data_type: 'varchar' is_nullable: 1 size: 80 +new shelving location for the item to have while on reseve (optional) + =head2 location_enabled data_type: 'tinyint' default_value: 0 is_nullable: 0 +indicates if itype should be changed while on course reserve + =head2 location_storage data_type: 'varchar' is_nullable: 1 size: 80 +a place to store the location when the item is on course reserve + =head2 enabled data_type: 'enum' @@ -135,6 +169,8 @@ __PACKAGE__->table("course_items"); extra: {list => ["yes","no"]} is_nullable: 0 +if at least one enabled course has this item on reseve, this field will be 'yes', otherwise it will be 'no' + =head2 timestamp data_type: 'timestamp' @@ -314,8 +350,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-04-24 10:54:54 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cXNlGAgIZMs+Id7/FJSBRQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:g97N0MosrfgL6Jg3NVJUFA __PACKAGE__->add_columns( '+itype_enabled' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/CourseReserve.pm b/Koha/Schema/Result/CourseReserve.pm index 8bb41cbb23..65a3f743b0 100644 --- a/Koha/Schema/Result/CourseReserve.pm +++ b/Koha/Schema/Result/CourseReserve.pm @@ -35,22 +35,30 @@ __PACKAGE__->table("course_reserves"); is_foreign_key: 1 is_nullable: 0 +foreign key to link to courses.course_id + =head2 ci_id data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +foreign key to link to courses_items.ci_id + =head2 staff_note data_type: 'longtext' is_nullable: 1 +staff only note + =head2 public_note data_type: 'longtext' is_nullable: 1 +public, OPAC visible note + =head2 timestamp data_type: 'timestamp' @@ -141,8 +149,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8SDdUrbxKuAwp6rgn85RmA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:K3co29iVHAcF2/S0tGT1LA sub koha_objects_class { 'Koha::Course::Reserves'; diff --git a/Koha/Schema/Result/CoverImage.pm b/Koha/Schema/Result/CoverImage.pm index d8e9854132..034933d41b 100644 --- a/Koha/Schema/Result/CoverImage.pm +++ b/Koha/Schema/Result/CoverImage.pm @@ -29,34 +29,46 @@ __PACKAGE__->table("cover_images"); is_auto_increment: 1 is_nullable: 0 +unique identifier for the image + =head2 biblionumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +foreign key from biblio table to link to biblionumber + =head2 itemnumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +foreign key from item table to link to itemnumber + =head2 mimetype data_type: 'varchar' is_nullable: 0 size: 15 +image type + =head2 imagefile data_type: 'mediumblob' is_nullable: 0 +image file contents + =head2 thumbnail data_type: 'mediumblob' is_nullable: 0 +thumbnail file contents + =head2 timestamp data_type: 'timestamp' @@ -64,6 +76,8 @@ __PACKAGE__->table("cover_images"); default_value: current_timestamp is_nullable: 0 +image creation/update time + =cut __PACKAGE__->add_columns( @@ -143,8 +157,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-10-12 09:13:32 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:F8pfwsORemCIxoVAPIohXw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Qzy8edw2HP4jZbZRNCOf4A # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Deletedbiblio.pm b/Koha/Schema/Result/Deletedbiblio.pm index 5d02066493..e3f48a3acd 100644 --- a/Koha/Schema/Result/Deletedbiblio.pm +++ b/Koha/Schema/Result/Deletedbiblio.pm @@ -29,6 +29,8 @@ __PACKAGE__->table("deletedbiblio"); is_auto_increment: 1 is_nullable: 0 +unique identifier assigned to each bibliographic record + =head2 frameworkcode data_type: 'varchar' @@ -36,51 +38,71 @@ __PACKAGE__->table("deletedbiblio"); is_nullable: 0 size: 4 +foriegn key from the biblio_framework table to identify which framework was used in cataloging this record + =head2 author data_type: 'longtext' is_nullable: 1 +statement of responsibility from MARC record (100$a in MARC21) + =head2 title data_type: 'longtext' is_nullable: 1 +title (without the subtitle) from the MARC record (245$a in MARC21) + =head2 medium data_type: 'longtext' is_nullable: 1 +medium from the MARC record (245$h in MARC21) + =head2 subtitle data_type: 'longtext' is_nullable: 1 +remainder of the title from the MARC record (245$b in MARC21) + =head2 part_number data_type: 'longtext' is_nullable: 1 +part number from the MARC record (245$n in MARC21) + =head2 part_name data_type: 'longtext' is_nullable: 1 +part name from the MARC record (245$p in MARC21) + =head2 unititle data_type: 'longtext' is_nullable: 1 +uniform title (without the subtitle) from the MARC record (240$a in MARC21) + =head2 notes data_type: 'longtext' is_nullable: 1 +values from the general notes field in the MARC record (500$a in MARC21) split by bar (|) + =head2 serial data_type: 'tinyint' is_nullable: 1 +Boolean indicating whether biblio is for a serial + =head2 seriestitle data_type: 'longtext' @@ -91,6 +113,8 @@ __PACKAGE__->table("deletedbiblio"); data_type: 'smallint' is_nullable: 1 +publication or copyright date from the MARC record + =head2 timestamp data_type: 'timestamp' @@ -98,17 +122,23 @@ __PACKAGE__->table("deletedbiblio"); default_value: current_timestamp is_nullable: 0 +date and time this record was last touched + =head2 datecreated data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 0 +the date this record was added to Koha + =head2 abstract data_type: 'longtext' is_nullable: 1 +summary from the MARC record (520$a in MARC21) + =cut __PACKAGE__->add_columns( @@ -181,8 +211,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-08-05 13:53:34 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FQaznWmkfR2Ge5NG8lDmSw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KwlqhkWWX6CYWb3l2fCcSg sub koha_objects_class { 'Koha::Old::Biblios'; diff --git a/Koha/Schema/Result/Deletedbiblioitem.pm b/Koha/Schema/Result/Deletedbiblioitem.pm index e2849ecd99..f0804b5e13 100644 --- a/Koha/Schema/Result/Deletedbiblioitem.pm +++ b/Koha/Schema/Result/Deletedbiblioitem.pm @@ -29,12 +29,16 @@ __PACKAGE__->table("deletedbiblioitems"); default_value: 0 is_nullable: 0 +primary key, unique identifier assigned by Koha + =head2 biblionumber data_type: 'integer' default_value: 0 is_nullable: 0 +foreign key linking this table to the biblio table + =head2 volume data_type: 'longtext' @@ -51,16 +55,22 @@ __PACKAGE__->table("deletedbiblioitems"); is_nullable: 1 size: 10 +biblio level item type (MARC21 942$c) + =head2 isbn data_type: 'longtext' is_nullable: 1 +ISBN (MARC21 020$a) + =head2 issn data_type: 'longtext' is_nullable: 1 +ISSN (MARC21 022$a) + =head2 ean data_type: 'longtext' @@ -77,6 +87,8 @@ __PACKAGE__->table("deletedbiblioitems"); is_nullable: 1 size: 255 +publisher (MARC21 260$b) + =head2 volumedate data_type: 'date' @@ -88,6 +100,8 @@ __PACKAGE__->table("deletedbiblioitems"); data_type: 'mediumtext' is_nullable: 1 +volume information (MARC21 362$a) + =head2 collectiontitle data_type: 'longtext' @@ -126,12 +140,16 @@ __PACKAGE__->table("deletedbiblioitems"); is_nullable: 1 size: 255 +illustrations (MARC21 300$b) + =head2 pages data_type: 'varchar' is_nullable: 1 size: 255 +number of pages (MARC21 300$c) + =head2 notes data_type: 'longtext' @@ -143,29 +161,39 @@ __PACKAGE__->table("deletedbiblioitems"); is_nullable: 1 size: 255 +material size (MARC21 300$c) + =head2 place data_type: 'varchar' is_nullable: 1 size: 255 +publication place (MARC21 260$a) + =head2 lccn data_type: 'varchar' is_nullable: 1 size: 25 +library of congress control number (MARC21 010$a) + =head2 url data_type: 'mediumtext' is_nullable: 1 +url (MARC21 856$u) + =head2 cn_source data_type: 'varchar' is_nullable: 1 size: 10 +classification source (MARC21 942$2) + =head2 cn_class data_type: 'varchar' @@ -190,12 +218,16 @@ __PACKAGE__->table("deletedbiblioitems"); is_nullable: 1 size: 255 +normalized version of the call number used for sorting + =head2 agerestriction data_type: 'varchar' is_nullable: 1 size: 255 +target audience/age restriction from the bib record (MARC21 521$a) + =head2 totalissues data_type: 'integer' @@ -288,8 +320,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("biblioitemnumber"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QLYBa1Ea8Jau2Wy6U+wyQw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rGXNjpclQJ3+na+MYa4YFA sub koha_objects_class { 'Koha::Old::Biblioitems'; diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm index d091fe98bd..e13547e499 100644 --- a/Koha/Schema/Result/Deletedborrower.pm +++ b/Koha/Schema/Result/Deletedborrower.pm @@ -29,173 +29,237 @@ __PACKAGE__->table("deletedborrowers"); default_value: 0 is_nullable: 0 +primary key, Koha assigned ID number for patrons/borrowers + =head2 cardnumber data_type: 'varchar' is_nullable: 1 size: 32 +unique key, library assigned ID number for patrons/borrowers + =head2 surname data_type: 'longtext' is_nullable: 1 +patron/borrower's last name (surname) + =head2 firstname data_type: 'mediumtext' is_nullable: 1 +patron/borrower's first name + =head2 title data_type: 'longtext' is_nullable: 1 +patron/borrower's title, for example: Mr. or Mrs. + =head2 othernames data_type: 'longtext' is_nullable: 1 +any other names associated with the patron/borrower + =head2 initials data_type: 'mediumtext' is_nullable: 1 +initials for your patron/borrower + =head2 streetnumber data_type: 'tinytext' is_nullable: 1 +the house number for your patron/borrower's primary address + =head2 streettype data_type: 'tinytext' is_nullable: 1 +the street type (Rd., Blvd, etc) for your patron/borrower's primary address + =head2 address data_type: 'longtext' is_nullable: 1 +the first address line for your patron/borrower's primary address + =head2 address2 data_type: 'mediumtext' is_nullable: 1 +the second address line for your patron/borrower's primary address + =head2 city data_type: 'longtext' is_nullable: 1 +the city or town for your patron/borrower's primary address + =head2 state data_type: 'mediumtext' is_nullable: 1 +the state or province for your patron/borrower's primary address + =head2 zipcode data_type: 'tinytext' is_nullable: 1 +the zip or postal code for your patron/borrower's primary address + =head2 country data_type: 'mediumtext' is_nullable: 1 +the country for your patron/borrower's primary address + =head2 email data_type: 'longtext' is_nullable: 1 +the primary email address for your patron/borrower's primary address + =head2 phone data_type: 'mediumtext' is_nullable: 1 +the primary phone number for your patron/borrower's primary address + =head2 mobile data_type: 'tinytext' is_nullable: 1 +the other phone number for your patron/borrower's primary address + =head2 fax data_type: 'longtext' is_nullable: 1 +the fax number for your patron/borrower's primary address + =head2 emailpro data_type: 'mediumtext' is_nullable: 1 +the secondary email addres for your patron/borrower's primary address + =head2 phonepro data_type: 'mediumtext' is_nullable: 1 +the secondary phone number for your patron/borrower's primary address + =head2 B_streetnumber accessor: 'b_streetnumber' data_type: 'tinytext' is_nullable: 1 +the house number for your patron/borrower's alternate address + =head2 B_streettype accessor: 'b_streettype' data_type: 'tinytext' is_nullable: 1 +the street type (Rd., Blvd, etc) for your patron/borrower's alternate address + =head2 B_address accessor: 'b_address' data_type: 'mediumtext' is_nullable: 1 +the first address line for your patron/borrower's alternate address + =head2 B_address2 accessor: 'b_address2' data_type: 'mediumtext' is_nullable: 1 +the second address line for your patron/borrower's alternate address + =head2 B_city accessor: 'b_city' data_type: 'longtext' is_nullable: 1 +the city or town for your patron/borrower's alternate address + =head2 B_state accessor: 'b_state' data_type: 'mediumtext' is_nullable: 1 +the state for your patron/borrower's alternate address + =head2 B_zipcode accessor: 'b_zipcode' data_type: 'tinytext' is_nullable: 1 +the zip or postal code for your patron/borrower's alternate address + =head2 B_country accessor: 'b_country' data_type: 'mediumtext' is_nullable: 1 +the country for your patron/borrower's alternate address + =head2 B_email accessor: 'b_email' data_type: 'mediumtext' is_nullable: 1 +the patron/borrower's alternate email address + =head2 B_phone accessor: 'b_phone' data_type: 'longtext' is_nullable: 1 +the patron/borrower's alternate phone number + =head2 dateofbirth data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +the patron/borrower's date of birth (YYYY-MM-DD) + =head2 branchcode data_type: 'varchar' @@ -203,6 +267,8 @@ __PACKAGE__->table("deletedborrowers"); is_nullable: 0 size: 10 +foreign key from the branches table, includes the code of the patron/borrower's home branch + =head2 categorycode data_type: 'varchar' @@ -210,192 +276,262 @@ __PACKAGE__->table("deletedborrowers"); is_nullable: 0 size: 10 +foreign key from the categories table, includes the code of the patron category + =head2 dateenrolled data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +date the patron was added to Koha (YYYY-MM-DD) + =head2 dateexpiry data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +date the patron/borrower's card is set to expire (YYYY-MM-DD) + =head2 date_renewed data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +date the patron/borrower's card was last renewed + =head2 gonenoaddress data_type: 'tinyint' is_nullable: 1 +set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address + =head2 lost data_type: 'tinyint' is_nullable: 1 +set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card + =head2 debarred data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +until this date the patron can only check-in (no loans, no holds, etc.), is a fine based on days instead of money (YYYY-MM-DD) + =head2 debarredcomment data_type: 'varchar' is_nullable: 1 size: 255 +comment on the stop of patron + =head2 contactname data_type: 'longtext' is_nullable: 1 +used for children and profesionals to include surname or last name of guarantor or organization name + =head2 contactfirstname data_type: 'mediumtext' is_nullable: 1 +used for children to include first name of guarantor + =head2 contacttitle data_type: 'mediumtext' is_nullable: 1 +used for children to include title (Mr., Mrs., etc) of guarantor + =head2 borrowernotes data_type: 'longtext' is_nullable: 1 +a note on the patron/borrower's account that is only visible in the staff interface + =head2 relationship data_type: 'varchar' is_nullable: 1 size: 100 +used for children to include the relationship to their guarantor + =head2 sex data_type: 'varchar' is_nullable: 1 size: 1 +patron/borrower's gender + =head2 password data_type: 'varchar' is_nullable: 1 size: 60 +patron/borrower's encrypted password + =head2 flags data_type: 'integer' is_nullable: 1 +will include a number associated with the staff member's permissions + =head2 userid data_type: 'varchar' is_nullable: 1 size: 75 +patron/borrower's opac and/or staff interface log in + =head2 opacnote data_type: 'longtext' is_nullable: 1 +a note on the patron/borrower's account that is visible in the OPAC and staff interface + =head2 contactnote data_type: 'varchar' is_nullable: 1 size: 255 +a note related to the patron/borrower's alternate address + =head2 sort1 data_type: 'varchar' is_nullable: 1 size: 80 +a field that can be used for any information unique to the library + =head2 sort2 data_type: 'varchar' is_nullable: 1 size: 80 +a field that can be used for any information unique to the library + =head2 altcontactfirstname data_type: 'mediumtext' is_nullable: 1 +first name of alternate contact for the patron/borrower + =head2 altcontactsurname data_type: 'mediumtext' is_nullable: 1 +surname or last name of the alternate contact for the patron/borrower + =head2 altcontactaddress1 data_type: 'mediumtext' is_nullable: 1 +the first address line for the alternate contact for the patron/borrower + =head2 altcontactaddress2 data_type: 'mediumtext' is_nullable: 1 +the second address line for the alternate contact for the patron/borrower + =head2 altcontactaddress3 data_type: 'mediumtext' is_nullable: 1 +the city for the alternate contact for the patron/borrower + =head2 altcontactstate data_type: 'mediumtext' is_nullable: 1 +the state for the alternate contact for the patron/borrower + =head2 altcontactzipcode data_type: 'mediumtext' is_nullable: 1 +the zipcode for the alternate contact for the patron/borrower + =head2 altcontactcountry data_type: 'mediumtext' is_nullable: 1 +the country for the alternate contact for the patron/borrower + =head2 altcontactphone data_type: 'mediumtext' is_nullable: 1 +the phone number for the alternate contact for the patron/borrower + =head2 smsalertnumber data_type: 'varchar' is_nullable: 1 size: 50 +the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on) + =head2 sms_provider_id data_type: 'integer' is_nullable: 1 +the provider of the mobile phone number defined in smsalertnumber + =head2 privacy data_type: 'integer' default_value: 1 is_nullable: 0 +patron/borrower's privacy settings related to their checkout history KEY `borrowernumber` (`borrowernumber`), + =head2 privacy_guarantor_fines data_type: 'tinyint' default_value: 0 is_nullable: 0 +controls if relatives can see this patron's fines + =head2 privacy_guarantor_checkouts data_type: 'tinyint' default_value: 0 is_nullable: 0 +controls if relatives can see this patron's checkouts + =head2 checkprevcheckout data_type: 'varchar' @@ -403,6 +539,8 @@ __PACKAGE__->table("deletedborrowers"); is_nullable: 0 size: 7 +produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'. + =head2 updated_on data_type: 'timestamp' @@ -410,12 +548,16 @@ __PACKAGE__->table("deletedborrowers"); default_value: current_timestamp is_nullable: 0 +time of last change could be useful for synchronization with external systems (among others) + =head2 lastseen data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +last time a patron has been seen (connected at the OPAC or staff interface) + =head2 lang data_type: 'varchar' @@ -423,29 +565,39 @@ __PACKAGE__->table("deletedborrowers"); is_nullable: 0 size: 25 +lang to use to send notices to this patron + =head2 login_attempts data_type: 'integer' default_value: 0 is_nullable: 0 +number of failed login attemps + =head2 overdrive_auth_token data_type: 'mediumtext' is_nullable: 1 +persist OverDrive auth token + =head2 anonymized data_type: 'tinyint' default_value: 0 is_nullable: 0 +flag for data anonymization + =head2 autorenew_checkouts data_type: 'tinyint' default_value: 1 is_nullable: 0 +flag for allowing auto-renewal + =cut __PACKAGE__->add_columns( @@ -623,8 +775,8 @@ __PACKAGE__->add_columns( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-07-20 10:54:51 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4xYIkJhZWN+O/s8cMYbJmw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZVKapg14KPBMzgnIkXJnig __PACKAGE__->add_columns( '+anonymized' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Deleteditem.pm b/Koha/Schema/Result/Deleteditem.pm index fbed06c6ce..12c8900c5a 100644 --- a/Koha/Schema/Result/Deleteditem.pm +++ b/Koha/Schema/Result/Deleteditem.pm @@ -29,71 +29,95 @@ __PACKAGE__->table("deleteditems"); default_value: 0 is_nullable: 0 +primary key and unique identifier added by Koha + =head2 biblionumber data_type: 'integer' default_value: 0 is_nullable: 0 +foreign key from biblio table used to link this item to the right bib record + =head2 biblioitemnumber data_type: 'integer' default_value: 0 is_nullable: 0 +foreign key from the biblioitems table to link to item to additional information + =head2 barcode data_type: 'varchar' is_nullable: 1 size: 20 +item barcode (MARC21 952$p) + =head2 dateaccessioned data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +date the item was acquired or added to Koha (MARC21 952$d) + =head2 booksellerid data_type: 'longtext' is_nullable: 1 +where the item was purchased (MARC21 952$e) + =head2 homebranch data_type: 'varchar' is_nullable: 1 size: 10 +foreign key from the branches table for the library that owns this item (MARC21 952$a) + =head2 price data_type: 'decimal' is_nullable: 1 size: [8,2] +purchase price (MARC21 952$g) + =head2 replacementprice data_type: 'decimal' is_nullable: 1 size: [8,2] +cost the library charges to replace the item if it has been marked lost (MARC21 952$v) + =head2 replacementpricedate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +the date the price is effective from (MARC21 952$w) + =head2 datelastborrowed data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +the date the item was last checked out + =head2 datelastseen data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +the date the item was last see (usually the last time the barcode was scanned or inventory was done) + =head2 stack data_type: 'tinyint' @@ -105,91 +129,123 @@ __PACKAGE__->table("deleteditems"); default_value: 0 is_nullable: 0 +authorized value defining why this item is not for loan (MARC21 952$7) + =head2 damaged data_type: 'tinyint' default_value: 0 is_nullable: 0 +authorized value defining this item as damaged (MARC21 952$4) + =head2 damaged_on data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +the date and time an item was last marked as damaged, NULL if not damaged + =head2 itemlost data_type: 'tinyint' default_value: 0 is_nullable: 0 +authorized value defining this item as lost (MARC21 952$1) + =head2 itemlost_on data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +the date and time an item was last marked as lost, NULL if not lost + =head2 withdrawn data_type: 'tinyint' default_value: 0 is_nullable: 0 +authorized value defining this item as withdrawn (MARC21 952$0) + =head2 withdrawn_on data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +the date and time an item was last marked as withdrawn, NULL if not withdrawn + =head2 itemcallnumber data_type: 'varchar' is_nullable: 1 size: 255 +call number for this item (MARC21 952$o) + =head2 coded_location_qualifier data_type: 'varchar' is_nullable: 1 size: 10 +coded location qualifier(MARC21 952$f) + =head2 issues data_type: 'smallint' default_value: 0 is_nullable: 1 +number of times this item has been checked out + =head2 renewals data_type: 'smallint' is_nullable: 1 +number of times this item has been renewed + =head2 reserves data_type: 'smallint' is_nullable: 1 +number of times this item has been placed on hold/reserved + =head2 restricted data_type: 'tinyint' is_nullable: 1 +authorized value defining use restrictions for this item (MARC21 952$5) + =head2 itemnotes data_type: 'longtext' is_nullable: 1 +public notes on this item (MARC21 952$z) + =head2 itemnotes_nonpublic data_type: 'longtext' is_nullable: 1 +non-public notes on this item (MARC21 952$x) + =head2 holdingbranch data_type: 'varchar' is_nullable: 1 size: 10 +foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) + =head2 timestamp data_type: 'timestamp' @@ -197,91 +253,123 @@ __PACKAGE__->table("deleteditems"); default_value: current_timestamp is_nullable: 0 +date and time this item was last altered + =head2 location data_type: 'varchar' is_nullable: 1 size: 80 +authorized value for the shelving location for this item (MARC21 952$c) + =head2 permanent_location data_type: 'varchar' is_nullable: 1 size: 80 +linked to the CART and PROC temporary locations feature, stores the permanent shelving location + =head2 onloan data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +defines if item is checked out (NULL for not checked out, and due date for checked out) + =head2 cn_source data_type: 'varchar' is_nullable: 1 size: 10 +classification source used on this item (MARC21 952$2) + =head2 cn_sort data_type: 'varchar' is_nullable: 1 size: 255 +normalized form of the call number (MARC21 952$o) used for sorting + =head2 ccode data_type: 'varchar' is_nullable: 1 size: 80 +authorized value for the collection code associated with this item (MARC21 952$8) + =head2 materials data_type: 'mediumtext' is_nullable: 1 +materials specified (MARC21 952$3) + =head2 uri data_type: 'mediumtext' is_nullable: 1 +URL for the item (MARC21 952$u) + =head2 itype data_type: 'varchar' is_nullable: 1 size: 10 +foreign key from the itemtypes table defining the type for this item (MARC21 952$y) + =head2 more_subfields_xml data_type: 'longtext' is_nullable: 1 +additional 952 subfields in XML format + =head2 enumchron data_type: 'mediumtext' is_nullable: 1 +serial enumeration/chronology for the item (MARC21 952$h) + =head2 copynumber data_type: 'varchar' is_nullable: 1 size: 32 +copy number (MARC21 952$t) + =head2 stocknumber data_type: 'varchar' is_nullable: 1 size: 32 +inventory number (MARC21 952$i) + =head2 new_status data_type: 'varchar' is_nullable: 1 size: 32 +'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob. + =head2 exclude_from_local_holds_priority data_type: 'tinyint' is_nullable: 1 +Exclude this item from local holds priority + =cut __PACKAGE__->add_columns( @@ -407,8 +495,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("itemnumber"); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-09-30 15:31:01 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1l4g7uiQo9gkdrWbNxAsJg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ytND0t16cwo9dseU+JZSGQ __PACKAGE__->add_columns( '+exclude_from_local_holds_priority' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Desk.pm b/Koha/Schema/Result/Desk.pm index 9201a9315e..20aae97fe0 100644 --- a/Koha/Schema/Result/Desk.pm +++ b/Koha/Schema/Result/Desk.pm @@ -29,6 +29,8 @@ __PACKAGE__->table("desks"); is_auto_increment: 1 is_nullable: 0 +unique identifier + =head2 desk_name data_type: 'varchar' @@ -36,6 +38,8 @@ __PACKAGE__->table("desks"); is_nullable: 0 size: 100 +name of the desk + =head2 branchcode data_type: 'varchar' @@ -43,6 +47,8 @@ __PACKAGE__->table("desks"); is_nullable: 0 size: 10 +library the desk is located at + =cut __PACKAGE__->add_columns( @@ -99,8 +105,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-11-06 11:00:40 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Weoxj3CBeajLEzx9DBX1ag +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7qeCP25arGQpM4xxnTmWbw # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/HouseboundProfile.pm b/Koha/Schema/Result/HouseboundProfile.pm index 0406e9f7a2..5c37bb36d5 100644 --- a/Koha/Schema/Result/HouseboundProfile.pm +++ b/Koha/Schema/Result/HouseboundProfile.pm @@ -29,41 +29,57 @@ __PACKAGE__->table("housebound_profile"); is_foreign_key: 1 is_nullable: 0 +Number of the borrower associated with this profile. + =head2 day data_type: 'mediumtext' is_nullable: 0 +The preferred day of the week for delivery. + =head2 frequency data_type: 'mediumtext' is_nullable: 0 +The Authorised_Value definining the pattern for delivery. + =head2 fav_itemtypes data_type: 'mediumtext' is_nullable: 1 +Free text describing preferred itemtypes. + =head2 fav_subjects data_type: 'mediumtext' is_nullable: 1 +Free text describing preferred subjects. + =head2 fav_authors data_type: 'mediumtext' is_nullable: 1 +Free text describing preferred authors. + =head2 referral data_type: 'mediumtext' is_nullable: 1 +Free text indicating how the borrower was added to the service. + =head2 notes data_type: 'mediumtext' is_nullable: 1 +Free text for additional notes. + =cut __PACKAGE__->add_columns( @@ -130,8 +146,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ESpGqu3oX9qad3elnDvOiw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VmCvv8WVQCmAXCfWHsLIdg sub koha_object_class { 'Koha::Patron::HouseboundProfile'; diff --git a/Koha/Schema/Result/HouseboundRole.pm b/Koha/Schema/Result/HouseboundRole.pm index 7c1489ed33..d0c267f5c7 100644 --- a/Koha/Schema/Result/HouseboundRole.pm +++ b/Koha/Schema/Result/HouseboundRole.pm @@ -29,18 +29,24 @@ __PACKAGE__->table("housebound_role"); is_foreign_key: 1 is_nullable: 0 +borrowernumber link + =head2 housebound_chooser data_type: 'tinyint' default_value: 0 is_nullable: 0 +set to 1 to indicate this patron is a housebound chooser volunteer + =head2 housebound_deliverer data_type: 'tinyint' default_value: 0 is_nullable: 0 +set to 1 to indicate this patron is a housebound deliverer volunteer + =cut __PACKAGE__->add_columns( @@ -82,8 +88,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-21 18:20:25 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SU7khVgiUf1OVvaFpKaFPA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BocU8VE+5j4lYlxNU6Lofw sub koha_object_class { 'Koha::Patron::HouseboundRole'; diff --git a/Koha/Schema/Result/HouseboundVisit.pm b/Koha/Schema/Result/HouseboundVisit.pm index 4f3b402bc4..a0488bab0f 100644 --- a/Koha/Schema/Result/HouseboundVisit.pm +++ b/Koha/Schema/Result/HouseboundVisit.pm @@ -29,36 +29,48 @@ __PACKAGE__->table("housebound_visit"); is_auto_increment: 1 is_nullable: 0 +ID of the visit. + =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +Number of the borrower, & the profile, linked to this visit. + =head2 appointment_date data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +Date of visit. + =head2 day_segment data_type: 'varchar' is_nullable: 1 size: 10 +Rough time frame: 'morning', 'afternoon' 'evening' + =head2 chooser_brwnumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +Number of the borrower to choose items for delivery. + =head2 deliverer_brwnumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +Number of the borrower to deliver items. + =cut __PACKAGE__->add_columns( @@ -146,8 +158,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-04-25 13:21:23 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5zyc7l2BtF5cgpZeKbJNZg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PJwWk4901BF+CG6AXgjffg sub koha_object_class { 'Koha::Patron::HouseboundVisit'; diff --git a/Koha/Schema/Result/Illcomment.pm b/Koha/Schema/Result/Illcomment.pm index 04a04370c4..90a389a095 100644 --- a/Koha/Schema/Result/Illcomment.pm +++ b/Koha/Schema/Result/Illcomment.pm @@ -29,6 +29,8 @@ __PACKAGE__->table("illcomments"); is_auto_increment: 1 is_nullable: 0 +Unique ID of the comment + =head2 illrequest_id data_type: 'bigint' @@ -36,17 +38,23 @@ __PACKAGE__->table("illcomments"); is_foreign_key: 1 is_nullable: 0 +ILL request number + =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +Link to the user who made the comment (could be librarian, patron or ILL partner library) + =head2 comment data_type: 'text' is_nullable: 1 +The text of the comment + =head2 timestamp data_type: 'timestamp' @@ -54,6 +62,8 @@ __PACKAGE__->table("illcomments"); default_value: current_timestamp is_nullable: 0 +Date and time when the comment was made + =cut __PACKAGE__->add_columns( @@ -129,8 +139,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-26 19:57:17 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JJC9ohn0V61+WzMppDKUJw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:z5Y6mVTLtrYxmqmyAc/E7A # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Illrequest.pm b/Koha/Schema/Result/Illrequest.pm index 4260a8d2df..16e7d9e6ed 100644 --- a/Koha/Schema/Result/Illrequest.pm +++ b/Koha/Schema/Result/Illrequest.pm @@ -30,17 +30,23 @@ __PACKAGE__->table("illrequests"); is_auto_increment: 1 is_nullable: 0 +ILL request number + =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +Patron associated with request + =head2 biblio_id data_type: 'integer' is_nullable: 1 +Potential bib linked to request + =head2 branchcode data_type: 'varchar' @@ -48,12 +54,16 @@ __PACKAGE__->table("illrequests"); is_nullable: 0 size: 50 +The branch associated with the request + =head2 status data_type: 'varchar' is_nullable: 1 size: 50 +Current Koha status of request + =head2 status_alias data_type: 'varchar' @@ -61,18 +71,24 @@ __PACKAGE__->table("illrequests"); is_nullable: 1 size: 80 +Foreign key to relevant authorised_values.authorised_value + =head2 placed data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +Date the request was placed + =head2 replied data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +Last API response + =head2 updated data_type: 'timestamp' @@ -86,52 +102,70 @@ __PACKAGE__->table("illrequests"); datetime_undef_if_invalid: 1 is_nullable: 1 +Date the request was completed + =head2 medium data_type: 'varchar' is_nullable: 1 size: 30 +The Koha request type + =head2 accessurl data_type: 'varchar' is_nullable: 1 size: 500 +Potential URL for accessing item + =head2 cost data_type: 'varchar' is_nullable: 1 size: 20 +Quotes cost of request + =head2 price_paid data_type: 'varchar' is_nullable: 1 size: 20 +Final cost of request + =head2 notesopac data_type: 'mediumtext' is_nullable: 1 +Patron notes attached to request + =head2 notesstaff data_type: 'mediumtext' is_nullable: 1 +Staff notes attached to request + =head2 orderid data_type: 'varchar' is_nullable: 1 size: 50 +Backend id attached to request + =head2 backend data_type: 'varchar' is_nullable: 1 size: 20 +The backend used to create request + =cut __PACKAGE__->add_columns( @@ -283,8 +317,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-02-22 14:32:49 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:I6fY8XRfEmRxSzOeVT9Krw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ek47WcMZpSBpxUajJuEN+Q # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Illrequestattribute.pm b/Koha/Schema/Result/Illrequestattribute.pm index 7fa897c3e9..c5e7af75d3 100644 --- a/Koha/Schema/Result/Illrequestattribute.pm +++ b/Koha/Schema/Result/Illrequestattribute.pm @@ -30,23 +30,31 @@ __PACKAGE__->table("illrequestattributes"); is_foreign_key: 1 is_nullable: 0 +ILL request number + =head2 type data_type: 'varchar' is_nullable: 0 size: 200 +API ILL property name + =head2 value data_type: 'mediumtext' is_nullable: 0 +API ILL property value + =head2 readonly data_type: 'tinyint' default_value: 1 is_nullable: 0 +Is this attribute read only + =cut __PACKAGE__->add_columns( @@ -97,8 +105,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-05-17 09:17:53 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sFY1giVMz5AkXCPidhyGjw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qNhL5kiGVR8WroCHQY5DyQ __PACKAGE__->add_columns( '+readonly' => { is_boolean => 1 } diff --git a/Koha/Schema/Result/ImportBatch.pm b/Koha/Schema/Result/ImportBatch.pm index 829297596c..da8f290a74 100644 --- a/Koha/Schema/Result/ImportBatch.pm +++ b/Koha/Schema/Result/ImportBatch.pm @@ -29,11 +29,15 @@ __PACKAGE__->table("import_batches"); is_auto_increment: 1 is_nullable: 0 +unique identifier and primary key + =head2 matcher_id data_type: 'integer' is_nullable: 1 +the id of the match rule used (matchpoints.matcher_id) + =head2 template_id data_type: 'integer' @@ -51,12 +55,16 @@ __PACKAGE__->table("import_batches"); default_value: 0 is_nullable: 0 +number of records in the file + =head2 num_items data_type: 'integer' default_value: 0 is_nullable: 0 +number of items in the file + =head2 upload_timestamp data_type: 'timestamp' @@ -64,6 +72,8 @@ __PACKAGE__->table("import_batches"); default_value: current_timestamp is_nullable: 0 +date and time the file was uploaded + =head2 overlay_action data_type: 'enum' @@ -71,6 +81,8 @@ __PACKAGE__->table("import_batches"); extra: {list => ["replace","create_new","use_template","ignore"]} is_nullable: 0 +how to handle duplicate records + =head2 nomatch_action data_type: 'enum' @@ -78,6 +90,8 @@ __PACKAGE__->table("import_batches"); extra: {list => ["create_new","ignore"]} is_nullable: 0 +how to handle records where no match is found + =head2 item_action data_type: 'enum' @@ -85,6 +99,8 @@ __PACKAGE__->table("import_batches"); extra: {list => ["always_add","add_only_for_matches","add_only_for_new","ignore","replace"]} is_nullable: 0 +what to do with item records + =head2 import_status data_type: 'enum' @@ -92,6 +108,8 @@ __PACKAGE__->table("import_batches"); extra: {list => ["staging","staged","importing","imported","reverting","reverted","cleaned"]} is_nullable: 0 +the status of the imported file + =head2 batch_type data_type: 'enum' @@ -99,6 +117,8 @@ __PACKAGE__->table("import_batches"); extra: {list => ["batch","z3950","webservice"]} is_nullable: 0 +where this batch has come from + =head2 record_type data_type: 'enum' @@ -106,17 +126,23 @@ __PACKAGE__->table("import_batches"); extra: {list => ["biblio","auth","holdings"]} is_nullable: 0 +type of record in the batch + =head2 file_name data_type: 'varchar' is_nullable: 1 size: 100 +the name of the file uploaded + =head2 comments data_type: 'longtext' is_nullable: 1 +any comments added when the file was uploaded + =head2 profile_id data_type: 'integer' @@ -263,8 +289,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-11-06 13:52:29 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nnGJ0Nvgiz123+ic7v0GqQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+/u1tQQzT5ygzGwVgWxxwg =head2 koha_object_class diff --git a/Koha/Schema/Result/ImportBatchProfile.pm b/Koha/Schema/Result/ImportBatchProfile.pm index fb309cde71..faf19433ff 100644 --- a/Koha/Schema/Result/ImportBatchProfile.pm +++ b/Koha/Schema/Result/ImportBatchProfile.pm @@ -29,68 +29,92 @@ __PACKAGE__->table("import_batch_profiles"); is_auto_increment: 1 is_nullable: 0 +unique identifier and primary key + =head2 name data_type: 'varchar' is_nullable: 0 size: 100 +name of this profile + =head2 matcher_id data_type: 'integer' is_nullable: 1 +the id of the match rule used (matchpoints.matcher_id) + =head2 template_id data_type: 'integer' is_nullable: 1 +the id of the marc modification template + =head2 overlay_action data_type: 'varchar' is_nullable: 1 size: 50 +how to handle duplicate records + =head2 nomatch_action data_type: 'varchar' is_nullable: 1 size: 50 +how to handle records where no match is found + =head2 item_action data_type: 'varchar' is_nullable: 1 size: 50 +what to do with item records + =head2 parse_items data_type: 'tinyint' is_nullable: 1 +should items be parsed + =head2 record_type data_type: 'varchar' is_nullable: 1 size: 50 +type of record in the batch + =head2 encoding data_type: 'varchar' is_nullable: 1 size: 50 +file encoding + =head2 format data_type: 'varchar' is_nullable: 1 size: 50 +marc format + =head2 comments data_type: 'longtext' is_nullable: 1 +any comments added when the file was uploaded + =cut __PACKAGE__->add_columns( @@ -164,8 +188,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-11-06 13:52:29 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kThbQZTT2c0fuWAGgvoDLQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RmvuwPN8RT+tBsxR+Q7unA # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/ImportRecordMatch.pm b/Koha/Schema/Result/ImportRecordMatch.pm index 0ea5d56914..2350d376a6 100644 --- a/Koha/Schema/Result/ImportRecordMatch.pm +++ b/Koha/Schema/Result/ImportRecordMatch.pm @@ -29,17 +29,23 @@ __PACKAGE__->table("import_record_matches"); is_foreign_key: 1 is_nullable: 0 +the id given to the imported bib record (import_records.import_record_id) + =head2 candidate_match_id data_type: 'integer' is_nullable: 0 +the biblio the imported record matches (biblio.biblionumber) + =head2 score data_type: 'integer' default_value: 0 is_nullable: 0 +the match score + =cut __PACKAGE__->add_columns( @@ -69,8 +75,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hJW36EeP+H8+0/Ij3iuIFw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kWU/SGWvZBBvVwEvDysrtA # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Issue.pm b/Koha/Schema/Result/Issue.pm index 24f69275d7..541f4c3501 100644 --- a/Koha/Schema/Result/Issue.pm +++ b/Koha/Schema/Result/Issue.pm @@ -29,72 +29,96 @@ __PACKAGE__->table("issues"); is_auto_increment: 1 is_nullable: 0 +primary key for issues table + =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +foreign key, linking this to the borrowers table for the patron this item was checked out to + =head2 issuer_id data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +foreign key, linking this to the borrowers table for the user who checked out this item + =head2 itemnumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +foreign key, linking this to the items table for the item that was checked out + =head2 date_due data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +datetime the item is due (yyyy-mm-dd hh:mm::ss) + =head2 branchcode data_type: 'varchar' is_nullable: 1 size: 10 +foreign key, linking to the branches table for the location the item was checked out + =head2 returndate data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +date the item was returned, will be NULL until moved to old_issues + =head2 lastreneweddate data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +date the item was last renewed + =head2 renewals data_type: 'tinyint' default_value: 0 is_nullable: 0 +lists the number of times the item was renewed + =head2 unseen_renewals data_type: 'tinyint' default_value: 0 is_nullable: 0 +lists the number of consecutive times the item was renewed without being seen + =head2 auto_renew data_type: 'tinyint' default_value: 0 is_nullable: 1 +automatic renewal + =head2 auto_renew_error data_type: 'varchar' is_nullable: 1 size: 32 +automatic renewal error + =head2 timestamp data_type: 'timestamp' @@ -102,34 +126,46 @@ __PACKAGE__->table("issues"); default_value: current_timestamp is_nullable: 0 +the date and time this record was last touched + =head2 issuedate data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +date the item was checked out or issued + =head2 onsite_checkout data_type: 'integer' default_value: 0 is_nullable: 0 +in house use flag + =head2 note data_type: 'longtext' is_nullable: 1 +issue note text + =head2 notedate data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +datetime of issue note (yyyy-mm-dd hh:mm::ss) + =head2 noteseen data_type: 'integer' is_nullable: 1 +describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null + =cut __PACKAGE__->add_columns( @@ -300,8 +336,8 @@ __PACKAGE__->might_have( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-11-11 14:23:25 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SbeR9Pgvk2sMd+dYPAiCeA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CthteyTlda7sJnOS/TI2Eg __PACKAGE__->add_columns( '+auto_renew' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm index cd22433ad2..1d818126a4 100644 --- a/Koha/Schema/Result/Item.pm +++ b/Koha/Schema/Result/Item.pm @@ -29,6 +29,8 @@ __PACKAGE__->table("items"); is_auto_increment: 1 is_nullable: 0 +primary key and unique identifier added by Koha + =head2 biblionumber data_type: 'integer' @@ -36,6 +38,8 @@ __PACKAGE__->table("items"); is_foreign_key: 1 is_nullable: 0 +foreign key from biblio table used to link this item to the right bib record + =head2 biblioitemnumber data_type: 'integer' @@ -43,23 +47,31 @@ __PACKAGE__->table("items"); is_foreign_key: 1 is_nullable: 0 +foreign key from the biblioitems table to link to item to additional information + =head2 barcode data_type: 'varchar' is_nullable: 1 size: 20 +item barcode (MARC21 952$p) + =head2 dateaccessioned data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +date the item was acquired or added to Koha (MARC21 952$d) + =head2 booksellerid data_type: 'longtext' is_nullable: 1 +where the item was purchased (MARC21 952$e) + =head2 homebranch data_type: 'varchar' @@ -67,36 +79,48 @@ __PACKAGE__->table("items"); is_nullable: 1 size: 10 +foreign key from the branches table for the library that owns this item (MARC21 952$a) + =head2 price data_type: 'decimal' is_nullable: 1 size: [8,2] +purchase price (MARC21 952$g) + =head2 replacementprice data_type: 'decimal' is_nullable: 1 size: [8,2] +cost the library charges to replace the item if it has been marked lost (MARC21 952$v) + =head2 replacementpricedate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +the date the price is effective from (MARC21 952$w) + =head2 datelastborrowed data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +the date the item was last checked out/issued + =head2 datelastseen data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +the date the item was last see (usually the last time the barcode was scanned or inventory was done) + =head2 stack data_type: 'tinyint' @@ -108,85 +132,115 @@ __PACKAGE__->table("items"); default_value: 0 is_nullable: 0 +authorized value defining why this item is not for loan (MARC21 952$7) + =head2 damaged data_type: 'tinyint' default_value: 0 is_nullable: 0 +authorized value defining this item as damaged (MARC21 952$4) + =head2 damaged_on data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +the date and time an item was last marked as damaged, NULL if not damaged + =head2 itemlost data_type: 'tinyint' default_value: 0 is_nullable: 0 +authorized value defining this item as lost (MARC21 952$1) + =head2 itemlost_on data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +the date and time an item was last marked as lost, NULL if not lost + =head2 withdrawn data_type: 'tinyint' default_value: 0 is_nullable: 0 +authorized value defining this item as withdrawn (MARC21 952$0) + =head2 withdrawn_on data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +the date and time an item was last marked as withdrawn, NULL if not withdrawn + =head2 itemcallnumber data_type: 'varchar' is_nullable: 1 size: 255 +call number for this item (MARC21 952$o) + =head2 coded_location_qualifier data_type: 'varchar' is_nullable: 1 size: 10 +coded location qualifier(MARC21 952$f) + =head2 issues data_type: 'smallint' default_value: 0 is_nullable: 1 +number of times this item has been checked out/issued + =head2 renewals data_type: 'smallint' is_nullable: 1 +number of times this item has been renewed + =head2 reserves data_type: 'smallint' is_nullable: 1 +number of times this item has been placed on hold/reserved + =head2 restricted data_type: 'tinyint' is_nullable: 1 +authorized value defining use restrictions for this item (MARC21 952$5) + =head2 itemnotes data_type: 'longtext' is_nullable: 1 +public notes on this item (MARC21 952$z) + =head2 itemnotes_nonpublic data_type: 'longtext' is_nullable: 1 +non-public notes on this item (MARC21 952$x) + =head2 holdingbranch data_type: 'varchar' @@ -194,6 +248,8 @@ __PACKAGE__->table("items"); is_nullable: 1 size: 10 +foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) + =head2 timestamp data_type: 'timestamp' @@ -201,91 +257,123 @@ __PACKAGE__->table("items"); default_value: current_timestamp is_nullable: 0 +date and time this item was last altered + =head2 location data_type: 'varchar' is_nullable: 1 size: 80 +authorized value for the shelving location for this item (MARC21 952$c) + =head2 permanent_location data_type: 'varchar' is_nullable: 1 size: 80 +linked to the CART and PROC temporary locations feature, stores the permanent shelving location + =head2 onloan data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +defines if item is checked out (NULL for not checked out, and due date for checked out) + =head2 cn_source data_type: 'varchar' is_nullable: 1 size: 10 +classification source used on this item (MARC21 952$2) + =head2 cn_sort data_type: 'varchar' is_nullable: 1 size: 255 +normalized form of the call number (MARC21 952$o) used for sorting + =head2 ccode data_type: 'varchar' is_nullable: 1 size: 80 +authorized value for the collection code associated with this item (MARC21 952$8) + =head2 materials data_type: 'mediumtext' is_nullable: 1 +materials specified (MARC21 952$3) + =head2 uri data_type: 'mediumtext' is_nullable: 1 +URL for the item (MARC21 952$u) + =head2 itype data_type: 'varchar' is_nullable: 1 size: 10 +foreign key from the itemtypes table defining the type for this item (MARC21 952$y) + =head2 more_subfields_xml data_type: 'longtext' is_nullable: 1 +additional 952 subfields in XML format + =head2 enumchron data_type: 'mediumtext' is_nullable: 1 +serial enumeration/chronology for the item (MARC21 952$h) + =head2 copynumber data_type: 'varchar' is_nullable: 1 size: 32 +copy number (MARC21 952$t) + =head2 stocknumber data_type: 'varchar' is_nullable: 1 size: 32 +inventory number (MARC21 952$i) + =head2 new_status data_type: 'varchar' is_nullable: 1 size: 32 +'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob. + =head2 exclude_from_local_holds_priority data_type: 'tinyint' is_nullable: 1 +Exclude this item from local holds priority + =cut __PACKAGE__->add_columns( @@ -762,8 +850,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-10-12 09:13:32 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pmAVO6LxCb6wAJvfh+rndw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:U5Tm2JfUnfhACRDJ4SpFgQ __PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" ); diff --git a/Koha/Schema/Result/Itemtype.pm b/Koha/Schema/Result/Itemtype.pm index 3a4c46ae1d..266f19ee0f 100644 --- a/Koha/Schema/Result/Itemtype.pm +++ b/Koha/Schema/Result/Itemtype.pm @@ -30,6 +30,8 @@ __PACKAGE__->table("itemtypes"); is_nullable: 0 size: 10 +unique key, a code associated with the item type + =head2 parent_type data_type: 'varchar' @@ -37,75 +39,101 @@ __PACKAGE__->table("itemtypes"); is_nullable: 1 size: 10 +unique key, a code associated with the item type + =head2 description data_type: 'longtext' is_nullable: 1 +a plain text explanation of the item type + =head2 rentalcharge data_type: 'decimal' is_nullable: 1 size: [28,6] +the amount charged when this item is checked out/issued + =head2 rentalcharge_daily data_type: 'decimal' is_nullable: 1 size: [28,6] +the amount charged for each day between checkout date and due date + =head2 rentalcharge_daily_calendar data_type: 'tinyint' default_value: 1 is_nullable: 0 +controls if the daily rental fee is calculated directly or using finesCalendar + =head2 rentalcharge_hourly data_type: 'decimal' is_nullable: 1 size: [28,6] +the amount charged for each hour between checkout date and due date + =head2 rentalcharge_hourly_calendar data_type: 'tinyint' default_value: 1 is_nullable: 0 +controls if the hourly rental fee is calculated directly or using finesCalendar + =head2 defaultreplacecost data_type: 'decimal' is_nullable: 1 size: [28,6] +default replacement cost + =head2 processfee data_type: 'decimal' is_nullable: 1 size: [28,6] +default text be recorded in the column note when the processing fee is applied + =head2 notforloan data_type: 'smallint' is_nullable: 1 +1 if the item is not for loan, 0 if the item is available for loan + =head2 imageurl data_type: 'varchar' is_nullable: 1 size: 200 +URL for the item type icon + =head2 summary data_type: 'mediumtext' is_nullable: 1 +information from the summary field, may include HTML + =head2 checkinmsg data_type: 'varchar' is_nullable: 1 size: 255 +message that is displayed when an item with the given item type is checked in + =head2 checkinmsgtype data_type: 'char' @@ -113,24 +141,32 @@ __PACKAGE__->table("itemtypes"); is_nullable: 0 size: 16 +type (CSS class) for the checkinmsg, can be 'alert' or 'message' + =head2 sip_media_type data_type: 'varchar' is_nullable: 1 size: 3 +SIP2 protocol media type for this itemtype + =head2 hideinopac data_type: 'tinyint' default_value: 0 is_nullable: 0 +Hide the item type from the search options in OPAC + =head2 searchcategory data_type: 'varchar' is_nullable: 1 size: 80 +Group this item type with others with the same value on OPAC search options + =cut __PACKAGE__->add_columns( @@ -287,8 +323,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-08-13 08:14:04 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5RxmTmtrwJJhTZMur1N05A +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:iByLvz6PwhMByZC9bJb8ig __PACKAGE__->add_columns( '+rentalcharge_hourly_calendar' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/LanguageScriptBidi.pm b/Koha/Schema/Result/LanguageScriptBidi.pm index 7272374da4..76f7654811 100644 --- a/Koha/Schema/Result/LanguageScriptBidi.pm +++ b/Koha/Schema/Result/LanguageScriptBidi.pm @@ -29,12 +29,16 @@ __PACKAGE__->table("language_script_bidi"); is_nullable: 1 size: 25 +script subtag, Arab, Hebr, etc. + =head2 bidi data_type: 'varchar' is_nullable: 1 size: 3 +rtl ltr + =cut __PACKAGE__->add_columns( @@ -45,8 +49,8 @@ __PACKAGE__->add_columns( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TBR2kCdB/nvEcdDo8I4rQA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GSnruAebthrEidJqzPY6Yg # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/LanguageSubtagRegistry.pm b/Koha/Schema/Result/LanguageSubtagRegistry.pm index b93780295c..0a47981f0b 100644 --- a/Koha/Schema/Result/LanguageSubtagRegistry.pm +++ b/Koha/Schema/Result/LanguageSubtagRegistry.pm @@ -35,12 +35,16 @@ __PACKAGE__->table("language_subtag_registry"); is_nullable: 1 size: 25 +language-script-region-variant-extension-privateuse + =head2 description data_type: 'varchar' is_nullable: 1 size: 25 +only one of the possible descriptions for ease of reference, see language_descriptions for the complete list + =head2 added data_type: 'date' @@ -81,8 +85,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("id"); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Rauj/sMGM6sskKuMC/XRcQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:M4QL1kgte1o/Wz+XjSduWA # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Letter.pm b/Koha/Schema/Result/Letter.pm index 42fd22a793..62a0d65eaa 100644 --- a/Koha/Schema/Result/Letter.pm +++ b/Koha/Schema/Result/Letter.pm @@ -30,6 +30,8 @@ __PACKAGE__->table("letter"); is_nullable: 0 size: 20 +Koha module that triggers this notice or slip + =head2 code data_type: 'varchar' @@ -37,6 +39,8 @@ __PACKAGE__->table("letter"); is_nullable: 0 size: 20 +unique identifier for this notice or slip + =head2 branchcode data_type: 'varchar' @@ -44,6 +48,8 @@ __PACKAGE__->table("letter"); is_nullable: 0 size: 10 +the branch this notice or slip is used at (branches.branchcode) + =head2 name data_type: 'varchar' @@ -51,12 +57,16 @@ __PACKAGE__->table("letter"); is_nullable: 0 size: 100 +plain text name for this notice or slip + =head2 is_html data_type: 'tinyint' default_value: 0 is_nullable: 1 +does this notice or slip use HTML (1 for yes, 0 for no) + =head2 title data_type: 'varchar' @@ -64,11 +74,15 @@ __PACKAGE__->table("letter"); is_nullable: 0 size: 200 +subject line of the notice + =head2 content data_type: 'mediumtext' is_nullable: 1 +body text for the notice or slip + =head2 message_transport_type data_type: 'varchar' @@ -77,6 +91,8 @@ __PACKAGE__->table("letter"); is_nullable: 0 size: 20 +transport type for this notice + =head2 lang data_type: 'varchar' @@ -84,6 +100,8 @@ __PACKAGE__->table("letter"); is_nullable: 0 size: 25 +lang of the notice + =head2 updated_on data_type: 'timestamp' @@ -91,6 +109,8 @@ __PACKAGE__->table("letter"); default_value: current_timestamp is_nullable: 0 +last modification + =cut __PACKAGE__->add_columns( @@ -170,8 +190,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-09-30 15:33:05 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gjuJZIDufXefljX+aP2TPg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KsiHfYDT9WzuiTET1Y/BhA sub koha_object_class { 'Koha::Notice::Template'; diff --git a/Koha/Schema/Result/LibraryGroup.pm b/Koha/Schema/Result/LibraryGroup.pm index 6ffb7a8ac4..c2cc933e4b 100644 --- a/Koha/Schema/Result/LibraryGroup.pm +++ b/Koha/Schema/Result/LibraryGroup.pm @@ -29,12 +29,16 @@ __PACKAGE__->table("library_groups"); is_auto_increment: 1 is_nullable: 0 +unique id for each group + =head2 parent_id data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +if this is a child group, the id of the parent group + =head2 branchcode data_type: 'varchar' @@ -42,47 +46,63 @@ __PACKAGE__->table("library_groups"); is_nullable: 1 size: 10 +The branchcode of a branch belonging to the parent group + =head2 title data_type: 'varchar' is_nullable: 1 size: 100 +Short description of the goup + =head2 description data_type: 'mediumtext' is_nullable: 1 +Longer explanation of the group, if necessary + =head2 ft_hide_patron_info data_type: 'tinyint' default_value: 0 is_nullable: 0 +Turn on the feature 'Hide patron's info' for this group + =head2 ft_search_groups_opac data_type: 'tinyint' default_value: 0 is_nullable: 0 +Use this group for staff side search groups + =head2 ft_search_groups_staff data_type: 'tinyint' default_value: 0 is_nullable: 0 +Use this group for opac side search groups + =head2 ft_local_hold_group data_type: 'tinyint' default_value: 0 is_nullable: 0 +Use this group to identify libraries as pick up location for holds + =head2 created_on data_type: 'timestamp' datetime_undef_if_invalid: 1 is_nullable: 1 +Date and time of creation + =head2 updated_on data_type: 'timestamp' @@ -90,6 +110,8 @@ __PACKAGE__->table("library_groups"); default_value: current_timestamp is_nullable: 0 +Date and time of last + =cut __PACKAGE__->add_columns( @@ -224,8 +246,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-30 15:43:39 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qg0Ckj0ZBRjSaQgEcvxSZA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WOqjMuJNt1Sh2FUvt3NGxA sub koha_object_class { 'Koha::Library::Group'; diff --git a/Koha/Schema/Result/Linktracker.pm b/Koha/Schema/Result/Linktracker.pm index d36c177a09..7a4e495583 100644 --- a/Koha/Schema/Result/Linktracker.pm +++ b/Koha/Schema/Result/Linktracker.pm @@ -29,32 +29,44 @@ __PACKAGE__->table("linktracker"); is_auto_increment: 1 is_nullable: 0 +primary key identifier + =head2 biblionumber data_type: 'integer' is_nullable: 1 +biblionumber of the record the link is from + =head2 itemnumber data_type: 'integer' is_nullable: 1 +itemnumber if applicable that the link was from + =head2 borrowernumber data_type: 'integer' is_nullable: 1 +borrowernumber who clicked the link + =head2 url data_type: 'mediumtext' is_nullable: 1 +the link itself + =head2 timeclicked data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +the date and time the link was clicked + =cut __PACKAGE__->add_columns( @@ -89,8 +101,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("id"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MSNByG1qh/5CpRYTcLv/gA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dNzvrDz4qAO/rvZaYUEjAg # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Localization.pm b/Koha/Schema/Result/Localization.pm index dec7ebff50..1919258b36 100644 --- a/Koha/Schema/Result/Localization.pm +++ b/Koha/Schema/Result/Localization.pm @@ -47,6 +47,8 @@ __PACKAGE__->table("localization"); is_nullable: 0 size: 25 +could be a foreign key + =head2 translation data_type: 'mediumtext' @@ -98,8 +100,8 @@ __PACKAGE__->set_primary_key("localization_id"); __PACKAGE__->add_unique_constraint("entity_code_lang", ["entity", "code", "lang"]); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4642LmshpGd3JW7YxM5pIA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Elbup2i+1JON+xa38uzd6A # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Message.pm b/Koha/Schema/Result/Message.pm index 4f4237ed6b..1ed5b0e16c 100644 --- a/Koha/Schema/Result/Message.pm +++ b/Koha/Schema/Result/Message.pm @@ -29,29 +29,39 @@ __PACKAGE__->table("messages"); is_auto_increment: 1 is_nullable: 0 +unique identifier assigned by Koha + =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +foreign key linking this message to the borrowers table + =head2 branchcode data_type: 'varchar' is_nullable: 1 size: 10 +foreign key linking the message to the branches table + =head2 message_type data_type: 'varchar' is_nullable: 0 size: 1 +whether the message is for the librarians (L) or the patron (B) + =head2 message data_type: 'mediumtext' is_nullable: 0 +the text of the message + =head2 message_date data_type: 'timestamp' @@ -59,12 +69,16 @@ __PACKAGE__->table("messages"); default_value: current_timestamp is_nullable: 0 +the date and time the message was written + =head2 manager_id data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +creator of message + =cut __PACKAGE__->add_columns( @@ -139,8 +153,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-02-15 13:15:09 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kYM+0CFPm/wdNp7EosdlRw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:EvxjiNgWGReZ9rEVmS5YVw sub koha_object_class { 'Koha::Patron::Message'; diff --git a/Koha/Schema/Result/MiscFile.pm b/Koha/Schema/Result/MiscFile.pm index c194ce0fa0..a9a3e4326f 100644 --- a/Koha/Schema/Result/MiscFile.pm +++ b/Koha/Schema/Result/MiscFile.pm @@ -29,40 +29,54 @@ __PACKAGE__->table("misc_files"); is_auto_increment: 1 is_nullable: 0 +unique id for the file record + =head2 table_tag data_type: 'varchar' is_nullable: 0 size: 255 +usually table name, or arbitrary unique tag + =head2 record_id data_type: 'integer' is_nullable: 0 +record id from the table this file is associated to + =head2 file_name data_type: 'varchar' is_nullable: 0 size: 255 +file name + =head2 file_type data_type: 'varchar' is_nullable: 0 size: 255 +MIME type of the file + =head2 file_description data_type: 'varchar' is_nullable: 1 size: 255 +description given to the file + =head2 file_content data_type: 'longblob' is_nullable: 0 +file content + =head2 date_uploaded data_type: 'timestamp' @@ -70,6 +84,8 @@ __PACKAGE__->table("misc_files"); default_value: current_timestamp is_nullable: 0 +date and time the file was added + =cut __PACKAGE__->add_columns( @@ -109,8 +125,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("file_id"); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2014-05-25 21:17:02 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VWGyKXxK0dqymMsEGCjJxg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pMegXaTV3y1vCURBL1Zsdg # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/NeedMergeAuthority.pm b/Koha/Schema/Result/NeedMergeAuthority.pm index a4e4795e11..88d87e1a91 100644 --- a/Koha/Schema/Result/NeedMergeAuthority.pm +++ b/Koha/Schema/Result/NeedMergeAuthority.pm @@ -29,21 +29,29 @@ __PACKAGE__->table("need_merge_authorities"); is_auto_increment: 1 is_nullable: 0 +unique id + =head2 authid data_type: 'bigint' is_nullable: 0 +reference to original authority record + =head2 authid_new data_type: 'bigint' is_nullable: 1 +reference to optional new authority record + =head2 reportxml data_type: 'mediumtext' is_nullable: 1 +xml showing original reporting tag + =head2 timestamp data_type: 'timestamp' @@ -51,6 +59,8 @@ __PACKAGE__->table("need_merge_authorities"); default_value: current_timestamp is_nullable: 0 +date and time last modified + =head2 done data_type: 'tinyint' @@ -92,8 +102,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("id"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7LzwIYvExKvNgr8/HDZlsg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZGE483WQMHZLpdgAAPHMKg sub koha_object_class { 'Koha::Authority::MergeRequest'; diff --git a/Koha/Schema/Result/OauthAccessToken.pm b/Koha/Schema/Result/OauthAccessToken.pm index 6e14006d0c..acae6ea479 100644 --- a/Koha/Schema/Result/OauthAccessToken.pm +++ b/Koha/Schema/Result/OauthAccessToken.pm @@ -29,17 +29,23 @@ __PACKAGE__->table("oauth_access_tokens"); is_nullable: 0 size: 191 +generarated access token + =head2 client_id data_type: 'varchar' is_nullable: 0 size: 191 +the client id the access token belongs to + =head2 expires data_type: 'integer' is_nullable: 0 +expiration time in seconds + =cut __PACKAGE__->add_columns( @@ -64,8 +70,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("access_token"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-05-09 12:50:58 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:M6tueO6jmJwgmwMrqO1L0Q +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3mL1s811AK45Nn5yPSJSaA sub koha_object_class { 'Koha::OAuthAccessToken'; diff --git a/Koha/Schema/Result/OldIssue.pm b/Koha/Schema/Result/OldIssue.pm index f39389a49a..7d37600caf 100644 --- a/Koha/Schema/Result/OldIssue.pm +++ b/Koha/Schema/Result/OldIssue.pm @@ -28,72 +28,96 @@ __PACKAGE__->table("old_issues"); data_type: 'integer' is_nullable: 0 +primary key for issues table + =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +foreign key, linking this to the borrowers table for the patron this item was checked out to + =head2 issuer_id data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +foreign key, linking this to the borrowers table for the user who checked out this item + =head2 itemnumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +foreign key, linking this to the items table for the item that was checked out + =head2 date_due data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +date the item is due (yyyy-mm-dd) + =head2 branchcode data_type: 'varchar' is_nullable: 1 size: 10 +foreign key, linking to the branches table for the location the item was checked out + =head2 returndate data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +date the item was returned + =head2 lastreneweddate data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +date the item was last renewed + =head2 renewals data_type: 'tinyint' default_value: 0 is_nullable: 0 +lists the number of times the item was renewed + =head2 unseen_renewals data_type: 'tinyint' default_value: 0 is_nullable: 0 +lists the number of consecutive times the item was renewed without being seen + =head2 auto_renew data_type: 'tinyint' default_value: 0 is_nullable: 1 +automatic renewal + =head2 auto_renew_error data_type: 'varchar' is_nullable: 1 size: 32 +automatic renewal error + =head2 timestamp data_type: 'timestamp' @@ -101,34 +125,46 @@ __PACKAGE__->table("old_issues"); default_value: current_timestamp is_nullable: 0 +the date and time this record was last touched + =head2 issuedate data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +date the item was checked out or issued + =head2 onsite_checkout data_type: 'integer' default_value: 0 is_nullable: 0 +in house use flag + =head2 note data_type: 'longtext' is_nullable: 1 +issue note text + =head2 notedate data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +datetime of issue note (yyyy-mm-dd hh:mm::ss) + =head2 noteseen data_type: 'integer' is_nullable: 1 +describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null + =cut __PACKAGE__->add_columns( @@ -270,8 +306,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-11-11 14:23:25 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TvYB0Fiet6DBvDkRf/BRAg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BWwXBAuls9a0HhscR0WlGQ __PACKAGE__->add_columns( '+auto_renew' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/OldReserve.pm b/Koha/Schema/Result/OldReserve.pm index a65cef0814..05174e1566 100644 --- a/Koha/Schema/Result/OldReserve.pm +++ b/Koha/Schema/Result/OldReserve.pm @@ -28,76 +28,102 @@ __PACKAGE__->table("old_reserves"); data_type: 'integer' is_nullable: 0 +primary key + =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +foreign key from the borrowers table defining which patron this hold is for + =head2 reservedate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +the date the hold was places + =head2 biblionumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +foreign key from the biblio table defining which bib record this hold is on + =head2 branchcode data_type: 'varchar' is_nullable: 1 size: 10 +foreign key from the branches table defining which branch the patron wishes to pick this hold up at + =head2 desk_id data_type: 'integer' is_nullable: 1 +foreign key from the desks table defining which desk the patron should pick this hold up at + =head2 notificationdate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +currently unused + =head2 reminderdate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +currently unused + =head2 cancellationdate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +the date this hold was cancelled + =head2 cancellation_reason data_type: 'varchar' is_nullable: 1 size: 80 +optional authorised value CANCELLATION_REASON + =head2 reservenotes data_type: 'longtext' is_nullable: 1 +notes related to this hold + =head2 priority data_type: 'smallint' default_value: 1 is_nullable: 0 +where in the queue the patron sits + =head2 found data_type: 'varchar' is_nullable: 1 size: 1 +a one letter code defining what the status is of the hold is after it has been confirmed + =head2 timestamp data_type: 'timestamp' @@ -105,24 +131,32 @@ __PACKAGE__->table("old_reserves"); default_value: current_timestamp is_nullable: 0 +the date and time this hold was last updated + =head2 itemnumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with + =head2 waitingdate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +the date the item was marked as waiting for the patron at the library + =head2 expirationdate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date) + =head2 lowestPriority accessor: 'lowest_priority' @@ -130,18 +164,24 @@ __PACKAGE__->table("old_reserves"); default_value: 0 is_nullable: 0 +has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no) + =head2 suspend data_type: 'tinyint' default_value: 0 is_nullable: 0 +in this hold suspended (1 for yes, 0 for no) + =head2 suspend_until data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +the date this hold is suspended until (NULL for infinitely) + =head2 itemtype data_type: 'varchar' @@ -149,18 +189,24 @@ __PACKAGE__->table("old_reserves"); is_nullable: 1 size: 10 +If record level hold, the optional itemtype of the item the patron is requesting + =head2 item_level_hold data_type: 'tinyint' default_value: 0 is_nullable: 0 +Is the hpld placed at item level + =head2 non_priority data_type: 'tinyint' default_value: 0 is_nullable: 0 +Is this a non priority hold + =cut __PACKAGE__->add_columns( @@ -321,8 +367,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-11-06 11:00:40 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7weIpuc0RpZ/MxFn94E8dg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aVQsdX811LswCsWyBqkSbQ __PACKAGE__->belongs_to( "item", diff --git a/Koha/Schema/Result/OpacNews.pm b/Koha/Schema/Result/OpacNews.pm index 2f4964ddbc..fc86e19139 100644 --- a/Koha/Schema/Result/OpacNews.pm +++ b/Koha/Schema/Result/OpacNews.pm @@ -30,6 +30,8 @@ __PACKAGE__->table("opac_news"); is_auto_increment: 1 is_nullable: 0 +unique identifier for the news article + =head2 branchcode data_type: 'varchar' @@ -37,6 +39,8 @@ __PACKAGE__->table("opac_news"); is_nullable: 1 size: 10 +branch code users to create branch specific news, NULL is every branch. + =head2 title data_type: 'varchar' @@ -44,11 +48,15 @@ __PACKAGE__->table("opac_news"); is_nullable: 0 size: 250 +title of the news article + =head2 content data_type: 'mediumtext' is_nullable: 0 +the body of your news article + =head2 lang data_type: 'varchar' @@ -56,12 +64,16 @@ __PACKAGE__->table("opac_news"); is_nullable: 0 size: 50 +location for the article (koha is the staff interface, slip is the circulation receipt and language codes are for the opac) + =head2 published_on data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +publication date + =head2 updated_on data_type: 'timestamp' @@ -69,23 +81,31 @@ __PACKAGE__->table("opac_news"); default_value: current_timestamp is_nullable: 0 +last modification + =head2 expirationdate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +date the article is set to expire or no longer be visible + =head2 number data_type: 'integer' is_nullable: 1 +the order in which this article appears in that specific location + =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +The user who created the news article + =cut __PACKAGE__->add_columns( @@ -176,8 +196,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-09-02 12:50:13 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IKAwgZM6jqOTbksraZb21w +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Edd8K7ANL49fG7FKjwyRVQ sub koha_object_class { 'Koha::NewsItem'; diff --git a/Koha/Schema/Result/Overduerule.pm b/Koha/Schema/Result/Overduerule.pm index 1d248ed394..e5c112c2f4 100644 --- a/Koha/Schema/Result/Overduerule.pm +++ b/Koha/Schema/Result/Overduerule.pm @@ -29,6 +29,8 @@ __PACKAGE__->table("overduerules"); is_auto_increment: 1 is_nullable: 0 +unique identifier for the overduerules + =head2 branchcode data_type: 'varchar' @@ -36,6 +38,8 @@ __PACKAGE__->table("overduerules"); is_nullable: 0 size: 10 +foreign key from the branches table to define which branch this rule is for (if blank it's all libraries) + =head2 categorycode data_type: 'varchar' @@ -43,17 +47,23 @@ __PACKAGE__->table("overduerules"); is_nullable: 0 size: 10 +foreign key from the categories table to define which patron category this rule is for + =head2 delay1 data_type: 'integer' is_nullable: 1 +number of days after the item is overdue that the first notice is sent + =head2 letter1 data_type: 'varchar' is_nullable: 1 size: 20 +foreign key from the letter table to define which notice should be sent as the first notice + =head2 debarred1 data_type: 'varchar' @@ -61,11 +71,15 @@ __PACKAGE__->table("overduerules"); is_nullable: 1 size: 1 +is the patron restricted when the first notice is sent (1 for yes, 0 for no) + =head2 delay2 data_type: 'integer' is_nullable: 1 +number of days after the item is overdue that the second notice is sent + =head2 debarred2 data_type: 'varchar' @@ -73,29 +87,39 @@ __PACKAGE__->table("overduerules"); is_nullable: 1 size: 1 +is the patron restricted when the second notice is sent (1 for yes, 0 for no) + =head2 letter2 data_type: 'varchar' is_nullable: 1 size: 20 +foreign key from the letter table to define which notice should be sent as the second notice + =head2 delay3 data_type: 'integer' is_nullable: 1 +number of days after the item is overdue that the third notice is sent + =head2 letter3 data_type: 'varchar' is_nullable: 1 size: 20 +foreign key from the letter table to define which notice should be sent as the third notice + =head2 debarred3 data_type: 'integer' default_value: 0 is_nullable: 1 +is the patron restricted when the third notice is sent (1 for yes, 0 for no) + =cut __PACKAGE__->add_columns( @@ -171,8 +195,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-01-06 12:00:28 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Opfa1YZ3IeQRRbyrbKAkNQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pORigxtC5qztZWHI29mZ/g # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/PatronConsent.pm b/Koha/Schema/Result/PatronConsent.pm index bf0d6e1510..5432676652 100644 --- a/Koha/Schema/Result/PatronConsent.pm +++ b/Koha/Schema/Result/PatronConsent.pm @@ -41,6 +41,8 @@ __PACKAGE__->table("patron_consent"); extra: {list => ["GDPR_PROCESSING"]} is_nullable: 1 +allows for future extension + =head2 given_on data_type: 'datetime' @@ -110,8 +112,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-09-20 13:00:20 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:as3b13eS31zkIPr9uxP7+A +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Rkn/K2jtHPFkGoG4QCmLsw sub koha_object_class { 'Koha::Patron::Consent'; diff --git a/Koha/Schema/Result/PatronList.pm b/Koha/Schema/Result/PatronList.pm index f755f85585..ccb9fb1d5c 100644 --- a/Koha/Schema/Result/PatronList.pm +++ b/Koha/Schema/Result/PatronList.pm @@ -29,18 +29,24 @@ __PACKAGE__->table("patron_lists"); is_auto_increment: 1 is_nullable: 0 +unique identifier + =head2 name data_type: 'varchar' is_nullable: 0 size: 255 +the list's name + =head2 owner data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +borrowernumber of the list creator + =head2 shared data_type: 'tinyint' @@ -105,8 +111,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-18 16:54:33 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ulv0BHLlcWdeLgD6qPxmUQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+gAlf5GQ7YSgAtFIXgqVWw # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/PatronListPatron.pm b/Koha/Schema/Result/PatronListPatron.pm index 441d7a443c..6ff8f0ab67 100644 --- a/Koha/Schema/Result/PatronListPatron.pm +++ b/Koha/Schema/Result/PatronListPatron.pm @@ -29,18 +29,24 @@ __PACKAGE__->table("patron_list_patrons"); is_auto_increment: 1 is_nullable: 0 +unique identifier + =head2 patron_list_id data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +the list this entry is part of + =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +the borrower that is part of this list + =cut __PACKAGE__->add_columns( @@ -97,8 +103,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 21:34:14 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0gmBJbxnHkobBAazvKnY7g +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WEOKHfprX7+detNjQ3pV/g # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Patronimage.pm b/Koha/Schema/Result/Patronimage.pm index 30cf1e0dcc..40fa54dfc4 100644 --- a/Koha/Schema/Result/Patronimage.pm +++ b/Koha/Schema/Result/Patronimage.pm @@ -29,17 +29,23 @@ __PACKAGE__->table("patronimage"); is_foreign_key: 1 is_nullable: 0 +the borrowernumber of the patron this image is attached to (borrowers.borrowernumber) + =head2 mimetype data_type: 'varchar' is_nullable: 0 size: 15 +the format of the image (png, jpg, etc) + =head2 imagefile data_type: 'mediumblob' is_nullable: 0 +the image + =cut __PACKAGE__->add_columns( @@ -81,8 +87,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uuRGyWlemwOH1PCkvhqxdQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DWbMgbxlYcZhGF1YK9fDIA sub koha_object_class { 'Koha::Patron::Image'; diff --git a/Koha/Schema/Result/ProblemReport.pm b/Koha/Schema/Result/ProblemReport.pm index 5df3c7a065..11fed23b42 100644 --- a/Koha/Schema/Result/ProblemReport.pm +++ b/Koha/Schema/Result/ProblemReport.pm @@ -29,6 +29,8 @@ __PACKAGE__->table("problem_reports"); is_auto_increment: 1 is_nullable: 0 +unique identifier assigned by Koha + =head2 title data_type: 'varchar' @@ -36,6 +38,8 @@ __PACKAGE__->table("problem_reports"); is_nullable: 0 size: 40 +report subject line + =head2 content data_type: 'varchar' @@ -43,6 +47,8 @@ __PACKAGE__->table("problem_reports"); is_nullable: 0 size: 255 +report message content + =head2 borrowernumber data_type: 'integer' @@ -50,6 +56,8 @@ __PACKAGE__->table("problem_reports"); is_foreign_key: 1 is_nullable: 0 +the user who created the problem report + =head2 branchcode data_type: 'varchar' @@ -58,17 +66,23 @@ __PACKAGE__->table("problem_reports"); is_nullable: 0 size: 10 +borrower's branch + =head2 username data_type: 'varchar' is_nullable: 1 size: 75 +OPAC username + =head2 problempage data_type: 'text' is_nullable: 1 +page the user triggered the problem report form from + =head2 recipient data_type: 'enum' @@ -76,6 +90,8 @@ __PACKAGE__->table("problem_reports"); extra: {list => ["admin","library"]} is_nullable: 0 +the 'to-address' of the problem report + =head2 created_on data_type: 'timestamp' @@ -83,6 +99,8 @@ __PACKAGE__->table("problem_reports"); default_value: current_timestamp is_nullable: 0 +timestamp of report submission + =head2 status data_type: 'varchar' @@ -90,6 +108,8 @@ __PACKAGE__->table("problem_reports"); is_nullable: 0 size: 6 +status of the report. New, Viewed, Closed + =cut __PACKAGE__->add_columns( @@ -181,8 +201,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-03 12:13:26 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ho9ENAxH51/ZlZO9KD4KOQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ETzDxg5r4N476ZWkK2wviQ # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/PseudonymizedBorrowerAttribute.pm b/Koha/Schema/Result/PseudonymizedBorrowerAttribute.pm index 788de88ecc..0f93710a8d 100644 --- a/Koha/Schema/Result/PseudonymizedBorrowerAttribute.pm +++ b/Koha/Schema/Result/PseudonymizedBorrowerAttribute.pm @@ -29,6 +29,8 @@ __PACKAGE__->table("pseudonymized_borrower_attributes"); is_auto_increment: 1 is_nullable: 0 +Row id field + =head2 transaction_id data_type: 'integer' @@ -42,12 +44,16 @@ __PACKAGE__->table("pseudonymized_borrower_attributes"); is_nullable: 0 size: 10 +foreign key from the borrower_attribute_types table, defines which custom field this value was entered for + =head2 attribute data_type: 'varchar' is_nullable: 1 size: 255 +custom patron field value + =cut __PACKAGE__->add_columns( @@ -106,8 +112,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-11 17:12:17 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:q6CTb8kq83p1bEM+ilfAww +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MFvIdRnRrju9z7J9uurEhQ # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Quote.pm b/Koha/Schema/Result/Quote.pm index 99bcb14f7c..842316a337 100644 --- a/Koha/Schema/Result/Quote.pm +++ b/Koha/Schema/Result/Quote.pm @@ -29,22 +29,30 @@ __PACKAGE__->table("quotes"); is_auto_increment: 1 is_nullable: 0 +unique id for the quote + =head2 source data_type: 'mediumtext' is_nullable: 1 +source/credit for the quote + =head2 text data_type: 'longtext' is_nullable: 0 +text of the quote + =head2 timestamp data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +date and time that the quote last appeared in the opac + =cut __PACKAGE__->add_columns( @@ -75,8 +83,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("id"); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-02-19 11:09:24 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CdcbCjhjmsLLDQ1AAOja7Q +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AsjlfoqGCpt8DKeRpizVjA # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Rating.pm b/Koha/Schema/Result/Rating.pm index a8fe6e436b..a25f1eae72 100644 --- a/Koha/Schema/Result/Rating.pm +++ b/Koha/Schema/Result/Rating.pm @@ -29,17 +29,23 @@ __PACKAGE__->table("ratings"); is_foreign_key: 1 is_nullable: 0 +the borrowernumber of the patron who left this rating (borrowers.borrowernumber) + =head2 biblionumber data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +the biblio this rating is for (biblio.biblionumber) + =head2 rating_value data_type: 'tinyint' is_nullable: 0 +the rating, from 1 to 5 + =head2 timestamp data_type: 'timestamp' @@ -112,8 +118,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YT3jPQbA2TBuOuUXfEt7gQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:wUwI/h1WR8kVGMNCrv/tUQ # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/RepeatableHoliday.pm b/Koha/Schema/Result/RepeatableHoliday.pm index f89f10a2f4..882f063bc1 100644 --- a/Koha/Schema/Result/RepeatableHoliday.pm +++ b/Koha/Schema/Result/RepeatableHoliday.pm @@ -29,6 +29,8 @@ __PACKAGE__->table("repeatable_holidays"); is_auto_increment: 1 is_nullable: 0 +unique identifier assigned by Koha + =head2 branchcode data_type: 'varchar' @@ -36,21 +38,29 @@ __PACKAGE__->table("repeatable_holidays"); is_nullable: 0 size: 10 +foreign key from the branches table, defines which branch this closing is for + =head2 weekday data_type: 'smallint' is_nullable: 1 +day of the week (0=Sunday, 1=Monday, etc) this closing is repeated on + =head2 day data_type: 'smallint' is_nullable: 1 +day of the month this closing is on + =head2 month data_type: 'smallint' is_nullable: 1 +month this closing is in + =head2 title data_type: 'varchar' @@ -58,11 +68,15 @@ __PACKAGE__->table("repeatable_holidays"); is_nullable: 0 size: 50 +title of this closing + =head2 description data_type: 'mediumtext' is_nullable: 0 +description for this closing + =cut __PACKAGE__->add_columns( @@ -112,8 +126,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-20 13:57:27 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bBw2WEvzF5sX+AOteNsPPQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OZykv+F1kgqeLvezCyhvZA # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/ReportsDictionary.pm b/Koha/Schema/Result/ReportsDictionary.pm index e81b1aa52c..edacbab816 100644 --- a/Koha/Schema/Result/ReportsDictionary.pm +++ b/Koha/Schema/Result/ReportsDictionary.pm @@ -29,40 +29,54 @@ __PACKAGE__->table("reports_dictionary"); is_auto_increment: 1 is_nullable: 0 +unique identifier assigned by Koha + =head2 name data_type: 'varchar' is_nullable: 1 size: 255 +name for this definition + =head2 description data_type: 'mediumtext' is_nullable: 1 +description for this definition + =head2 date_created data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +date and time this definition was created + =head2 date_modified data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +date and time this definition was last modified + =head2 saved_sql data_type: 'mediumtext' is_nullable: 1 +SQL snippet for us in reports + =head2 report_area data_type: 'varchar' is_nullable: 1 size: 6 +Koha module this definition is for Circulation, Catalog, Patrons, Acquistions, Accounts) + =cut __PACKAGE__->add_columns( @@ -103,8 +117,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("id"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0akgYM7kqiLxz95xUCdrdQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7r8vJ2yWD3yQCyri+uNSRw # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Reserve.pm b/Koha/Schema/Result/Reserve.pm index 491e200f19..8d0757e24d 100644 --- a/Koha/Schema/Result/Reserve.pm +++ b/Koha/Schema/Result/Reserve.pm @@ -29,6 +29,8 @@ __PACKAGE__->table("reserves"); is_auto_increment: 1 is_nullable: 0 +primary key + =head2 borrowernumber data_type: 'integer' @@ -36,12 +38,16 @@ __PACKAGE__->table("reserves"); is_foreign_key: 1 is_nullable: 0 +foreign key from the borrowers table defining which patron this hold is for + =head2 reservedate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +the date the hold was placed + =head2 biblionumber data_type: 'integer' @@ -49,6 +55,8 @@ __PACKAGE__->table("reserves"); is_foreign_key: 1 is_nullable: 0 +foreign key from the biblio table defining which bib record this hold is on + =head2 branchcode data_type: 'varchar' @@ -56,53 +64,71 @@ __PACKAGE__->table("reserves"); is_nullable: 1 size: 10 +foreign key from the branches table defining which branch the patron wishes to pick this hold up at + =head2 desk_id data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +foreign key from the desks table defining which desk the patron should pick this hold up at + =head2 notificationdate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +currently unused + =head2 reminderdate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +currently unused + =head2 cancellationdate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +the date this hold was cancelled + =head2 cancellation_reason data_type: 'varchar' is_nullable: 1 size: 80 +optional authorised value CANCELLATION_REASON + =head2 reservenotes data_type: 'longtext' is_nullable: 1 +notes related to this hold + =head2 priority data_type: 'smallint' default_value: 1 is_nullable: 0 +where in the queue the patron sits + =head2 found data_type: 'varchar' is_nullable: 1 size: 1 +a one letter code defining what the status is of the hold is after it has been confirmed + =head2 timestamp data_type: 'timestamp' @@ -110,24 +136,32 @@ __PACKAGE__->table("reserves"); default_value: current_timestamp is_nullable: 0 +the date and time this hold was last updated + =head2 itemnumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with + =head2 waitingdate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +the date the item was marked as waiting for the patron at the library + =head2 expirationdate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date) + =head2 lowestPriority accessor: 'lowest_priority' @@ -154,18 +188,24 @@ __PACKAGE__->table("reserves"); is_nullable: 1 size: 10 +If record level hold, the optional itemtype of the item the patron is requesting + =head2 item_level_hold data_type: 'tinyint' default_value: 0 is_nullable: 0 +Is the hpld placed at item level + =head2 non_priority data_type: 'tinyint' default_value: 0 is_nullable: 0 +Is this a non priority hold + =cut __PACKAGE__->add_columns( @@ -381,8 +421,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-11-06 11:00:40 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ue2kNBP+lq8+9NthPiYrrw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BlMb2M0MEmFuTiMSSBEseg __PACKAGE__->belongs_to( "item", diff --git a/Koha/Schema/Result/ReturnClaim.pm b/Koha/Schema/Result/ReturnClaim.pm index f088a80fd6..96f82d5877 100644 --- a/Koha/Schema/Result/ReturnClaim.pm +++ b/Koha/Schema/Result/ReturnClaim.pm @@ -29,71 +29,95 @@ __PACKAGE__->table("return_claims"); is_auto_increment: 1 is_nullable: 0 +Unique ID of the return claim + =head2 itemnumber data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +ID of the item + =head2 issue_id data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +ID of the checkout that triggered the claim + =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +ID of the patron + =head2 notes data_type: 'mediumtext' is_nullable: 1 +Notes about the claim + =head2 created_on data_type: 'timestamp' datetime_undef_if_invalid: 1 is_nullable: 1 +Time and date the claim was created + =head2 created_by data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +ID of the staff member that registered the claim + =head2 updated_on data_type: 'timestamp' datetime_undef_if_invalid: 1 is_nullable: 1 +Time and date of the latest change on the claim (notes) + =head2 updated_by data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +ID of the staff member that updated the claim + =head2 resolution data_type: 'varchar' is_nullable: 1 size: 80 +Resolution code (RETURN_CLAIM_RESOLUTION AVs) + =head2 resolved_on data_type: 'timestamp' datetime_undef_if_invalid: 1 is_nullable: 1 +Time and date the claim was resolved + =head2 resolved_by data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +ID of the staff member that resolved the claim + =cut __PACKAGE__->add_columns( @@ -274,8 +298,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-31 12:18:39 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:a1MJxAPCP8yuYvzkXp5q8w +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qcgfUNzvsOB0UMm/94mZMQ sub koha_objects_class { 'Koha::Checkouts::ReturnClaims'; diff --git a/Koha/Schema/Result/Review.pm b/Koha/Schema/Result/Review.pm index 6c628b41c2..c796e82022 100644 --- a/Koha/Schema/Result/Review.pm +++ b/Koha/Schema/Result/Review.pm @@ -29,35 +29,47 @@ __PACKAGE__->table("reviews"); is_auto_increment: 1 is_nullable: 0 +unique identifier for this comment + =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +foreign key from the borrowers table defining which patron left this comment + =head2 biblionumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +foreign key from the biblio table defining which bibliographic record this comment is for + =head2 review data_type: 'mediumtext' is_nullable: 1 +the body of the comment + =head2 approved data_type: 'tinyint' default_value: 0 is_nullable: 1 +whether this comment has been approved by a librarian (1 for yes, 0 for no) + =head2 datereviewed data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +the date the comment was left + =cut __PACKAGE__->add_columns( @@ -134,8 +146,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gEngecP849wzHprYW7H2tw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1Am1qqe4ETom7ylth3Tvpg # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/SavedSql.pm b/Koha/Schema/Result/SavedSql.pm index 833c4fe21f..dd441fc853 100644 --- a/Koha/Schema/Result/SavedSql.pm +++ b/Koha/Schema/Result/SavedSql.pm @@ -29,28 +29,38 @@ __PACKAGE__->table("saved_sql"); is_auto_increment: 1 is_nullable: 0 +unique id and primary key assigned by Koha + =head2 borrowernumber data_type: 'integer' is_nullable: 1 +the staff member who created this report (borrowers.borrowernumber) + =head2 date_created data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +the date this report was created + =head2 last_modified data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +the date this report was last edited + =head2 savedsql data_type: 'mediumtext' is_nullable: 1 +the SQL for this report + =head2 last_run data_type: 'datetime' @@ -64,17 +74,23 @@ __PACKAGE__->table("saved_sql"); is_nullable: 0 size: 255 +the name of this report + =head2 type data_type: 'varchar' is_nullable: 1 size: 255 +always 1 for tabular + =head2 notes data_type: 'mediumtext' is_nullable: 1 +the notes or description given to this report + =head2 cache_expiry data_type: 'integer' @@ -170,8 +186,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("id"); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-01-23 12:56:39 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:f7wxGGnBk3z6mw2CkaeD9A +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:198dNG9DGQzop+s5IHy7sw __PACKAGE__->add_columns( '+public' => { is_boolean => 1 } diff --git a/Koha/Schema/Result/SearchHistory.pm b/Koha/Schema/Result/SearchHistory.pm index e2886df82c..4765530135 100644 --- a/Koha/Schema/Result/SearchHistory.pm +++ b/Koha/Schema/Result/SearchHistory.pm @@ -29,28 +29,38 @@ __PACKAGE__->table("search_history"); is_auto_increment: 1 is_nullable: 0 +search history id + =head2 userid data_type: 'integer' is_nullable: 0 +the patron who performed the search (borrowers.borrowernumber) + =head2 sessionid data_type: 'varchar' is_nullable: 0 size: 32 +a system generated session id + =head2 query_desc data_type: 'varchar' is_nullable: 0 size: 255 +the search that was performed + =head2 query_cgi data_type: 'mediumtext' is_nullable: 0 +the string to append to the search url to rerun the search + =head2 type data_type: 'varchar' @@ -58,11 +68,15 @@ __PACKAGE__->table("search_history"); is_nullable: 0 size: 16 +search type, must be 'biblio' or 'authority' + =head2 total data_type: 'integer' is_nullable: 0 +the total of results found + =head2 time data_type: 'timestamp' @@ -70,6 +84,8 @@ __PACKAGE__->table("search_history"); default_value: current_timestamp is_nullable: 0 +the date and time the search was run + =cut __PACKAGE__->add_columns( @@ -114,8 +130,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("id"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:d+Qf8sL7wLldvw2qPLoBgQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3NBo7G2g9DhTUj1FT3I3Mw # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Serial.pm b/Koha/Schema/Result/Serial.pm index e3bcadbf6f..46c22cc420 100644 --- a/Koha/Schema/Result/Serial.pm +++ b/Koha/Schema/Result/Serial.pm @@ -29,18 +29,24 @@ __PACKAGE__->table("serial"); is_auto_increment: 1 is_nullable: 0 +unique key for the issue + =head2 biblionumber data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +foreign key for the biblio.biblionumber that this issue is attached to + =head2 subscriptionid data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +foreign key to the subscription.subscriptionid that this issue is part of + =head2 serialseq data_type: 'varchar' @@ -48,70 +54,94 @@ __PACKAGE__->table("serial"); is_nullable: 0 size: 100 +issue information (volume, number, etc) + =head2 serialseq_x data_type: 'varchar' is_nullable: 1 size: 100 +first part of issue information + =head2 serialseq_y data_type: 'varchar' is_nullable: 1 size: 100 +second part of issue information + =head2 serialseq_z data_type: 'varchar' is_nullable: 1 size: 100 +third part of issue information + =head2 status data_type: 'tinyint' default_value: 0 is_nullable: 0 +status code for this issue (see manual for full descriptions) + =head2 planneddate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +date expected + =head2 notes data_type: 'mediumtext' is_nullable: 1 +notes + =head2 publisheddate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +date published + =head2 publisheddatetext data_type: 'varchar' is_nullable: 1 size: 100 +date published (descriptive) + =head2 claimdate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +date claimed + =head2 claims_count data_type: 'integer' default_value: 0 is_nullable: 1 +number of claims made related to this issue + =head2 routingnotes data_type: 'mediumtext' is_nullable: 1 +notes from the routing list + =cut __PACKAGE__->add_columns( @@ -207,8 +237,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-17 09:15:51 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ktCCJzkgRUFpYu857WQONA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SD7llCvCO+/67cXetzRKPQ # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/SpecialHoliday.pm b/Koha/Schema/Result/SpecialHoliday.pm index f398f209f9..a52248f53a 100644 --- a/Koha/Schema/Result/SpecialHoliday.pm +++ b/Koha/Schema/Result/SpecialHoliday.pm @@ -29,6 +29,8 @@ __PACKAGE__->table("special_holidays"); is_auto_increment: 1 is_nullable: 0 +unique identifier assigned by Koha + =head2 branchcode data_type: 'varchar' @@ -36,30 +38,40 @@ __PACKAGE__->table("special_holidays"); is_nullable: 0 size: 10 +foreign key from the branches table, defines which branch this closing is for + =head2 day data_type: 'smallint' default_value: 0 is_nullable: 0 +day of the month this closing is on + =head2 month data_type: 'smallint' default_value: 0 is_nullable: 0 +month this closing is in + =head2 year data_type: 'smallint' default_value: 0 is_nullable: 0 +year this closing is in + =head2 isexception data_type: 'smallint' default_value: 1 is_nullable: 0 +is this a holiday exception to a repeatable holiday (1 for yes, 0 for no) + =head2 title data_type: 'varchar' @@ -67,11 +79,15 @@ __PACKAGE__->table("special_holidays"); is_nullable: 0 size: 50 +title for this closing + =head2 description data_type: 'mediumtext' is_nullable: 0 +description of this closing + =cut __PACKAGE__->add_columns( @@ -123,8 +139,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-20 13:57:27 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cj8Oveni0l6kAR/azmw4SA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:H3PUa5HiJKKfdndKXbmJ6A # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Statistic.pm b/Koha/Schema/Result/Statistic.pm index 4396e4f799..b9911cf63f 100644 --- a/Koha/Schema/Result/Statistic.pm +++ b/Koha/Schema/Result/Statistic.pm @@ -29,57 +29,77 @@ __PACKAGE__->table("statistics"); datetime_undef_if_invalid: 1 is_nullable: 1 +date and time of the transaction + =head2 branch data_type: 'varchar' is_nullable: 1 size: 10 +foreign key, branch where the transaction occurred + =head2 value data_type: 'double precision' is_nullable: 1 size: [16,4] +monetary value associated with the transaction + =head2 type data_type: 'varchar' is_nullable: 1 size: 16 +transaction type (localuse, issue, return, renew, writeoff, payment) + =head2 other data_type: 'longtext' is_nullable: 1 +used by SIP + =head2 itemnumber data_type: 'integer' is_nullable: 1 +foreign key from the items table, links transaction to a specific item + =head2 itemtype data_type: 'varchar' is_nullable: 1 size: 10 +foreign key from the itemtypes table, links transaction to a specific item type + =head2 location data_type: 'varchar' is_nullable: 1 size: 80 +authorized value for the shelving location for this item (MARC21 952$c) + =head2 borrowernumber data_type: 'integer' is_nullable: 1 +foreign key from the borrowers table, links transaction to a specific borrower + =head2 ccode data_type: 'varchar' is_nullable: 1 size: 80 +foreign key from the items table, links transaction to a specific collection code + =cut __PACKAGE__->add_columns( @@ -110,8 +130,8 @@ __PACKAGE__->add_columns( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-04-18 10:07:43 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dzoFXsATo16GZERh8LYT2A +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OjX7bnPQw0SjrCRB2oVr1w # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Stockrotationitem.pm b/Koha/Schema/Result/Stockrotationitem.pm index 1289f97497..970c64a3d6 100644 --- a/Koha/Schema/Result/Stockrotationitem.pm +++ b/Koha/Schema/Result/Stockrotationitem.pm @@ -29,24 +29,32 @@ __PACKAGE__->table("stockrotationitems"); is_foreign_key: 1 is_nullable: 0 +Itemnumber to link to a stage & rota + =head2 stage_id data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +stage ID to link the item to + =head2 indemand data_type: 'tinyint' default_value: 0 is_nullable: 0 +Should this item be skipped for rotation? + =head2 fresh data_type: 'tinyint' default_value: 0 is_nullable: 0 +Flag showing item is only just added to rota + =cut __PACKAGE__->add_columns( @@ -105,8 +113,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-09 15:50:42 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gkOISrUyWYqUHtmqe7ZHug +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:k/nuwkR8IxEq2D/L6PxmxA __PACKAGE__->add_columns( '+indemand' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Stockrotationrota.pm b/Koha/Schema/Result/Stockrotationrota.pm index a719635624..7be85e74af 100644 --- a/Koha/Schema/Result/Stockrotationrota.pm +++ b/Koha/Schema/Result/Stockrotationrota.pm @@ -29,29 +29,39 @@ __PACKAGE__->table("stockrotationrotas"); is_auto_increment: 1 is_nullable: 0 +Stockrotation rota ID + =head2 title data_type: 'varchar' is_nullable: 0 size: 100 +Title for this rota + =head2 description data_type: 'text' is_nullable: 0 +Description for this rota + =head2 cyclical data_type: 'tinyint' default_value: 0 is_nullable: 0 +Should items on this rota keep cycling? + =head2 active data_type: 'tinyint' default_value: 0 is_nullable: 0 +Is this rota currently active? + =cut __PACKAGE__->add_columns( @@ -97,8 +107,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-09 15:50:42 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lTIDZ+w+46Kniub5Tqpqlg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BpWsKESjapNKXaj2bZ1sjg __PACKAGE__->add_columns( '+cyclical' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Stockrotationstage.pm b/Koha/Schema/Result/Stockrotationstage.pm index 845a712b33..a53bdf7a0e 100644 --- a/Koha/Schema/Result/Stockrotationstage.pm +++ b/Koha/Schema/Result/Stockrotationstage.pm @@ -29,17 +29,23 @@ __PACKAGE__->table("stockrotationstages"); is_auto_increment: 1 is_nullable: 0 +Unique stage ID + =head2 position data_type: 'integer' is_nullable: 0 +The position of this stage within its rota + =head2 rota_id data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +The rota this stage belongs to + =head2 branchcode_id data_type: 'varchar' @@ -47,12 +53,16 @@ __PACKAGE__->table("stockrotationstages"); is_nullable: 0 size: 10 +Branch this stage relates to + =head2 duration data_type: 'integer' default_value: 4 is_nullable: 0 +The number of days items shoud occupy this stage + =cut __PACKAGE__->add_columns( @@ -128,8 +138,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-09 15:50:42 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SKkedF8PL3DWma8kv8yYmg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qNvTMdYD3BCwd0McGICpFg # We use DBIx::Class::Ordered to handle stages manipulation. __PACKAGE__->load_components(qw( Ordered )); diff --git a/Koha/Schema/Result/Subscription.pm b/Koha/Schema/Result/Subscription.pm index c002d81853..2d6c322320 100644 --- a/Koha/Schema/Result/Subscription.pm +++ b/Koha/Schema/Result/Subscription.pm @@ -29,12 +29,16 @@ __PACKAGE__->table("subscription"); 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' @@ -42,18 +46,24 @@ __PACKAGE__->table("subscription"); 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' @@ -72,24 +82,32 @@ __PACKAGE__->table("subscription"); 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' @@ -101,6 +119,8 @@ __PACKAGE__->table("subscription"); data_type: 'longtext' is_nullable: 1 +notes + =head2 status data_type: 'varchar' @@ -108,6 +128,8 @@ __PACKAGE__->table("subscription"); is_nullable: 0 size: 100 +status of this subscription + =head2 lastvalue1 data_type: 'integer' @@ -147,17 +169,23 @@ __PACKAGE__->table("subscription"); 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 +any irregularities in the subscription + =head2 skip_serialseq data_type: 'tinyint' @@ -176,12 +204,16 @@ __PACKAGE__->table("subscription"); 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' @@ -197,6 +229,8 @@ __PACKAGE__->table("subscription"); data_type: 'mediumtext' is_nullable: 1 +default call number + =head2 location data_type: 'varchar' @@ -204,6 +238,8 @@ __PACKAGE__->table("subscription"); is_nullable: 1 size: 80 +default shelving location (items.location) + =head2 branchcode data_type: 'varchar' @@ -211,6 +247,8 @@ __PACKAGE__->table("subscription"); is_nullable: 0 size: 10 +default branches (items.homebranch) + =head2 lastbranch data_type: 'varchar' @@ -223,42 +261,56 @@ __PACKAGE__->table("subscription"); 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' @@ -497,8 +549,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-17 09:15:51 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Bw7XzPSvv9fjc9F6+uIBUw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RA/Z4pcP53tB0kXgo0W6fQ __PACKAGE__->has_many( "additional_field_values", diff --git a/Koha/Schema/Result/Subscriptionroutinglist.pm b/Koha/Schema/Result/Subscriptionroutinglist.pm index e218257986..c585737410 100644 --- a/Koha/Schema/Result/Subscriptionroutinglist.pm +++ b/Koha/Schema/Result/Subscriptionroutinglist.pm @@ -29,23 +29,31 @@ __PACKAGE__->table("subscriptionroutinglist"); is_auto_increment: 1 is_nullable: 0 +unique identifier assigned by Koha + =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +foreign key from the borrowers table, defines with patron is on the routing list + =head2 ranking data_type: 'integer' is_nullable: 1 +where the patron stands in line to receive the serial + =head2 subscriptionid data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +foreign key from the subscription table, defines which subscription this routing list is for + =cut __PACKAGE__->add_columns( @@ -120,8 +128,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AK595c56vgTa7ZjwZjberw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:L/6xUg+37bAUntrGWWYlaw sub koha_object_class { 'Koha::Subscription::Routinglist'; diff --git a/Koha/Schema/Result/Suggestion.pm b/Koha/Schema/Result/Suggestion.pm index e493474c57..6acb143b84 100644 --- a/Koha/Schema/Result/Suggestion.pm +++ b/Koha/Schema/Result/Suggestion.pm @@ -29,66 +29,88 @@ __PACKAGE__->table("suggestions"); is_auto_increment: 1 is_nullable: 0 +unique identifier assigned automatically by Koha + =head2 suggestedby data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +borrowernumber for the person making the suggestion, foreign key linking to the borrowers table + =head2 suggesteddate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 0 +date the suggestion was submitted + =head2 managedby data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +borrowernumber for the librarian managing the suggestion, foreign key linking to the borrowers table + =head2 manageddate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +date the suggestion was updated + =head2 acceptedby data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +borrowernumber for the librarian who accepted the suggestion, foreign key linking to the borrowers table + =head2 accepteddate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +date the suggestion was marked as accepted + =head2 rejectedby data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +borrowernumber for the librarian who rejected the suggestion, foreign key linking to the borrowers table + =head2 rejecteddate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +date the suggestion was marked as rejected + =head2 lastmodificationby data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +borrowernumber for the librarian who edit the suggestion for the last time + =head2 lastmodificationdate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 +date of the last modification + =head2 STATUS accessor: 'status' @@ -97,40 +119,54 @@ __PACKAGE__->table("suggestions"); is_nullable: 0 size: 10 +suggestion status (ASKED, CHECKED, ACCEPTED, REJECTED, ORDERED, AVAILABLE or a value from the SUGGEST_STATUS authorised value category) + =head2 archived data_type: 'tinyint' default_value: 0 is_nullable: 0 +is the suggestion archived? + =head2 note data_type: 'longtext' is_nullable: 1 +note entered on the suggestion + =head2 author data_type: 'varchar' is_nullable: 1 size: 80 +author of the suggested item + =head2 title data_type: 'varchar' is_nullable: 1 size: 255 +title of the suggested item + =head2 copyrightdate data_type: 'smallint' is_nullable: 1 +copyright date of the suggested item + =head2 publishercode data_type: 'varchar' is_nullable: 1 size: 255 +publisher of the suggested item + =head2 date data_type: 'timestamp' @@ -138,6 +174,8 @@ __PACKAGE__->table("suggestions"); default_value: current_timestamp is_nullable: 0 +date and time the suggestion was updated + =head2 volumedesc data_type: 'varchar' @@ -156,34 +194,46 @@ __PACKAGE__->table("suggestions"); is_nullable: 1 size: 255 +publication place of the suggested item + =head2 isbn data_type: 'varchar' is_nullable: 1 size: 30 +isbn of the suggested item + =head2 biblionumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +foreign key linking the suggestion to the biblio table after the suggestion has been ordered + =head2 reason data_type: 'mediumtext' is_nullable: 1 +reason for accepting or rejecting the suggestion + =head2 patronreason data_type: 'mediumtext' is_nullable: 1 +reason for making the suggestion + =head2 budgetid data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +foreign key linking the suggested budget to the aqbudgets table + =head2 branchcode data_type: 'varchar' @@ -191,40 +241,54 @@ __PACKAGE__->table("suggestions"); is_nullable: 1 size: 10 +foreign key linking the suggested branch to the branches table + =head2 collectiontitle data_type: 'mediumtext' is_nullable: 1 +collection name for the suggested item + =head2 itemtype data_type: 'varchar' is_nullable: 1 size: 30 +suggested item type + =head2 quantity data_type: 'smallint' is_nullable: 1 +suggested quantity to be purchased + =head2 currency data_type: 'varchar' is_nullable: 1 size: 10 +suggested currency for the suggested price + =head2 price data_type: 'decimal' is_nullable: 1 size: [28,6] +suggested price + =head2 total data_type: 'decimal' is_nullable: 1 size: [28,6] +suggested total cost (price*quantity updated for currency) + =cut __PACKAGE__->add_columns( @@ -484,8 +548,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-14 20:04:28 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BrvQGdgqpODl23IfwbqdUw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3hkIGEbrTi7MUug0zjvyFg __PACKAGE__->belongs_to( "suggester", diff --git a/Koha/Schema/Result/Systempreference.pm b/Koha/Schema/Result/Systempreference.pm index 2ff374e5ca..6b17d816ea 100644 --- a/Koha/Schema/Result/Systempreference.pm +++ b/Koha/Schema/Result/Systempreference.pm @@ -30,27 +30,37 @@ __PACKAGE__->table("systempreferences"); is_nullable: 0 size: 50 +system preference name + =head2 value data_type: 'mediumtext' is_nullable: 1 +system preference values + =head2 options data_type: 'longtext' is_nullable: 1 +options for multiple choice system preferences + =head2 explanation data_type: 'mediumtext' is_nullable: 1 +descriptive text for the system preference + =head2 type data_type: 'varchar' is_nullable: 1 size: 20 +type of question this preference asks (multiple choice, plain text, yes or no, etc) + =cut __PACKAGE__->add_columns( @@ -79,8 +89,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("variable"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QI7OL4VHrXe8FridIOCZ4A +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:d9V4/gPRw1ucbd/TzEzNUQ sub koha_object_class { 'Koha::Config::SysPref'; diff --git a/Koha/Schema/Result/TagAll.pm b/Koha/Schema/Result/TagAll.pm index fbb8894886..90e7cbb56e 100644 --- a/Koha/Schema/Result/TagAll.pm +++ b/Koha/Schema/Result/TagAll.pm @@ -29,35 +29,47 @@ __PACKAGE__->table("tags_all"); is_auto_increment: 1 is_nullable: 0 +unique id and primary key + =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +the patron who added the tag (borrowers.borrowernumber) + =head2 biblionumber data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +the bib record this tag was left on (biblio.biblionumber) + =head2 term data_type: 'varchar' is_nullable: 0 size: 191 +the tag + =head2 language data_type: 'integer' is_nullable: 1 +the language the tag was left in + =head2 date_created data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 0 +the date the tag was added + =cut __PACKAGE__->add_columns( @@ -129,8 +141,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-03-15 13:30:04 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3pY7wv0IRmQBSqr+EghQvw +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qQsYlIAUc1KP7M/RUaqd8g sub koha_object_class { 'Koha::Tag'; diff --git a/Koha/Schema/Result/TagsApproval.pm b/Koha/Schema/Result/TagsApproval.pm index 92b54b708d..4e0bac093b 100644 --- a/Koha/Schema/Result/TagsApproval.pm +++ b/Koha/Schema/Result/TagsApproval.pm @@ -29,30 +29,40 @@ __PACKAGE__->table("tags_approval"); is_nullable: 0 size: 191 +the tag + =head2 approved data_type: 'integer' default_value: 0 is_nullable: 0 +whether the tag is approved or not (1=yes, 0=pending, -1=rejected) + =head2 date_approved data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +the date this tag was approved + =head2 approved_by data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +the librarian who approved the tag (borrowers.borrowernumber) + =head2 weight_total data_type: 'integer' default_value: 1 is_nullable: 0 +the total number of times this tag was used + =cut __PACKAGE__->add_columns( @@ -122,8 +132,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-01-18 08:31:57 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4cvTasSpJ2c1vvVVe/R3UQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PR7rfXKXExWpmkdxcXRrbQ sub koha_object_class { 'Koha::Tags::Approval'; diff --git a/Koha/Schema/Result/TagsIndex.pm b/Koha/Schema/Result/TagsIndex.pm index acc98067ad..ee7a63114b 100644 --- a/Koha/Schema/Result/TagsIndex.pm +++ b/Koha/Schema/Result/TagsIndex.pm @@ -30,18 +30,24 @@ __PACKAGE__->table("tags_index"); is_nullable: 0 size: 191 +the tag + =head2 biblionumber data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +the bib record this tag was used on (biblio.biblionumber) + =head2 weight data_type: 'integer' default_value: 1 is_nullable: 0 +the number of times this term was used on this bib record + =cut __PACKAGE__->add_columns( @@ -100,8 +106,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-01-18 08:31:57 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ewTrnc9D1jcoyf65+MrSGQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:s+HP8nlAKZz2S7PI8MQBOA sub koha_object_class { 'Koha::Tags::Index'; diff --git a/Koha/Schema/Result/Virtualshelfcontent.pm b/Koha/Schema/Result/Virtualshelfcontent.pm index a8ad19d4b0..2708ad4333 100644 --- a/Koha/Schema/Result/Virtualshelfcontent.pm +++ b/Koha/Schema/Result/Virtualshelfcontent.pm @@ -30,6 +30,8 @@ __PACKAGE__->table("virtualshelfcontents"); is_foreign_key: 1 is_nullable: 0 +foreign key linking to the virtualshelves table, defines the list that this record has been added to + =head2 biblionumber data_type: 'integer' @@ -37,6 +39,8 @@ __PACKAGE__->table("virtualshelfcontents"); is_foreign_key: 1 is_nullable: 0 +foreign key linking to the biblio table, defines the bib record that has been added to the list + =head2 flags data_type: 'integer' @@ -49,12 +53,16 @@ __PACKAGE__->table("virtualshelfcontents"); default_value: current_timestamp is_nullable: 0 +date and time this bib record was added to the list + =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +borrower number that created this list entry (only the first one is saved: no need for use in/as key) + =cut __PACKAGE__->add_columns( @@ -138,8 +146,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ie3Gx+/HthZQ/4fHjcPF0w +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4c7f4juRHZXLlSgNwOohrA #TODO See BZ 14544: Should be resolved by db revision __PACKAGE__->set_primary_key("shelfnumber","biblionumber"); diff --git a/Koha/Schema/Result/Virtualshelfshare.pm b/Koha/Schema/Result/Virtualshelfshare.pm index 0adaf2b113..4c1be76d2a 100644 --- a/Koha/Schema/Result/Virtualshelfshare.pm +++ b/Koha/Schema/Result/Virtualshelfshare.pm @@ -29,30 +29,40 @@ __PACKAGE__->table("virtualshelfshares"); is_auto_increment: 1 is_nullable: 0 +unique key + =head2 shelfnumber data_type: 'integer' is_foreign_key: 1 is_nullable: 0 +foreign key for virtualshelves + =head2 borrowernumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +borrower that accepted access to this list + =head2 invitekey data_type: 'varchar' is_nullable: 1 size: 10 +temporary string used in accepting the invitation to access thist list; not-empty means that the invitation has not been accepted yet + =head2 sharedate data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 +date of invitation or acceptance of invitation + =cut __PACKAGE__->add_columns( @@ -122,8 +132,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gle9hUqefRoNSilv0gFc1w +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Aovcx4icmIsaRskB9qUSlA # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Virtualshelve.pm b/Koha/Schema/Result/Virtualshelve.pm index 83334f8ac4..4fa1265959 100644 --- a/Koha/Schema/Result/Virtualshelve.pm +++ b/Koha/Schema/Result/Virtualshelve.pm @@ -29,24 +29,32 @@ __PACKAGE__->table("virtualshelves"); is_auto_increment: 1 is_nullable: 0 +unique identifier assigned by Koha + =head2 shelfname data_type: 'varchar' is_nullable: 1 size: 255 +name of the list + =head2 owner data_type: 'integer' is_foreign_key: 1 is_nullable: 1 +foreign key linking to the borrowers table (using borrowernumber) for the creator of this list (changed from varchar(80) to int) + =head2 category data_type: 'varchar' is_nullable: 1 size: 1 +type of list (private [1], public [2]) + =head2 sortfield data_type: 'varchar' @@ -54,6 +62,8 @@ __PACKAGE__->table("virtualshelves"); is_nullable: 1 size: 16 +the field this list is sorted on + =head2 lastmodified data_type: 'timestamp' @@ -61,24 +71,32 @@ __PACKAGE__->table("virtualshelves"); default_value: current_timestamp is_nullable: 0 +date and time the list was last modified + =head2 created_on data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 0 +creation time + =head2 allow_change_from_owner data_type: 'tinyint' default_value: 1 is_nullable: 1 +can owner change contents? + =head2 allow_change_from_others data_type: 'tinyint' default_value: 0 is_nullable: 1 +can others change contents? + =cut __PACKAGE__->add_columns( @@ -181,8 +199,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-03-08 14:19:17 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Xoq0lhLouCbkAp6F4ZyMGQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6ZQ6kL/0DzyOMymz+4+LhA sub koha_object_class { 'Koha::Virtualshelf'; diff --git a/Koha/Schema/Result/Z3950server.pm b/Koha/Schema/Result/Z3950server.pm index 65ecc2ec1a..36050f7e00 100644 --- a/Koha/Schema/Result/Z3950server.pm +++ b/Koha/Schema/Result/Z3950server.pm @@ -29,62 +29,84 @@ __PACKAGE__->table("z3950servers"); is_auto_increment: 1 is_nullable: 0 +unique identifier assigned by Koha + =head2 host data_type: 'varchar' is_nullable: 1 size: 255 +target's host name + =head2 port data_type: 'integer' is_nullable: 1 +port number used to connect to target + =head2 db data_type: 'varchar' is_nullable: 1 size: 255 +target's database name + =head2 userid data_type: 'varchar' is_nullable: 1 size: 255 +username needed to log in to target + =head2 password data_type: 'varchar' is_nullable: 1 size: 255 +password needed to log in to target + =head2 servername data_type: 'longtext' is_nullable: 0 +name given to the target by the library + =head2 checked data_type: 'smallint' is_nullable: 1 +whether this target is checked by default (1 for yes, 0 for no) + =head2 rank data_type: 'integer' is_nullable: 1 +where this target appears in the list of targets + =head2 syntax data_type: 'varchar' is_nullable: 1 size: 80 +marc format provided by this target + =head2 timeout data_type: 'integer' default_value: 0 is_nullable: 0 +number of seconds before Koha stops trying to access this server + =head2 servertype data_type: 'enum' @@ -92,11 +114,15 @@ __PACKAGE__->table("z3950servers"); extra: {list => ["zed","sru"]} is_nullable: 0 +zed means z39.50 server + =head2 encoding data_type: 'mediumtext' is_nullable: 1 +characters encoding provided by this target + =head2 recordtype data_type: 'enum' @@ -104,28 +130,38 @@ __PACKAGE__->table("z3950servers"); extra: {list => ["authority","biblio"]} is_nullable: 0 +server contains bibliographic or authority records + =head2 sru_options data_type: 'varchar' is_nullable: 1 size: 255 +options like sru=get, sru_version=1.1; will be passed to the server via ZOOM + =head2 sru_fields data_type: 'longtext' is_nullable: 1 +contains the mapping between the Z3950 search fields and the specific SRU server indexes + =head2 add_xslt data_type: 'longtext' is_nullable: 1 +zero or more paths to XSLT files to be processed on the search results + =head2 attributes data_type: 'varchar' is_nullable: 1 size: 255 +additional attributes passed to PQF queries + =cut __PACKAGE__->add_columns( @@ -190,8 +226,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("id"); -# Created by DBIx::Class::Schema::Loader v0.07047 @ 2018-02-20 01:04:22 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YUp6TnDwq7/oLaSmSdVE3A +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6X1cn33CRBtk/lMZF8QY2Q sub koha_object_class { 'Koha::Z3950Server'; -- 2.39.5