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 mediumtext 16777215  √  null
firstname text 65535  √  null
title mediumtext 16777215  √  null
othernames mediumtext 16777215  √  null
initials text 65535  √  null
streetnumber varchar 10  √  null
streettype varchar 50  √  null
address mediumtext 16777215  √  null
address2 text 65535  √  null
city mediumtext 16777215  √  null
state text 65535  √  null
zipcode varchar 25  √  null
country text 65535  √  null
email mediumtext 16777215  √  null
phone text 65535  √  null
mobile varchar 50  √  null
fax mediumtext 16777215  √  null
emailpro text 65535  √  null
phonepro text 65535  √  null
B_streetnumber varchar 10  √  null
B_streettype varchar 50  √  null
B_address varchar 100  √  null
B_address2 text 65535  √  null
B_city mediumtext 16777215  √  null
B_state text 65535  √  null
B_zipcode varchar 25  √  null
B_country text 65535  √  null
B_email text 65535  √  null
B_phone mediumtext 16777215  √  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 mediumtext 16777215  √  null
contactfirstname text 65535  √  null
contacttitle text 65535  √  null
guarantorid int 10  √  null
borrowernotes mediumtext 16777215  √  null
relationship varchar 100  √  null
sex varchar 1  √  null
password varchar 30  √  null
flags int 10  √  null
userid varchar 75  √  null
opacnote mediumtext 16777215  √  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 text 65535  √  null
altcontactzipcode varchar 50  √  null
altcontactcountry text 65535  √  null
altcontactphone varchar 50  √  null
smsalertnumber varchar 50  √  null
privacy int 10  √  null
extended_attributes text 65535  √  null

Table contained 0 rows at Mon Jul 16 09:22 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: