Koha::Schema::Result::Borrower
borrowers
data_type: 'integer' is_auto_increment: 1 is_nullable: 0
primary key, Koha assigned ID number for patrons/borrowers
data_type: 'varchar' is_nullable: 1 size: 32
unique key, library assigned ID number for patrons/borrowers
data_type: 'longtext' is_nullable: 1
patron/borrower's last name (surname)
data_type: 'mediumtext' is_nullable: 1
patron/borrower's first name
data_type: 'longtext' is_nullable: 1
patron/borrower's preferred name
data_type: 'longtext' is_nullable: 1
patron/borrower's middle name
data_type: 'longtext' is_nullable: 1
patron/borrower's title, for example: Mr. or Mrs.
data_type: 'longtext' is_nullable: 1
any other names associated with the patron/borrower
data_type: 'mediumtext' is_nullable: 1
initials for your patron/borrower
data_type: 'longtext' is_nullable: 1
patron/borrower pronouns
data_type: 'tinytext' is_nullable: 1
the house number for your patron/borrower's primary address
data_type: 'tinytext' is_nullable: 1
the street type (Rd., Blvd, etc) for your patron/borrower's primary address
data_type: 'longtext' is_nullable: 1
the first address line for your patron/borrower's primary address
data_type: 'mediumtext' is_nullable: 1
the second address line for your patron/borrower's primary address
data_type: 'longtext' is_nullable: 1
the city or town for your patron/borrower's primary address
data_type: 'mediumtext' is_nullable: 1
the state or province for your patron/borrower's primary address
data_type: 'tinytext' is_nullable: 1
the zip or postal code for your patron/borrower's primary address
data_type: 'mediumtext' is_nullable: 1
the country for your patron/borrower's primary address
data_type: 'longtext' is_nullable: 1
the primary email address for your patron/borrower's primary address
data_type: 'mediumtext' is_nullable: 1
the primary phone number for your patron/borrower's primary address
data_type: 'tinytext' is_nullable: 1
the other phone number for your patron/borrower's primary address
data_type: 'longtext' is_nullable: 1
the fax number for your patron/borrower's primary address
data_type: 'mediumtext' is_nullable: 1
the secondary email addres for your patron/borrower's primary address
data_type: 'mediumtext' is_nullable: 1
the secondary phone number for your patron/borrower's primary address
accessor: 'b_streetnumber' data_type: 'tinytext' is_nullable: 1
the house number for your patron/borrower's alternate address
accessor: 'b_streettype' data_type: 'tinytext' is_nullable: 1
the street type (Rd., Blvd, etc) for your patron/borrower's alternate address
accessor: 'b_address' data_type: 'mediumtext' is_nullable: 1
the first address line for your patron/borrower's alternate address
accessor: 'b_address2' data_type: 'mediumtext' is_nullable: 1
the second address line for your patron/borrower's alternate address
accessor: 'b_city' data_type: 'longtext' is_nullable: 1
the city or town for your patron/borrower's alternate address
accessor: 'b_state' data_type: 'mediumtext' is_nullable: 1
the state for your patron/borrower's alternate address
accessor: 'b_zipcode' data_type: 'tinytext' is_nullable: 1
the zip or postal code for your patron/borrower's alternate address
accessor: 'b_country' data_type: 'mediumtext' is_nullable: 1
the country for your patron/borrower's alternate address
accessor: 'b_email' data_type: 'mediumtext' is_nullable: 1
the patron/borrower's alternate email address
accessor: 'b_phone' data_type: 'longtext' is_nullable: 1
the patron/borrower's alternate phone number
data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1
the patron/borrower's date of birth (YYYY-MM-DD)
data_type: 'varchar' default_value: (empty string) is_foreign_key: 1 is_nullable: 0 size: 10
foreign key from the branches table, includes the code of the patron/borrower's home branch
data_type: 'varchar' default_value: (empty string) is_foreign_key: 1 is_nullable: 0 size: 10
foreign key from the categories table, includes the code of the patron category
data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1
date the patron was added to Koha (YYYY-MM-DD)
data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1
date the patron/borrower's card is set to expire (YYYY-MM-DD)
data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1
date the patron/borrower's password is set to expire (YYYY-MM-DD)
data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1
date the patron/borrower's card was last renewed
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
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
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)
data_type: 'varchar' is_nullable: 1 size: 255
comment on the stop of the patron
data_type: 'longtext' is_nullable: 1
used for children and profesionals to include surname or last name of guarantor or organization name
data_type: 'mediumtext' is_nullable: 1
used for children to include first name of guarantor
data_type: 'mediumtext' is_nullable: 1
used for children to include title (Mr., Mrs., etc) of guarantor
data_type: 'longtext' is_nullable: 1
a note on the patron/borrower's account that is only visible in the staff interface
data_type: 'varchar' is_nullable: 1 size: 100
used for children to include the relationship to their guarantor
data_type: 'varchar' is_nullable: 1 size: 1
patron/borrower's gender
data_type: 'varchar' is_nullable: 1 size: 60
patron/borrower's Bcrypt encrypted password
data_type: 'mediumtext' is_nullable: 1
Secret for 2FA
data_type: 'enum' default_value: 'password' extra: {list => ["password","two-factor"]} is_nullable: 0
Authentication method
data_type: 'bigint' is_nullable: 1
will include a number associated with the staff member's permissions
data_type: 'varchar' is_nullable: 1 size: 75
patron/borrower's opac and/or staff interface log in
data_type: 'longtext' is_nullable: 1
a note on the patron/borrower's account that is visible in the OPAC and staff interface
data_type: 'varchar' is_nullable: 1 size: 255
a note related to the patron/borrower's alternate address
data_type: 'varchar' is_nullable: 1 size: 80
a field that can be used for any information unique to the library
data_type: 'varchar' is_nullable: 1 size: 80
a field that can be used for any information unique to the library
data_type: 'mediumtext' is_nullable: 1
first name of alternate contact for the patron/borrower
data_type: 'mediumtext' is_nullable: 1
surname or last name of the alternate contact for the patron/borrower
data_type: 'mediumtext' is_nullable: 1
the first address line for the alternate contact for the patron/borrower
data_type: 'mediumtext' is_nullable: 1
the second address line for the alternate contact for the patron/borrower
data_type: 'mediumtext' is_nullable: 1
the city for the alternate contact for the patron/borrower
data_type: 'mediumtext' is_nullable: 1
the state for the alternate contact for the patron/borrower
data_type: 'mediumtext' is_nullable: 1
the zipcode for the alternate contact for the patron/borrower
data_type: 'mediumtext' is_nullable: 1
the country for the alternate contact for the patron/borrower
data_type: 'mediumtext' is_nullable: 1
the phone number for the alternate contact for the patron/borrower
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)
data_type: 'integer' is_foreign_key: 1 is_nullable: 1
the provider of the mobile phone number defined in smsalertnumber
data_type: 'integer' default_value: 1 is_nullable: 0
patron/borrower's privacy settings related to their checkout history
data_type: 'tinyint' default_value: 0 is_nullable: 0
controls if relatives can see this patron's fines
data_type: 'tinyint' default_value: 0 is_nullable: 0
controls if relatives can see this patron's checkouts
data_type: 'varchar' default_value: 'inherit' 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'.
data_type: 'timestamp' datetime_undef_if_invalid: 1 default_value: current_timestamp is_nullable: 0
time of last change could be useful for synchronization with external systems (among others)
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)
data_type: 'varchar' default_value: 'default' is_nullable: 0 size: 25
lang to use to send notices to this patron
data_type: 'integer' default_value: 0 is_nullable: 0
number of failed login attemps
data_type: 'mediumtext' is_nullable: 1
persist OverDrive auth token
data_type: 'tinyint' default_value: 0 is_nullable: 0
flag for data anonymization
data_type: 'tinyint' default_value: 1 is_nullable: 0
flag for allowing auto-renewal
data_type: 'varchar' is_nullable: 1 size: 45
useful for reporting purposes
data_type: 'tinyint' default_value: 0 is_nullable: 0
boolean flag to mark selected patrons as protected from deletion
cardnumber
userid
Type: has_many
Related object: Koha::Schema::Result::Accountline
Type: has_many
Related object: Koha::Schema::Result::Accountline
Type: has_many
Related object: Koha::Schema::Result::AdditionalContent
Type: has_many
Related object: Koha::Schema::Result::AdvancedEditorMacro
Type: has_many
Related object: Koha::Schema::Result::Alert
Type: has_many
Related object: Koha::Schema::Result::ApiKey
Type: has_many
Related object: Koha::Schema::Result::Aqbasketuser
Type: has_many
Related object: Koha::Schema::Result::Aqbudgetborrower
Type: has_many
Related object: Koha::Schema::Result::AqorderUser
Type: has_many
Related object: Koha::Schema::Result::Aqorder
Type: has_many
Related object: Koha::Schema::Result::ArticleRequest
Type: has_many
Related object: Koha::Schema::Result::Booking
Type: has_many
Related object: Koha::Schema::Result::BorrowerAttribute
Type: has_many
Related object: Koha::Schema::Result::BorrowerDebarment
Type: has_many
Related object: Koha::Schema::Result::BorrowerFile
Type: has_many
Related object: Koha::Schema::Result::BorrowerMessagePreference
Type: has_many
Related object: Koha::Schema::Result::BorrowerRelationship
Type: has_many
Related object: Koha::Schema::Result::BorrowerRelationship
Type: belongs_to
Related object: Koha::Schema::Result::Branch
Type: has_many
Related object: Koha::Schema::Result::CashRegisterAction
Type: belongs_to
Related object: Koha::Schema::Result::Category
Type: has_many
Related object: Koha::Schema::Result::CheckoutRenewal
Type: has_many
Related object: Koha::Schema::Result::ClubEnrollment
Type: has_many
Related object: Koha::Schema::Result::ClubHoldsToPatronHold
Type: has_many
Related object: Koha::Schema::Result::CourseInstructor
Type: has_many
Related object: Koha::Schema::Result::CreatorBatch
Type: has_many
Related object: Koha::Schema::Result::CurbsidePickup
Type: has_many
Related object: Koha::Schema::Result::CurbsidePickup
Type: has_many
Related object: Koha::Schema::Result::Discharge
Type: has_many
Related object: Koha::Schema::Result::ErmCounterLog
Type: has_many
Related object: Koha::Schema::Result::ErmUserRole
Type: has_many
Related object: Koha::Schema::Result::HoldFillTarget
Type: might_have
Related object: Koha::Schema::Result::HouseboundProfile
Type: might_have
Related object: Koha::Schema::Result::HouseboundRole
Type: has_many
Related object: Koha::Schema::Result::HouseboundVisit
Type: has_many
Related object: Koha::Schema::Result::HouseboundVisit
Type: has_many
Related object: Koha::Schema::Result::Illbatch
Type: has_many
Related object: Koha::Schema::Result::Illcomment
Type: has_many
Related object: Koha::Schema::Result::Illrequest
Type: has_many
Related object: Koha::Schema::Result::Issue
Type: has_many
Related object: Koha::Schema::Result::Issue
Type: has_many
Related object: Koha::Schema::Result::ItemEditorTemplate
Type: has_many
Related object: Koha::Schema::Result::ItemsLastBorrower
Type: has_many
Related object: Koha::Schema::Result::Linktracker
Type: has_many
Related object: Koha::Schema::Result::MessageQueue
Type: has_many
Related object: Koha::Schema::Result::Message
Type: has_many
Related object: Koha::Schema::Result::Message
Type: has_many
Related object: Koha::Schema::Result::OldIssue
Type: has_many
Related object: Koha::Schema::Result::OldIssue
Type: has_many
Related object: Koha::Schema::Result::OldReserve
Type: has_many
Related object: Koha::Schema::Result::PatronConsent
Type: has_many
Related object: Koha::Schema::Result::PatronListPatron
Type: has_many
Related object: Koha::Schema::Result::PatronList
Type: might_have
Related object: Koha::Schema::Result::Patronimage
Type: has_many
Related object: Koha::Schema::Result::ProblemReport
Type: has_many
Related object: Koha::Schema::Result::Rating
Type: has_many
Related object: Koha::Schema::Result::Recall
Type: has_many
Related object: Koha::Schema::Result::Reserve
Type: has_many
Related object: Koha::Schema::Result::ReturnClaim
Type: has_many
Related object: Koha::Schema::Result::ReturnClaim
Type: has_many
Related object: Koha::Schema::Result::ReturnClaim
Type: has_many
Related object: Koha::Schema::Result::ReturnClaim
Type: has_many
Related object: Koha::Schema::Result::Review
Type: belongs_to
Related object: Koha::Schema::Result::SmsProvider
Type: has_many
Related object: Koha::Schema::Result::Subscriptionroutinglist
Type: has_many
Related object: Koha::Schema::Result::Suggestion
Type: has_many
Related object: Koha::Schema::Result::Suggestion
Type: has_many
Related object: Koha::Schema::Result::Suggestion
Type: has_many
Related object: Koha::Schema::Result::Suggestion
Type: has_many
Related object: Koha::Schema::Result::Suggestion
Type: has_many
Related object: Koha::Schema::Result::TagAll
Type: has_many
Related object: Koha::Schema::Result::TagsApproval
Type: has_many
Related object: Koha::Schema::Result::TicketUpdate
Type: has_many
Related object: Koha::Schema::Result::TicketUpdate
Type: has_many
Related object: Koha::Schema::Result::Ticket
Type: has_many
Related object: Koha::Schema::Result::Ticket
Type: has_many
Related object: Koha::Schema::Result::Ticket
Type: has_many
Related object: Koha::Schema::Result::TmpHoldsqueue
Type: has_many
Related object: Koha::Schema::Result::UserPermission
Type: has_many
Related object: Koha::Schema::Result::Virtualshelfcontent
Type: has_many
Related object: Koha::Schema::Result::Virtualshelfshare
Type: has_many
Related object: Koha::Schema::Result::Virtualshelve
Type: many_to_many
Composing rels: "aqbasketusers" -> basketno
Type: many_to_many
Composing rels: "aqbudgetborrowers" -> budget
Type: many_to_many
Composing rels: "course_instructors" -> course
Type: many_to_many
Composing rels: "aqorder_users" -> ordernumber
Type: many_to_many
Composing rels: "user_permissions" -> permission