borrowers

欄位	型態	範例
borrowernumber	int(11)
cardnumber	varchar(16)
surname	text
firstname	text
title	text
othernames	text
initials	text
streetaddress	text
suburb	text
city	text
phone	text
emailaddress	text
faxnumber	text
textmessaging	text
altstreetaddress	text
altsuburb	text
altcity	text
altphone	text
dateofbirth	date
branchcode	varchar(4)
categorycode	char(2)
dateenrolled	date
branchcode	varchar(4)
categorycode	char(2)
dateenrolled	date
gonenoaddress	tinyint(1)
lost	tinyint(1)
debarred	tinyint(1)
studentnumber	text
school	text
contactname	text
borrowernotes	text
guarantor	int(11)
area	char(2)
ethnicity	varchar(50)
ethnotes	varchar(255)
sex	char(1)
expiry	date
altnotes	varchar(255)
altrelationship	varchar(100)
streetcity	text
phoneday	varchar(50)
preferredcont	char(1)
physstreet	varchar(100)
password	varchar(30)
flags	int(11)
userid	varchar(30)
homezipcode	varchar(25)
zipcode	varchar(25)
sort1	varchar(80)
sort2	varchar(80)