borrowers


Columns

Column Type Size Nulls Auto Default Children Parents Comments
borrowernumber INT 10 √ null
accountlines.borrowernumber accountlines_ibfk_borrowers N
accountlines.manager_id accountlines_ibfk_borrowers_2 N
api_keys.patron_id api_keys_fk_patron_id C
aqbasketusers.borrowernumber aqbasketusers_ibfk_2 C
aqbudgetborrowers.borrowernumber aqbudgetborrowers_ibfk_2 C
aqorder_users.borrowernumber aqorder_users_ibfk_2 C
aqorders.created_by aqorders_created_by N
article_requests.borrowernumber article_requests_ibfk_1 C
borrower_attributes.borrowernumber borrower_attributes_ibfk_1 C
borrower_debarments.borrowernumber borrower_debarments_ibfk_1 C
borrower_files.borrowernumber borrower_files_ibfk_1 C
borrower_message_preferences.borrowernumber borrower_message_preferences_ibfk_1 C
club_enrollments.borrowernumber club_enrollments_ibfk_2 C
course_instructors.borrowernumber course_instructors_ibfk_1 C
creator_batches.borrower_number creator_batches_ibfk_1 C
discharges.borrower borrower_discharges_ibfk1 C
hold_fill_targets.borrowernumber hold_fill_targets_ibfk_1 C
housebound_profile.borrowernumber housebound_profile_bnfk C
housebound_role.borrowernumber_id houseboundrole_bnfk C
housebound_visit.chooser_brwnumber houseboundvisit_bnfk_1 C
housebound_visit.deliverer_brwnumber houseboundvisit_bnfk_2 C
illcomments.borrowernumber illcomments_bnfk C
illrequests.borrowernumber illrequests_bnfk C
issues.borrowernumber issues_ibfk_1 R
items_last_borrower.borrowernumber items_last_borrower_ibfk_2 C
message_queue.borrowernumber messageq_ibfk_1 C
messages.borrowernumber messages_borrowernumber C
messages.manager_id messages_ibfk_1 N
old_issues.borrowernumber old_issues_ibfk_1 N
old_reserves.borrowernumber old_reserves_ibfk_1 N
opac_news.borrowernumber borrowernumber_fk N
patron_consent.borrowernumber patron_consent_ibfk_1 C
patron_list_patrons.borrowernumber patron_list_patrons_ibfk_2 C
patron_lists.owner patron_lists_ibfk_1 C
patronimage.borrowernumber patronimage_fk1 C
ratings.borrowernumber ratings_ibfk_1 C
reserves.borrowernumber reserves_ibfk_1 C
reviews.borrowernumber reviews_ibfk_1 N
subscriptionroutinglist.borrowernumber subscriptionroutinglist_ibfk_1 C
suggestions.acceptedby suggestions_ibfk_acceptedby N
suggestions.managedby suggestions_ibfk_managedby N
suggestions.rejectedby suggestions_ibfk_rejectedby N
suggestions.suggestedby suggestions_ibfk_suggestedby N
tags_all.borrowernumber tags_borrowers_fk_1 N
tags_approval.approved_by tags_approval_borrowers_fk_1 N
user_permissions.borrowernumber user_permissions_ibfk_1 C
virtualshelfcontents.borrowernumber shelfcontents_ibfk_3 N
virtualshelfshares.borrowernumber virtualshelfshares_ibfk_2 N
virtualshelves.owner virtualshelves_ibfk_1 N

primary key, Koha assigned ID number for patrons/borrowers
cardnumber VARCHAR 32 √ null

unique key, library assigned ID number for patrons/borrowers
surname LONGTEXT 2147483647 √ null

patron/borrower's last name (surname)
firstname MEDIUMTEXT 16777215 √ null

patron/borrower's first name
title LONGTEXT 2147483647 √ null

patron/borrower's title, for example: Mr. or Mrs.
othernames LONGTEXT 2147483647 √ null

any other names associated with the patron/borrower
initials MEDIUMTEXT 16777215 √ null

initials for your patron/borrower
streetnumber VARCHAR 10 √ null

the house number for your patron/borrower's primary address
streettype VARCHAR 50 √ null

the street type (Rd., Blvd, etc) for your patron/borrower's primary address
address LONGTEXT 2147483647 √ null

the first address line for your patron/borrower's primary address
address2 MEDIUMTEXT 16777215 √ null

the second address line for your patron/borrower's primary address
city LONGTEXT 2147483647 √ null

the city or town for your patron/borrower's primary address
state MEDIUMTEXT 16777215 √ null

the state or province for your patron/borrower's primary address
zipcode VARCHAR 25 √ null

the zip or postal code for your patron/borrower's primary address
country MEDIUMTEXT 16777215 √ null

the country for your patron/borrower's primary address
email LONGTEXT 2147483647 √ null

the primary email address for your patron/borrower's primary address
phone MEDIUMTEXT 16777215 √ null

the primary phone number for your patron/borrower's primary address
mobile VARCHAR 50 √ null

the other phone number for your patron/borrower's primary address
fax LONGTEXT 2147483647 √ null

the fax number for your patron/borrower's primary address
emailpro MEDIUMTEXT 16777215 √ null

the secondary email addres for your patron/borrower's primary address
phonepro MEDIUMTEXT 16777215 √ null

the secondary phone number for your patron/borrower's primary address
B_streetnumber VARCHAR 10 √ null

the house number for your patron/borrower's alternate address
B_streettype VARCHAR 50 √ null

the street type (Rd., Blvd, etc) for your patron/borrower's alternate address
B_address VARCHAR 100 √ null

the first address line for your patron/borrower's alternate address
B_address2 MEDIUMTEXT 16777215 √ null

the second address line for your patron/borrower's alternate address
B_city LONGTEXT 2147483647 √ null

the city or town for your patron/borrower's alternate address
B_state MEDIUMTEXT 16777215 √ null

the state for your patron/borrower's alternate address
B_zipcode VARCHAR 25 √ null

the zip or postal code for your patron/borrower's alternate address
B_country MEDIUMTEXT 16777215 √ null

the country for your patron/borrower's alternate address
B_email MEDIUMTEXT 16777215 √ null

the patron/borrower's alternate email address
B_phone LONGTEXT 2147483647 √ null

the patron/borrower's alternate phone number
dateofbirth DATE 10 √ null

the patron/borrower's date of birth (YYYY-MM-DD)
branchcode VARCHAR 10
branches.branchcode borrowers_ibfk_2 R

foreign key from the branches table, includes the code of the patron/borrower's home branch
categorycode VARCHAR 10
categories.categorycode borrowers_ibfk_1 R

foreign key from the categories table, includes the code of the patron category
dateenrolled DATE 10 √ null

date the patron was added to Koha (YYYY-MM-DD)
dateexpiry DATE 10 √ null

date the patron/borrower's card is set to expire (YYYY-MM-DD)
date_renewed DATE 10 √ null

date the patron/borrower's card was last renewed
gonenoaddress BIT 0 √ null

set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address
lost BIT 0 √ null

set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card
debarred DATE 10 √ null

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)
debarredcomment VARCHAR 255 √ null

comment on the stop of the patron
contactname LONGTEXT 2147483647 √ null

used for children and profesionals to include surname or last name of guarantor or organization name
contactfirstname MEDIUMTEXT 16777215 √ null

used for children to include first name of guarantor
contacttitle MEDIUMTEXT 16777215 √ null

used for children to include title (Mr., Mrs., etc) of guarantor
guarantorid INT 10 √ null

borrowernumber used for children or professionals to link them to guarantors or organizations
borrowernotes LONGTEXT 2147483647 √ null

a note on the patron/borrower's account that is only visible in the staff client
relationship VARCHAR 100 √ null

used for children to include the relationship to their guarantor
sex VARCHAR 1 √ null

patron/borrower's gender
password VARCHAR 60 √ null

patron/borrower's Bcrypt encrypted password
flags INT 10 √ null

will include a number associated with the staff member's permissions
userid VARCHAR 75 √ null

patron/borrower's opac and/or staff client log in
opacnote LONGTEXT 2147483647 √ null

a note on the patron/borrower's account that is visible in the OPAC and staff client
contactnote VARCHAR 255 √ null

a note related to the patron/borrower's alternate address
sort1 VARCHAR 80 √ null

a field that can be used for any information unique to the library
sort2 VARCHAR 80 √ null

a field that can be used for any information unique to the library
altcontactfirstname VARCHAR 255 √ null

first name of alternate contact for the patron/borrower
altcontactsurname VARCHAR 255 √ null

surname or last name of the alternate contact for the patron/borrower
altcontactaddress1 VARCHAR 255 √ null

the first address line for the alternate contact for the patron/borrower
altcontactaddress2 VARCHAR 255 √ null

the second address line for the alternate contact for the patron/borrower
altcontactaddress3 VARCHAR 255 √ null

the city for the alternate contact for the patron/borrower
altcontactstate MEDIUMTEXT 16777215 √ null

the state for the alternate contact for the patron/borrower
altcontactzipcode VARCHAR 50 √ null

the zipcode for the alternate contact for the patron/borrower
altcontactcountry MEDIUMTEXT 16777215 √ null

the country for the alternate contact for the patron/borrower
altcontactphone VARCHAR 50 √ null

the phone number for the alternate contact for the patron/borrower
smsalertnumber VARCHAR 50 √ null

the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on)
sms_provider_id INT 10 √ null
sms_providers.id borrowers_ibfk_3 N

the provider of the mobile phone number defined in smsalertnumber
privacy INT 10 1

patron/borrower's privacy settings related to their reading history
privacy_guarantor_checkouts BIT 0 0

controls if relatives can see this patron's checkouts
checkprevcheckout VARCHAR 7 inherit

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'.
updated_on TIMESTAMP 19 current_timestamp()

time of last change could be useful for synchronization with external systems (among others)
lastseen DATETIME 19 √ null

last time a patron has been seen (connected at the OPAC or staff interface)
lang VARCHAR 25 default

lang to use to send notices to this patron
login_attempts INT 10 √ 0

number of failed login attemps
overdrive_auth_token MEDIUMTEXT 16777215 √ null

persist OverDrive auth token
anonymized BIT 0 0

flag for data anonymization

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc borrowernumber
branchcode Performance Asc branchcode
cardnumber Must be unique Asc cardnumber
categorycode Performance Asc categorycode
firstname_idx Performance Asc firstname
guarantorid Performance Asc guarantorid
othernames_idx Performance Asc othernames
sms_provider_id Performance Asc sms_provider_id
surname_idx Performance Asc surname
userid Must be unique Asc userid

Relationships

Close relationships within degrees of separation