From fe5d39b7b8682de308806c880a1a5279ee9fee7e Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Thu, 21 Jan 2021 06:57:42 -0500 Subject: [PATCH] Bug 26995: Update schema [DO NOT PUSH] --- 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 | 160 +++++++++++++++++- 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 | 14 +- .../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 | 160 +++++++++++++++++- 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, 2490 insertions(+), 240 deletions(-) diff --git a/Koha/Schema/Result/AccountCreditType.pm b/Koha/Schema/Result/AccountCreditType.pm index 602b1fd7e9..b71e3ba7f9 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:68pbi2+RgkjSrfSudDNAfA __PACKAGE__->add_columns( '+is_system' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/AccountDebitType.pm b/Koha/Schema/Result/AccountDebitType.pm index 8772813c2e..56f732e826 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mAzmSdW6jeYlUOqv7lIr1Q __PACKAGE__->add_columns( '+is_system' => { is_boolean => 1 } diff --git a/Koha/Schema/Result/AccountOffset.pm b/Koha/Schema/Result/AccountOffset.pm index 02751ae83a..5f65322b10 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HZp7Ilze0sIkVqhsErC2kQ sub koha_object_class { 'Koha::Account::Offset'; diff --git a/Koha/Schema/Result/AccountOffsetType.pm b/Koha/Schema/Result/AccountOffsetType.pm index fd62a02969..c61e44d70d 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IhGFWPAnwAb88g3BBUe01Q # 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..5f21a0a14b 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/Ve0Q3xBSkKamXG+2roUZw =head2 library diff --git a/Koha/Schema/Result/ActionLog.pm b/Koha/Schema/Result/ActionLog.pm index 78236ea9eb..c48b0311fd 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AD9G0KiiFUmhsS9m8O1Z+w # 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..afd2c2a31a 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0MjMrOzpCHJGtrwtLzF7Hw # 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..a4ce2786a0 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nx5E23ZVUbLOGfBgLYIIQQ # 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..88ff46ed2e 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hE2MSdkkb71NoBpDM1jo5A __PACKAGE__->add_columns( '+shared' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/ApiKey.pm b/Koha/Schema/Result/ApiKey.pm index f8e091fbb7..538986cf9c 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Wt1nC+nAMD9+zcNi9YbTEQ __PACKAGE__->add_columns( '+active' => { is_boolean => 1 } diff --git a/Koha/Schema/Result/Aqbasket.pm b/Koha/Schema/Result/Aqbasket.pm index 60d5633a58..72a69c0ae4 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Alq0lbSwRP7DUVIHJoHZpQ __PACKAGE__->has_many( "additional_field_values", diff --git a/Koha/Schema/Result/Aqbookseller.pm b/Koha/Schema/Result/Aqbookseller.pm index a9bf2e51bd..b5429e8b6a 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rKz25TwTWSmdrEgVCrVbMQ __PACKAGE__->add_columns( '+active' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Aqbudget.pm b/Koha/Schema/Result/Aqbudget.pm index e645e55432..6c1cb826f2 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vmww5X6TKh/6iWnXt+xc1w __PACKAGE__->belongs_to( "budget", diff --git a/Koha/Schema/Result/Aqbudgetperiod.pm b/Koha/Schema/Result/Aqbudgetperiod.pm index 5ae2c98e81..03980ae568 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hWHx+2tHfiRhRqj3YchPnw sub koha_object_class { 'Koha::Acquisition::Budget'; diff --git a/Koha/Schema/Result/Aqcontact.pm b/Koha/Schema/Result/Aqcontact.pm index 0de8efc761..a802259d39 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:O7JzmE0CiJ7iDfvyCi4QrA __PACKAGE__->add_columns( '+orderacquisition' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Aqinvoice.pm b/Koha/Schema/Result/Aqinvoice.pm index fe1f8f265e..f0cc9ace89 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jOZUccjnTE+Tzd3ivMs6Uw sub koha_object_class { 'Koha::Acquisition::Invoice'; diff --git a/Koha/Schema/Result/AqinvoiceAdjustment.pm b/Koha/Schema/Result/AqinvoiceAdjustment.pm index 16bc45acb2..65ca59f654 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:L3lnMcRFhpTnAJCNPfZ45g sub koha_object_class { 'Koha::Acquisition::Invoice::Adjustment'; diff --git a/Koha/Schema/Result/Aqorder.pm b/Koha/Schema/Result/Aqorder.pm index f873aa6da3..be330dd77a 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TfwIBYIVTqp9qOqenaoHxQ __PACKAGE__->belongs_to( "basket", diff --git a/Koha/Schema/Result/AqorderUser.pm b/Koha/Schema/Result/AqorderUser.pm index 54750d4ce5..35c37ac5c4 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BHsb47cCXXZ1LO4vMV0T2g # 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..6913b4748e 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cDtOodtFZfM/s/1DA/RFWA sub koha_object_class { 'Koha::Acquisition::Order::Claim'; diff --git a/Koha/Schema/Result/AqordersItem.pm b/Koha/Schema/Result/AqordersItem.pm index ac99f2e10c..68c11cf8e1 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:K/7cgnLhY6csXVYfo2rtkw # 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..d5e273a330 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5gT5YreB/oDegz6Lgo8/xA # 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..6c59455949 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mhh5q7kqI+gH2sbu8y9uQA # 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..50d6a60741 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7g/qaNBJwsmAm6nh6mIr6A __PACKAGE__->has_one( diff --git a/Koha/Schema/Result/BiblioFramework.pm b/Koha/Schema/Result/BiblioFramework.pm index 93ed47386b..b021aea927 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:r15t5YxeOpHFq6VRfEYYQg # 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..111afe453f 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rDwWn5ndpGmmhgusk8SmAA __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..5f92e2d56d 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,71 +278,89 @@ __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 -=head2 relationship - - data_type: 'varchar' - is_nullable: 1 - size: 100 +a note on the patron/borrower's account that is only visible in the staff interface =head2 sex @@ -284,121 +368,165 @@ __PACKAGE__->table("borrowers"); 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 +534,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 +543,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 +560,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( @@ -554,8 +698,6 @@ __PACKAGE__->add_columns( { data_type => "mediumtext", is_nullable => 1 }, "borrowernotes", { data_type => "longtext", is_nullable => 1 }, - "relationship", - { data_type => "varchar", is_nullable => 1, size => 100 }, "sex", { data_type => "varchar", is_nullable => 1, size => 1 }, "password", @@ -1713,8 +1855,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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:p19R3ym2b7Es0K4bGRlYOw __PACKAGE__->add_columns( '+anonymized' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/BorrowerAttribute.pm b/Koha/Schema/Result/BorrowerAttribute.pm index 2a8398ad68..9f32ece8a0 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TJaujD5jDExU+B8X9ALeww =head2 borrower_attribute_types diff --git a/Koha/Schema/Result/BorrowerAttributeType.pm b/Koha/Schema/Result/BorrowerAttributeType.pm index 1d807f5081..ea343e4b4c 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.07046 @ 2021-01-21 11:55:30 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6AOwZeATSu2jBEaTiZ7tpQ __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..243f4afaec 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VgmNUSJuF4edkufZh/+r5Q # 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..6b2e48a05a 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:W42furxlvGDZDwgtppaavw # 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..731f2879a8 100644 --- a/Koha/Schema/Result/BorrowerModification.pm +++ b/Koha/Schema/Result/BorrowerModification.pm @@ -295,12 +295,6 @@ __PACKAGE__->table("borrower_modifications"); data_type: 'longtext' is_nullable: 1 -=head2 relationship - - data_type: 'varchar' - is_nullable: 1 - size: 100 - =head2 sex data_type: 'varchar' @@ -421,6 +415,8 @@ __PACKAGE__->table("borrower_modifications"); datetime_undef_if_invalid: 1 is_nullable: 1 +data processing consent + =cut __PACKAGE__->add_columns( @@ -545,8 +541,6 @@ __PACKAGE__->add_columns( { data_type => "mediumtext", is_nullable => 1 }, "borrowernotes", { data_type => "longtext", is_nullable => 1 }, - "relationship", - { data_type => "varchar", is_nullable => 1, size => 100 }, "sex", { data_type => "varchar", is_nullable => 1, size => 1 }, "password", @@ -610,8 +604,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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Vzqe4y1VKlPzSCi8dc72GQ sub koha_object_class { 'Koha::Patron::Modification'; diff --git a/Koha/Schema/Result/BorrowerPasswordRecovery.pm b/Koha/Schema/Result/BorrowerPasswordRecovery.pm index c7f567d102..d06e5a6237 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/KE+MtQb53sAtv1PLOH6xw # 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..de3d023eea 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FUQJRPdycQ8UH7ddEp/ZmQ __PACKAGE__->add_columns( '+pickup_location' => { is_boolean => 1 } diff --git a/Koha/Schema/Result/Branchtransfer.pm b/Koha/Schema/Result/Branchtransfer.pm index 7fc813e507..6d0cb0a828 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IEqGHqb6OH7sn8Cf1ea64Q sub koha_object_class { 'Koha::Item::Transfer'; diff --git a/Koha/Schema/Result/CashRegister.pm b/Koha/Schema/Result/CashRegister.pm index 6cb01e7848..3c9e664b72 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Hg0mW8a2VRb6Pm5FfcnuQw __PACKAGE__->add_columns( '+archived' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/CashRegisterAction.pm b/Koha/Schema/Result/CashRegisterAction.pm index 6643a73a85..8409c0eba2 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:skIDbja7UDxRbMZ0zqMgDQ sub koha_objects_class { 'Koha::Cash::Register::Actions'; diff --git a/Koha/Schema/Result/Category.pm b/Koha/Schema/Result/Category.pm index 0fdac2cc7c..b34f435e7a 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:K1jfTo+O5QHkRxrss9Xs3Q __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..9d561bbee7 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YFqwNwP1HDwU1TcJyn1SQw sub koha_objects_class { 'Koha::Cities'; diff --git a/Koha/Schema/Result/ClubHold.pm b/Koha/Schema/Result/ClubHold.pm index fca4b51046..39538cc498 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:NE3PDCJ01WPZr5THKRrhiQ sub koha_objects_class { 'Koha::Club::Holds'; diff --git a/Koha/Schema/Result/Collection.pm b/Koha/Schema/Result/Collection.pm index f8c3d8e46b..0b39d0ddeb 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:csLFex12w89wWao3pJikFA # 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..d3b56279d8 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ePAT/DLyVd0BklkxL6q3Jg # 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..d01f4d33b0 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:srMXE9huuvvZXpiLXkHMuA sub koha_objects_class { 'Koha::Course::Instructors'; diff --git a/Koha/Schema/Result/CourseItem.pm b/Koha/Schema/Result/CourseItem.pm index 495cf77964..05f574ac45 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:D5zO+P3v2EPLTS6dde4YMw __PACKAGE__->add_columns( '+itype_enabled' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/CourseReserve.pm b/Koha/Schema/Result/CourseReserve.pm index 8bb41cbb23..2a3616cfab 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jPqC4AvNvugDK1fZIssJyw sub koha_objects_class { 'Koha::Course::Reserves'; diff --git a/Koha/Schema/Result/CoverImage.pm b/Koha/Schema/Result/CoverImage.pm index d8e9854132..61d15a5ca8 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LdHgdqpdXRqSSklRec/2Uw # 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..cc16cca535 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rE4YoB/41fCiKbzQaUR8XQ sub koha_objects_class { 'Koha::Old::Biblios'; diff --git a/Koha/Schema/Result/Deletedbiblioitem.pm b/Koha/Schema/Result/Deletedbiblioitem.pm index e2849ecd99..faa03ed201 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QmikL038NhPIMxp1MrZsbg sub koha_objects_class { 'Koha::Old::Biblioitems'; diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm index d091fe98bd..c59bd07883 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,71 +276,89 @@ __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 -=head2 relationship - - data_type: 'varchar' - is_nullable: 1 - size: 100 +a note on the patron/borrower's account that is only visible in the staff interface =head2 sex @@ -282,120 +366,164 @@ __PACKAGE__->table("deletedborrowers"); 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 +531,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 +540,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 +557,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( @@ -539,8 +683,6 @@ __PACKAGE__->add_columns( { data_type => "mediumtext", is_nullable => 1 }, "borrowernotes", { data_type => "longtext", is_nullable => 1 }, - "relationship", - { data_type => "varchar", is_nullable => 1, size => 100 }, "sex", { data_type => "varchar", is_nullable => 1, size => 1 }, "password", @@ -623,8 +765,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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UyLvm5ZrVFTPYwsI0yzNfQ __PACKAGE__->add_columns( '+anonymized' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Deleteditem.pm b/Koha/Schema/Result/Deleteditem.pm index fbed06c6ce..e6922c92c6 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kwBP6OCpv5LAt5GWGlrTgw __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..2aee4fc909 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JGE5AStMT8DONyO4EHWtTg # 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..dfb8f20c6d 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Kn8ysQJBBMF8hNU8sRrlig sub koha_object_class { 'Koha::Patron::HouseboundProfile'; diff --git a/Koha/Schema/Result/HouseboundRole.pm b/Koha/Schema/Result/HouseboundRole.pm index 7c1489ed33..679faf5558 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VDQ+m99d4dXk8GOeXxSELQ sub koha_object_class { 'Koha::Patron::HouseboundRole'; diff --git a/Koha/Schema/Result/HouseboundVisit.pm b/Koha/Schema/Result/HouseboundVisit.pm index 4f3b402bc4..e560a8750e 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Prm180VwMowL77YrM+1z+g sub koha_object_class { 'Koha::Patron::HouseboundVisit'; diff --git a/Koha/Schema/Result/Illcomment.pm b/Koha/Schema/Result/Illcomment.pm index 04a04370c4..2c3d52ba0f 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QM8yi8lNH5hbnbhqaeIy2g # 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..ad7fe80c66 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GNYtw75SblcxetqJ0Jb7xA # 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..0740c35c69 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:f9g81zrH/C/Bg0Z1XkcF1g __PACKAGE__->add_columns( '+readonly' => { is_boolean => 1 } diff --git a/Koha/Schema/Result/ImportBatch.pm b/Koha/Schema/Result/ImportBatch.pm index 829297596c..fe1d983e2c 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JAr+Z5i1SrCL1TITWad58g =head2 koha_object_class diff --git a/Koha/Schema/Result/ImportBatchProfile.pm b/Koha/Schema/Result/ImportBatchProfile.pm index fb309cde71..d4bbacbc74 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SsG6P/HVwk5ffR0kx6rpNA # 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..bcce7e319f 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DQgMbHk2TGPgbka2NJEDKQ # 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..bf95c39cc1 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UZCAInCKLuz8hLkUsgL5wQ __PACKAGE__->add_columns( '+auto_renew' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm index cd22433ad2..802782e06a 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GopLobaZCA20jNnT9qoNHw __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..10b5333b31 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ySigxOH7NOKTJVVABRM2dA __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..aea7c38e13 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:XWgChkbVuJUVI3XA7bLukA # 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..088ca43065 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0iEdEFKPcFdTsPE9Gi0XOA # 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..ba5bc6f2b4 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/YnudVRAGDv9Ornd02Z3tw sub koha_object_class { 'Koha::Notice::Template'; diff --git a/Koha/Schema/Result/LibraryGroup.pm b/Koha/Schema/Result/LibraryGroup.pm index 6ffb7a8ac4..fb5dadbebd 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:M88qvFivMH/m7Jp+gy9stw sub koha_object_class { 'Koha::Library::Group'; diff --git a/Koha/Schema/Result/Linktracker.pm b/Koha/Schema/Result/Linktracker.pm index d36c177a09..5d480b43fc 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hvFaGAQ5h4gEAk2zggg2XA # 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..72f3ca366d 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3m5AhwkBUV0eL112dIW8ng # 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..a8c9efc4ca 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:EDJMOeEw3pPEpeUXVHo7dQ sub koha_object_class { 'Koha::Patron::Message'; diff --git a/Koha/Schema/Result/MiscFile.pm b/Koha/Schema/Result/MiscFile.pm index c194ce0fa0..01bd03ec42 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1ew2RboOyOxRy2vR+nqFJA # 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..076252163d 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:iJYZ7R+5yHKLG5U3xvI7vw sub koha_object_class { 'Koha::Authority::MergeRequest'; diff --git a/Koha/Schema/Result/OauthAccessToken.pm b/Koha/Schema/Result/OauthAccessToken.pm index 6e14006d0c..c15f99dc85 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qP6pU3XXXz5PFHJXHnRxLg sub koha_object_class { 'Koha::OAuthAccessToken'; diff --git a/Koha/Schema/Result/OldIssue.pm b/Koha/Schema/Result/OldIssue.pm index f39389a49a..f2a4121673 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:B5UJmyy6RttUfrn6Yfl+7w __PACKAGE__->add_columns( '+auto_renew' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/OldReserve.pm b/Koha/Schema/Result/OldReserve.pm index a65cef0814..adf72dd95e 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UH6coasIQnguSLtDdr6HEg __PACKAGE__->belongs_to( "item", diff --git a/Koha/Schema/Result/OpacNews.pm b/Koha/Schema/Result/OpacNews.pm index 2f4964ddbc..42b9cfc5e3 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:d05UDcRR2JQeyM7yLPxRWw sub koha_object_class { 'Koha::NewsItem'; diff --git a/Koha/Schema/Result/Overduerule.pm b/Koha/Schema/Result/Overduerule.pm index 1d248ed394..12d1b10f9b 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Xf0rcjwRs7RNXYRGwmXVpg # 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..7009581542 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ru+EK+OWW8yuZKiKnUq8RQ sub koha_object_class { 'Koha::Patron::Consent'; diff --git a/Koha/Schema/Result/PatronList.pm b/Koha/Schema/Result/PatronList.pm index f755f85585..7d077667de 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZAHlIRS467WC+83XxPZTDQ # 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..7744756c54 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dyC7iyqeTGsX0CC6QfOjnw # 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..cc5a65c032 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2QK5jUqVIi7JAyucjFkf2g sub koha_object_class { 'Koha::Patron::Image'; diff --git a/Koha/Schema/Result/ProblemReport.pm b/Koha/Schema/Result/ProblemReport.pm index 5df3c7a065..37195a71d6 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TMIbQ+WlM2C8Hq988zPa5g # 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..de2ddef87f 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Bw3EfLDrcITA2jekO9T/5w # 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..56477f21e9 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pwVJXk++6BSpyLpW/xgG0g # 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..4979cc91e3 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8pZz4cHTRRbwCBNoOI1M6w # 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..14b4d5327b 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SJGTXe8M997nUa9YbCsvqA # 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..8dbdb5d0a4 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:e/jY0HOiZ1WNTjL+B7Te4A # 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..a2ab929fa7 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uxMjobQcBjW3Xw7iK14wHg __PACKAGE__->belongs_to( "item", diff --git a/Koha/Schema/Result/ReturnClaim.pm b/Koha/Schema/Result/ReturnClaim.pm index f088a80fd6..3a6ea8e55e 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sgKOmqHean67iIbRFjtvRw sub koha_objects_class { 'Koha::Checkouts::ReturnClaims'; diff --git a/Koha/Schema/Result/Review.pm b/Koha/Schema/Result/Review.pm index 6c628b41c2..1db5fa7758 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.07046 @ 2021-01-21 11:55:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dGBh60T7gmxyAlwRtteI5A # 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..5864ef99a0 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.07046 @ 2021-01-21 11:55:32 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5y8Rbrui2vN4CmNMMoB9Yg __PACKAGE__->add_columns( '+public' => { is_boolean => 1 } diff --git a/Koha/Schema/Result/SearchHistory.pm b/Koha/Schema/Result/SearchHistory.pm index e2886df82c..e42f9b34fa 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.07046 @ 2021-01-21 11:55:32 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:g+8YtQUhvGiVO/d7Za5KOQ # 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..04b48c62b7 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.07046 @ 2021-01-21 11:55:32 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:u6geU3+R9sLPWS2BNbjLpg # 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..eb8b389ffb 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.07046 @ 2021-01-21 11:55:32 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YUbFprptkxnsy744QuTiJA # 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..843dd27b2c 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.07046 @ 2021-01-21 11:55:32 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HLDGH51Urg5Ke0u6VHNxNQ # 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..d3f2b11922 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.07046 @ 2021-01-21 11:55:32 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xk/EKJHnfn16eEEGRFefTw __PACKAGE__->add_columns( '+indemand' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Stockrotationrota.pm b/Koha/Schema/Result/Stockrotationrota.pm index a719635624..cf71db0c41 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.07046 @ 2021-01-21 11:55:32 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:woyzTbETJhCWaWLruQSnYA __PACKAGE__->add_columns( '+cyclical' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Stockrotationstage.pm b/Koha/Schema/Result/Stockrotationstage.pm index 845a712b33..8eaeb9d503 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.07046 @ 2021-01-21 11:55:32 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2WGw2w91CdR9RoY+vzY7xw # 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..14ea7656c0 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.07046 @ 2021-01-21 11:55:32 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ur0DNjmTa/pSquXKgyjF4A __PACKAGE__->has_many( "additional_field_values", diff --git a/Koha/Schema/Result/Subscriptionroutinglist.pm b/Koha/Schema/Result/Subscriptionroutinglist.pm index e218257986..18c88403e7 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.07046 @ 2021-01-21 11:55:32 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ULAuyH4sJu6Uc7TlOepGbg sub koha_object_class { 'Koha::Subscription::Routinglist'; diff --git a/Koha/Schema/Result/Suggestion.pm b/Koha/Schema/Result/Suggestion.pm index e493474c57..6c025d878f 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.07046 @ 2021-01-21 11:55:32 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HRkzAEJtBU4CwHugS216wA __PACKAGE__->belongs_to( "suggester", diff --git a/Koha/Schema/Result/Systempreference.pm b/Koha/Schema/Result/Systempreference.pm index 2ff374e5ca..5526bf481e 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.07046 @ 2021-01-21 11:55:32 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:tpbJjLaoOVKAoTFG7iTMFg sub koha_object_class { 'Koha::Config::SysPref'; diff --git a/Koha/Schema/Result/TagAll.pm b/Koha/Schema/Result/TagAll.pm index fbb8894886..4e644dcfdc 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.07046 @ 2021-01-21 11:55:32 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xpyAfLcSzJ1a4p/Rk2KNyg sub koha_object_class { 'Koha::Tag'; diff --git a/Koha/Schema/Result/TagsApproval.pm b/Koha/Schema/Result/TagsApproval.pm index 92b54b708d..188de12b8a 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.07046 @ 2021-01-21 11:55:32 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zHEk9DLVYdYoLbtEZXVFQw sub koha_object_class { 'Koha::Tags::Approval'; diff --git a/Koha/Schema/Result/TagsIndex.pm b/Koha/Schema/Result/TagsIndex.pm index acc98067ad..0d2a29f5f7 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.07046 @ 2021-01-21 11:55:32 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jZ7PoeDTmrR68PwcnrLKLg sub koha_object_class { 'Koha::Tags::Index'; diff --git a/Koha/Schema/Result/Virtualshelfcontent.pm b/Koha/Schema/Result/Virtualshelfcontent.pm index a8ad19d4b0..65a2c0fd6a 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.07046 @ 2021-01-21 11:55:32 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HwRg0l+b4O1Q7vEh46s1RQ #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..d94c0d7fb1 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.07046 @ 2021-01-21 11:55:32 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ef6dMgGrMT354DaTdY8TdQ # 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..a10497ceb0 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.07046 @ 2021-01-21 11:55:32 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ffp0sPdLMjk5q3BLxXf1+Q sub koha_object_class { 'Koha::Virtualshelf'; diff --git a/Koha/Schema/Result/Z3950server.pm b/Koha/Schema/Result/Z3950server.pm index 65ecc2ec1a..7931a56e2a 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.07046 @ 2021-01-21 11:55:32 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Xux7rgcpAESaWO+ll5RnQg sub koha_object_class { 'Koha::Z3950Server'; -- 2.24.1 (Apple Git-126)