borrower_modifications

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
timestamp TIMESTAMP 19 current_timestamp()
verification_token VARCHAR 255 ''
changed_fields MEDIUMTEXT 16777215 √ NULL
borrowernumber INT 10 0
cardnumber VARCHAR 32 √ NULL
surname LONGTEXT 2147483647 √ NULL
firstname MEDIUMTEXT 16777215 √ NULL
preferred_name LONGTEXT 2147483647 √ NULL

patron/borrower’s preferred name
middle_name LONGTEXT 2147483647 √ NULL

patron/borrower’s middle name
title LONGTEXT 2147483647 √ NULL
othernames LONGTEXT 2147483647 √ NULL
initials MEDIUMTEXT 16777215 √ NULL
pronouns LONGTEXT 2147483647 √ NULL
streetnumber VARCHAR 10 √ NULL
streettype VARCHAR 50 √ NULL
address LONGTEXT 2147483647 √ NULL
address2 MEDIUMTEXT 16777215 √ NULL
city LONGTEXT 2147483647 √ NULL
state MEDIUMTEXT 16777215 √ NULL
zipcode VARCHAR 25 √ NULL
country MEDIUMTEXT 16777215 √ NULL
email LONGTEXT 2147483647 √ NULL
phone MEDIUMTEXT 16777215 √ NULL
mobile VARCHAR 50 √ NULL
fax LONGTEXT 2147483647 √ NULL
emailpro MEDIUMTEXT 16777215 √ NULL
phonepro MEDIUMTEXT 16777215 √ NULL
B_streetnumber VARCHAR 10 √ NULL
B_streettype VARCHAR 50 √ NULL
B_address VARCHAR 100 √ NULL
B_address2 MEDIUMTEXT 16777215 √ NULL
B_city LONGTEXT 2147483647 √ NULL
B_state MEDIUMTEXT 16777215 √ NULL
B_zipcode VARCHAR 25 √ NULL
B_country MEDIUMTEXT 16777215 √ NULL
B_email MEDIUMTEXT 16777215 √ NULL
B_phone LONGTEXT 2147483647 √ NULL
dateofbirth DATE 10 √ NULL
branchcode VARCHAR 10 √ NULL
categorycode VARCHAR 10 √ NULL
categories.categorycode Implied Constraint R
dateenrolled DATE 10 √ NULL
dateexpiry DATE 10 √ NULL
date_renewed DATE 10 √ NULL
gonenoaddress TINYINT 3 √ NULL
lost TINYINT 3 √ NULL
debarred DATE 10 √ NULL
debarredcomment VARCHAR 255 √ NULL
contactname LONGTEXT 2147483647 √ NULL
contactfirstname MEDIUMTEXT 16777215 √ NULL
contacttitle MEDIUMTEXT 16777215 √ NULL
borrowernotes LONGTEXT 2147483647 √ NULL
relationship VARCHAR 100 √ NULL
sex VARCHAR 1 √ NULL
password VARCHAR 30 √ NULL
flags BIGINT 19 √ NULL
userid VARCHAR 75 √ NULL
opacnote LONGTEXT 2147483647 √ NULL
contactnote VARCHAR 255 √ NULL
sort1 VARCHAR 80 √ NULL
sort2 VARCHAR 80 √ NULL
altcontactfirstname VARCHAR 255 √ NULL
altcontactsurname VARCHAR 255 √ NULL
altcontactaddress1 VARCHAR 255 √ NULL
altcontactaddress2 VARCHAR 255 √ NULL
altcontactaddress3 VARCHAR 255 √ NULL
altcontactstate MEDIUMTEXT 16777215 √ NULL
altcontactzipcode VARCHAR 50 √ NULL
altcontactcountry MEDIUMTEXT 16777215 √ NULL
altcontactphone VARCHAR 50 √ NULL
smsalertnumber VARCHAR 50 √ NULL
privacy INT 10 √ NULL
extended_attributes MEDIUMTEXT 16777215 √ NULL
gdpr_proc_consent DATETIME 19 √ NULL

data processing consent
primary_contact_method VARCHAR 45 √ NULL

useful for reporting purposes
lang VARCHAR 25 √ NULL

Indexes

Constraint Name Type Sort Column(s)
borrower_modifications_s_pk Primary key Asc/Asc verification_token + borrowernumber
borrowernumber Performance Asc borrowernumber
PRIMARY Must be unique Asc/Asc verification_token + borrowernumber
verification_token Performance Asc verification_token

Relationships

Close relationships within degrees of separation