Koha::Schema::Result::Deletedborrower
deletedborrowersdata_type: 'integer' default_value: 0 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 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_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_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 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 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_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 KEY `borrowernumber` (`borrowernumber`),
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