Table testsql_comments.deletedborrowers Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
borrowernumber int 10 0
borrowers.borrowernumber Implied Constraint R
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
refund_lost_item_fee_rules.branchcode Implied Constraint R
foreign key from the branches table, includes the code of the patron/borrower's home branch
categorycode varchar 10
default_borrower_circ_rules.categorycode Implied Constraint 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 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 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 the provider of the mobile phone number defined in smsalertnumber
privacy int 10 1 patron/borrower's privacy settings related to their reading history KEY `borrowernumber` (`borrowernumber`),
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

Table contained 0 rows at Mon Jul 16 08:37 NZST 2018

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

Close relationships: