Table testsql_comments.deletedborrowers
stores data related to the patrons/borrowers you have deleted

 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
patronimage.borrowernumber Implied Constraint R
primary key, Koha assigned ID number for patrons/borrowers
cardnumber varchar 16  √  null unique key, library assigned ID number for patrons/borrowers
surname mediumtext 16777215 patron/borrower's last name (surname)
firstname text 65535  √  null patron/borrower's first name
title mediumtext 16777215  √  null patron/borrower's title, for example: Mr. or Mrs.
othernames mediumtext 16777215  √  null any other names associated with the patron/borrower
initials text 65535  √  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 mediumtext 16777215 the first address line for your patron/borrower's primary address
address2 text 65535  √  null the second address line for your patron/borrower's primary address
city mediumtext 16777215 the city or town for your patron/borrower's primary address
state text 65535  √  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 text 65535  √  null the country for your patron/borrower's primary address
email mediumtext 16777215  √  null the primary email address for your patron/borrower's primary address
phone text 65535  √  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 mediumtext 16777215  √  null the fax number for your patron/borrower's primary address
emailpro text 65535  √  null the secondary email addres for your patron/borrower's primary address
phonepro text 65535  √  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 text 65535  √  null the second address line for your patron/borrower's alternate address
B_city mediumtext 16777215  √  null the city or town for your patron/borrower's alternate address
B_state text 65535  √  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 text 65535  √  null the country for your patron/borrower's alternate address
B_email text 65535  √  null the patron/borrower's alternate email address
B_phone mediumtext 16777215  √  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 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)
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 (YYY-MM-DD)
debarredcomment varchar 255  √  null comment on the stop of patron
contactname mediumtext 16777215  √  null used for children and profesionals to include surname or last name of guarentor or organization name
contactfirstname text 65535  √  null used for children to include first name of guarentor
contacttitle text 65535  √  null used for children to include title (Mr., Mrs., etc) of guarentor
guarantorid int 10  √  null borrowernumber used for children or professionals to link them to guarentors or organizations
borrowernotes mediumtext 16777215  √  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 guarentor
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 mediumtext 16777215  √  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 text 65535  √  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 text 65535  √  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 SNS 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
updated_on timestamp 19 CURRENT_TIMESTAMP time of last change could be useful for synchronization with external systems (among others)

Table contained 0 rows at Tue Dec 27 16:10 NZDT 2016

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: