|
Lines 602-615
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
| 602 |
`dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD) |
602 |
`dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD) |
| 603 |
`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 |
603 |
`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 |
| 604 |
`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 |
604 |
`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 |
| 605 |
`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) |
605 |
`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 (YYYY-MM-DD) |
| 606 |
`debarredcomment` VARCHAR(255) DEFAULT NULL, -- comment on the stop of patron |
606 |
`debarredcomment` VARCHAR(255) DEFAULT NULL, -- comment on the stop of patron |
| 607 |
`contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarentor or organization name |
607 |
`contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarantor or organization name |
| 608 |
`contactfirstname` text, -- used for children to include first name of guarentor |
608 |
`contactfirstname` text, -- used for children to include first name of guarantor |
| 609 |
`contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarentor |
609 |
`contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarantor |
| 610 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarentors or organizations |
610 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarantors or organizations |
| 611 |
`borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client |
611 |
`borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client |
| 612 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor |
612 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarantor |
| 613 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
613 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
| 614 |
`password` varchar(60) default NULL, -- patron/borrower's encrypted password |
614 |
`password` varchar(60) default NULL, -- patron/borrower's encrypted password |
| 615 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
615 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
|
Lines 627-633
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
| 627 |
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower |
627 |
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower |
| 628 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
628 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
| 629 |
`altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower |
629 |
`altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower |
| 630 |
`smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on) |
630 |
`smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on) |
| 631 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
631 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
| 632 |
`privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history KEY `borrowernumber` (`borrowernumber`), |
632 |
`privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history KEY `borrowernumber` (`borrowernumber`), |
| 633 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
633 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
|
Lines 1639-1654
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
| 1639 |
`dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD) |
1639 |
`dateexpiry` date default NULL, -- date the patron/borrower's card is set to expire (YYYY-MM-DD) |
| 1640 |
`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 |
1640 |
`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 |
| 1641 |
`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 |
1641 |
`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 |
| 1642 |
`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) |
1642 |
`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 (YYYY-MM-DD) |
| 1643 |
`debarredcomment` VARCHAR(255) DEFAULT NULL, -- comment on the stop of the patron |
1643 |
`debarredcomment` VARCHAR(255) DEFAULT NULL, -- comment on the stop of the patron |
| 1644 |
`contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarentor or organization name |
1644 |
`contactname` mediumtext, -- used for children and profesionals to include surname or last name of guarantor or organization name |
| 1645 |
`contactfirstname` text, -- used for children to include first name of guarentor |
1645 |
`contactfirstname` text, -- used for children to include first name of guarantor |
| 1646 |
`contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarentor |
1646 |
`contacttitle` text, -- used for children to include title (Mr., Mrs., etc) of guarantor |
| 1647 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarentors or organizations |
1647 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarantors or organizations |
| 1648 |
`borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client |
1648 |
`borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client |
| 1649 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor |
1649 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarantor |
| 1650 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
1650 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
| 1651 |
`password` varchar(60) default NULL, -- patron/borrower's encrypted password |
1651 |
`password` varchar(60) default NULL, -- patron/borrower's Bcrypt encrypted password |
| 1652 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
1652 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
| 1653 |
`userid` varchar(75) default NULL, -- patron/borrower's opac and/or staff client log in |
1653 |
`userid` varchar(75) default NULL, -- patron/borrower's opac and/or staff client log in |
| 1654 |
`opacnote` mediumtext, -- a note on the patron/borrower's account that is visible in the OPAC and staff client |
1654 |
`opacnote` mediumtext, -- a note on the patron/borrower's account that is visible in the OPAC and staff client |
|
Lines 1664-1670
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
| 1664 |
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower |
1664 |
`altcontactzipcode` varchar(50) default NULL, -- the zipcode for the alternate contact for the patron/borrower |
| 1665 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
1665 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
| 1666 |
`altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower |
1666 |
`altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower |
| 1667 |
`smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on) |
1667 |
`smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on) |
| 1668 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
1668 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
| 1669 |
`privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history |
1669 |
`privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history |
| 1670 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
1670 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
| 1671 |
- |
|
|