deletedborrowers

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
borrowernumber INT 10 0

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

middle_name LONGTEXT 2147483647 null

patron/borrower’s middle 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

pronouns LONGTEXT 2147483647 null

patron/borrower pronouns

streetnumber TINYTEXT 255 null

the house number for your patron/borrower’s primary address

streettype TINYTEXT 255 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 TINYTEXT 255 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 TINYTEXT 255 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 TINYTEXT 255 null

the house number for your patron/borrower’s alternate address

B_streettype TINYTEXT 255 null

the street type (Rd., Blvd, etc) for your patron/borrower’s alternate address

B_address MEDIUMTEXT 16777215 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 TINYTEXT 255 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

foreign key from the branches table, includes the code of the patron/borrower’s home branch

categorycode VARCHAR 10
categories.categorycode Implied ConstraintR

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)

password_expiration_date DATE 10 null

date the patron/borrower’s password 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 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

borrowernotes LONGTEXT 2147483647 null

a note on the patron/borrower’s account that is only visible in the staff interface

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 encrypted password

secret MEDIUMTEXT 16777215 null

Secret for 2FA

auth_method enum('password', 'two-factor') 10 password

Authentication method

flags BIGINT 19 null

will include a number associated with the staff member’s permissions

userid VARCHAR 75 null

patron/borrower’s opac and/or staff interface log in

opacnote LONGTEXT 2147483647 null

a note on the patron/borrower’s account that is visible in the OPAC and staff interface

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 MEDIUMTEXT 16777215 null

first name of alternate contact for the patron/borrower

altcontactsurname MEDIUMTEXT 16777215 null

surname or last name of the alternate contact for the patron/borrower

altcontactaddress1 MEDIUMTEXT 16777215 null

the first address line for the alternate contact for the patron/borrower

altcontactaddress2 MEDIUMTEXT 16777215 null

the second address line for the alternate contact for the patron/borrower

altcontactaddress3 MEDIUMTEXT 16777215 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 MEDIUMTEXT 16777215 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 MEDIUMTEXT 16777215 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

the provider of the mobile phone number defined in smsalertnumber

privacy INT 10 1

patron/borrower’s privacy settings related to their checkout history KEY borrowernumber (borrowernumber),

privacy_guarantor_fines BIT 0 0

controls if relatives can see this patron’s fines

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

autorenew_checkouts BIT 0 1

flag for allowing auto-renewal

primary_contact_method VARCHAR 45 null

useful for reporting purposes

Indexes

Constraint Name Type Sort Column(s)
borrowernumber Performance Asc borrowernumber
cardnumber Performance Asc cardnumber
sms_provider_id Performance Asc sms_provider_id

Relationships