|
Lines 256-262
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
| 256 |
`altcontactsurname` varchar(255) default NULL, -- surname or last name of the alternate contact for the patron/borrower |
256 |
`altcontactsurname` varchar(255) default NULL, -- surname or last name of the alternate contact for the patron/borrower |
| 257 |
`altcontactaddress1` varchar(255) default NULL, -- the first address line for the alternate contact for the patron/borrower |
257 |
`altcontactaddress1` varchar(255) default NULL, -- the first address line for the alternate contact for the patron/borrower |
| 258 |
`altcontactaddress2` varchar(255) default NULL, -- the second address line for the alternate contact for the patron/borrower |
258 |
`altcontactaddress2` varchar(255) default NULL, -- the second address line for the alternate contact for the patron/borrower |
| 259 |
`altcontactaddress3` varchar(255) default NULL, -- the third address line for the alternate contact for the patron/borrower |
259 |
`altcontactaddress3` varchar(255) default NULL, -- the city for the alternate contact for the patron/borrower |
| 260 |
`altcontactstate` text default NULL, -- the city and state for the alternate contact for the patron/borrower |
260 |
`altcontactstate` text default NULL, -- the city and state for the alternate contact for the patron/borrower |
| 261 |
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower |
261 |
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower |
| 262 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
262 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
|
Lines 727-733
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
| 727 |
`altcontactsurname` varchar(255) default NULL, -- surname or last name of the alternate contact for the patron/borrower |
727 |
`altcontactsurname` varchar(255) default NULL, -- surname or last name of the alternate contact for the patron/borrower |
| 728 |
`altcontactaddress1` varchar(255) default NULL, -- the first address line for the alternate contact for the patron/borrower |
728 |
`altcontactaddress1` varchar(255) default NULL, -- the first address line for the alternate contact for the patron/borrower |
| 729 |
`altcontactaddress2` varchar(255) default NULL, -- the second address line for the alternate contact for the patron/borrower |
729 |
`altcontactaddress2` varchar(255) default NULL, -- the second address line for the alternate contact for the patron/borrower |
| 730 |
`altcontactaddress3` varchar(255) default NULL, -- the third address line for the alternate contact for the patron/borrower |
730 |
`altcontactaddress3` varchar(255) default NULL, -- the city for the alternate contact for the patron/borrower |
| 731 |
`altcontactstate` text default NULL, -- the city and state for the alternate contact for the patron/borrower |
731 |
`altcontactstate` text default NULL, -- the city and state for the alternate contact for the patron/borrower |
| 732 |
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower |
732 |
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower |
| 733 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
733 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
| 734 |
- |
|
|