Lines 243-249
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
243 |
`contactfirstname` text, -- used for children to include first name of guarentor |
243 |
`contactfirstname` text, -- used for children to include first name of guarentor |
244 |
`contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarentor |
244 |
`contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarentor |
245 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarentors or organizations |
245 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarentors or organizations |
246 |
`borrowernotes` mediumtext, -- a note on the patron/borroewr's account that is only visible in the staff client |
246 |
`borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client |
247 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor |
247 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor |
248 |
`ethnicity` varchar(50) default NULL, -- unused in Koha |
248 |
`ethnicity` varchar(50) default NULL, -- unused in Koha |
249 |
`ethnotes` varchar(255) default NULL, -- unused in Koha |
249 |
`ethnotes` varchar(255) default NULL, -- unused in Koha |
Lines 873-879
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
873 |
`contactfirstname` text, -- used for children to include first name of guarentor |
873 |
`contactfirstname` text, -- used for children to include first name of guarentor |
874 |
`contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarentor |
874 |
`contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarentor |
875 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarentors or organizations |
875 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarentors or organizations |
876 |
`borrowernotes` mediumtext, -- a note on the patron/borroewr's account that is only visible in the staff client |
876 |
`borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client |
877 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor |
877 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor |
878 |
`ethnicity` varchar(50) default NULL, -- unused in Koha |
878 |
`ethnicity` varchar(50) default NULL, -- unused in Koha |
879 |
`ethnotes` varchar(255) default NULL, -- unused in Koha |
879 |
`ethnotes` varchar(255) default NULL, -- unused in Koha |
880 |
- |
|
|