Table testsql_comments.borrower_modifications 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
timestamp timestamp 19 CURRENT_TIMESTAMP
verification_token varchar 255
borrowernumber int 10 0
borrowers.borrowernumber Implied Constraint R
cardnumber varchar 32  √  null
surname longtext 2147483647  √  null
firstname mediumtext 16777215  √  null
title longtext 2147483647  √  null
othernames longtext 2147483647  √  null
initials mediumtext 16777215  √  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
refund_lost_item_fee_rules.branchcode Implied Constraint R
categorycode varchar 10  √  null
default_borrower_circ_rules.categorycode Implied Constraint R
dateenrolled date 10  √  null
dateexpiry date 10  √  null
date_renewed date 10  √  null
gonenoaddress bit 0  √  null
lost bit 0  √  null
debarred date 10  √  null
debarredcomment varchar 255  √  null
contactname longtext 2147483647  √  null
contactfirstname mediumtext 16777215  √  null
contacttitle mediumtext 16777215  √  null
guarantorid int 10  √  null
borrowernotes longtext 2147483647  √  null
relationship varchar 100  √  null
sex varchar 1  √  null
password varchar 30  √  null
flags int 10  √  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

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

Indexes:
Column(s) Type Sort Constraint Name
verification_token + borrowernumber Primary key Asc/Asc PRIMARY
borrowernumber Performance Asc borrowernumber
verification_token Performance Asc verification_token

Close relationships: