Lines 232-238
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
232 |
`dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD) |
232 |
`dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD) |
233 |
`gonenoaddress` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address |
233 |
`gonenoaddress` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address |
234 |
`lost` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card |
234 |
`lost` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card |
235 |
`debarred` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as being restricted |
235 |
`debarred` date default NULL, -- until this date the patron can only check-in (no loans, no holds, etc.), is a fine based on days instead of money (YYY-MM-DD) |
|
|
236 |
`debarredcomment` VARCHAR(255) DEFAULT NULL, -- comment on the stop of the patron |
236 |
`contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarentor or organization name |
237 |
`contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarentor or organization name |
237 |
`contactfirstname` text, -- used for children to include first name of guarentor |
238 |
`contactfirstname` text, -- used for children to include first name of guarentor |
238 |
`contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarentor |
239 |
`contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarentor |
Lines 692-698
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
692 |
`dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD) |
693 |
`dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD) |
693 |
`gonenoaddress` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address |
694 |
`gonenoaddress` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address |
694 |
`lost` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card |
695 |
`lost` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card |
695 |
`debarred` tinyint(1) default NULL, -- set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as being restricted |
696 |
`debarred` date default NULL, -- until this date the patron can only check-in (no loans, no holds, etc.), is a fine based on days instead of money (YYY-MM-DD) |
|
|
697 |
`debarredcomment` VARCHAR(255) DEFAULT NULL, -- comment on the stop of patron |
696 |
`contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarentor or organization name |
698 |
`contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarentor or organization name |
697 |
`contactfirstname` text, -- used for children to include first name of guarentor |
699 |
`contactfirstname` text, -- used for children to include first name of guarentor |
698 |
`contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarentor |
700 |
`contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarentor |